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');