
CREATE TABLE `recommendation_catalog` (
  `serial_rmc` INT NOT NULL AUTO_INCREMENT,
  `code_rmc` VARCHAR(20) NULL,
  `recommendation_rmc` TEXT NULL,
  `type_rmc` ENUM('ACADEMIC','DISCIPLINE') NULL,
  `status_rmc` ENUM('ACTIVE','INACTIVE') NULL,
  PRIMARY KEY (`serial_rmc`));

CREATE TABLE `year_recommendation_level` (
  `serial_yrl` INT NOT NULL AUTO_INCREMENT,
  `serial_scy` INT NOT NULL,
  `serial_set` INT NULL,
  `serial_lvl` INT NULL,
  `serial_rmc` INT NULL,
  `status_yrl` ENUM('ACTIVE','INACTIVE') NULL,
  PRIMARY KEY (`serial_yrl`));


CREATE TABLE `student_period_recommendations` (
  `serial_spr` int(11) NOT NULL AUTO_INCREMENT,
  `serial_prd` int(11) NOT NULL,
  `serial_std` int(11) NOT NULL,
  `serial_rmc` int(11) NOT NULL,
  `status_spr` enum('ACTIVE','INACTIVE') NOT NULL DEFAULT 'ACTIVE',
  PRIMARY KEY (`serial_spr`)
);


INSERT INTO `process` (`serial_prc`, `prc_serial_prc`, `name_prc`, `link_prc`, `weight_prc`, `status_prc`) VALUES ('742', '199', 'Cuadros Juntas', 'laravel/public/studentPeriodRecommendations', '10', 'LOCKABLE');



insert into allowed_pages_by_process (`serial_prc`, `url_dsc`) VALUES ('742','studentperiodrecommendationscontroller@getindex');
insert into allowed_pages_by_process (`serial_prc`, `url_dsc`) VALUES ('742','studentperiodrecommendationscontroller@getstudentsbycourse');
insert into allowed_pages_by_process (`serial_prc`, `url_dsc`) VALUES ('742','studentperiodrecommendationscontroller@postsearchrecommendation');
insert into allowed_pages_by_process (`serial_prc`, `url_dsc`) VALUES ('742','studentperiodrecommendationscontroller@postsavestudentperiodrecommendation');
insert into allowed_pages_by_process (`serial_prc`, `url_dsc`) VALUES ('742','studentperiodrecommendationscontroller@getsubjectsreport');
insert into allowed_pages_by_process (`serial_prc`, `url_dsc`) VALUES ('742','studentperiodrecommendationscontroller@getgeneralperiodreport');
insert into allowed_pages_by_process (`serial_prc`, `url_dsc`) VALUES ('742','sectioncontroller@getsectionsbyschoolyearoptions');
insert into allowed_pages_by_process (`serial_prc`, `url_dsc`) VALUES ('742','coursecontroller@getallbysectionoptions');
insert into allowed_pages_by_process (`serial_prc`, `url_dsc`) VALUES ('742','periodcontroller@getperiodsbycourseoptions');