Update of /cvsroot/openfirst/downloads/setup
In directory sc8-pr-cvs1:/tmp/cvs-serv10361/setup
Modified Files:
setup.mysql
Added Files:
setup.mssql
Log Message:
Change all occurances of include() to include_once(), correct some style issues, add mssql setup script
--- NEW FILE: setup.mssql ---
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
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
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/downloads/setup/setup.mysql,v
retrieving revision 1.1
retrieving revision 1.2
diff -C2 -d -r1.1 -r1.2
*** setup.mysql 7 Oct 2003 01:33:23 -0000 1.1
--- setup.mysql 23 Nov 2003 17:28:19 -0000 1.2
***************
*** 1,3 ****
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
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
! 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='';
\ No newline at end of file
--- 1,3 ----
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
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
! 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='';
|
