Update of /cvsroot/openfirst/photogallery/setup
In directory sc8-pr-cvs1:/tmp/cvs-serv20259
Modified Files:
setup.mysql
Log Message:
Added sql command for adding the image table.
Index: setup.mysql
===================================================================
RCS file: /cvsroot/openfirst/photogallery/setup/setup.mysql,v
retrieving revision 1.9
retrieving revision 1.10
diff -C2 -d -r1.9 -r1.10
*** setup.mysql 20 Aug 2003 22:56:10 -0000 1.9
--- setup.mysql 21 Aug 2003 17:55:56 -0000 1.10
***************
*** 1,3 ****
! CREATE TABLE `ofirst_photogallery_galleries` (`ID` TINYINT (3) UNSIGNED NOT NULL auto_increment, `GalleryName` TEXT, `Author` TEXT, `Dates` TIME NOT NULL, `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,`Date` tinytext, 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>';
--- 1,4 ----
! 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>';
|
