-- allowed_pages_by_process para pai y project anual
insert into allowed_pages_by_process values(364,'gradecriteriacontroller@getPaievaluationYear');
insert into allowed_pages_by_process values(364,'gradecriteriacontroller@postPaievaluationYear');
insert into allowed_pages_by_process values(364,'gradecriteriacontroller@postPaievaluationYearOptional');
-- recalificar
insert into allowed_pages_by_process values(499,'gradecriteriacontroller@getPaievaluationYear');
insert into allowed_pages_by_process values(499,'gradecriteriacontroller@postPaievaluationYear');
insert into allowed_pages_by_process values(499,'gradecriteriacontroller@postPaievaluationYearOptional');

-- configurar libreta letort pai gestion academica letort pai
INSERT INTO `report_card` (`serial_rcd`, `name_rcd`, `description_rcd`, `type_rcd`, `controller_rcd`, `method_rcd`, `status_rcd`)
VALUES ('37', 'Reporte PAI Letort', 'Reporte PAI Letort', 'PAI', 'MethodsGradeReporController', 'postPAIPeriodReportCard', 'ACTIVE');
insert into allowed_pages_by_process (serial_prc,url_dsc)
values(491,'MethodsGradeReporController@postPAIPeriodReportCard');

--primero aceptar null en serial_gct
alter table grade_criteria_range modify column serial_gct int(11) NULL;

-- modificar columna prd para null
alter table criteria_period_average modify column serial_prd int(11) NULL;