[geeklog-cvs] geeklog-1.3/sql/updates mysql_1.3.9_to_1.3.10.php,1.3,1.4

[vinny at iowaoutdoors.org]

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

Modified Files:
	mysql_1.3.9_to_1.3.10.php 
Log Message:
Removed some unused indexes from the comments tables.  These indexes were
used in a previous version of the comment performance overhaul.


Index: mysql_1.3.9_to_1.3.10.php
===================================================================
RCS file: /var/cvs/geeklog-1.3/sql/updates/mysql_1.3.9_to_1.3.10.php,v
retrieving revision 1.3
retrieving revision 1.4
diff -C2 -d -r1.3 -r1.4
*** mysql_1.3.9_to_1.3.10.php	9 May 2004 09:54:03 -0000	1.3
--- mysql_1.3.9_to_1.3.10.php	20 May 2004 18:32:14 -0000	1.4
***************
*** 66,71 ****
  $_SQL[] = "ALTER TABLE {$_TABLES['comments']} ADD indent mediumint(10) unsigned NOT NULL default '0' AFTER rht";
  $_SQL[] = "ALTER TABLE {$_TABLES['comments']} ADD ipaddress varchar(15) NOT NULL default '' AFTER uid";
- $_SQL[] = "ALTER TABLE {$_TABLES['comments']} ADD INDEX comments_pid(pid)";
- $_SQL[] = "ALTER TABLE {$_TABLES['comments']} ADD INDEX comments_sid_pid(sid,pid)";
  $_SQL[] = "ALTER TABLE {$_TABLES['comments']} ADD INDEX comments_lft(lft)";
  $_SQL[] = "ALTER TABLE {$_TABLES['comments']} ADD INDEX comments_rht(rht)";
--- 66,69 ----