/*------ 26/11/2016 01:32:45 --------*/ UPDATE CONFIGURACOES SET COMPILACAO='1.3.8.0'; /*------ 10/06/2020 22:14:11 --------*/ CREATE TABLE AJUSTESFISCAIS( IDAJUSTE CODIGO NOT NULL); /*------ 10/06/2020 22:14:11 --------*/ alter table AJUSTESFISCAIS add primary key (IDAJUSTE); /*------ 10/06/2020 22:14:31 --------*/ ALTER TABLE AJUSTESFISCAIS ADD CODEMPRESA INTEIRO_NULL; /*------ 10/06/2020 22:14:43 --------*/ ALTER TABLE AJUSTESFISCAIS ADD DATA DATA; /*------ 10/06/2020 22:15:54 --------*/ ALTER TABLE AJUSTESFISCAIS ADD CODAJUSTE VAR_CHAR5; /*------ 10/06/2020 22:16:38 --------*/ ALTER TABLE AJUSTESFISCAIS ADD DESCRICAO VARCHAR_100; /*------ 10/06/2020 22:16:56 --------*/ ALTER TABLE AJUSTESFISCAIS ADD VALOR VALOR_10_2; /*------ 10/06/2020 22:19:14 --------*/ CREATE GENERATOR GEN_AJUSTESFISCAIS; /*------ 10/06/2020 22:19:14 --------*/ SET TERM ^ ; CREATE TRIGGER AJUSTESFISCAIS_BI FOR AJUSTESFISCAIS ACTIVE BEFORE INSERT POSITION 0 AS BEGIN IF (NEW.IDAJUSTE IS NULL OR NEW.IDAJUSTE=0) THEN NEW.IDAJUSTE = GEN_ID(GEN_AJUSTESFISCAIS,1); END ^ SET TERM ; ^ /*------ 11/06/2020 23:52:38 --------*/ CREATE TABLE MOVSIMPLES( ID CODIGO NOT NULL, CODINTERNO INTEIRO_NULL, REFERENCIA VARCHAR_30, DESCRICAO VARCHAR_100, VALOR VALOR_10_2, TIPO VARCHAR_30, STATUS CHAR1); /*------ 11/06/2020 23:52:38 --------*/ alter table MOVSIMPLES add primary key (ID); /*------ 11/06/2020 23:53:08 --------*/ CREATE GENERATOR GEN_MOVSIMPLES; /*------ 11/06/2020 23:53:08 --------*/ SET TERM ^ ; CREATE TRIGGER MOVSIMPLES_BI FOR MOVSIMPLES ACTIVE BEFORE INSERT POSITION 0 AS BEGIN IF (NEW.ID IS NULL OR NEW.ID=0) THEN NEW.ID = GEN_ID(GEN_MOVSIMPLES,1); END ^ SET TERM ; ^ /*------ 13/06/2020 10:38:12 --------*/ update RDB$RELATION_FIELDS set RDB$FIELD_SOURCE = 'VARCHAR_100' where (RDB$FIELD_NAME = 'DESCRICAO') and (RDB$RELATION_NAME = 'CFOP') ;