INSERT INTO  `school_flag` (`name_scf`, `alias_scf`, `status_scf`) VALUES ('USE_UBICATION_TEST', 'Otros', 'INACTIVE');
INSERT INTO  `school_flag` (`name_scf`, `alias_scf`, `description_scf`, `status_scf`) VALUES ('SHOW_FINAL_YEAR_STUDENT_DETAIL_GRADES', 'Otros', 'Muestra la seleccion de final del año en el template DEV/laravel/app/controllers/templateStudentGradesDetail/StudentDetailTableController.php', 'INACTIVE');
INSERT INTO  `school_flag` (`name_scf`, `alias_scf`, `description_scf`, `status_scf`) VALUES ('SHOW_EXAM_STUDENT_DETAIL_GRADES', 'Otros', 'Muestra la columna de examen en el template DEV/laravel/app/controllers/templateStudentGradesDetail/StudentDetailTableController.php', 'INACTIVE');
INSERT INTO  `school_flag` (`name_scf`, `alias_scf`, `description_scf`, `status_scf`) VALUES ('SHOW_HEAD_STUDENT_DETAIL_GRADES', 'Otros', 'Muestra la cabecera de curso y promedio en el template DEV/laravel/app/controllers/templateStudentGradesDetail/StudentDetailTableController.php', 'INACTIVE');
INSERT INTO  `school_flag` (`name_scf`, `alias_scf`, `description_scf`, `status_scf`) VALUES ('SHOW_DETAILS_ACADEMIC_RECORD', 'Otros', 'Muestra boton de detalles en pantalla de record academico', 'INACTIVE');
INSERT INTO  `school_flag` (`name_scf`, `description_scf`, `status_scf`) VALUES ('SHOW_SELECT_PERIOD_ACADEMIC_RECORD', 'Muestra dropdowns para escoger periodos en pantalla de record academico', 'INACTIVE');


INSERT INTO process (`serial_prc`, `prc_serial_prc`, `name_prc`, `link_prc`, `weight_prc`, `status_prc`) VALUES ('880', '172', 'Record Acádemico', 'laravel/public/academicRecord/index', '2.00', 'LOCKABLE');
insert into allowed_pages_by_process values (880, 'AcademicRecordController@getIndex');
insert into allowed_pages_by_process values (880, 'AcademicRecordController@postSearchStudent');
insert into allowed_pages_by_process values (880, 'AcademicRecordController@postAcademicRecordContainer');
insert into allowed_pages_by_process values (880, 'StudentDetailTableController@postDetailGradesTable');
insert into allowed_pages_by_process values (880, 'StudentDetailTableController@getLoadModalGradesActivityType');
insert into allowed_pages_by_process values (880, 'AcademicRecordController@postSaveEmail');
insert into allowed_pages_by_process values (880, 'AcademicRecordController@getModalUpdateData');
insert into allowed_pages_by_process values (880, 'AcademicRecordController@postValidateIdentification');
insert into allowed_pages_by_process values (880, 'AcademicRecordController@postSaveStudentInformation');
insert into allowed_pages_by_process values (880, 'AcademicRecordController@getModalAddLicense');
insert into allowed_pages_by_process values (880, 'AcademicRecordController@postSaveLicense');
insert into allowed_pages_by_process values (880, 'AcademicRecordController@deleteLicense');

CREATE TABLE `english_course_licenses` (
   `serial_ecl` int(11) NOT NULL AUTO_INCREMENT,
   `serial_std` int(11) DEFAULT NULL,
   `licenses_ecl` text NOT NULL,
   `date_expired_ecl` datetime DEFAULT NULL,
   `date_create_ecl` datetime DEFAULT NULL,
   `date_update_ecl` datetime DEFAULT NULL,
   `status_ecl` enum('ACTIVE','EXPIRED','INACTIVE') DEFAULT 'ACTIVE',
   PRIMARY KEY (`serial_ecl`)
 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;


INSERT INTO `report_card` (`serial_rcd`, `name_rcd`, `description_rcd`, `type_rcd`, `route_rcd`, `controller_rcd`, `method_rcd`, `action_rcd`, `status_rcd`) VALUES (NULL, 'Certificado de Aprobación de Nivel', 'Certificado de Aprobación de Nivel Fulbright', 'PROMOTION', NULL, 'FulbrightReportsController', 'postPromotionReport', 'PROMOTION', 'ACTIVE');
insert into allowed_pages_by_process values (880, 'FulbrightReportsController@getPromotionReport');