
INSERT INTO `list` (`name_lst`, `alias_lst`, `status_lst`) VALUES ('ACEPTA PREAPROBAR ESTUDIANTES', 'ACEPTPREAPROVED', 'ACTIVE');

INSERT INTO `process` (`serial_prc`, `prc_serial_prc`, `name_prc`, `link_prc`, `status_prc`) VALUES ('654', '627', 'Reserva de cupos', 'laravel/public/wizardQuota', 'LOCKABLE');

insert into allowed_pages_by_process values('654','wizardpreregistrationcontroller@getindex');
insert into allowed_pages_by_process values('654','wizardpreregistrationcontroller@poststudentsquota');
insert into allowed_pages_by_process values('654','wizardpreregistrationcontroller@postsavequota');
insert into allowed_pages_by_process values('654','wizardpreregistrationcontroller@postreviewquota');
insert into allowed_pages_by_process values('654','wizardpreregistrationcontroller@postpreaprubedstudents');
insert into allowed_pages_by_process values('654','wizardpreregistrationcontroller@postsavepreaprovedstudents');
insert into allowed_pages_by_process values('654','wizardpreregistrationcontroller@postreport');
insert into allowed_pages_by_process values('654','wizardpreregistrationcontroller@postreportno');
insert into allowed_pages_by_process values('654','wizardpreregistrationcontroller@postreportcontractno');
insert into allowed_pages_by_process values('654','wizardpreregistrationcontroller@postreportpreaprovedsayno');
insert into allowed_pages_by_process values('654','wizardpreregistrationcontroller@postreportpreaprovedsayyes');
insert into allowed_pages_by_process values('654','wizardpreregistrationcontroller@postreportblacklist');
insert into allowed_pages_by_process values('654','wizardpreregistrationcontroller@postsendmailno');
insert into allowed_pages_by_process values('654','wizardpreregistrationcontroller@postsendmailblacklist');
insert into allowed_pages_by_process values('654','wizardpreregistrationcontroller@postsendmailnocontract');
insert into allowed_pages_by_process values('654','wizardpreregistrationcontroller@postsendmailpreapruvedStdents');
insert into allowed_pages_by_process values('654','wizardpreregistrationcontroller@postsendmailnopreapruvedstudents');
insert into allowed_pages_by_process values('654','wizardcontroller@postSaveServicesContract');


ALTER TABLE `wizard_document_guardian_authorize` 
ADD COLUMN `ip_address_wdg` VARCHAR(45) NULL AFTER `date_wdg`,
ADD COLUMN `wizard_document_guardian_authorizecol` VARCHAR(45) NULL AFTER `status_wdg`;

ALTER TABLE `list_student_year` 
ADD COLUMN `ip_address_lsy` VARCHAR(45) NULL AFTER `acept_lsy`,
ADD COLUMN `list_student_yearcol` VARCHAR(45) NULL AFTER `status_lsy`;

