ALTER TABLE `aspirant_guardian` 
ADD COLUMN `graduate_degree1_asgu` VARCHAR(45) NULL DEFAULT NULL AFTER `university_degree_asgu`,
ADD COLUMN `university_degree1_asgu` VARCHAR(45) NULL DEFAULT NULL AFTER `graduate_degree1_asgu`;
ALTER TABLE `aspirant_guardian`
ADD COLUMN `exstudent` ENUM('YES', 'NO') NOT NULL DEFAULT 'NO';


ALTER TABLE `aspirant_student` 
ADD COLUMN `status_asstu` ENUM('ACTIVE', 'INACTIVE') NULL DEFAULT 'ACTIVE';


insert into process(serial_prc,prc_serial_prc,name_prc,link_prc,weight_prc)values
(664,(select prc.serial_prc from process prc where name_prc like '%Proceso de admisiones%'),'Inactivar Aspirante','laravel/public/Admission/inactive-aspirant',11.00);

insert into allowed_pages_by_process(serial_prc,url_dsc) values
(664,'admissioncontroller@getinactiveaspirant'),
(664,'admissioncontroller@postaspirantsbyschoolyear'),
(664,'admissioncontroller@postinactiveaspirant');

