[geeklog-cvs] geeklog-1.3/sql/updates mysql_1.3.9_to_1.3.10.php,1.8,1.9
dhaun at iowaoutdoors.org
dhaun at iowaoutdoors.org
Tue Jul 27 03:29:06 EDT 2004
Update of /var/cvs/geeklog-1.3/sql/updates
In directory www:/tmp/cvs-serv9636/sql/updates
Modified Files:
mysql_1.3.9_to_1.3.10.php
Log Message:
Get rid of the obsolete 'layout' blocks
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.8
retrieving revision 1.9
diff -C2 -d -r1.8 -r1.9
*** mysql_1.3.9_to_1.3.10.php 26 Jul 2004 07:50:08 -0000 1.8
--- mysql_1.3.9_to_1.3.10.php 27 Jul 2004 07:29:04 -0000 1.9
***************
*** 100,103 ****
--- 100,106 ----
$_SQL[] = "UPDATE {$_TABLES['blocks']} SET type = 'gldefault' WHERE name = 'older_stories'";
+ // remove obsolete "layout" blocks from _very_ old databases ...
+ $_SQL[] = "DELETE FROM {$_TABLES['blocks']} WHERE type = 'layout'";
+
// add an index on the 'topic' field of the syndication table
$_SQL[] = "ALTER TABLE {$_TABLES['syndication']} ADD INDEX syndication_topic(topic)";
More information about the geeklog-cvs
mailing list