/** Ranjith Balachandran 26-06-2018 Onwards ***/


CREATE TABLE `attendanceSMSConfig` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `sendSMSTo` int(5) DEFAULT NULL,
  `smsContent` varchar(250) DEFAULT NULL,
  `hours` varchar(20) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB;

CREATE TABLE `attendanceSMSConfiguredBatches` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `attendanceSMSConfig_id` int(5) DEFAULT NULL,
  `course_type_id` int(5) DEFAULT NULL,
  `batches_id` int(5) DEFAULT NULL,
  `batchStartYear` int(10) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB;


/**Aswin 29-06-2018**/

CREATE TABLE `hidden_hod_batches` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `batchID` int(11) NOT NULL,
  `deptID` int(11) NOT NULL,
  `createdBy` varchar(45) DEFAULT NULL,
  `updatedBy` varchar(45) DEFAULT NULL,
  `createdDate` datetime DEFAULT NULL,
  `updatedDate` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB;

create table hidden_hod_batches (id int primary key auto_increment,batchID int not null,deptID int not null,createdBy varchar(45),updatedBy varchar(45),createdDate datetime default current_timestamp,updatedDate datetime on update current_timestamp);


/**Aswin 02-07-2018**/

alter table question_paper_pool add column question_paper_sections_id int not null;
create table question_paper_sections (id int primary key auto_increment,sectionName varchar(45) not null,subjectID int not null,createdBy int not null,createdDate datetime);

/**Aswin 04-07-2018**/

alter table question_paper_pool add column placeholder varchar(200);
create table question_paper_module_weightages (id int primary key auto_increment,weightage int not null,question_paper_module_id int not null,subjectID int not null,staffID int not null,constraint question_paper_module_c unique (question_paper_module_id,subjectID,staffID));

