[geeklog-cvs] geeklog-1.3/sql/updates mysql_1.3.9_to_1.3.10.php,1.6,1.7

[dhaun at iowaoutdoors.org]

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

Modified Files:
	mysql_1.3.9_to_1.3.10.php 
Log Message:
Added an index on the 'topic' field of the syndication 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.6
retrieving revision 1.7
diff -C2 -d -r1.6 -r1.7
*** mysql_1.3.9_to_1.3.10.php	30 May 2004 16:44:13 -0000	1.6
--- mysql_1.3.9_to_1.3.10.php	24 Jul 2004 18:35:40 -0000	1.7
***************
*** 100,102 ****
--- 100,105 ----
  $_SQL[] = "UPDATE {$_TABLES['blocks']} SET type = 'gldefault' WHERE name = 'older_stories'";
  
+ // add an index on the 'topic' field of the syndication table
+ $_SQL[] = "ALTER TABLE {$_TABLES['syndication']} ADD INDEX syndication_topic(topic)";
+ 
  ?>