[Openfirst-cvscommit] news/setup setup.mysql,1.5,1.6

[<dav...@us...>]

Update of /cvsroot/openfirst/news/setup
In directory sc8-pr-cvs1:/tmp/cvs-serv9658

Modified Files:
	setup.mysql 
Log Message:
Added creation command for comment table.

Index: setup.mysql
===================================================================
RCS file: /cvsroot/openfirst/news/setup/setup.mysql,v
retrieving revision 1.5
retrieving revision 1.6
diff -C2 -d -r1.5 -r1.6
*** setup.mysql	28 Sep 2003 15:40:00 -0000	1.5
--- setup.mysql	28 Sep 2003 16:25:08 -0000	1.6
***************
*** 1,3 ****
--- 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">Steam our News</a>',includes='viewnews.php';