[geeklog-cvs] geeklog-1.3/sql mysql_tableanddata.php,1.41,1.42

[dhaun at geeklog.net]

Update of /usr/cvs/geeklog/geeklog-1.3/sql
In directory internal.geeklog.net:/tmp/cvs-serv6406

Modified Files:
	mysql_tableanddata.php 
Log Message:
Fixed parse errors and a duplicate index (seems I checked in the wrong file last time ...)


Index: mysql_tableanddata.php
===================================================================
RCS file: /usr/cvs/geeklog/geeklog-1.3/sql/mysql_tableanddata.php,v
retrieving revision 1.41
retrieving revision 1.42
diff -C2 -d -r1.41 -r1.42
*** mysql_tableanddata.php	17 Feb 2003 21:18:44 -0000	1.41
--- mysql_tableanddata.php	23 Feb 2003 18:16:32 -0000	1.42
***************
*** 830,850 ****
  $_DATA[] = "INSERT INTO {$_TABLES['vars']} (name, value) VALUES ('sp_group_id','15')";
  
! $_INDEX[] = 'ALTER TABLE {$_TABLES['comments']} ADD INDEX comments_date(date)';
  
! $_INDEX[] = 'ALTER TABLE {$_TABLES['events']} ADD INDEX events_datestart(datestart)';
! $_INDEX[] = 'ALTER TABLE {$_TABLES['events']} ADD INDEX events_dateend(dateend)';
  
! $_INDEX[] = 'ALTER TABLE {$_TABLES['group_assignments']} ADD INDEX group_assignments_ug_main_grp_id(ug_main_grp_id)';
! $_INDEX[] = 'ALTER TABLE {$_TABLES['group_assignments']} ADD INDEX group_assignments_ug_uid(ug_uid)';
  
! $_INDEX[] = 'ALTER TABLE {$_TABLES['links']} ADD INDEX links_category(category)';
! $_INDEX[] = 'ALTER TABLE {$_TABLES['links']} ADD INDEX links_date(date)';
  
! $_INDEX[] = 'ALTER TABLE {$_TABLES['pollquestions']} ADD INDEX pollquestions_date(date)';
  
! $_INDEX[] = 'ALTER TABLE {$_TABLES['stories']} ADD INDEX stories_date(date)';
! $_INDEX[] = 'ALTER TABLE {$_TABLES['stories']} ADD INDEX stories_frontpage(frontpage)';
  
! $_INDEX[] = 'ALTER TABLE {$_TABLES['userindex']} ADD INDEX userindex_maxstories(maxstories)';
  
  ?>
--- 830,849 ----
  $_DATA[] = "INSERT INTO {$_TABLES['vars']} (name, value) VALUES ('sp_group_id','15')";
  
! $_INDEX[] = "ALTER TABLE {$_TABLES['comments']} ADD INDEX comments_date(date)";
  
! $_INDEX[] = "ALTER TABLE {$_TABLES['events']} ADD INDEX events_datestart(datestart)";
! $_INDEX[] = "ALTER TABLE {$_TABLES['events']} ADD INDEX events_dateend(dateend)";
  
! $_INDEX[] = "ALTER TABLE {$_TABLES['group_assignments']} ADD INDEX group_assignments_ug_uid(ug_uid)";
  
! $_INDEX[] = "ALTER TABLE {$_TABLES['links']} ADD INDEX links_category(category)";
! $_INDEX[] = "ALTER TABLE {$_TABLES['links']} ADD INDEX links_date(date)";
  
! $_INDEX[] = "ALTER TABLE {$_TABLES['pollquestions']} ADD INDEX pollquestions_date(date)";
  
! $_INDEX[] = "ALTER TABLE {$_TABLES['stories']} ADD INDEX stories_date(date)";
! $_INDEX[] = "ALTER TABLE {$_TABLES['stories']} ADD INDEX stories_frontpage(frontpage)";
  
! $_INDEX[] = "ALTER TABLE {$_TABLES['userindex']} ADD INDEX userindex_maxstories(maxstories)";
  
  ?>