Update of /cvsroot/openfirst/photogallery/setup
In directory sc8-pr-cvs1:/tmp/cvs-serv14346/setup
Added Files:
setup.mssql
Log Message:
Replace mysql functions with new database functions, allowing multiple database types to be used easily.
--- NEW FILE: setup.mssql ---
CREATE TABLE `ofirst_photogallery_galleries` (`ID` TINYINT (3) UNSIGNED NOT NULL auto_increment, `GalleryName` TEXT, `Author` TEXT, `Dates` text, `Description` TEXT, `NumPhotos` INT (3) UNSIGNED DEFAULT '0' NOT NULL, PRIMARY KEY(`ID`)) TYPE=MyISAM;
CREATE TABLE `ofirst_photogallery_comments` (`ID` tinyint(3) unsigned NOT NULL auto_increment,`Image` tinytext,`Gallery` tinytext,`Author` tinytext,`EMail` tinytext,`Comment` text,`Dates` text, PRIMARY KEY (`ID`)) TYPE=MyISAM;
CREATE TABLE `ofirst_photogallery_image` (`ID` tinyint(3) unsigned NOT NULL auto_increment,`Image` tinytext,`Gallery` tinytext,`ImageName` tinytext,`Description` tinytext,`Comment` text,`Dates` text, PRIMARY KEY (`ID`)) TYPE=MyISAM;
INSERT INTO ofirst_config SET includes='photogallery.php',modulename='photogallery',showonmenu='0',active='0',adminnavigation='<a href="$basepath/photogallery/admin/">Gallery Manager</a> | <a href="$basepath/photogallery/admin/newgallery.php">New Gallery</a>',modulenavigation='<a href="$basepath/photogallery/">View Gallery</a>';
|
