CREATE TABLE DICCIONARIO_CTAEM_NIVEL_1
(
  VMPCODIGOCTAEM1 decimal(20) NOT NULL,
  VMPNOMBRECTAEM1 varchar(400)
);
CREATE TABLE DICCIONARIO_CTAEM_NIVEL_2
(
  VMPPCODIGOCTAEM2 decimal(20) NOT NULL,
  VMPPNOMBRECTAEM2 varchar(400),
  VMPPCODIGOCTAEM1 decimal(20)
);
CREATE TABLE dtproperties
(
  id int identity NOT NULL,
  objectid int,
  property varchar(64) NOT NULL,
  value varchar(255),
  uvalue nvarchar(255),
  lvalue varbinary(max),
  version int NOT NULL DEFAULT (0)
);


ALTER TABLE OM_ESP ADD codigoctaem1 decimal(20);
ALTER TABLE OM_ESP ADD codigoctaem2 decimal(20);
ALTER TABLE OM_ESP ADD commonNameGroupId int;
ALTER TABLE OM_ESP ADD ID_MUL varchar(1) NOT NULL;
ALTER TABLE OM_ESP_PRIACT2 ADD ID_MUL varchar(1) NOT NULL;
ALTER TABLE OM_INTERACCION ADD interactionId int NOT NULL;
ALTER TABLE OM_INTERACCION ALTER COLUMN priact1 int;
ALTER TABLE OM_INTERACCION ALTER COLUMN priact2 int;

