/******************************************************************************/
/****              Generated by IBExpert 14/09/2026 10:45:36               ****/
/******************************************************************************/

/******************************************************************************/
/****     Following SET SQL DIALECT is just for the Database Comparer      ****/
/******************************************************************************/
SET SQL DIALECT 3;



/******************************************************************************/
/****                                Tables                                ****/
/******************************************************************************/


CREATE GENERATOR GEN_CADATALHOS;

CREATE TABLE CADATALHOS (
    ID      INTEGER NOT NULL,
    ATALHO  VARCHAR(100) CHARACTER SET WIN1252,
    DESCRICAO  VARCHAR(200) CHARACTER SET WIN1252
);



/******************************************************************************/
/****                             Primary keys                             ****/
/******************************************************************************/

ALTER TABLE CADATALHOS ADD CONSTRAINT PK_CADATALHOS PRIMARY KEY (ID);


/******************************************************************************/
/****                               Triggers                               ****/
/******************************************************************************/



SET TERM ^ ;



/******************************************************************************/
/****                         Triggers for tables                          ****/
/******************************************************************************/



/* Trigger: INSCADATALHOS */
CREATE OR ALTER TRIGGER INSCADATALHOS FOR CADATALHOS
ACTIVE BEFORE INSERT POSITION 0
AS
BEGIN
   NEW.id = GEN_ID(GEN_CADATALHOS, 1);
END
^
SET TERM ; ^



/******************************************************************************/
/****                              Privileges                              ****/
/******************************************************************************/