[Openfirst-cvscommit] photogallery/setup setup.mssql,NONE,1.1

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

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