insert into process (serial_prc,prc_serial_prc, name_prc, link_prc, weight_prc, status_prc) values(809,52,'Sustitución de Usuarios','laravel/public/userSubstitution',999,'LOCKABLE'); insert into allowed_pages_by_process values(809,'UserSubstitutionController@getIndex'); insert into allowed_pages_by_process values(809,'UserSubstitutionController@postLoadEmployeeContainer'); insert into allowed_pages_by_process values(809,'UserSubstitutionController@postLoadStudentContainer'); insert into allowed_pages_by_process values(809,'UserSubstitutionController@postLoadGuardianContainer'); insert into allowed_pages_by_process values(809,'UserSubstitutionController@postUserSearch'); insert into allowed_pages_by_process values(809,'UserSubstitutionController@postLoadProfile'); insert into allowed_pages_by_process values(809,'UserSubstitutionController@postChange'); CREATE TABLE log_alternative_session ( `serial_las` INT NOT NULL AUTO_INCREMENT, `serial_real_usr` INT NOT NULL, `serial_alternative_usr` INT NOT NULL, `serial_real_prf` INT NOT NULL, `serial_alternative_prf` INT NOT NULL, `proccess_las` Text NULL, `data_send_las` Text NULL, `date_las` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, -- fecha en que se crea el registro `status_las` ENUM('ACTIVE','INACTIVE') NOT NULL DEFAULT 'ACTIVE', PRIMARY KEY (`serial_las`) ); alter table process add column allow_prc ENUM('YES', 'NO') NULL AFTER id_exclusion;