Update of /cvsroot/openfirst/projects/setup
In directory sc8-pr-cvs1:/tmp/cvs-serv14504/setup
Modified Files:
setup.mssql
Log Message:
Moving meetings planner into its own module, therefore I am removing these command setups.
Index: setup.mssql
===================================================================
RCS file: /cvsroot/openfirst/projects/setup/setup.mssql,v
retrieving revision 1.7
retrieving revision 1.8
diff -C2 -d -r1.7 -r1.8
*** setup.mssql 1 Nov 2003 16:46:32 -0000 1.7
--- setup.mssql 1 Nov 2003 17:15:23 -0000 1.8
***************
*** 1,8 ****
CREATE TABLE `ofirst_projects_groups` ( `ID` int(3) unsigned NOT NULL auto_increment, `GroupName` tinytext, `Description` text, `Moderators` tinytext, `Members` tinytext, `Dates` text, PRIMARY KEY (`ID`)) TYPE=MyISAM;
- CREATE TABLE `ofirst_projects_meetings` ( `ID` int(3) unsigned NOT NULL auto_increment, `Dates` text, `ForDate` text, `Description` text, `ArrangedFor` text, `AbsentList` text, `Notes` text, `Status` text, PRIMARY KEY (`ID`)) TYPE=MyISAM;
CREATE TABLE `ofirst_projects_notes` ( `ID` int(3) unsigned NOT NULL auto_increment, `ProjectID` tinyint(8) default NULL, `AttachedFile` blob, `mime` text, `GroupID` tinyint(8) default NULL, `TaskID` tinyint(8) default NULL, `Description` text, `Commiter` tinytext, `Dates` text, PRIMARY KEY (`ID`)) TYPE=MyISAM;
CREATE TABLE `ofirst_projects_projects` ( `ID` int(3) unsigned NOT NULL auto_increment, `ProjectName` tinytext, `GroupID` tinyint(3) default '0', `Completion` tinytext, `Description` text, `Assigned` text, `TarDate` text, `Dates` text, `Pend` tinytext, PRIMARY KEY (`ID`)) TYPE=MyISAM;
CREATE TABLE `ofirst_projects_tasks` ( `ID` int(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 modulename='projects',showonmenu='0',active='0',adminnavigation='<a href="$basepath/projects/admin/updatesetup.php">Update Service Setup</a>',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>',includes='projectsmodule.php';
ALTER TABLE ofirst_members ADD COLUMN ProjectsUpdates tinytext
ALTER TABLE ofirst_members ADD COLUMN ProjectsCommitSelect tinytext
--- 1,7 ----
CREATE TABLE `ofirst_projects_groups` ( `ID` int(3) unsigned NOT NULL auto_increment, `GroupName` tinytext, `Description` text, `Moderators` tinytext, `Members` tinytext, `Dates` text, PRIMARY KEY (`ID`)) TYPE=MyISAM;
CREATE TABLE `ofirst_projects_notes` ( `ID` int(3) unsigned NOT NULL auto_increment, `ProjectID` tinyint(8) default NULL, `AttachedFile` blob, `mime` text, `GroupID` tinyint(8) default NULL, `TaskID` tinyint(8) default NULL, `Description` text, `Commiter` tinytext, `Dates` text, PRIMARY KEY (`ID`)) TYPE=MyISAM;
CREATE TABLE `ofirst_projects_projects` ( `ID` int(3) unsigned NOT NULL auto_increment, `ProjectName` tinytext, `GroupID` tinyint(3) default '0', `Completion` tinytext, `Description` text, `Assigned` text, `TarDate` text, `Dates` text, `Pend` tinytext, PRIMARY KEY (`ID`)) TYPE=MyISAM;
CREATE TABLE `ofirst_projects_tasks` ( `ID` int(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 modulename='projects',showonmenu='0',active='0',adminnavigation='<a href="$basepath/projects/admin/updatesetup.php">Update Service Setup</a>',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/today.php">Todays Changes</a>',includes='projectsmodule.php';
ALTER TABLE ofirst_members ADD COLUMN ProjectsUpdates tinytext
ALTER TABLE ofirst_members ADD COLUMN ProjectsCommitSelect tinytext
|
