INSERT INTO process (`serial_prc`, `prc_serial_prc`, `name_prc`, `link_prc`, `weight_prc`, `status_prc`) VALUES ('729', '39', 'Adaptación Curricular', 'laravel/public/curricurlarAdaptationConfig', '1.00', 'LOCKABLE');

insert into allowed_pages_by_process (serial_prc, url_dsc) values (729,'curricularadaptationconfigcontroller@getIndex');
insert into allowed_pages_by_process (serial_prc, url_dsc) values (729,'curricularadaptationconfigcontroller@getSubjects');
insert into allowed_pages_by_process (serial_prc, url_dsc) values (729,'curricularadaptationconfigcontroller@postSaveStudentsConf');


insert into allowed_pages_by_process (serial_prc, url_dsc) values (729,'curricularadaptationconfigcontroller@postStudents');
insert into allowed_pages_by_process (serial_prc, url_dsc) values (729,'sectioncontroller@getsectionsbyschoolyearoptions');
insert into allowed_pages_by_process (serial_prc, url_dsc) values (729,'subperiodcontroller@getSubperiodsbyperiod');


insert into allowed_pages_by_process (serial_prc, url_dsc) values (729,'periodcontroller@getPeriods');
insert into allowed_pages_by_process (serial_prc, url_dsc) values (729,'CourseController@getAllclassgroupbysetlvlscyeoptions');

ALTER TABLE student_subject_period_average DROP COLUMN curricular_adaptation;

ALTER TABLE student_subject_subperiod_average DROP COLUMN curricular_adaptation;

ALTER TABLE student_subject_period_average
ADD COLUMN curricular_adaptation ENUM('NONE','FIRST','SECOND','THIRD') NULL DEFAULT 'NONE' AFTER recovery_plan_ssa;

ALTER TABLE student_subject_subperiod_average
ADD COLUMN curricular_adaptation ENUM('NONE','FIRST','SECOND','THIRD') NULL DEFAULT 'NONE' AFTER recovery_plan_sss;

INSERT INTO process (`serial_prc`, `name_prc`, `link_prc`) VALUES ('733', 'Adaptación Curricular', '#');
INSERT INTO process (`serial_prc`, `prc_serial_prc`, `name_prc`, `link_prc`) VALUES ('734', '733', 'Reporte', 'laravel/public/curricurlarAdaptationReport');
UPDATE process SET `prc_serial_prc`='733' WHERE `serial_prc`='729';
insert into allowed_pages_by_process (serial_prc, url_dsc) values (734,'curricularadaptationreportcontroller@getIndex');
insert into allowed_pages_by_process (serial_prc, url_dsc) values (734,'curricularadaptationreportcontroller@postReport');

