[geeklog-cvs] geeklog-1.3/sql mysql_tableanddata.php,1.68,1.69

[vinny at iowaoutdoors.org]

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

Modified Files:
	mysql_tableanddata.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_tableanddata.php
===================================================================
RCS file: /var/cvs/geeklog-1.3/sql/mysql_tableanddata.php,v
retrieving revision 1.68
retrieving revision 1.69
diff -C2 -d -r1.68 -r1.69
*** mysql_tableanddata.php	9 May 2004 09:54:03 -0000	1.68
--- mysql_tableanddata.php	20 May 2004 18:32:13 -0000	1.69
***************
*** 70,77 ****
    uid mediumint(8) NOT NULL default '1',
    ipaddress varchar(15) NOT NULL default '',
!   INDEX comments_cid(cid),
!   INDEX comments_type(type),
!   INDEX comments_sid_pid(sid, pid),
!   INDEX comments_pid(pid),
    INDEX comments_uid(uid),
    INDEX comments_lft(lft),
--- 70,74 ----
    uid mediumint(8) NOT NULL default '1',
    ipaddress varchar(15) NOT NULL default '',
!   INDEX comments_sid(sid),
    INDEX comments_uid(uid),
    INDEX comments_lft(lft),