[geeklog-cvs] geeklog-1.3/sql mysql_tableanddata.php,1.92,1.93

[dhaun at iowaoutdoors.org]

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

Modified Files:
	mysql_tableanddata.php 
Log Message:
Added support for sending and receiving trackback comments (Feature Request #34)


Index: mysql_tableanddata.php
===================================================================
RCS file: /var/cvs/geeklog-1.3/sql/mysql_tableanddata.php,v
retrieving revision 1.92
retrieving revision 1.93
diff -C2 -d -r1.92 -r1.93
*** mysql_tableanddata.php	18 Dec 2004 20:55:48 -0000	1.92
--- mysql_tableanddata.php	16 Jan 2005 19:14:29 -0000	1.93
***************
*** 566,569 ****
--- 566,586 ----
  
  $_SQL[40] = "
+ CREATE TABLE {$_TABLES['trackback']} (
+   cid int(10) unsigned NOT NULL auto_increment,
+   sid varchar(40) NOT NULL,
+   url varchar(255) default NULL,
+   title varchar(128) default NULL,
+   blog varchar(80) default NULL,
+   excerpt text,
+   date datetime default NULL,
+   type varchar(30) NOT NULL default 'article',
+   ipaddress varchar(15) NOT NULL default '',
+   PRIMARY KEY (cid),
+   INDEX trackback_sid(sid),
+   INDEX trackback_type(type)
+ ) TYPE=MyISAM
+ ";
+ 
+ $_SQL[41] = "
  CREATE TABLE {$_TABLES['staticpage']} (
    sp_id varchar(40) NOT NULL default '',
***************
*** 598,602 ****
  ";
   
! $_SQL[41] = "
  CREATE TABLE {$_TABLES['spamx']} (
    name varchar(20) NOT NULL default '',
--- 615,619 ----
  ";
   
! $_SQL[42] = "
  CREATE TABLE {$_TABLES['spamx']} (
    name varchar(20) NOT NULL default '',
***************
*** 908,911 ****
--- 925,930 ----
  $_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)";