alter table process add column system_version_prc enum('CURRENT','NEW') NOT NULL DEFAULT 'CURRENT' after default_profile_prc;



-- creo tabla para controlar sesiones entre sistemas
CREATE TABLE IF NOT EXISTS sessions_between_versions (
  serial_sbv int NOT NULL AUTO_INCREMENT,
  serial_usr int NOT NULL,
  serial_prf int NOT NULL,
  initial_token_sbv varchar(64) NULL,
  life_token_sbv varchar(64) NULL,
  date_create_initial_token_sbv DATETIME NULL,
  date_update_initial_token_sbv DATETIME NULL,
  date_create_life_token_sbv DATETIME NULL,
  date_update_life_token_sbv DATETIME NULL,
  status_sbv enum('ACTIVE','EXPIRED','INACTIVE') NOT NULL DEFAULT 'ACTIVE',
  PRIMARY KEY (serial_sbv)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;


-- creo tabla para controlar licencias de acceso
CREATE TABLE IF NOT EXISTS sessions_between_versions (
  serial_sbv int NOT NULL AUTO_INCREMENT,
  serial_usr int NOT NULL,
  serial_prf int NOT NULL,
  initial_token_sbv varchar(32) NULL,
  life_token_sbv varchar(32) NULL,
  date_create_initial_token_sbv DATETIME NULL,
  date_update_initial_token_sbv DATETIME NULL,
  date_create_life_token_sbv DATETIME NULL,
  date_update_life_token_sbv DATETIME NULL,
  status_sbv enum('ACTIVE','EXPIRED','INACTIVE') NOT NULL DEFAULT 'ACTIVE',
  PRIMARY KEY (serial_sbv)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;