CREATE TABLE TABLE1 (
    ID             INTEGER NOT NULL,
    ADATE          DATE,
    ATIME          TIME,
    FIELD1       SMALLINT,
    FIELD2          INTEGER,
    FIELD3      SMALLINT,
    FIELD4    SMALLINT,
    FIELD5        SMALLINT,
    FIELD6           SMALLINT,
    FIELD7     SMALLINT,
    FIELD8       SMALLINT,
    FIELD9       SMALLINT,
    FIELD10      BIGINT,
    FIELD11          VARCHAR(15),
    FIELD12        INTEGER,
    FIELD13      SMALLINT,
    FIELD14          VARCHAR(15),
    FIELD15        INTEGER,
    FIELD16      SMALLINT,
    FIELD17      INTEGER,
    FIELD18     INTEGER,
    FIELD19  SMALLINT,
    FIELD20      SMALLINT,
    FIELD21       SMALLINT,
    FIELD22      SMALLINT,
    FIELD23            BLOB SUB_TYPE 1 SEGMENT SIZE 16,
    FIELD24       BIGINT,
    FIELD25       BIGINT,
    FIELD26          INTEGER,
    FIELD27       SMALLINT,
    FIELD28          SMALLINT,
    FIELD29            SMALLINT,
    FIELD30      SMALLINT,
    FIELD31         INTEGER,
    FIELD32       SMALLINT,
    FIELD33       SMALLINT,
    FIELD34          INTEGER,
    FIELD35          SMALLINT,
    FIELD36      SMALLINT,
    FIELD37         INTEGER,
    FIELD38     SMALLINT,
    FIELD39        SMALLINT,
    FIELD40      SMALLINT,
    FIELD41       SMALLINT,
    FIELD42          INTEGER,
    FIELD43       SMALLINT,
    FIELD44      SMALLINT
);

CREATE TRIGGER TABLE1_BI FOR TABLE1
ACTIVE BEFORE INSERT POSITION 0
as
begin
  if (new.id is null) then
    new.id = gen_id(gen_table1_id,1);
end

gbak:opened file C:\data\db.fbk
gbak:transportable backup -- data in XDR format
gbak:		backup file is compressed
gbak:created database C:\data\db.fdb, page_size 4096 bytes
gbak: started transaction 
...
gbak:     committing metadata 
gbak:finishing, closing, and going home