Update of /cvsroot/openfirst/awards/setup
In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv22829
Modified Files:
setup.mssql setup.mysql
Log Message:
Correct table structure on existing installations of awards module.
Index: setup.mssql
===================================================================
RCS file: /cvsroot/openfirst/awards/setup/setup.mssql,v
retrieving revision 1.2
retrieving revision 1.3
diff -C2 -d -r1.2 -r1.3
*** setup.mssql 27 Nov 2003 02:35:39 -0000 1.2
--- setup.mssql 14 Feb 2004 14:35:26 -0000 1.3
***************
*** 1,2 ****
CREATE TABLE `ofirst_awards` (`ID` int(6) unsigned NOT NULL auto_increment, `AwardName` tinytext, `Description` text,`Event` tinytext, `Date` date default NULL, `Recipient` tinytext, `Image` tinytext, PRIMARY KEY (`ID`)) TYPE=MyISAM;
! INSERT INTO ofirst_config SET modulename='awards',showonmenu='0',active='0',adminnavigation='<a href="$basepath/awards/admin/">Manage Awards</a>',modulenavigation='<a href="$basepath/awards/">View Awards</a>';
\ No newline at end of file
--- 1,3 ----
CREATE TABLE `ofirst_awards` (`ID` int(6) unsigned NOT NULL auto_increment, `AwardName` tinytext, `Description` text,`Event` tinytext, `Date` date default NULL, `Recipient` tinytext, `Image` tinytext, PRIMARY KEY (`ID`)) TYPE=MyISAM;
! ALTER TABLE `ofirst_awards` ADD column Description TEXT;
! INSERT INTO ofirst_config SET modulename='awards',showonmenu='0',active='0',adminnavigation='<a href="$basepath/awards/admin/">Manage Awards</a>',modulenavigation='<a href="$basepath/awards/">View Awards</a>';
Index: setup.mysql
===================================================================
RCS file: /cvsroot/openfirst/awards/setup/setup.mysql,v
retrieving revision 1.7
retrieving revision 1.8
diff -C2 -d -r1.7 -r1.8
*** setup.mysql 27 Nov 2003 02:35:39 -0000 1.7
--- setup.mysql 14 Feb 2004 14:35:26 -0000 1.8
***************
*** 1,2 ****
CREATE TABLE `ofirst_awards` (`ID` int(6) unsigned NOT NULL auto_increment, `AwardName` tinytext, `Description` text,`Event` tinytext, `Date` date default NULL, `Recipient` tinytext, `Image` tinytext, PRIMARY KEY (`ID`)) TYPE=MyISAM;
! INSERT INTO ofirst_config SET modulename='awards',showonmenu='0',active='0',adminnavigation='<a href="$basepath/awards/admin/">Manage Awards</a>',modulenavigation='<a href="$basepath/awards/">View Awards</a>';
\ No newline at end of file
--- 1,3 ----
CREATE TABLE `ofirst_awards` (`ID` int(6) unsigned NOT NULL auto_increment, `AwardName` tinytext, `Description` text,`Event` tinytext, `Date` date default NULL, `Recipient` tinytext, `Image` tinytext, PRIMARY KEY (`ID`)) TYPE=MyISAM;
! ALTER TABLE `ofirst_awards` ADD column Description TEXT;
! INSERT INTO ofirst_config SET modulename='awards',showonmenu='0',active='0',adminnavigation='<a href="$basepath/awards/admin/">Manage Awards</a>',modulenavigation='<a href="$basepath/awards/">View Awards</a>';
|
