/******************************************************************************/
/****         Generated by IBExpert 2006.12.13 30.01.2007 18:35:24         ****/
/******************************************************************************/

SET SQL DIALECT 3;


SET CLIENTLIB 'C:\Program Files\Firebird\Firebird_2_0\bin\fbclient.dll';

CREATE DATABASE 'localhost:D:\db\test1.fdb'
USER 'SYSDBA' PASSWORD 'masterkey'
PAGE_SIZE 16384
DEFAULT CHARACTER SET UTF8;



/******************************************************************************/
/****                              Generators                              ****/
/******************************************************************************/

CREATE GENERATOR GEN_LANGUAGE_ID;
SET GENERATOR GEN_LANGUAGE_ID TO 11;



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



CREATE TABLE LANGUAGE (
    LANGUAGE_ID  INTEGER NOT NULL,
    NAME         CHAR(40)
);



/******************************************************************************/
/****                             Primary Keys                             ****/
/******************************************************************************/

ALTER TABLE LANGUAGE ADD CONSTRAINT PK_LANGUAGE PRIMARY KEY (LANGUAGE_ID);


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


SET TERM ^ ;


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



/* Trigger: LANGUAGE_BI */
CREATE TRIGGER LANGUAGE_BI FOR LANGUAGE
ACTIVE BEFORE INSERT POSITION 0
AS
BEGIN
  IF (NEW.LANGUAGE_ID IS NULL) THEN
    NEW.LANGUAGE_ID = GEN_ID(GEN_LANGUAGE_ID,1);
END
^

SET TERM ; ^




________ Information from NOD32 ________
This message was checked by NOD32 Antivirus System for Linux Mail Servers.
http://www.eset.com