CREATE TABLE IF NOT EXISTS `form_blended` (
  `serial_fbl` INT NOT NULL AUTO_INCREMENT,
  `serial_std` INT NOT NULL,
  `serial_grd` INT NOT NULL,
  `serial_scy` INT NOT NULL,
  `require_transport_fbl` ENUM('YES', 'NO') NULL,
  `zone_transport_fbl` VARCHAR(100) NULL,
  `authorization_assistance_fbl` ENUM('YES', 'NO') NULL,
  `authorization_bio_protocols_fbl` ENUM('YES', 'NO') NULL,
  `authorization_retired_fbl` ENUM('YES', 'NO') NULL,
  `file_guardian_fbl` VARCHAR(200) NULL,
  `status_fbl` ENUM('ACTIVE', 'INACTIVE') NULL DEFAULT 'ACTIVE',
  `created_at` DATETIME NULL,
  `updated_at` DATETIME NULL,
  PRIMARY KEY (`serial_fbl`),
  INDEX `fk_form_blended_student_idx` (`serial_std` ASC),
  INDEX `fk_form_blended_guardian_idx` (`serial_grd` ASC),
  INDEX `fk_form_blended_school_year_idx` (`serial_scy` ASC),
  CONSTRAINT `fk_form_blended_student`
    FOREIGN KEY (`serial_std`)
    REFERENCES `student` (`serial_std`),
  CONSTRAINT `fk_form_blended_guardian`
    FOREIGN KEY (`serial_grd`)
    REFERENCES `guardian` (`serial_grd`),
  CONSTRAINT `fk_form_blended_school_year`
    FOREIGN KEY (`serial_scy`)
    REFERENCES `school_year` (`serial_scy`))
ENGINE = InnoDB;

ALTER TABLE `form_blended`
ADD COLUMN `type_vaccine_fbl` VARCHAR(100) NULL DEFAULT NULL AFTER `zone_transport_fbl`;

ALTER TABLE `form_blended`
ADD COLUMN `vaccine_covid_file_fbl` VARCHAR(45) NULL DEFAULT NULL AFTER `file_guardian_fbl`,
ADD COLUMN `vaccine_covid_fbl` ENUM('YES', 'NO') NULL DEFAULT NULL  AFTER `zone_transport_fbl`;

ALTER TABLE `form_blended`
ADD COLUMN `modality_fbl` VARCHAR(100) NULL DEFAULT NULL AFTER `serial_scy`,
ADD COLUMN `main_street_fbl` VARCHAR(100) NULL DEFAULT NULL AFTER `require_transport_fbl`,
ADD COLUMN `second_street_fbl` VARCHAR(100) NULL DEFAULT NULL AFTER `main_street_fbl`,
ADD COLUMN `require_lunch_fbl` ENUM('YES', 'NO') NULL AFTER `zone_transport_fbl`;

insert into process(serial_prc,prc_serial_prc, name_prc, link_prc, weight_prc, status_prc, id_exclusion)
values (816,null,'Semi Presencial','#',3.25,'LOCKABLE', null);


insert into process(serial_prc,prc_serial_prc, name_prc, link_prc, weight_prc, status_prc, id_exclusion)
values (817,816,'Formulario Semi Presencial','laravel/public/blendedForm',3.25,'LOCKABLE', null);

insert into allowed_pages_by_process values(817,'blendedcontroller@getindex');
insert into allowed_pages_by_process values(817,'blendedcontroller@validatePhoto');
insert into allowed_pages_by_process values(817,'blendedcontroller@postOpenForm');
insert into allowed_pages_by_process values(817,'blendedcontroller@postsaveform');

insert into process(serial_prc,prc_serial_prc, name_prc, link_prc, weight_prc, status_prc, id_exclusion)
values (833,816,'Documentos Presencial','laravel/public/blendedDocument',6.00,'LOCKABLE', null);

insert into allowed_pages_by_process values(817,'blendeddocumentcontroller@getindex');
insert into allowed_pages_by_process values(817,'blendeddocumentcontroller@getstudents');

select * from process;