[Openfirst-cvscommit] projects/setup setup.mysql,NONE,1.1

[<dav...@us...>]

Update of /cvsroot/openfirst/projects/setup
In directory sc8-pr-cvs1:/tmp/cvs-serv3608

Added Files:
	setup.mysql 
Log Message:
initial upload

--- NEW FILE: setup.mysql ---
CREATE TABLE `ofirst_projects_groups` (  `ID` tinyint(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` tinyint(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` tinyint(3) unsigned NOT NULL auto_increment,  `ProjectID` tinyint(8) default NULL,  `GroupID` tinyint(8) default NULL,  `TaskID` tinyint(8) default NULL,  `Description` tinytext,  `Commiter` tinytext,  `Dates` text,  PRIMARY KEY  (`ID`)) TYPE=MyISAM;
CREATE TABLE `ofirst_projects_projects` (  `ID` tinyint(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` 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