SET SQL DIALECT 3;

SET NAMES UTF8;

SET CLIENTLIB 'D:\Baza5\fbclientx86\fbclient.dll';

CREATE DATABASE 'LOCALHOST/3055:LOG_DB5'
USER 'SYSDBA' PASSWORD 'masterkey'
PAGE_SIZE 16384
DEFAULT CHARACTER SET UTF8 COLLATION UTF8;

/******************************************************************************/
/****                               Domains                                ****/
/******************************************************************************/

CREATE DOMAIN D_ATTACHMENT_NAME AS
VARCHAR(255);

CREATE DOMAIN D_AUTH_METHOD AS
VARCHAR(255) CHARACTER SET ASCII;

CREATE DOMAIN D_BIGINT AS
BIGINT;

CREATE DOMAIN D_BOOLEAN AS
BOOLEAN;

CREATE DOMAIN D_CHG_KIND AS
VARCHAR(8);

CREATE DOMAIN D_CLIENT_VERSION AS
VARCHAR(255) CHARACTER SET ASCII;

CREATE DOMAIN D_COMMENT AS
VARCHAR(200);

CREATE DOMAIN D_CONN_ID AS
BIGINT
NOT NULL;

CREATE DOMAIN D_DATE AS
DATE;

CREATE DOMAIN D_FIELDNAME AS
CHAR(63);

CREATE DOMAIN D_INTEGER AS
INTEGER;

CREATE DOMAIN D_INTKEY AS
BIGINT
NOT NULL;

CREATE DOMAIN D_RELATIONNAME AS
CHAR(63);

CREATE DOMAIN D_REMOTE_ADDRESS AS
VARCHAR(255) CHARACTER SET ASCII;

CREATE DOMAIN D_REMOTE_HOST AS
VARCHAR(255);

CREATE DOMAIN D_REMOTE_OS_USER AS
VARCHAR(255);

CREATE DOMAIN D_REMOTE_PROCESS AS
VARCHAR(255);

CREATE DOMAIN D_REMOTE_PROTOCOL AS
VARCHAR(10) CHARACTER SET ASCII;

CREATE DOMAIN D_REMOTE_VERSION AS
VARCHAR(255) CHARACTER SET ASCII;

CREATE DOMAIN D_SESSION_TIMEZONE AS
CHAR(63);

CREATE DOMAIN D_SMALLINT AS
SMALLINT;

CREATE DOMAIN D_TIMESTAMP AS
CHAR(63);

CREATE DOMAIN D_USER_ROLE AS
CHAR(63);



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

CREATE SEQUENCE GEN_CHG_CONN_ID START WITH 0 INCREMENT BY 1;


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



RECREATE TABLE CHG_CONN (
    CHG_CONN_ID             D_CONN_ID /* D_CONN_ID = BIGINT NOT NULL */,
    CHG_ATTACHMENT_ID       D_BIGINT /* D_BIGINT = BIGINT */,
    CHG_SERVER_PID          D_INTEGER /* D_INTEGER = INTEGER */,
    CHG_STATE               D_SMALLINT /* D_SMALLINT = SMALLINT */,
    CHG_ATTACHMENT_NAME     D_ATTACHMENT_NAME /* D_ATTACHMENT_NAME = VARCHAR(255) */,
    CHG_USER                D_USER_ROLE /* D_USER_ROLE = CHAR(63) */,
    CHG_ROLE                D_USER_ROLE /* D_USER_ROLE = CHAR(63) */,
    CHG_REMOTE_PROTOCOL     D_REMOTE_PROTOCOL /* D_REMOTE_PROTOCOL = VARCHAR(10) */,
    CHG_REMOTE_ADDRESS      D_REMOTE_ADDRESS /* D_REMOTE_ADDRESS = VARCHAR(255) */,
    CHG_REMOTE_PID          D_INTEGER /* D_INTEGER = INTEGER */,
    CHG_CHARACTER_SET_ID    D_SMALLINT /* D_SMALLINT = SMALLINT */,
    CHG_TIMESTAMP           D_TIMESTAMP /* D_TIMESTAMP = CHAR(63) */,
    CHG_GARBAGE_COLLECTION  D_SMALLINT /* D_SMALLINT = SMALLINT */,
    CHG_REMOTE_PROCESS      D_REMOTE_PROCESS /* D_REMOTE_PROCESS = VARCHAR(255) */,
    CHG_STAT_ID             D_INTEGER /* D_INTEGER = INTEGER */,
    CHG_CLIENT_VERSION      D_CLIENT_VERSION /* D_CLIENT_VERSION = VARCHAR(255) */,
    CHG_REMOTE_VERSION      D_REMOTE_VERSION /* D_REMOTE_VERSION = VARCHAR(255) */,
    CHG_REMOTE_HOST         D_REMOTE_HOST /* D_REMOTE_HOST = VARCHAR(255) */,
    CHG_REMOTE_OS_USER      D_REMOTE_OS_USER /* D_REMOTE_OS_USER = VARCHAR(255) */,
    CHG_AUTH_METHOD         D_AUTH_METHOD /* D_AUTH_METHOD = VARCHAR(255) */,
    CHG_SYSTEM_FLAG         D_SMALLINT /* D_SMALLINT = SMALLINT */,
    CHG_IDLE_TIMEOUT        MON$IDLE_TIMEOUT /* MON$IDLE_TIMEOUT = INTEGER NOT NULL */,
    CHG_IDLE_TIMER          MON$IDLE_TIMER /* MON$IDLE_TIMER = TIMESTAMP WITH TIME ZONE NOT NULL */,
    CHG_STATEMENT_TIMEOUT   MON$STATEMENT_TIMEOUT /* MON$STATEMENT_TIMEOUT = INTEGER NOT NULL */,
    CHG_WIRE_COMPRESSED     D_BOOLEAN /* D_BOOLEAN = BOOLEAN */,
    CHG_WIRE_ENCRYPTED      D_BOOLEAN /* D_BOOLEAN = BOOLEAN */,
    CHG_WIRE_CRYPT_PLUGIN   MON$WIRE_CRYPT_PLUGIN /* MON$WIRE_CRYPT_PLUGIN = VARCHAR(63) NOT NULL */,
    CHG_SESSION_TIMEZONE    D_SESSION_TIMEZONE /* D_SESSION_TIMEZONE = CHAR(63) */,
    CHG_PARALLEL_WORKERS    MON$PARALLEL_WORKERS /* MON$PARALLEL_WORKERS = INTEGER NOT NULL */,
    CHG_ONTIME              D_TIMESTAMP /* D_TIMESTAMP = CHAR(63) */,
    CHG_OFFTIME             D_TIMESTAMP /* D_TIMESTAMP = CHAR(63) */
);



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

ALTER TABLE CHG_CONN ADD PRIMARY KEY (CHG_CONN_ID);


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



SET TERM ^ ;



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

/* Trigger: CHG_CONN_BI */
CREATE OR ALTER TRIGGER CHG_CONN_BI FOR CHG_CONN
ACTIVE BEFORE INSERT POSITION 0
AS
BEGIN
  IF (NEW.chg_CONN_ID IS NULL) THEN
    NEW.chg_CONN_ID = GEN_ID(GEN_chg_conn_ID,1);
END
^
SET TERM ; ^