CREATE TABLE TBFRETE_COTACAO (
    ID INTEGER NOT NULL,
    DATA DATE,
    TRANSPORTADORA_ID INTEGER,
    VOLUMES INTEGER,
    PESO NUMERIC(15,4),
    VALOR NUMERIC(15,4));

ALTER TABLE TBFRETE_COTACAO
ADD CONSTRAINT PK_TBFRETE_COTACAO
PRIMARY KEY (ID);


CREATE SEQUENCE GTBFRETE_COTACAO;

create trigger ttbfrete_cotacao_b01i for tbfrete_cotacao
active before insert position 0
as
begin
  if (new.id is null) then
    new.id = gen_id(gtbfrete_cotacao,1);
end;
