CREATE TABLE `services_contract` ( `serial_srv` INT NOT NULL AUTO_INCREMENT, `name_srv` VARCHAR(250) NULL, `url_srv` VARCHAR(250) NULL, `in_use_srv` TINYINT NULL, `status_srv` ENUM('ACTIVE', 'INACTIVE') NULL, PRIMARY KEY (`serial_srv`)); ALTER TABLE `services_contract` ADD COLUMN `created_at` DATETIME NULL AFTER `status_srv`, ADD COLUMN `updated_at` DATETIME NULL AFTER `created_at`; CREATE TABLE `signature_services_contract` ( `serial_ssc` INT NOT NULL AUTO_INCREMENT, `serial_srv` INT NULL, `serial_usr` INT NULL, `date_ssc` DATETIME NULL, `ip_address_srv` VARCHAR(250) NULL, `status_ssc` ENUM('ACTIVE', 'INACTIVE') NULL, `created_at` DATETIME NULL, `updated_at` DATETIME NULL, PRIMARY KEY (`serial_ssc`), INDEX `fk_ssc_srv_idx` (`serial_srv` ASC), INDEX `fk_ssc_usr_idx` (`serial_usr` ASC), CONSTRAINT `fk_ssc_srv` FOREIGN KEY (`serial_srv`) REFERENCES `services_contract` (`serial_srv`) ON DELETE NO ACTION ON UPDATE NO ACTION, CONSTRAINT `fk_ssc_usr` FOREIGN KEY (`serial_usr`) REFERENCES `user` (`serial_usr`) ON DELETE NO ACTION ON UPDATE NO ACTION); ALTER TABLE `services_contract` ADD COLUMN `serial_scy` INT NULL AFTER `serial_srv`, ADD INDEX `fk_srv_scy_idx` (`serial_scy` ASC); ALTER TABLE `services_contract` ADD CONSTRAINT `fk_srv_scy` FOREIGN KEY (`serial_scy`) REFERENCES `school_year` (`serial_scy`) ON DELETE NO ACTION ON UPDATE NO ACTION; ALTER TABLE `services_contract` ADD COLUMN `serial_usr` INT NULL AFTER `serial_scy`, ADD INDEX `fk_srv_usr_idx` (`serial_usr` ASC); ALTER TABLE `services_contract` ADD CONSTRAINT `fk_srv_usr` FOREIGN KEY (`serial_usr`) REFERENCES `user` (`serial_usr`) ON DELETE NO ACTION ON UPDATE NO ACTION; INSERT INTO `process` (`serial_prc`, `prc_serial_prc`, `name_prc`, `link_prc`, `weight_prc`, `status_prc`) VALUES ('852', '1', 'Términos y condiciones', 'laravel/public/servicescontract/home', '1.00', 'LOCKABLE'); insert into allowed_pages_by_process values(852,'servicesontractcontroller@gethome'); insert into allowed_pages_by_process values(852,'servicesontractcontroller@getindex'); insert into allowed_pages_by_process values(852,'servicesontractcontroller@getinfo'); insert into allowed_pages_by_process values(852,'servicesontractcontroller@postsave');