[Openfirst-cvscommit] downloads/setup setup.mssql,NONE,1.1 setup.mysql,1.1,1.2

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

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