/*------ 27/06/2020 11:24:14 --------*/

ALTER TABLE ITENSMOVIMENTOPROD
ADD QTDTRIB NUMERIC_10_5;


/*------ 27/06/2020 11:24:39 --------*/

ALTER TABLE ITENSMOVIMENTOPROD
ADD VALORUNTRIB NUMERIC_10_5;


/*------ 27/06/2020 11:24:55 --------*/

ALTER TABLE ITENSMOVIMENTOPROD
ADD UNTRIB VAR_CHAR5;


/*------ 27/06/2020 11:25:28 --------*/

ALTER TABLE ITENSMOVIMENTOPROD
ADD CEANTRIB VARCHAR_40;


/*------ 27/06/2020 14:48:54 --------*/

ALTER TABLE ITENSMOVIMENTOPROD
ADD CODBENFISCAL VARCHAR_15;


/*------ 29/06/2020 20:49:51 --------*/

CREATE TABLE PAISES(
    CODPAIS CODIGO NOT NULL,
    DESCRICAO VARCHAR_100,
    STATUS STATUS);


/*------ 29/06/2020 20:49:51 --------*/

alter table PAISES
add 
primary key (CODPAIS);


/*------ 29/06/2020 20:50:17 --------*/

CREATE GENERATOR GEN_PAISES;


/*------ 29/06/2020 20:50:17 --------*/

SET TERM ^ ;

CREATE TRIGGER PAISES_BI FOR PAISES
ACTIVE BEFORE INSERT POSITION 0
AS
BEGIN
  IF (NEW.CODPAIS IS NULL OR NEW.CODPAIS=0) THEN
      NEW.CODPAIS = GEN_ID(GEN_PAISES,1);
END
^

SET TERM ; ^




/*------ 29/06/2020 20:50:51 --------*/

ALTER TABLE ENDERECOSCLI
ADD CODPAIS INTEIRO_NULL;


/*------ 29/06/2020 20:51:07 --------*/

ALTER TABLE ENDERECOSFORN
ADD CODPAIS INTEIRO_NULL;


/*------ 29/06/2020 20:51:28 --------*/

ALTER TABLE EMPRESA
ADD CODPAIS INTEIRO_NULL;