ALTER TABLE `year_discount` 
ADD COLUMN `order_dsc` INT NULL AFTER `days_before_limit_ydc`;

ALTER TABLE `family_address` 
ADD COLUMN `travel_address_fma` ENUM('YES', 'NO') NULL DEFAULT 'NO' AFTER `city_fma`;


ALTER TABLE `student_address` 
ADD COLUMN `travel_address_sta` ENUM('YES', 'NO') NULL DEFAULT 'NO' AFTER `reference`;

ALTER TABLE `list` 
CHANGE COLUMN `alias_lst` `alias_lst` ENUM('ENABLEDPREPAY', 'INSURANCE', 'FINALIZE', 'ACEPTPREAPROVED', 'TRAVEL', 'SHIFT') NULL DEFAULT NULL ;

ALTER TABLE `list_student_year` 
CHANGE COLUMN `list_student_yearcol` `options_lsy` ENUM('TRANSPORTE COMPLETO', 'MEDIO TRANSPORTE', 'ENTRANCE', 'EXIT','ALL' ,'NOTRAVEL') NULL DEFAULT NULL AFTER `ip_address_lsy`;


INSERT INTO `list` (`name_lst`, `alias_lst`, `status_lst`) VALUES ('TRANSPORTE', 'TRAVEL', 'ACTIVE');
INSERT INTO `list` (`name_lst`, `alias_lst`, `status_lst`) VALUES ('TURNO', 'SHIFT', 'ACTIVE');

ALTER TABLE `list_student_year` 
CHANGE COLUMN `options_lsy` `options_lsy` ENUM('TRANSPORTE COMPLETO', 'MEDIO TRANSPORTE', 'ENTRANCE', 'EXIT', 'NOTRAVEL') NULL DEFAULT NULL ;

INSERT INTO `process` (`serial_prc`, `prc_serial_prc`, `name_prc`, `link_prc`, `status_prc`) VALUES ('662', '438', 'Wizard de transporte', 'laravel/public/update', 'LOCKABLE');

insert into allowed_pages_by_process values('662','authorizedpeoplecontroller@postauthorizedpeople');
insert into allowed_pages_by_process values('662','authorizedpeoplecontroller@postsaveauthorizedpeoplebystudent');
insert into allowed_pages_by_process values('662','authorizedpeoplecontroller@postauthorizedpeopleinfo');
insert into allowed_pages_by_process values('662','addresscontroller@getindex');
insert into allowed_pages_by_process values('662','addresscontroller@getownersaddress');
insert into allowed_pages_by_process values('662','addresscontroller@getaddresinfo');
insert into allowed_pages_by_process values('662','addresscontroller@postsavefamilyaddress');
insert into allowed_pages_by_process values('662','addresscontroller@getcheckisasignedaddress');
insert into allowed_pages_by_process values('662','transportwizardcontroller@getindex');
insert into allowed_pages_by_process values('662','transportwizardcontroller@postsave');
insert into allowed_pages_by_process values('662','travelwizardcontroller@getindex');
insert into allowed_pages_by_process values('662','travelwizardcontroller@postpaymenttravel');
insert into allowed_pages_by_process values('662','travelwizardcontroller@getwizardindex');
insert into allowed_pages_by_process values('662','travelwizardcontroller@postsavetraveladdress');
insert into allowed_pages_by_process values('662','travelwizardcontroller@postaddresoptions');
insert into allowed_pages_by_process values('662','travelwizardcontroller@checktravel');
insert into allowed_pages_by_process values('662','travelwizardcontroller@gettravel');
insert into allowed_pages_by_process values('662','travelwizardcontroller@postsavetravelstudent');
insert into allowed_pages_by_process values('662','travelwizardcontroller@gettravelasigned');
insert into allowed_pages_by_process values('662','travelwizardcontroller@postsendmail');
insert into allowed_pages_by_process values('662','updatedatacontroller@getindex');
insert into allowed_pages_by_process values('662','travelwizardcontroller@postaddresoptions');
insert into allowed_pages_by_process values('662','newaddresscontroller@getcounties');
insert into allowed_pages_by_process values('662','newaddresscontroller@getparishes');
insert into allowed_pages_by_process values('662','wizardcontroller@postsaveservicescontract');
insert into allowed_pages_by_process values('662','travelwizardcontroller@postsaveWizardtravelstudent');

ALTER TABLE `guardian_address` 
ADD COLUMN `travel_address_gda` ENUM('YES', 'NO') NULL DEFAULT 'NO' AFTER `coordinate_s`;

ALTER TABLE `authorized_persons` 
ADD COLUMN `status_aup` ENUM('ACTIVE', 'INACTIVE') NULL DEFAULT 'ACTIVE' AFTER `phone_aup`;

