ALTER TABLE `studentaccount` 
ADD COLUMN `aadhaar_no` VARCHAR(45) NULL DEFAULT NULL AFTER `annualIncome`;

CREATE TABLE sd_relation(
id int(11) NOT NULL AUTO_INCREMENT PRIMARY KEY,
subjectID INT(8) DEFAULT NULL,
deptID INT(8) DEFAULT NULL,
createdBy INT(8) NOT NULL,
updatedBy INT(8) NOT NULL,
createdDate date NOT NULL,
updatedDate date NOT NULL,
KEY subjectID (subjectID), 
KEY deptID (deptID)
) ENGINE=INNODB;

CREATE TABLE subject_sem_relation ( 
id int(11) NOT NULL AUTO_INCREMENT, 
subjectID int(11) NOT NULL, 
semID int(11) NOT NULL, 
created_by int(11) NOT NULL, 
created_date datetime NOT NULL, 
updated_by int(11) NOT NULL, 
updated_date datetime NOT NULL, 
PRIMARY KEY (id) 
) ENGINE=InnoDB;

ALTER TABLE subjects ADD COLUMN isSubjectHide INT DEFAULT 0;