ALTER TABLE `postulation_form` 
ADD COLUMN `description_pfr` TEXT NULL AFTER `end_date_pfr`,
ADD COLUMN `max_date_to_pay_pfr` DATETIME NULL AFTER `description_pfr`;

ALTER TABLE `postulation_form` 
ADD COLUMN `header_pfr` VARCHAR(200) NULL AFTER `description_pfr`;


ALTER TABLE `postulation_form_question_answer` 
ADD COLUMN `serial_usr` INT NULL AFTER `serial_pns`,
ADD INDEX `fk_applicant_form_qustion_answer_applicant_answer_usr_idx` (`serial_usr` ASC);
ALTER TABLE `postulation_form_question_answer` 
ADD CONSTRAINT `fk_applicant_form_qustion_answer_applicant_answer_usr`
  FOREIGN KEY (`serial_usr`)
  REFERENCES `user` (`serial_usr`)
  ON DELETE NO ACTION
  ON UPDATE NO ACTION;


INSERT INTO `process` (`serial_prc`, `prc_serial_prc`, `name_prc`, `link_prc`, `weight_prc`, `status_prc`) VALUES ('877', '39', 'Configuración de formulario de postulación', 'laravel/public/setuppostulation', '1', 'LOCKABLE');
insert into allowed_pages_by_process values(877,'setuppostulationformcontroller@getindex');
insert into allowed_pages_by_process values(877,'setuppostulationformcontroller@postforms');
insert into allowed_pages_by_process values(877,'setuppostulationformcontroller@getform');
insert into allowed_pages_by_process values(877,'setuppostulationformcontroller@postsave');
insert into allowed_pages_by_process values(877,'setuppostulationformcontroller@postsaveimage');
insert into allowed_pages_by_process values(877,'setuppostulationformcontroller@getnewform');
insert into allowed_pages_by_process values(877,'setuppostulationformcontroller@postsavenewform');
insert into allowed_pages_by_process values(877,'postulationanswercontroller@getpostulationanswers');
insert into allowed_pages_by_process values(877,'postulationanswercontroller@postpostulationanswers');
insert into allowed_pages_by_process values(877,'postulationanswercontroller@getpostulationanswerinfo');
insert into allowed_pages_by_process values(877,'postulationanswercontroller@postsave');
insert into allowed_pages_by_process values(877,'postulationformquestionanswercontroller@getpostulationformquestionanswers');
insert into allowed_pages_by_process values(877,'postulationformquestionanswercontroller@getpostulationformquestionanswerinfo');
insert into allowed_pages_by_process values(877,'postulationformquestionanswercontroller@postsave');
insert into allowed_pages_by_process values(877,'postulationformquestionanswercontroller@postremoveanswer');
insert into allowed_pages_by_process values(877,'postulationformquestionanswercontroller@postchangetypepoq');
insert into allowed_pages_by_process values(877,'postulationformquestionanswercontroller@postaddquestions');
insert into allowed_pages_by_process values(877,'postulationquestioncontroller@getpostulationquestions');
insert into allowed_pages_by_process values(877,'postulationquestioncontroller@postpostulationquestions');
insert into allowed_pages_by_process values(877,'postulationquestioncontroller@getpostulationquestioninfo');
insert into allowed_pages_by_process values(877,'postulationquestioncontroller@postsave');

ALTER TABLE `school_year` 
ADD COLUMN `automatic_billing_scy` ENUM('YES', 'NO') NULL DEFAULT 'YES' AFTER `schedule_register_text_scy`;

ALTER TABLE `postulation_form` 
ADD COLUMN `automatic_billing_pfr` ENUM('YES', 'NO') NULL DEFAULT 'YES' AFTER `text_email_rejected_pfr`;

insert into allowed_pages_by_process values('870','postulantadmincontroller@getdelete');
insert into allowed_pages_by_process values('870','postulantadmincontroller@postdelete');
insert into allowed_pages_by_process values('866','insciptionschoolyearcontroller@getcopy');
insert into allowed_pages_by_process values('866','insciptionschoolyearcontroller@postcopy');
insert into allowed_pages_by_process values('866','insciptionschoolyearcontroller@getpayementsbyschooolyear');
insert into allowed_pages_by_process values('866','scheduleinscriptioncontroller@getscheduleinscription');
insert into allowed_pages_by_process values('866','scheduleinscriptioncontroller@postscheduleinscription');
insert into allowed_pages_by_process values('866','scheduleinscriptioncontroller@getscheduleinscriptioninfo');
insert into allowed_pages_by_process values('866','scheduleinscriptioncontroller@postsave');