ALTER TABLE `report_card` 
ADD COLUMN `description_rcd` TEXT NULL AFTER `name_rcd`,
ADD COLUMN `type_rcd` ENUM('SUBPERIOD', 'PERIOD', 'FINAL', 'MINISTRY_PERIOD', 'MINISTRY_FINAL', 'MINISTRY_AVERAGE_PERIOD','PAI') NULL AFTER `description_rcd`;
ALTER TABLE `report_card`
CHANGE COLUMN `type_rcd` `type_rcd` ENUM('SUBPERIOD', 'PERIOD', 'FINAL', 'MINISTRY_PERIOD', 'MINISTRY_FINAL', 'MINISTRY_AVERAGE_PERIOD', 'PAI', 'REGISTRATION_CERT', 'PROMOTION', 'COMPLETION_EGB', 'APTITUDE') NULL DEFAULT NULL ;



ALTER TABLE `level_section_year_report_card` 
CHANGE COLUMN `type_lrc` `type_lrc` ENUM('SUBPERIOD', 'PERIOD', 'YEAR', 'PAI') NULL DEFAULT NULL ;

ALTER TABLE `level_section_year_report_card`
CHANGE COLUMN `type_lrc` `type_lrc` ENUM('SUBPERIOD', 'PERIOD', 'FINAL', 'MINISTRY_PERIOD', 'MINISTRY_FINAL', 'MINISTRY_AVERAGE_PERIOD', 'PAI', 'REGISTRATION_CERT', 'PROMOTION', 'COMPLETION_EGB', 'APTITUDE') NULL DEFAULT NULL ;


insert into allowed_pages_by_process values ((select serial_prc from process where link_prc ='laravel/public/gradeReport' order by serial_prc limit 1),'methodsgradereporcontroller@postpaireportcard' );
insert into allowed_pages_by_process values ((select serial_prc from process where link_prc ='laravel/public/gradeReport' order by serial_prc desc limit 1),'methodsgradereporcontroller@postpaireportcard' );
insert into allowed_pages_by_process values ((select serial_prc from process where link_prc ='laravel/public/gradeReport' order by serial_prc desc limit 1),'methodsgradereporcontroller@postguardianreport' );

INSERT INTO `process` (`serial_prc`, `prc_serial_prc`, `name_prc`, `link_prc`, `weight_prc`, `status_prc`) VALUES ('653', '199', 'Configuración de libretas', 'laravel/public/reportCard', '1.00', 'LOCKABLE');

insert into allowed_pages_by_process values(653,'reportcardcotroller@getindex');
insert into allowed_pages_by_process values(653,'reportcardcotroller@getindexinfo');
insert into allowed_pages_by_process values(653,'reportcardcotroller@getinfo');
insert into allowed_pages_by_process values(653,'reportcardcotroller@postsave');
insert into allowed_pages_by_process values(653,'reportcardcotroller@getfile');
insert into allowed_pages_by_process values(653,'reportcardcotroller@getconfiguration');
insert into allowed_pages_by_process values(653,'reportcardcotroller@postloadlevels');
insert into allowed_pages_by_process values(653,'reportcardcotroller@postsavelevelreportcard');
insert into allowed_pages_by_process values(653,'reportcardcotroller@getinfobyschoolyear');