ALTER TABLE `aspirant_report` 
ADD COLUMN `created_comment_1` DATETIME NULL AFTER `serial_usr1`,
ADD COLUMN `aspirant_reportcol` VARCHAR(45) NULL AFTER `serial_user2`;

ALTER TABLE `aspirant_report` 
CHANGE COLUMN `aspirant_reportcol` `update_comment_1` DATETIME NULL DEFAULT NULL AFTER `created_comment_1`;

ALTER TABLE `aspirant_report` 
CHANGE COLUMN `update_comment_1` `updatet_comment_1` DATETIME NULL DEFAULT NULL ;


ALTER TABLE `aspirant_report` 
CHANGE COLUMN `updatet_comment_1` `updated_comment_1` DATETIME NULL DEFAULT NULL ;

ALTER TABLE `aspirant_report` 
ADD COLUMN `created_comment_2` DATETIME NULL AFTER `serial_user2`,
ADD COLUMN `updated_comment_2` DATETIME NULL AFTER `created_comment_2`;


ALTER TABLE `aspirant_student` 
ADD COLUMN `date_appliction_status` DATETIME NULL AFTER `Application_status`;

ALTER TABLE `employee_section` 
CHANGE COLUMN `type_user` `type_user` ENUM('DIRECTOR', 'ASSISTANT', 'USER', 'TRANSPORTATION_COORDINATOR', 'SECRETARY', 'JUSTIFICATION_COORDINATOR', 'DESTINATION_MAIL_FATHER_ADMISSION', 'APPLICANT_STUDENT_APPROVER', 'EMAIL_ADMISSION_REPORT_GRADES','EMAIL_ADMISSION_PROCEED_TO_TEST','EMAIL_ADMISSION_PROCEED_TO_INTERVIEW','EMAIL_ADMISSION_REPORT_INTERVIEW') CHARACTER SET 'utf8' COLLATE 'utf8_unicode_ci' NULL DEFAULT 'TRANSPORTATION_COORDINATOR' ;

ALTER TABLE `aspirant_student` 
ADD COLUMN `proceeds_to_test` ENUM('YES', 'NO') NULL DEFAULT 'NO' AFTER `payment_mode`;


ALTER TABLE `aspirant_student` 
CHANGE COLUMN `proceeds_to_test` `proceeds_to_test_astu` ENUM('YES', 'NO') NULL DEFAULT 'NO' ,
ADD COLUMN `serial_usr_proceeds_test_astu` INT NULL AFTER `proceeds_to_test_astu`,
ADD INDEX `fk_serial_usr_to_test_idx` (`serial_usr_proceeds_test_astu` ASC);
ALTER TABLE `aspirant_student` 
ADD CONSTRAINT `fk_serial_usr_to_test`
  FOREIGN KEY (`serial_usr_proceeds_test_astu`)
  REFERENCES `user` (`serial_usr`)
  ON DELETE NO ACTION
  ON UPDATE NO ACTION;

  ALTER TABLE `aspirant_student` 
ADD COLUMN `date_proceeds_to_test_astu` DATETIME NULL AFTER `serial_usr_proceeds_test_astu`;


ALTER TABLE `aspirant_student` 
ADD COLUMN `proceeds_to_interview_astu` ENUM('YES', 'NO') NULL DEFAULT 'NO' AFTER `date_proceeds_to_test_astu`,
ADD COLUMN `date_proceeds_to_interview_astu` DATETIME NULL AFTER `proceeds_to_interview_astu`,
ADD COLUMN `serial_usr_proceeds_interview_astu` INT NULL AFTER `date_proceeds_to_interview_astu`;


ALTER TABLE `aspirant_student` 
ADD INDEX `fk_serial_usr_to_interview_idx` (`serial_usr_proceeds_interview_astu` ASC);
ALTER TABLE `aspirant_student` 
ADD CONSTRAINT `fk_serial_usr_to_interview`
  FOREIGN KEY (`serial_usr_proceeds_interview_astu`)
  REFERENCES `user` (`serial_usr`)
  ON DELETE NO ACTION
  ON UPDATE NO ACTION;

