[Openfirst-cvscommit] news/setup setup.mssql,1.2,1.3 setup.mysql,1.7,1.8

[<i-...@us...>]

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

Modified Files:
	setup.mssql setup.mysql 
Log Message:
Setup for Downloads module

Index: setup.mssql
===================================================================
RCS file: /cvsroot/openfirst/news/setup/setup.mssql,v
retrieving revision 1.2
retrieving revision 1.3
diff -C2 -d -r1.2 -r1.3
*** setup.mssql	30 Sep 2003 11:48:16 -0000	1.2
--- setup.mssql	6 Oct 2003 22:12:10 -0000	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">Stream our News</a>',includes='viewnews.php';
--- 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='';

Index: setup.mysql
===================================================================
RCS file: /cvsroot/openfirst/news/setup/setup.mysql,v
retrieving revision 1.7
retrieving revision 1.8
diff -C2 -d -r1.7 -r1.8
*** setup.mysql	30 Sep 2003 11:48:16 -0000	1.7
--- setup.mysql	6 Oct 2003 22:12:10 -0000	1.8
***************
*** 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';
--- 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='';