/* Ranjith Balachandran july 18 2018 */

ALTER TABLE pattern_deptcourses ADD COLUMN patternAbbreviation varchar(50) DEFAULT NULL;

CREATE TABLE `supplyMarkRoundOffConfig` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `courseTypeId` int(5) DEFAULT NULL,
  `batchStartYear` varchar(50) DEFAULT NULL,
  `semId` int(5) DEFAULT NULL,
  `isRoundOff` int(5) DEFAULT 1,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB;

ALTER TABLE `pg_admission_admit_student_inbranch`
CHANGE COLUMN `admissionNo` `admissionNo` VARCHAR(30) NULL DEFAULT NULL ;


/*Aswin 20-07-2018*/
create table exam_notification (id int primary key auto_increment,instructions longtext not null,examRegId int,examSupplyId int,examRevalId int);


/** Ranjith Balachandran 26-07-2018 **/


CREATE TABLE `cancellation_prefix` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`campus_typeID` int(11) NOT NULL,
`fromDate` date NOT NULL,
`toDate` date NOT NULL,
`prefix` varchar(20) NOT NULL,
`prefixYear` varchar(20) DEFAULT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `campus_typeID` (`campus_typeID`,`fromDate`,`toDate`),
CONSTRAINT `cancel_prefix_ibfk_1` FOREIGN KEY (`campus_typeID`) REFERENCES `campus_type` (`id`) ON UPDATE CASCADE
) ENGINE=InnoDB;

CREATE TABLE `studentCancellationCertificateNo` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `studentaccount_id` int(10) DEFAULT NULL,
  `cancellationCertificateNo` int(10) DEFAULT NULL,
  `cancellation_prefix_id` int(10) DEFAULT NULL,
  `is_deleted` int(10) DEFAULT '0',
  PRIMARY KEY (`id`),
  UNIQUE KEY `studentCcNoUnique` (`studentaccount_id`,`cancellationCertificateNo`)
) ENGINE=InnoDB;


/***kishan july 27, 2018 ***********/
ALTER TABLE `pg_admission_management_students` 
CHANGE COLUMN `admissionNo` `admissionNo` VARCHAR(30) NULL DEFAULT NULL ;

ALTER TABLE `pg_admission_admit_weightage_student_inbranch` 
CHANGE COLUMN `admissionNo` `admissionNo` VARCHAR(30) NULL DEFAULT NULL ;




