[geeklog-cvs] geeklog-1.3/sql/updates mysql_1.3.9_to_1.3.10.php,1.12,1.13
dhaun at iowaoutdoors.org
dhaun at iowaoutdoors.org
Wed Aug 4 14:45:59 EDT 2004
Update of /var/cvs/geeklog-1.3/sql/updates
In directory www:/tmp/cvs-serv20883/updates
Modified Files:
mysql_1.3.9_to_1.3.10.php
Log Message:
Added index for 'onleft' and 'name' in the hope of speeding up themes with different left and right block templates
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.12
retrieving revision 1.13
diff -C2 -d -r1.12 -r1.13
*** mysql_1.3.9_to_1.3.10.php 3 Aug 2004 10:53:27 -0000 1.12
--- mysql_1.3.9_to_1.3.10.php 4 Aug 2004 18:45:57 -0000 1.13
***************
*** 113,115 ****
--- 113,119 ----
$_SQL[] = "ALTER TABLE {$_TABLES['topics']} ADD archive_flag tinyint(1) unsigned NOT NULL DEFAULT '0' AFTER is_default";
+ // add index for 'onleft' and 'name' to speed up themes with different left and right block templates
+ $_SQL[] = "ALTER TABLE {$_TABLES['blocks']} ADD INDEX blocks_onleft(onleft)";
+ $_SQL[] = "ALTER TABLE {$_TABLES['blocks']} ADD INDEX blocks_name(name)";
+
?>
More information about the geeklog-cvs
mailing list