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