/*------ 23/03/2016 14:35:57 --------*/ CREATE TABLE TABNCM( ID CODIGO NOT NULL); /*------ 23/03/2016 14:35:57 --------*/ alter table TABNCM add primary key (ID); /*------ 23/03/2016 14:36:32 --------*/ ALTER TABLE TABNCM ADD NCM VARCHAR_15; /*------ 23/03/2016 14:36:43 --------*/ ALTER TABLE TABNCM ADD DESCRICAO VARCHAR_100; /*------ 23/03/2016 14:37:25 --------*/ ALTER TABLE TABNCM ADD ALIQNAC NUMERIC_10_5; /*------ 23/03/2016 14:37:37 --------*/ ALTER TABLE TABNCM ADD ALIQIMP NUMERIC_10_5; /*------ 23/03/2016 14:37:59 --------*/ CREATE GENERATOR GEN_TABNCM; /*------ 23/03/2016 14:37:59 --------*/ SET TERM ^ ; CREATE TRIGGER TABNCM_BI FOR TABNCM ACTIVE BEFORE INSERT POSITION 0 AS BEGIN IF (NEW.ID IS NULL OR NEW.ID=0) THEN NEW.ID = GEN_ID(GEN_TABNCM,1); END ^ SET TERM ; ^ /*------ 24/03/2016 01:20:24 --------*/ ALTER TABLE TABNCM ADD CEST VARCHAR_15; /*------ 24/03/2016 01:23:39 --------*/ ALTER TABLE PRODUTOS ADD CEST VARCHAR_15; /*------ 03/04/2016 21:25:58 --------*/ ALTER TABLE UF ADD ICMS NUMERIC_10_5; /*------ 03/04/2016 21:46:17 --------*/ ALTER TABLE UF ADD ICSINTER NUMERIC_10_5;