[Openfirst-cvscommit] projects/setup setup.mssql,1.3,1.4 setup.mysql,1.5,1.6
Brought to you by:
xtimg
Menu
▾
▴
[Openfirst-cvscommit] projects/setup setup.mssql,1.3,1.4 setup.mysql,1.5,1.6
|
From: <dav...@us...> - 2003-10-12 23:39:55
|
Update of /cvsroot/openfirst/projects/setup In directory sc8-pr-cvs1:/tmp/cvs-serv20904/setup Modified Files: setup.mssql setup.mysql Log Message: Added new design and features to scripts. I am aware of the mysql commands that are in the module, but for the sake of documenting my work, I will upload the current versions. Index: setup.mssql =================================================================== RCS file: /cvsroot/openfirst/projects/setup/setup.mssql,v retrieving revision 1.3 retrieving revision 1.4 diff -C2 -d -r1.3 -r1.4 *** setup.mssql 10 Oct 2003 01:38:47 -0000 1.3 --- setup.mssql 12 Oct 2003 23:39:51 -0000 1.4 *************** *** 1,8 **** ! 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>',includes='projectsmodule.php'; ALTER TABLE ofirst_members ADD COLUMN ProjectsUpdates tinytext ALTER TABLE ofirst_members ADD COLUMN ProjectsCommitSelect tinytext --- 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, `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` 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 includes='',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 Index: setup.mysql =================================================================== RCS file: /cvsroot/openfirst/projects/setup/setup.mysql,v retrieving revision 1.5 retrieving revision 1.6 diff -C2 -d -r1.5 -r1.6 *** setup.mysql 10 Oct 2003 01:38:47 -0000 1.5 --- setup.mysql 12 Oct 2003 23:39:51 -0000 1.6 *************** *** 1,9 **** ! 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>',includes='projectsmodule.php'; ! ALTER TABLE ofirst_members ADD COLUMN ProjectsUpdates tinytext ! ALTER TABLE ofirst_members ADD COLUMN ProjectsCommitSelect tinytext ! ALTER TABLE ofirst_members ADD COLUMN ProjectsSendTemplate tinytext \ No newline at end of file --- 1,9 ---- ! 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, `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` 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 includes='',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; ! ALTER TABLE ofirst_members ADD COLUMN ProjectsSendTemplate tinytext; \ No newline at end of file |
