Update of /cvsroot/openfirst/projects/setup
In directory sc8-pr-cvs1:/tmp/cvs-serv26958
Modified Files:
setup.mysql
Log Message:
Removed a few commands and set ProjectsUpdates with default of off for updates.
Index: setup.mysql
===================================================================
RCS file: /cvsroot/openfirst/projects/setup/setup.mysql,v
retrieving revision 1.1
retrieving revision 1.2
diff -C2 -d -r1.1 -r1.2
*** setup.mysql 27 Aug 2003 12:58:29 -0000 1.1
--- setup.mysql 30 Aug 2003 15:18:33 -0000 1.2
***************
*** 5,10 ****
CREATE TABLE `ofirst_projects_tasks` ( `ID` tinyint(3) unsigned NOT NULL auto_increment, `TaskName` text, `ProjectID` tinytext, `GroupID` tinytext, `DateAssigned` text, `TarDate` text, `Description` text, `Assigned` text, `Dates` text, `Completion` tinytext, `Pend` text, PRIMARY KEY (`ID`)) TYPE=MyISAM;
INSERT INTO ofirst_config SET includes='',modulename='projects',showonmenu='0',active='0',modulenavigation='<a href="$basepath/projects/groups.php">Action Register</a> | <a href="$basepath/projects/mytask.php">My Tasks</a> | <a href="$basepath/projects/preferences.php">Preferences</a> | <a href="$basepath/projects/meetings.php">Meetings</a> | <a href="$basepath/projects/today.php">Todays Changes</a>';
! ALTER TABLE ofirst_members ADD COLUMN ProjectsFrequency tinytext
! ALTER TABLE ofirst_members ADD COLUMN ProjectsSendCountDown tinytext
ALTER TABLE ofirst_members ADD COLUMN ProjectsCommitSelect tinytext
ALTER TABLE ofirst_members ADD COLUMN ProjectsSendTemplate tinytext
--- 5,9 ----
CREATE TABLE `ofirst_projects_tasks` ( `ID` tinyint(3) unsigned NOT NULL auto_increment, `TaskName` text, `ProjectID` tinytext, `GroupID` tinytext, `DateAssigned` text, `TarDate` text, `Description` text, `Assigned` text, `Dates` text, `Completion` tinytext, `Pend` text, PRIMARY KEY (`ID`)) TYPE=MyISAM;
INSERT INTO ofirst_config SET includes='',modulename='projects',showonmenu='0',active='0',modulenavigation='<a href="$basepath/projects/groups.php">Action Register</a> | <a href="$basepath/projects/mytask.php">My Tasks</a> | <a href="$basepath/projects/preferences.php">Preferences</a> | <a href="$basepath/projects/meetings.php">Meetings</a> | <a href="$basepath/projects/today.php">Todays Changes</a>';
! ALTER TABLE ofirst_members ADD COLUMN ProjectsUpdates tinytext unsigned default 'Off'
ALTER TABLE ofirst_members ADD COLUMN ProjectsCommitSelect tinytext
ALTER TABLE ofirst_members ADD COLUMN ProjectsSendTemplate tinytext
|