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;