/**
 * @author Aswin
 */
ALTER TABLE `supplyexam_publishresult` 
ADD COLUMN `fromDate` DATE NULL AFTER `semID`,
ADD COLUMN `toDate` DATE NULL AFTER `fromDate`;


ALTER TABLE `exam_revaluation` 
ADD COLUMN `fromDate` DATE NULL AFTER `published`,
ADD COLUMN `toDate` DATE NULL AFTER `fromDate`;


/*@author Aswin*/
CREATE TABLE `supply_improve_batches` (
  `id` INT NOT NULL AUTO_INCREMENT,
  `batchID` INT NULL,
  `exam_supplementary_id` INT NULL,
  PRIMARY KEY (`id`));
  
  ALTER TABLE `supply_improve_batches` 
ADD COLUMN `current_semID` INT NULL AFTER `exam_supplementary_id`;


CREATE TABLE `autonomous_feature_settings` (
  `id` INT NOT NULL AUTO_INCREMENT,
  `enable_regular_exam_hall_ticket_student_side` INT NULL DEFAULT 0,
  PRIMARY KEY (`id`));


  
 INSERT INTO autonomous_feature_settings (enable_regular_exam_hall_ticket_student_side) VALUES (1);


ALTER TABLE dynamicform_initiate ADD COLUMN needAcknowledgement INT DEFAULT 1;

  
ALTER TABLE supply_improve_batches
ADD CONSTRAINT batch_supple_unique UNIQUE (batchID,exam_supplementary_id,current_semID);
