CREATE GENERATOR GEN_TBVEICULO_REVISAO_ID; CREATE TABLE TBVEICULO_REVISAO ( VR_CODIGO INTEGER NOT NULL, VR_CODVEICULO INTEGER, VR_NUMREVISAO INTEGER, VR_DATA DATE, VR_KM NUMERIC(15,2), VR_STATUS VARCHAR(15) ); /******************************************************************************/ /*** Primary Keys ***/ /******************************************************************************/ ALTER TABLE TBVEICULO_REVISAO ADD CONSTRAINT PK_TBVEICULO_REVISAO PRIMARY KEY (VR_CODIGO); /******************************************************************************/ /*** Foreign Keys ***/ /******************************************************************************/ ALTER TABLE TBVEICULO_REVISAO ADD CONSTRAINT FK_TBVEICULO_REVISAO_1 FOREIGN KEY (VR_CODVEICULO) REFERENCES TBVEICULO (VEI_CODIGO) ON DELETE CASCADE ON UPDATE CASCADE; /******************************************************************************/ /*** Triggers ***/ /******************************************************************************/ SET TERM ^ ; /******************************************************************************/ /*** Triggers for tables ***/ /******************************************************************************/ /* Trigger: TBVEICULO_REVISAO_BI */ CREATE OR ALTER TRIGGER TBVEICULO_REVISAO_BI FOR TBVEICULO_REVISAO ACTIVE BEFORE INSERT POSITION 0 as begin if (new.vr_codigo is null) then new.vr_codigo = gen_id(gen_tbveiculo_revisao_id,1); end ^ SET TERM ; ^ /******************************************************************************/ CREATE GENERATOR GEN_TBVEICULO_REVISAO_ITENS_ID; CREATE TABLE TBVEICULO_REVISAO_ITENS ( VRI_CODIGO INTEGER NOT NULL, VRI_CODREVISAO INTEGER, VRI_CODITEM INTEGER, VRI_SERVICO VARCHAR(10), VRI_OBS VARCHAR(120) ); /******************************************************************************/ /*** Primary Keys ***/ /******************************************************************************/ ALTER TABLE TBVEICULO_REVISAO_ITENS ADD CONSTRAINT PK_TBVEICULO_REVISAO_ITENS PRIMARY KEY (VRI_CODIGO); /******************************************************************************/ /*** Foreign Keys ***/ /******************************************************************************/ ALTER TABLE TBVEICULO_REVISAO_ITENS ADD CONSTRAINT FK_TBVEICULO_REVISAO_ITENS_1 FOREIGN KEY (VRI_CODREVISAO) REFERENCES TBVEICULO_REVISAO (VR_CODIGO) ON DELETE CASCADE ON UPDATE CASCADE; ALTER TABLE TBVEICULO_REVISAO_ITENS ADD CONSTRAINT FK_TBVEICULO_REVISAO_ITENS_2 FOREIGN KEY (VRI_CODITEM) REFERENCES TBVEICULO_IND_REVISAO (VR_CODIGO); /******************************************************************************/ /*** Triggers ***/ /******************************************************************************/ SET TERM ^ ; /******************************************************************************/ /*** Triggers for tables ***/ /******************************************************************************/ /* Trigger: TBVEICULO_REVISAO_ITENS_BI */ CREATE OR ALTER TRIGGER TBVEICULO_REVISAO_ITENS_BI FOR TBVEICULO_REVISAO_ITENS ACTIVE BEFORE INSERT POSITION 0 as begin if (new.vri_codigo is null) then new.vri_codigo = gen_id(gen_tbveiculo_revisao_itens_id,1); end ^ SET TERM ; ^ /******************************************************************************/