[geeklog-cvs] geeklog-1.3/sql mysql_tableanddata.php,1.92,1.93
dhaun at iowaoutdoors.org
dhaun at iowaoutdoors.org
Sun Jan 16 14:14:31 EST 2005
- Previous message (by thread): [geeklog-cvs] geeklog-1.3/public_html/docs config.html,1.43,1.44 history,1.265,1.266
- Next message (by thread): [geeklog-cvs] geeklog-1.3/system lib-trackback.php,NONE,1.1 lib-database.php,1.33,1.34 lib-plugins.php,1.52,1.53 lib-story.php,1.15,1.16
- Messages sorted by:
[ date ]
[ thread ]
[ subject ]
[ author ]
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)";
- Previous message (by thread): [geeklog-cvs] geeklog-1.3/public_html/docs config.html,1.43,1.44 history,1.265,1.266
- Next message (by thread): [geeklog-cvs] geeklog-1.3/system lib-trackback.php,NONE,1.1 lib-database.php,1.33,1.34 lib-plugins.php,1.52,1.53 lib-story.php,1.15,1.16
- Messages sorted by:
[ date ]
[ thread ]
[ subject ]
[ author ]
More information about the geeklog-cvs
mailing list