
CREATE TABLE TBDB (
    ID         INTEGER,
    DESCRICAO  VARCHAR(50),
    CAMINHO    VARCHAR(100),
    STATUS     INTEGER
);

CREATE SEQUENCE GTBDB;

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

INSERT INTO TBMENU (CONTROLE, GRUPO, SUBGRUPO, TIPO, URL, DESCRICAO, DATAHORA)
            VALUES (11700, 'ADM', 'ADM', '1   ', '', 'GERENCIADOR FIREBIRD', '2020-03-26 09:40:18');


INSERT INTO TBMENU (CONTROLE, GRUPO, SUBGRUPO, TIPO, URL, DESCRICAO, DATAHORA)
            VALUES (22550, 'PCP', 'PCP', '1   ', '', 'CONTROLE DE PLACAS DO CD', '2020-03-26 18:36:27');
