Viewing file: upgradeEassess16Oct2551.sql (2.16 KB) -rw-r--r-- Select action/file-type: (+) | (+) | (+) | Code (+) | Session (+) | (+) | SDB (+) | (+) | (+) | (+) | (+) | (+) |
SET NAMES 'tis620';
USE eassess;
CREATE TABLE `SysStudyTypeAssess` (
`sstId` int(11) NOT NULL default '0',
`sstName` varchar(20) NOT NULL default '',
`sstNameEng` varchar(20) NOT NULL default '',
`sstAbbr` varchar(5) NOT NULL default '',
`sstAbbrEng` varchar(5) NOT NULL default '',
PRIMARY KEY (`sstId`)
) ENGINE=InnoDB DEFAULT CHARSET=tis620;
CREATE TABLE `TimeTableAssess` (
`ttId` int(11) NOT NULL default '0',
`ttClId` int(11) NOT NULL default '0',
`ttMainPlace` varchar(255) NOT NULL default '',
`ttSubPlace` varchar(255) NOT NULL default '',
`ttFlagPlace` int(2) NOT NULL default '0',
`ttWdAcYWeekNo` int(11) NOT NULL default '0',
`ttDyId` int(11) NOT NULL default '0',
`ttFrPr` int(11) NOT NULL default '0',
`ttToPr` int(11) NOT NULL default '0',
`ttOfId` int(11) NOT NULL default '0',
`ttSstId` int(11) NOT NULL default '0',
`ttTitle` varchar(255) NOT NULL default '',
PRIMARY KEY (`ttId`),
KEY `ttClId` (`ttClId`),
KEY `ttDyId` (`ttDyId`),
KEY `ttFrPr` (`ttFrPr`),
KEY `ttToPr` (`ttToPr`),
KEY `ttOfId` (`ttOfId`),
KEY `ttSstId` (`ttSstId`)
) ENGINE=InnoDB DEFAULT CHARSET=tis620;
CREATE TABLE `WeekDateAssess` (
`wdAcY` int(4) NOT NULL default '0',
`wdAcYWeekNo` int(11) NOT NULL default '0',
`wdTmId` int(1) NOT NULL default '0',
`wdTmWeekNo` int(11) NOT NULL default '0',
`wdFrDate` date NOT NULL default '0000-00-00',
`wdToDate` date NOT NULL default '0000-00-00',
PRIMARY KEY (`wdAcY`,`wdAcYWeekNo`)
) ENGINE=InnoDB DEFAULT CHARSET=tis620;
ALTER TABLE `ClassAssess` ADD `officerId` INT(11) DEFAULT '0' NOT NULL;
ALTER TABLE `HoldCourseTmp` ADD `ttId` INT(11) DEFAULT '0' NULL;
ALTER TABLE `HoldCourse` ADD `ttId` INT(11) DEFAULT '0' NULL;
ALTER TABLE `DoAssessment` ADD `ttId` INT(11) DEFAULT '0' NOT NULL;
ALTER TABLE `DefineAssessment` ADD `isPreAssess` BINARY DEFAULT '0' NOT NULL;
ALTER TABLE `HoldCourseTmp` ADD `officerId` INT(11) DEFAULT '0' NULL;
ALTER TABLE `HoldCourse` ADD `officerId` INT(11) DEFAULT '0' NULL;
-- 7Nov2551
ALTER TABLE `FileUpdate` CHANGE `filename1` `filename1` VARCHAR( 255 ) NULL ,
CHANGE `filename2` `filename2` VARCHAR( 255 ) NULL;
|