/************SUJESH.T 17/10/2017**************************/


ALTER TABLE `exam_registration` 
ADD COLUMN `simage` INT(11) NULL DEFAULT 1 AFTER `shortCourse`,
ADD COLUMN `pimage` INT(11) NULL DEFAULT 1 AFTER `simage`;


ALTER TABLE `exam_supplementary` 
ADD COLUMN `pimage` INT(11) NULL DEFAULT 0 AFTER `examYear`,
ADD COLUMN `simage` INT(11) NULL DEFAULT 0 AFTER `pimage`;



CREATE TABLE `batch_timetable_date` (
  `Id` INT(11) NOT NULL AUTO_INCREMENT,
  `batchId` INT(11) NOT NULL,
  `subjectId` INT(11) NOT NULL,
  `dayId` INT(11) NOT NULL,
  `hourId` INT(11) NOT NULL,
  `semId` INT(11) NOT NULL,
  `sbsId` INT(11) NULL DEFAULT NULL,
  `is_allowed` TINYINT(4) NULL DEFAULT 0,
  `stratTime` VARCHAR(256) NULL DEFAULT NULL,
  `endTime` VARCHAR(256) NULL DEFAULT NULL,
  `date` DATE NULL,
  PRIMARY KEY (`Id`));



/*******************KISHAN oct 19,2017 *********************/
ALTER TABLE studentaccount CHANGE COLUMN studentSignImage studentSignImage VARCHAR (250) DEFAULT NULL;
