insert into allowed_pages_by_process values('503','InformationStudentReportController@getInfoModal');
insert into allowed_pages_by_process values('503','InformationStudentReportController@postValidateUser');


-- reporte informacion general estudiantes y representantes RIGER
CREATE TABLE IF NOT EXISTS mail_send_code (
  serial_msc int NOT NULL AUTO_INCREMENT,
  name_mail_msc	varchar(100) NULL,
  host_mail_msc	varchar(50)	NULL,
  from_mail_msc	varchar(50)	NULL,
  user_mail_msc	varchar(50)	NULL,
  pswd_mail_msc	text	NULL,
  port_mail_msc	int(4)	NULL,
  ssl_mail_msc	enum('YES','NO')	DEFAULT 'NO',
  tls_mail_msc	enum('YES','NO')	DEFAULT 'NO',
  options_msc set('USE_AUTH','USE_AUTH_RIGER')  NULL,
  PRIMARY KEY (serial_msc)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;


CREATE TABLE IF NOT EXISTS users_allowed_access (
  serial_uaa int NOT NULL AUTO_INCREMENT,
  username_uaa varchar(255) NOT NULL,
  password_uaa varchar(255)  NULL,
  ip_uaa varchar(255)  NULL,
  last_login_uaa datetime NULL,
  status_uaa enum('ACTIVE','INACTIVE') DEFAULT 'ACTIVE',
  unique i_serial_uaa(username_uaa),
  PRIMARY KEY (serial_uaa)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

select * from mail_send_code;