ALTER TABLE `school_year` 
ADD COLUMN `enable_travel_scy` ENUM('YES', 'NO') NOT NULL DEFAULT 'NO' AFTER `project_allowed_scy`;


ALTER TABLE `student_year` 
ADD COLUMN `last_time_trv` ENUM('YES', 'NO') NULL DEFAULT NULL AFTER `authorize_departure_pedagogy`,
ADD COLUMN `turn` ENUM('MORNING', 'LATE') NULL DEFAULT NULL AFTER `last_time_trv`;


CREATE TABLE `wizard_travel_student` (
  `serial_wts` INT NOT NULL AUTO_INCREMENT,
  `serial_std` INT NULL,
  `serial_scy` INT NULL,
  `finalize_wts` ENUM('YES', 'NO') NULL,
  `date_wts` DATETIME NULL,
  `observation_wts` TEXT NULL,
  `status_wts` ENUM('ACTIVE', 'INACTIVE') NULL,
  PRIMARY KEY (`serial_wts`),
  INDEX `fk_wts_std_idx` (`serial_std` ASC),
  INDEX `fk_wts_scy_idx` (`serial_scy` ASC),
  CONSTRAINT `fk_wts_std`
    FOREIGN KEY (`serial_std`)
    REFERENCES `student` (`serial_std`)
    ON DELETE NO ACTION
    ON UPDATE NO ACTION,
  CONSTRAINT `fk_wts_scy`
    FOREIGN KEY (`serial_scy`)
    REFERENCES `school_year` (`serial_scy`)
    ON DELETE NO ACTION
    ON UPDATE NO ACTION);

	ALTER TABLE `wizard_travel_student` 
ADD COLUMN `aproved` ENUM('YES', 'NO') NULL DEFAULT NULL AFTER `observation_wts`;

	
	-- proceso  verificar serial_prc
	INSERT INTO `process` (`serial_prc`, `prc_serial_prc`, `name_prc`, `link_prc`, `weight_prc`, `status_prc`) VALUES ('505', '52', 'Actualización de transporte', 'laravel/public/wizardTravel', '40.91', 'LOCKABLE');
	insert into allowed_pages_by_process values(505,'travelwizardcontroller@getindex');
insert into allowed_pages_by_process values(505,'travelwizardcontroller@postpaymenttravel');
insert into allowed_pages_by_process values(505,'travelwizardcontroller@postsave');

