
UPDATE `level_group_school_year` SET `is_pai_level`='YES' WHERE `serial_lgsy`='9';
UPDATE `level_group_school_year` SET `is_pai_level`='YES' WHERE `serial_lgsy`='10';
UPDATE `level_group_school_year` SET `is_pai_level`='YES' WHERE `serial_lgsy`='11';
UPDATE `level_group_school_year` SET `is_pai_level`='YES' WHERE `serial_lgsy`='12';
UPDATE `level_group_school_year` SET `is_pai_level`='YES' WHERE `serial_lgsy`='13';

SET FOREIGN_KEY_CHECKS = 0;
DELETE FROM `profile_process` WHERE `serial_prc` = 392;
DELETE FROM `process` WHERE `serial_prc` = 392;
DELETE FROM `allowed_pages_by_process` WHERE `serial_prc` = 489;
DELETE FROM `allowed_pages_by_process` WHERE `serial_prc` = 490;
SET FOREIGN_KEY_CHECKS = 1;

INSERT INTO `allowed_pages_by_process` (`serial_prc`, `url_dsc`) VALUES 
('489', 'gradecriteriacontroller@getpaigradesreport'), 
('489', 'gradecriteriacontroller@getsubjectdetailexcel'),
('489', 'gradecriteriacontroller@getloadcriteriagradesbyperiod'),
('489', 'gradecriteriacontroller@getloadsubjectdetail'),
('489', 'gradecriteriacontroller@getloadoptionalsubjectsbygroup'),
('489', 'gradecriteriacontroller@getloadstudentdetail'),
('489', 'gradecriteriacontroller@getperiodgradespaiexcel');

INSERT INTO `allowed_pages_by_process` (`serial_prc`, `url_dsc`) VALUES 
('490', 'gradecriteriacontroller@getpaigradesreportcoursedirector'),  
('490', 'gradecriteriacontroller@getsubjectdetailexcel'),
('490', 'gradecriteriacontroller@getloadcriteriagradesbyperiod'),
('490', 'gradecriteriacontroller@getloadsubjectdetail'),
('490', 'gradecriteriacontroller@getloadoptionalsubjectsbygroup'),
('490', 'gradecriteriacontroller@getloadstudentdetail'),
('490', 'gradecriteriacontroller@getperiodgradespaiexcel');

INSERT INTO `allowed_pages_by_process` (`serial_prc`, `url_dsc`) VALUES
('364', 'gradecriteriacontroller@getsubjectdetailexcel');