CREATE DATABASE "Test.gdb"
  USER "SYSDBA"
  PASSWORD "masterkey"
  PAGE_SIZE 4096;

/* Domain definitions */
CREATE DOMAIN TABLE_ID AS INTEGER NOT NULL;

/* Table: TEST, Owner: SYSDBA */
CREATE TABLE TEST (ID TABLE_ID,
        mp3title VARCHAR(200),
        mp3file BLOB SUB_TYPE 0 SEGMENT SIZE 80,
PRIMARY KEY (ID));

CREATE GENERATOR TEST_ID_GEN;

COMMIT WORK;

SET TERM ^ ;

/* Triggers only will work for SQL triggers */
CREATE TRIGGER SET_TEST_ID FOR TEST                            
ACTIVE BEFORE INSERT POSITION 0 
AS
BEGIN
  NEW.ID = GEN_ID(TEST_ID_GEN, 1);
END
 ^
COMMIT WORK ^
SET TERM ; ^