insert into process (serial_prc, prc_serial_prc, name_prc, link_prc, weight_prc, status_prc, id_exclusion, allow_prc)
values(821,199,'Gestión de Visualización e Ingreso de Notas','laravel/public/manageRegisterAndShowGrade',100,'LOCKABLE',NULL,NULL);

insert into allowed_pages_by_process values (821,'ManageRegisterAndShowGradeController@getIndex');
insert into allowed_pages_by_process values (821,'ManageRegisterAndShowGradeController@postContainerRegister');
insert into allowed_pages_by_process values (821,'ManageRegisterAndShowGradeController@postContainerView');


CREATE TABLE IF NOT EXISTS lock_grades_subject (
  serial_lgs int NOT NULL AUTO_INCREMENT,
  serial_sbc int NULL DEFAULT NULL,
  serial_osb int NULL DEFAULT NULL,
  serial_lop int NULL DEFAULT NULL,
  serial_sbp int NULL DEFAULT NULL,
  serial_prd int NULL DEFAULT NULL,
  serial_scy int NULL DEFAULT NULL,
  grade_entry ENUM('YES','NO') NULL DEFAULT 'YES',
  -- show_grades ENUM('YES','NO') NULL DEFAULT 'YES',
  exam_entry ENUM('YES','NO') NULL DEFAULT 'YES',
  -- show_exam ENUM('YES','NO') NULL DEFAULT 'YES',
  status_lgs enum('ACTIVE','INACTIVE') DEFAULT 'ACTIVE',
  PRIMARY KEY (serial_lgs)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;



insert into allowed_pages_by_process values (821,'ManageRegisterAndShowGradeController@postContainerSubjectByCourse');
insert into allowed_pages_by_process values (821,'ManageRegisterAndShowGradeController@postSaveAction');
insert into allowed_pages_by_process values (821,'ManageRegisterAndShowGradeController@postChangeAllSubjects');

-- components
insert into allowed_pages_by_process values (821,'BaseMethodsTemplateController@postDropDownSchoolYear');
insert into allowed_pages_by_process values (821,'BaseMethodsTemplateController@postSectionWithLevel');
insert into allowed_pages_by_process values (821,'BaseMethodsTemplateController@postSectionNavbar');
insert into allowed_pages_by_process values (821,'ManageRegisterAndShowGradeController@postLoadCourseBySection');
insert into allowed_pages_by_process values (821,'ManageRegisterAndShowGradeController@postSaveActionAllView');
insert into allowed_pages_by_process values (821,'ManageRegisterAndShowGradeController@postSaveActionView');

CREATE TABLE IF NOT EXISTS lock_view_grades (
  serial_lvg int NOT NULL AUTO_INCREMENT,
  serial_crs int NULL DEFAULT NULL,
  serial_scy int NULL DEFAULT NULL,
  serial_prd int NULL DEFAULT NULL,
  serial_sbp int NULL DEFAULT NULL,
  show_grades_subperiod_lvg ENUM('LOCKED','UNLOCKED') NULL DEFAULT 'UNLOCKED',
  show_grades_period_lvg ENUM('LOCKED','UNLOCKED') NULL DEFAULT 'UNLOCKED',
  show_grades_exam_lvg ENUM('LOCKED','UNLOCKED') NULL DEFAULT 'UNLOCKED',
  show_grades_annual_lvg ENUM('LOCKED','UNLOCKED') NULL DEFAULT 'UNLOCKED',
  status_lvg enum('ACTIVE','INACTIVE') DEFAULT 'ACTIVE',
  PRIMARY KEY (serial_lvg)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- LETORT
update school_setup set options='SEND_COPY_ALL_GUARDIANS,SKILLS,SHOW_SUBPERIOD_REPORT_CARD,SHOW_PERIOD_REPORT_CARD,SHOW_PAI_REPORT_CARD,HAS_MOBILE_APP,INCIDENT_REPORT_ADMINISTRATION,LOCK_PROMOTION_BY_LOCKED_GRADES,LOCK_VIEW_GRADES_TAB';