Update of /cvsroot/openfirst/forum/setup
In directory sc8-pr-cvs1:/tmp/cvs-serv9118/forum/setup
Modified Files:
setup.mssql setup.mysql
Log Message:
Modified setup scripts for compatibility with the previous format of the members table
Index: setup.mssql
===================================================================
RCS file: /cvsroot/openfirst/forum/setup/setup.mssql,v
retrieving revision 1.2
retrieving revision 1.3
diff -C2 -d -r1.2 -r1.3
*** setup.mssql 13 Oct 2003 22:19:03 -0000 1.2
--- setup.mssql 23 Nov 2003 20:04:24 -0000 1.3
***************
*** 2,3 ****
--- 2,4 ----
CREATE TABLE IF NOT EXISTS `ofirst_forumposts` (`ID` bigint(8) unsigned NOT NULL auto_increment, `forum` varchar(45) NOT NULL default '', `ReplyTo` bigint(45) unsigned NOT NULL default '0', `Title` tinytext NOT NULL, `Author` tinytext NOT NULL, `Message` text, `DatePosted` datetime NOT NULL default '0000-00-00 00:00:00', UNIQUE KEY `ID` (`ID`)) TYPE=MyISAM;
INSERT INTO ofirst_config SET modulename='forum',showonmenu='0',active='0',adminnavigation='<a href="$basepath/forum/admin/">Forum Admin</a>',modulenavigation='<a href="$basepath/forum/">Forum Home</a>',includes='forumvisit.php';
+ ALTER TABLE `ofirst_members` ADD `forumvisit` DATETIME;
\ No newline at end of file
Index: setup.mysql
===================================================================
RCS file: /cvsroot/openfirst/forum/setup/setup.mysql,v
retrieving revision 1.2
retrieving revision 1.3
diff -C2 -d -r1.2 -r1.3
*** setup.mysql 13 Oct 2003 22:19:03 -0000 1.2
--- setup.mysql 23 Nov 2003 20:04:25 -0000 1.3
***************
*** 2,3 ****
--- 2,4 ----
CREATE TABLE IF NOT EXISTS `ofirst_forumposts` (`ID` bigint(8) unsigned NOT NULL auto_increment, `forum` varchar(45) NOT NULL default '', `ReplyTo` bigint(45) unsigned NOT NULL default '0', `Title` tinytext NOT NULL, `Author` tinytext NOT NULL, `Message` text, `DatePosted` datetime NOT NULL default '0000-00-00 00:00:00', UNIQUE KEY `ID` (`ID`)) TYPE=MyISAM;
INSERT INTO ofirst_config SET modulename='forum',showonmenu='0',active='0',adminnavigation='<a href="$basepath/forum/admin/">Forum Admin</a>',modulenavigation='<a href="$basepath/forum/">Forum Home</a>',includes='forumvisit.php';
+ ALTER TABLE `ofirst_members` ADD `forumvisit` DATETIME;
\ No newline at end of file
|
