[Openfirst-cvscommit] news/setup setup.mysql,1.8,1.9 setup.mssql,1.3,1.4

[<xt...@us...>]

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

Modified Files:
	setup.mysql setup.mssql 
Log Message:
Revert SQL scripts back to proper news SQL scripts

Index: setup.mysql
===================================================================
RCS file: /cvsroot/openfirst/news/setup/setup.mysql,v
retrieving revision 1.8
retrieving revision 1.9
diff -C2 -d -r1.8 -r1.9
*** setup.mysql	6 Oct 2003 22:12:10 -0000	1.8
--- setup.mysql	6 Oct 2003 22:27:08 -0000	1.9
***************
*** 1,24 ****
! CREATE TABLE `ofirst_downloads` (
!   `ID` bigint(12) unsigned NOT NULL auto_increment,
!   `Category` varchar(35) NOT NULL default '',
!   `Title` tinytext NOT NULL,
!   `Description` mediumtext,
!   `mime` tinytext,
!   `ext` tinytext,
!   `DateAdded` date NOT NULL default '0000-00-00',
!   `FileData` longblob NOT NULL,
!   `hits` int(12) default '0',
!   PRIMARY KEY  (`ID`),
!   UNIQUE KEY `ID` (`ID`),
!   KEY `ID_2` (`ID`)
! ) TYPE=MyISAM COMMENT='Files Table for Download Manager'
! CREATE TABLE `ofirst_downloadcat` (
!   `ID` int(12) NOT NULL auto_increment,
!   `Category` varchar(35) NOT NULL default '',
!   `Description` tinytext,
!   `Icon` tinytext,
!   PRIMARY KEY  (`ID`),
!   UNIQUE KEY `ID` (`ID`,`Category`(12)),
!   KEY `ID_2` (`ID`)
! ) TYPE=MyISAM COMMENT='Download Categories'
! INSERT INTO ofirst_config SET modulename='downloads',showonmenu='0',active='0',adminnavigation='<a href="$basepath/downloads/admin">Category Editor</a>',modulenavigation='<a href="$basepath/downloads/">Downloads Home</a>',includes='';
--- 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.mssql
===================================================================
RCS file: /cvsroot/openfirst/news/setup/setup.mssql,v
retrieving revision 1.3
retrieving revision 1.4
diff -C2 -d -r1.3 -r1.4
*** setup.mssql	6 Oct 2003 22:12:10 -0000	1.3
--- setup.mssql	6 Oct 2003 22:27:08 -0000	1.4
***************
*** 1,24 ****
! CREATE TABLE `ofirst_downloads` (
!   `ID` bigint(12) unsigned NOT NULL auto_increment,
!   `Category` varchar(35) NOT NULL default '',
!   `Title` tinytext NOT NULL,
!   `Description` mediumtext,
!   `mime` tinytext,
!   `ext` tinytext,
!   `DateAdded` date NOT NULL default '0000-00-00',
!   `FileData` longblob NOT NULL,
!   `hits` int(12) default '0',
!   PRIMARY KEY  (`ID`),
!   UNIQUE KEY `ID` (`ID`),
!   KEY `ID_2` (`ID`)
! ) TYPE=MyISAM COMMENT='Files Table for Download Manager'
! CREATE TABLE `ofirst_downloadcat` (
!   `ID` int(12) NOT NULL auto_increment,
!   `Category` varchar(35) NOT NULL default '',
!   `Description` tinytext,
!   `Icon` tinytext,
!   PRIMARY KEY  (`ID`),
!   UNIQUE KEY `ID` (`ID`,`Category`(12)),
!   KEY `ID_2` (`ID`)
! ) TYPE=MyISAM COMMENT='Download Categories'
! INSERT INTO ofirst_config SET modulename='downloads',showonmenu='0',active='0',adminnavigation='<a href="$basepath/downloads/admin">Category Editor</a>',modulenavigation='<a href="$basepath/downloads/">Downloads Home</a>',includes='';
--- 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';