[Openfirst-cvscommit] photogallery/setup setup.mssql,1.1,1.2 setup.mysql,1.10,1.11
Brought to you by:
xtimg
From: <xt...@us...> - 2003-08-26 02:14:05
|
Update of /cvsroot/openfirst/photogallery/setup In directory sc8-pr-cvs1:/tmp/cvs-serv20047 Modified Files: setup.mssql setup.mysql Log Message: Fix older installs, updating them to have dates in the proper era Index: setup.mssql =================================================================== RCS file: /cvsroot/openfirst/photogallery/setup/setup.mssql,v retrieving revision 1.1 retrieving revision 1.2 diff -C2 -d -r1.1 -r1.2 *** setup.mssql 23 Aug 2003 20:32:49 -0000 1.1 --- setup.mssql 24 Aug 2003 15:43:19 -0000 1.2 *************** *** 2,4 **** 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>'; \ No newline at end of file --- 2,5 ---- 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>'; ! ALTER TABLE ofirst_photogallery_galleries CHANGE Dates Dates TEXT; Index: setup.mysql =================================================================== RCS file: /cvsroot/openfirst/photogallery/setup/setup.mysql,v retrieving revision 1.10 retrieving revision 1.11 diff -C2 -d -r1.10 -r1.11 *** setup.mysql 21 Aug 2003 17:55:56 -0000 1.10 --- setup.mysql 24 Aug 2003 15:43:19 -0000 1.11 *************** *** 2,4 **** 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>'; \ No newline at end of file --- 2,5 ---- 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>'; ! ALTER TABLE ofirst_photogallery_galleries CHANGE Dates Dates TEXT; |