CREATE TABLE IF NOT EXISTS `work_return_form` (
  `serial_wrf` INT NOT NULL AUTO_INCREMENT,
  `serial_emp` INT NOT NULL,
  `serial_scy` INT NOT NULL,
  `section_wrf` VARCHAR(100) NULL,
  `catastrophic_disease_wrf` ENUM('YES', 'NO') NULL,
  `medical_certificate_wrf` ENUM('YES', 'NO') NULL,
  `pregnant_wrf` ENUM('YES', 'NO') NULL,
  `gestation_weeks_wrf` VARCHAR(100) NULL,
  `test_covid_wrf` ENUM('YES', 'NO') NULL,
  `transport_wrf` VARCHAR(200) NULL,
  `fever_wrf` ENUM('YES', 'NO') NULL,
  `cough_wrf` ENUM('YES', 'NO') NULL,
  `throat_pain_wrf` ENUM('YES', 'NO') NULL,
  `respiratory_difficulty_wrf` ENUM('YES', 'NO') NULL,
  `lose_smell_taste_wrf` ENUM('YES', 'NO') NULL,
  `body_pain_wrf` ENUM('YES', 'NO') NULL,
  `skin_lesions_wrf` ENUM('YES', 'NO') NULL,
  `abdominal_pain_wrf` ENUM('YES', 'NO') NULL,
  `medical_consultation_wrf` ENUM('YES', 'NO') NULL,
  `contact_symptom_person_wrf` ENUM('YES', 'NO') NULL,
  `contact_covid_person_wrf` ENUM('YES', 'NO') NULL,
  `contact_out_person_wrf` ENUM('YES', 'NO') NULL,
  `vaccine_covid_wrf` ENUM('YES', 'NO','DISMISSAL') NULL,
  `vaccine_influenza_wrf` ENUM('YES', 'NO') NULL,
  `vaccine_pneumonia_wrf` ENUM('YES', 'NO') NULL,
  `statement_wrf` ENUM('YES', 'NO') NULL,
  `status_wrf` ENUM('ACTIVE', 'INACTIVE') NULL DEFAULT 'ACTIVE',
  `created_at` DATETIME NULL,
  `updated_at` DATETIME NULL,
  PRIMARY KEY (`serial_wrf`),
  INDEX `fk_work_return_form_employee_idx` (`serial_emp` ASC),
  INDEX `fk_work_return_form_school_year_idx` (`serial_scy` ASC),
  CONSTRAINT `fk_work_return_form_employee`
    FOREIGN KEY (`serial_emp`)
    REFERENCES `employee` (`serial_emp`),
  CONSTRAINT `fk_work_return_form_school_year`
    FOREIGN KEY (`serial_scy`)
    REFERENCES `school_year` (`serial_scy`))
ENGINE = InnoDB;

ALTER TABLE `work_return_form`
ADD COLUMN `test_covid_file_wrf` VARCHAR(100) NULL DEFAULT NULL AFTER `test_covid_wrf`,
ADD COLUMN `certificate_file_wrf` VARCHAR(100) NULL DEFAULT NULL AFTER `medical_certificate_wrf`,
ADD COLUMN `vaccine_covid_file_wrf` VARCHAR(100) NULL DEFAULT NULL AFTER `vaccine_covid_wrf`;

ALTER TABLE `work_return_form`
ADD COLUMN `type_vaccine_wrf` VARCHAR(100) NULL DEFAULT NULL AFTER `vaccine_covid_file_wrf`;

insert into process(serial_prc,prc_serial_prc, name_prc, link_prc, weight_prc, status_prc, id_exclusion)
values (820,816,'Formulario Retorno Laboral','laravel/public/workReturnForm',3.75,'LOCKABLE', null);

insert into allowed_pages_by_process values(820,'workreturnformcontroller@getindex');
insert into allowed_pages_by_process values(820,'workreturnformcontroller@validatePhoto');
insert into allowed_pages_by_process values(820,'workreturnformcontroller@postopenform');
insert into allowed_pages_by_process values(820,'workreturnformcontroller@postsaveform');

select * from process;