[Openfirst-cvscommit] projects/setup setup.mssql,1.11,1.12 setup.mysql,1.10,1.11
Brought to you by:
xtimg
Menu
▾
▴
[Openfirst-cvscommit] projects/setup setup.mssql,1.11,1.12 setup.mysql,1.10,1.11
|
From: <dav...@us...> - 2003-11-23 22:17:30
|
Update of /cvsroot/openfirst/projects/setup In directory sc8-pr-cvs1:/tmp/cvs-serv1133 Modified Files: setup.mssql setup.mysql Log Message: Changed the description box to be text to store more data rather than limiting it. Index: setup.mssql =================================================================== RCS file: /cvsroot/openfirst/projects/setup/setup.mssql,v retrieving revision 1.11 retrieving revision 1.12 diff -C2 -d -r1.11 -r1.12 *** setup.mssql 23 Nov 2003 15:00:58 -0000 1.11 --- setup.mssql 23 Nov 2003 22:17:27 -0000 1.12 *************** *** 1,5 **** 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` 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; --- 1,5 ---- 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; Index: setup.mysql =================================================================== RCS file: /cvsroot/openfirst/projects/setup/setup.mysql,v retrieving revision 1.10 retrieving revision 1.11 diff -C2 -d -r1.10 -r1.11 *** setup.mysql 23 Nov 2003 15:00:58 -0000 1.10 --- setup.mysql 23 Nov 2003 22:17:27 -0000 1.11 *************** *** 1,5 **** 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` 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; --- 1,5 ---- 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; |
