[geeklog-cvs] geeklog-1.3/sql mysql_tableanddata.php,1.94,1.95

[dhaun at iowaoutdoors.org]

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

Modified Files:
	mysql_tableanddata.php 
Log Message:
Added an index on the trackback URL


Index: mysql_tableanddata.php
===================================================================
RCS file: /var/cvs/geeklog-1.3/sql/mysql_tableanddata.php,v
retrieving revision 1.94
retrieving revision 1.95
diff -C2 -d -r1.94 -r1.95
*** mysql_tableanddata.php	23 Jan 2005 11:08:35 -0000	1.94
--- mysql_tableanddata.php	28 Jan 2005 08:36:55 -0000	1.95
***************
*** 579,583 ****
--- 579,585 ----
    PRIMARY KEY (cid),
    INDEX trackback_sid(sid),
+   INDEX trackback_url(url)
    INDEX trackback_type(type)
+   INDEX trackback_date(date)
  ) TYPE=MyISAM
  ";
***************
*** 926,931 ****
  $_INDEX[] = "ALTER TABLE {$_TABLES['stories']} ADD INDEX stories_frontpage(frontpage)";
  
- $_INDEX[] = "ALTER TABLE {$_TABLES['trackback']} ADD INDEX trackback_date(date)";
- 
  $_INDEX[] = "ALTER TABLE {$_TABLES['userindex']} ADD INDEX userindex_maxstories(maxstories)";
  
--- 928,931 ----