[geeklog-cvs] geeklog-1.3/sql mysql_tableanddata.php,1.95,1.96

[dhaun at iowaoutdoors.org]

Update of /var/cvs/geeklog-1.3/sql
In directory www:/tmp/cvs-serv21272/sql

Modified Files:
	mysql_tableanddata.php 
Log Message:
Create all indexes with the tables again (raising the minimum requirement to MySQL 3.23.2).


Index: mysql_tableanddata.php
===================================================================
RCS file: /var/cvs/geeklog-1.3/sql/mysql_tableanddata.php,v
retrieving revision 1.95
retrieving revision 1.96
diff -C2 -d -r1.95 -r1.96
*** mysql_tableanddata.php	28 Jan 2005 08:36:55 -0000	1.95
--- mysql_tableanddata.php	28 Jan 2005 12:34:20 -0000	1.96
***************
*** 77,80 ****
--- 77,81 ----
    INDEX comments_lft(lft),
    INDEX comments_rht(rht),
+   INDEX comments_date(date),
    PRIMARY KEY  (cid)
  ) TYPE=MyISAM
***************
*** 124,127 ****
--- 125,130 ----
    INDEX events_eid(eid),
    INDEX events_event_type(event_type),
+   INDEX events_datestart(datestart),
+   INDEX events_dateend(dateend),
    PRIMARY KEY  (eid)
  ) TYPE=MyISAM
***************
*** 183,186 ****
--- 186,190 ----
    ug_grp_id mediumint(8) unsigned default NULL,
    INDEX group_assignments_ug_main_grp_id(ug_main_grp_id),
+   INDEX group_assignments_ug_uid(ug_uid),
    KEY ug_main_grp_id (ug_main_grp_id)
  ) TYPE=MyISAM
***************
*** 214,217 ****
--- 218,223 ----
    perm_anon tinyint(1) unsigned NOT NULL default '2',
    INDEX links_lid(lid),
+   INDEX links_category(category),
+   INDEX links_date(date),
    PRIMARY KEY  (lid)
  ) TYPE=MyISAM
***************
*** 309,312 ****
--- 315,319 ----
    INDEX pollquestions_commentcode(commentcode),
    INDEX pollquestions_statuscode(statuscode),
+   INDEX pollquestions_date(date),
    PRIMARY KEY  (qid)
  ) TYPE=MyISAM
***************
*** 405,408 ****
--- 412,417 ----
    INDEX stories_statuscode(statuscode),
    INDEX stories_expire(expire),
+   INDEX stories_date(date),
+   INDEX stories_frontpage(frontpage),
    PRIMARY KEY  (sid)
  ) TYPE=MyISAM
***************
*** 495,498 ****
--- 504,508 ----
    INDEX userindex_uid(uid),
    INDEX userindex_noboxes(noboxes),
+   INDEX userindex_maxstories(maxstories),
    PRIMARY KEY  (uid)
  ) TYPE=MyISAM
***************
*** 579,584 ****
    PRIMARY KEY (cid),
    INDEX trackback_sid(sid),
!   INDEX trackback_url(url)
!   INDEX trackback_type(type)
    INDEX trackback_date(date)
  ) TYPE=MyISAM
--- 589,594 ----
    PRIMARY KEY (cid),
    INDEX trackback_sid(sid),
!   INDEX trackback_url(url),
!   INDEX trackback_type(type),
    INDEX trackback_date(date)
  ) TYPE=MyISAM
***************
*** 909,932 ****
  $_DATA[] = "INSERT INTO {$_TABLES['vars']} (name, value) VALUES ('lastemailedstories','') ";
  
- #
- # These indexes are only added for MySQL version 3.23.2 and up
- #
- 
- $_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)";
- 
  ?>
--- 919,921 ----