[Openfirst-cvscommit] projects/setup setup.mssql,1.1,1.2
Brought to you by:
xtimg
From: <dav...@us...> - 2003-10-03 02:16:12
|
Update of /cvsroot/openfirst/projects/setup In directory sc8-pr-cvs1:/tmp/cvs-serv24020/setup Modified Files: setup.mssql Log Message: Fixed mssql script to be the same as the mysql setup script. Index: setup.mssql =================================================================== RCS file: /cvsroot/openfirst/projects/setup/setup.mssql,v retrieving revision 1.1 retrieving revision 1.2 diff -C2 -d -r1.1 -r1.2 *** setup.mssql 30 Aug 2003 00:04:02 -0000 1.1 --- setup.mssql 3 Oct 2003 02:15:46 -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 ALTER TABLE ofirst_members ADD COLUMN ProjectsCommitSelect tinytext ALTER TABLE ofirst_members ADD COLUMN ProjectsSendTemplate tinytext |