
CREATE TABLE `courseMaterial_pseudoSubject_relation` (
  `id` INT NOT NULL AUTO_INCREMENT,
  `course_material_id` INT NULL,
  `pseudosubjects_id` INT NULL,
  PRIMARY KEY (`id`));

ALTER TABLE course_material ADD COLUMN isPseudoSubject INT DEFAULT NULL;
  
ALTER TABLE course_material CHANGE COLUMN materialDocPath materialDocPath varchar(500) DEFAULT NULL;

ALTER TABLE course_material CHANGE COLUMN materialPdfPath materialPdfPath varchar(500) DEFAULT NULL;

ALTER TABLE course_material CHANGE COLUMN materialImgPath materialImgPath varchar(500) DEFAULT NULL;

ALTER TABLE course_material CHANGE COLUMN materialSwfPath materialSwfPath varchar(500) DEFAULT NULL;

ALTER TABLE exam ADD COLUMN isRoundOff INT DEFAULT 1;

ALTER TABLE opencourse_appln_initiate ADD COLUMN considerPlusTwoMarks INT DEFAULT 1;
/*Aswin 22-3-2018*/
drop table autonomous_feature_settings;
create table autonomous_feature_settings (id int primary key auto_increment,name varchar(100) not null,value tinyint(1) default 0,type varchar(100) not null,created_by varchar(100),created_date datetime default CURRENT_TIMESTAMP,updated_by varchar(100),updated_date TIMESTAMP);
insert into autonomous_feature_settings (name,value,type,created_by,updated_by) values ('REGULAR_HALL_TICKET_STUDENT_SIDE',0,'exam_controller','1','1');
alter table autonomous_feature_settings add constraint autonomous_settings unique (name,type);