-- ALTER TABLE `student` ADD COLUMN `lock_grades` ENUM('LOCKED','UNLOCKED') NULL DEFAULT 'UNLOCKED'  AFTER `siblins_post_between`;
INSERT INTO process (`serial_prc`, `prc_serial_prc`, `name_prc`, `link_prc`, `weight_prc`, `status_prc`)
VALUES (796, '149', 'Lista de Reportes', 'laravel/public/reportList', '999', 'LOCKABLE');


insert into allowed_pages_by_process (serial_prc, url_dsc) values (796,'ReportListController@getIndex');
insert into allowed_pages_by_process (serial_prc, url_dsc) values (796,'ReportListController@postReport');

-- --------------------------------------------------------------------------------------------------------------------------------
-- Crear tabla reportes
-- --------------------------------------------------------------------------------------------------------------------------------
CREATE TABLE IF NOT EXISTS report_list (
  serial_rpt int NOT NULL AUTO_INCREMENT,
  name_rpt varchar (250) NULL DEFAULT NULL,
  description_rpt varchar (250) NULL DEFAULT NULL,
  sql_rpt TEXT NULL DEFAULT NULL,
  defined_prf set('MEDICAL','DCE','EXTRACURRICULAR','COLLECTOR','TRANSPORT','ALL') DEFAULT 'ALL',
  status_rpt enum('ACTIVE','INACTIVE') DEFAULT 'ACTIVE',
  PRIMARY KEY (serial_rpt)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;