[Openfirst-cvscommit] awards/setup setup.mssql,1.2,1.3 setup.mysql,1.7,1.8

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

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