Update of /cvsroot/openfirst/news/setup
In directory sc8-pr-cvs1:/tmp/cvs-serv4124
Modified Files:
setup.mssql setup.mysql
Log Message:
Fix typo, bring MSSQL setup script in sync with MySQL setup script.
Index: setup.mssql
===================================================================
RCS file: /cvsroot/openfirst/news/setup/setup.mssql,v
retrieving revision 1.1
retrieving revision 1.2
diff -C2 -d -r1.1 -r1.2
*** setup.mssql 23 Aug 2003 20:25:13 -0000 1.1
--- setup.mssql 30 Sep 2003 11:48:16 -0000 1.2
***************
*** 1,3 ****
CREATE TABLE IF NOT EXISTS `ofirst_news` (`ID` int(6) unsigned NOT NULL auto_increment, `date` TINYTEXT, `poster` TINYTEXT, `title` TINYTEXT, `news` TEXT, PRIMARY KEY (`ID`)) Type=MyISAM;
ALTER TABLE ofirst_news ADD COLUMN image TEXT;
! INSERT INTO ofirst_config SET modulename='news',showonmenu='0',active='0',adminnavigation='<a href="$basepath/news/admin/">Admin Main</a>',modulenavigation='<a href="$basepath/news/">Current News</a>',includes='viewnews.php';
--- 1,4 ----
CREATE TABLE IF NOT EXISTS `ofirst_news` (`ID` int(6) unsigned NOT NULL auto_increment, `date` TINYTEXT, `poster` TINYTEXT, `title` TINYTEXT, `news` TEXT, PRIMARY KEY (`ID`)) Type=MyISAM;
ALTER TABLE ofirst_news ADD COLUMN image TEXT;
! CREATE TABLE `ofirst_news_comments` (`ID` tinyint(3) unsigned NOT NULL default '0', `Author` TEXT, `EMail` TINYTEXT, `Website` TINYTEXT, `Comment` TEXT, `Date` TEXT, PRIMARY KEY (`ID`)) TYPE=MyISAM;
! INSERT INTO ofirst_config SET modulename='news',showonmenu='0',active='0',adminnavigation='<a href="$basepath/news/admin/">Edit News</a>',modulenavigation='<a href="$basepath/news/">Current News</a> | <a href="$basepath/news/rssfeed.php">Stream our News</a>',includes='viewnews.php';
Index: setup.mysql
===================================================================
RCS file: /cvsroot/openfirst/news/setup/setup.mysql,v
retrieving revision 1.6
retrieving revision 1.7
diff -C2 -d -r1.6 -r1.7
*** setup.mysql 28 Sep 2003 16:25:08 -0000 1.6
--- setup.mysql 30 Sep 2003 11:48:16 -0000 1.7
***************
*** 2,4 ****
ALTER TABLE ofirst_news ADD COLUMN image TEXT;
CREATE TABLE `ofirst_news_comments` (`ID` tinyint(3) unsigned NOT NULL default '0', `Author` TEXT, `EMail` TINYTEXT, `Website` TINYTEXT, `Comment` TEXT, `Date` TEXT, PRIMARY KEY (`ID`)) TYPE=MyISAM;
! INSERT INTO ofirst_config SET modulename='news',showonmenu='0',active='0',adminnavigation='<a href="$basepath/news/admin/">Edit News</a>',modulenavigation='<a href="$basepath/news/">Current News</a> | <a href="$basepath/news/rssfeed.php">Steam our News</a>',includes='viewnews.php';
--- 2,4 ----
ALTER TABLE ofirst_news ADD COLUMN image TEXT;
CREATE TABLE `ofirst_news_comments` (`ID` tinyint(3) unsigned NOT NULL default '0', `Author` TEXT, `EMail` TINYTEXT, `Website` TINYTEXT, `Comment` TEXT, `Date` TEXT, PRIMARY KEY (`ID`)) TYPE=MyISAM;
! INSERT INTO ofirst_config SET modulename='news',showonmenu='0',active='0',adminnavigation='<a href="$basepath/news/admin/">Edit News</a>',modulenavigation='<a href="$basepath/news/">Current News</a> | <a href="$basepath/news/rssfeed.php">Stream our News</a>',includes='viewnews.php';
|