[geeklog-cvs] geeklog-1.3/sql/updates mysql_1.3.9_to_1.3.10.php,1.10,1.11
blaine at iowaoutdoors.org
blaine at iowaoutdoors.org
Sun Aug 1 17:37:54 EDT 2004
Update of /var/cvs/geeklog-1.3/sql/updates
In directory www:/tmp/cvs-serv26876/sql/updates
Modified Files:
mysql_1.3.9_to_1.3.10.php
Log Message:
Package of changes to support the Story Archive Feature.
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.10
retrieving revision 1.11
diff -C2 -d -r1.10 -r1.11
*** mysql_1.3.9_to_1.3.10.php 31 Jul 2004 03:30:39 -0000 1.10
--- mysql_1.3.9_to_1.3.10.php 1 Aug 2004 21:37:51 -0000 1.11
***************
*** 109,114 ****
$_SQL[] = "UPDATE {$_TABLES['links']} SET owner_id = 1 WHERE owner_id = 0";
! // Add new field for Story Archive feature
$_SQL[] = "ALTER TABLE {$_TABLES['stories']} ADD `expire` DATETIME NOT NULL AFTER `statuscode";
! ?>
--- 109,115 ----
$_SQL[] = "UPDATE {$_TABLES['links']} SET owner_id = 1 WHERE owner_id = 0";
! // Add new fields for Story Archive feature
$_SQL[] = "ALTER TABLE {$_TABLES['stories']} ADD `expire` DATETIME NOT NULL AFTER `statuscode";
+ $_SQL[] = "ALTER TABLE {$_TABLES['topics']} ADD `archive_flag` tinyint(1) unsigned NOT NULL DEFAULT '0' AFTER `is_default";
! ?>
\ No newline at end of file
More information about the geeklog-cvs
mailing list