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

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

Update of /cvsroot/openfirst/downloads/setup
In directory sc8-pr-cvs1:/tmp/cvs-serv27295/setup

Added Files:
	setup.mysql 
Log Message:
Download manager. Initial upload. Needs mssql setup script.

--- NEW FILE: setup.mysql ---
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='';