/****               Generated by IBExpert 13.07.03 18:08:44                ****/ 
SET SQL DIALECT  3 ;
CREATE GENERATOR GEN_REGIONS_ID;
SET NAMES WIN1251;
 /****                                Tables                                ****/ 
CREATE TABLE REGIONS (
    REGIONNO  INTEGER DEFAULT  0  NOT NULL,
    CAPTION   VARCHAR( 40 ) DEFAULT 'Region' NOT NULL,
    REMARK    BLOB SUB_TYPE  1  SEGMENT SIZE  80 
);

 /****                             Primary Keys                             ****/ 
ALTER TABLE REGIONS ADD CONSTRAINT PK_REGIONS PRIMARY KEY (REGIONNO);

 /****                               Triggers                               ****/ 
SET TERM ^ ;
 /* Trigger: REGIONS_BI0 */ 
CREATE TRIGGER REGIONS_BI0 FOR REGIONS
ACTIVE BEFORE INSERT POSITION  0 
AS
begin
  New.regionno = GEN_ID(gen_regions_id,  1 );
end
^
SET TERM ; ^
 /****                              Privileges                              ****/