ALTER TABLE LOTE DROP IDWEBSERVICE;

ALTER TABLE LOTE ADD TIPOAMBIENTE INT DEFAULT 0 NOT NULL;

ALTER TABLE LOTE ADD TIPOSERVICO INT DEFAULT 0 NOT NULL;

CREATE TABLE VERSAO (
    VERSAO       SMALLINT default 0 NOT NULL,
    SUBVERSAO    SMALLINT default 0 NOT NULL
);

ALTER TABLE VERSAO
ADD CONSTRAINT PK_VERSAO PRIMARY KEY
(
  Versao,
  SubVersao
);

Insert Into Versao Values (3, 10);



