[geeklog-cvs] geeklog-1.3/sql/updates mysql_1.3.9_to_1.3.10.php,1.2,1.3
dhaun at iowaoutdoors.org
dhaun at iowaoutdoors.org
Sun May 9 05:54:05 EDT 2004
Update of /var/cvs/geeklog-1.3/sql/updates
In directory www:/tmp/cvs-serv13147/sql/updates
Modified Files:
mysql_1.3.9_to_1.3.10.php
Log Message:
Added tracking of IP addresses of comment posters (suggested by Michael Jervis).
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.2
retrieving revision 1.3
diff -C2 -d -r1.2 -r1.3
*** mysql_1.3.9_to_1.3.10.php 5 Apr 2004 19:22:04 -0000 1.2
--- mysql_1.3.9_to_1.3.10.php 9 May 2004 09:54:03 -0000 1.3
***************
*** 65,68 ****
--- 65,69 ----
$_SQL[] = "ALTER TABLE {$_TABLES['comments']} ADD rht mediumint(10) unsigned NOT NULL default '0' AFTER lft";
$_SQL[] = "ALTER TABLE {$_TABLES['comments']} ADD indent mediumint(10) unsigned NOT NULL default '0' AFTER rht";
+ $_SQL[] = "ALTER TABLE {$_TABLES['comments']} ADD ipaddress varchar(15) NOT NULL default '' AFTER uid";
$_SQL[] = "ALTER TABLE {$_TABLES['comments']} ADD INDEX comments_pid(pid)";
$_SQL[] = "ALTER TABLE {$_TABLES['comments']} ADD INDEX comments_sid_pid(sid,pid)";
More information about the geeklog-cvs
mailing list