[geeklog-cvs] geeklog-1.3/sql/updates mysql_1.3.9_to_1.3.10.php,1.19,1.20
dhaun at iowaoutdoors.org
dhaun at iowaoutdoors.org
Fri Sep 24 06:08:05 EDT 2004
Update of /var/cvs/geeklog-1.3/sql/updates
In directory www:/tmp/cvs-serv11382/updates
Modified Files:
mysql_1.3.9_to_1.3.10.php
Log Message:
Add index on the 'statuscode' and 'expire' fields of the stories table.
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.19
retrieving revision 1.20
diff -C2 -d -r1.19 -r1.20
*** mysql_1.3.9_to_1.3.10.php 17 Sep 2004 10:52:37 -0000 1.19
--- mysql_1.3.9_to_1.3.10.php 24 Sep 2004 10:08:03 -0000 1.20
***************
*** 152,155 ****
--- 152,159 ----
$_SQL[] = "DELETE FROM {$_TABLES['vars']} WHERE name = 'rdf_sids'";
+ // add index on the 'statuscode' and 'expire' fields of the stories table
+ $_SQL[] = "ALTER TABLE {$_TABLES['stories']} ADD INDEX stories_statuscode(statuscode)";
+ $_SQL[] = "ALTER TABLE {$_TABLES['stories']} ADD INDEX stories_expire(expire)";
+
/**
More information about the geeklog-cvs
mailing list