ALTER TABLE `dates_to_current_payments` 
ENGINE = InnoDB ,
ADD COLUMN `serial_pcg` INT NULL AFTER `serial_dts`;

ALTER TABLE `dates_to_current_payments` 
ADD INDEX `fk_dts_pcg_idx` (`serial_pcg` ASC);
ALTER TABLE `dates_to_current_payments` 
ADD CONSTRAINT `fk_dts_scy`
  FOREIGN KEY (`serial_scy`)
  REFERENCES `school_year` (`serial_scy`)
  ON DELETE NO ACTION
  ON UPDATE NO ACTION,
ADD CONSTRAINT `fk_dts_pcg`
  FOREIGN KEY (`serial_pcg`)
  REFERENCES `payment_concept_group` (`serial_pcg`)
  ON DELETE NO ACTION
  ON UPDATE NO ACTION;


ALTER TABLE `student_year` 
ADD COLUMN `travel_month` SET('Sep', 'Oct', 'Nov', 'Dec', 'Jan', 'Feb', 'Mar', 'Apr', 'May', 'Jun') NULL DEFAULT 'Sep,Oct,Nov,Dec,Jan,Feb,Mar,Apr,May,Jun' AFTER `date_tuition_paid`;

ALTER TABLE `student_year` 
CHANGE COLUMN `travel_month` `travel_month_sty` SET('Sep', 'Oct', 'Nov', 'Dec', 'Jan', 'Feb', 'Mar', 'Apr', 'May', 'Jun') NULL DEFAULT 'Sep,Oct,Nov,Dec,Jan,Feb,Mar,Apr,May,Jun' ;

ALTER TABLE `dates_to_current_payments` 
ADD COLUMN `month_dts` ENUM('Sep', 'Oct', 'Nov', 'Dec', 'Jan', 'Feb', 'Mar', 'Apr', 'May', 'Jun') NULL AFTER `month_to_pay_dts`;


ALTER TABLE `student_transfer` 
ENGINE = InnoDB ,
ADD COLUMN `serial_ypc` INT NULL AFTER `serial_std`,
ADD COLUMN `serial_dts` INT NULL AFTER `serial_ypc`;



  
  ALTER TABLE `student_transfer` 
ADD INDEX `fk_serial_stt_ypc_idx` (`serial_ypc` ASC),
ADD INDEX `fk_serial_stt_dts_idx` (`serial_dts` ASC);
ALTER TABLE `student_transfer` 
ADD CONSTRAINT `fk_serial_stt_ypc`
  FOREIGN KEY (`serial_ypc`)
  REFERENCES `year_level_specialty_payment_concept` (`serial_ypc`)
  ON DELETE NO ACTION
  ON UPDATE NO ACTION,
ADD CONSTRAINT `fk_serial_stt_dts`
  FOREIGN KEY (`serial_dts`)
  REFERENCES `dates_to_current_payments` (`serial_dts`)
  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 ('835', '402', 'Trasporte por estudiante', 'laravel/public/reportTravelPaymentStatus', '1.00', 'LOCKABLE');
  insert into allowed_pages_by_process values(835,'reporttravelpaymentconceptscontroller@getindex');
insert into allowed_pages_by_process values(835,'reporttravelpaymentconceptscontroller@getinvoicemonth');
insert into allowed_pages_by_process values(835,'reporttravelpaymentconceptscontroller@getpaymentconceptgroups');
insert into allowed_pages_by_process values(835,'reporttravelpaymentconceptscontroller@postcompletereport');
  

