SET SQL DIALECT 3;



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


CREATE GENERATOR GEN_D_ID;

CREATE TABLE DICTIONARY (
    D_ID           DMN_INT_NOT_NULL NOT NULL /* DMN_INT_NOT_NULL = INTEGER NOT NULL */,
    D_MAIN_TYPE    DMN_VCHAR_3_NULL /* DMN_VCHAR_3_NULL = VARCHAR(3) */,
    D_TYPE         DMN_VCHAR_3_NOT_NULL NOT NULL /* DMN_VCHAR_3_NOT_NULL = VARCHAR(3) NOT NULL */,
    LANG           DMN_VCHAR_3_NOT_NULL NOT NULL /* DMN_VCHAR_3_NOT_NULL = VARCHAR(3) NOT NULL */,
    NAME           DMN_VCHAR_100_NOT_NULL NOT NULL /* DMN_VCHAR_100_NOT_NULL = VARCHAR(100) NOT NULL */,
    SORT_ID        DMN_INT_NULL /* DMN_INT_NULL = INTEGER */,
    SEL_ID_INT     DMN_INT_NULL /* DMN_INT_NULL = INTEGER */,
    SEL_ID_CHAR_3  DMN_VCHAR_3_NULL /* DMN_VCHAR_3_NULL = VARCHAR(3) */,
    SYSTEM         DMN_VCHAR_1_NOT_NULL DEFAULT 0 /* DMN_VCHAR_1_NOT_NULL = VARCHAR(1) */,
    MORE           DMN_VCHAR_500_NULL /* DMN_VCHAR_500_NULL = VARCHAR(500) */
);




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

ALTER TABLE DICTIONARY ADD CONSTRAINT PK_DICTIONARY PRIMARY KEY (D_ID);


/******************************************************************************/
/****                               Indices                                ****/
/******************************************************************************/

CREATE UNIQUE INDEX IDX_DICTIONARY_TYP_LNG_NAM ON DICTIONARY (D_TYPE, LANG, NAME);
CREATE INDEX IDX_DICTIONARY_MAI_LNG_NAM ON DICTIONARY (D_MAIN_TYPE, LANG, NAME);
CREATE INDEX IDX_DICTIONARY_TYP_LNG_SRT ON DICTIONARY (D_TYPE, LANG, SORT_ID);


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



SET TERM ^ ;



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



/* Trigger: DICTIONARY_BI */
CREATE OR ALTER TRIGGER DICTIONARY_BI FOR DICTIONARY
ACTIVE BEFORE INSERT POSITION 0
AS
BEGIN
if ((NEW.D_ID is NULL) OR (NEW.D_ID < 1)) then NEW.D_ID = GEN_ID(GEN_D_ID, 1);
END
^