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';
|
