[geeklog-cvs] geeklog-1.3/sql mysql_tableanddata.php,1.79,1.80
dhaun at iowaoutdoors.org
dhaun at iowaoutdoors.org
Fri Sep 24 06:08:05 EDT 2004
Update of /var/cvs/geeklog-1.3/sql
In directory www:/tmp/cvs-serv11382
Modified Files:
mysql_tableanddata.php
Log Message:
Add index on the 'statuscode' and 'expire' fields of the stories table.
Index: mysql_tableanddata.php
===================================================================
RCS file: /var/cvs/geeklog-1.3/sql/mysql_tableanddata.php,v
retrieving revision 1.79
retrieving revision 1.80
diff -C2 -d -r1.79 -r1.80
*** mysql_tableanddata.php 17 Sep 2004 10:52:36 -0000 1.79
--- mysql_tableanddata.php 24 Sep 2004 10:08:03 -0000 1.80
***************
*** 402,405 ****
--- 402,407 ----
INDEX stories_featured(featured),
INDEX stories_hits(hits),
+ INDEX stories_statuscode(statuscode),
+ INDEX stories_expire(expire),
PRIMARY KEY (sid)
) TYPE=MyISAM
More information about the geeklog-cvs
mailing list