Le script SQL de la base de données |
  
|
Le script SQL de la base de données |
|
SET SQL DIALECT 3;
CREATE DATABASE 'C:\VK-WinQV\WQVFiles\Dbase\QuickView.FDB'
USER 'SYSDBA' PASSWORD 'masterkey'
PAGE_SIZE 4096
DEFAULT CHARACTER SET NONE;
/* Domains definitions */
CREATE DOMAIN BOOLEAN_DOMAIN AS CHAR (1)
DEFAULT 'F'
CHECK (Value in ('F','T'));
CREATE DOMAIN ID_DOMAIN AS INTEGER
NOT NULL;
CREATE DOMAIN STATUS_DOMAIN AS CHAR (1)
DEFAULT 'A'
CHECK (Value in ('A','X','N','P','D'));
/* Generators definitions */
CREATE GENERATOR NEW_ALARM_GROUP ;
CREATE GENERATOR NEW_ALARM_MESSAGE ;
CREATE GENERATOR NEW_ALARM_TYPE ;
CREATE GENERATOR NEW_LOAD ;
CREATE GENERATOR NEW_MSG ;
CREATE GENERATOR NEW_PART ;
CREATE GENERATOR NEW_TB ;
CREATE GENERATOR NEW_BASKET;
CREATE GENERATOR NEW_CIP;
CREATE GENERATOR NEW_CIP_ACTION;
SET GENERATOR NEW_ALARM_GROUP TO 0;
SET GENERATOR NEW_ALARM_MESSAGE TO 0;
SET GENERATOR NEW_ALARM_TYPE TO 0;
SET GENERATOR NEW_LOAD TO 0;
SET GENERATOR NEW_MSG TO 0;
SET GENERATOR NEW_PART TO 0;
SET GENERATOR NEW_TB TO 0;
SET GENERATOR NEW_BASKET TO 0;
SET GENERATOR NEW_CIP TO 0;
SET GENERATOR NEW_CIP_ACTION TO 0;
/* Tables definitions */
CREATE TABLE VK_ACTIONS (
ACTION_ID INTEGER NOT NULL,
DESCRIPTION VARCHAR (80));
CREATE TABLE VK_ALARM_GROUPS (
REC_ID INTEGER NOT NULL,
ALAGROUP_ID INTEGER,
MACHINE_ID INTEGER,
DESCRIPTION VARCHAR (80),
NAME_LGU0 VARCHAR (32),
NAME_LGU1 VARCHAR (32),
NAME_LGU2 VARCHAR (32),
NAME_LGU3 VARCHAR (32),
STATUS STATUS_DOMAIN);
CREATE TABLE VK_ALARM_MESSAGES (
REC_ID INTEGER NOT NULL,
ALAMESSAGE_ID INTEGER,
MACHINE_ID INTEGER,
DESCRIPTION VARCHAR (80),
NAME_LGU0 VARCHAR (120),
NAME_LGU1 VARCHAR (120),
NAME_LGU2 VARCHAR (120),
NAME_LGU3 VARCHAR (120),
STATUS STATUS_DOMAIN);
CREATE TABLE VK_ALARM_TYPES (
REC_ID INTEGER NOT NULL,
ALATYPE_ID INTEGER,
MACHINE_ID INTEGER,
DESCRIPTION VARCHAR (80),
NAME_LGU0 VARCHAR (32),
NAME_LGU1 VARCHAR (32),
NAME_LGU2 VARCHAR (32),
NAME_LGU3 VARCHAR (32),
STATUS STATUS_DOMAIN);
CREATE TABLE VK_LOADS (
REC_ID INTEGER NOT NULL,
LOAD_ID INTEGER,
MACHINE_ID INTEGER,
CUSTOMER_NAME VARCHAR(80),
CUSTOMER_NUMBER VARCHAR(16),
CREATE_DATE DATE,
CREATE_TIME TIME,
CREATE_TIMESTAMP TIMESTAMP,
PROGRAM_NR SMALLINT,
PROGRAM_NAME VARCHAR(80),
PROGRAM_VERSION SMALLINT,
MODE_NR SMALLINT,
MODE_NAME VARCHAR(80),
MODE_VERSION SMALLINT,
JIG_NR SMALLINT,
POSITION_NR SMALLINT,
REMARQUE1 VARCHAR (80),
REMARQUE2 VARCHAR (80),
RECEIPT_NAME VARCHAR (80),
AREA_FRONT_A FLOAT,
AREA_BACK_A FLOAT,
AREA_FRONT_B FLOAT,
AREA_BACK_B FLOAT,
AREA_FRONT_C FLOAT,
AREA_BACK_C FLOAT,
AREA_FRONT_D FLOAT,
AREA_BACK_D FLOAT,
AREA_CHEM FLOAT,
UP_TYPE SMALLINT,
DOWN_TYPE SMALLINT,
ROTATION_TYPE SMALLINT,
ROTATION_SPEED SMALLINT,
SUPPORT_TYPE SMALLINT,
PANEL_TYPE SMALLINT,
PANEL_NR SMALLINT,
CHECK_SUM INTEGER,
END_STATUS SMALLINT,
UNLOAD_DATE DATE,
UNLOAD_TIME TIME,
UNLOAD_TIMESTAMP TIMESTAMP,
DEPARTEMENT VARCHAR (80),
TEAM VARCHAR(80),
NUM_LOAD SMALLINT,
TOTAL_LOAD SMALLINT,
VALIDATION SMALLINT,
TXT_1 VARCHAR(80),
TXT_2 VARCHAR(80),
TXT_3 VARCHAR(80),
TXT_4 VARCHAR(80),
TXT_5 VARCHAR(80),
TXT_6 VARCHAR(64),
TXT_7 VARCHAR(64),
TXT_8 VARCHAR(64),
TXT_9 VARCHAR(64),
TXT_10 VARCHAR(64),
TXT_11 VARCHAR(32),
TXT_12 VARCHAR(32),
TXT_13 VARCHAR(32),
TXT_14 VARCHAR(32),
TXT_15 VARCHAR(32),
TXT_16 VARCHAR(32),
TXT_17 VARCHAR(32),
TXT_18 VARCHAR(32),
TXT_19 VARCHAR(32),
TXT_20 VARCHAR(32),
CHEM_NAME_1 VARCHAR(64),
CHEM_NAME_2 VARCHAR(64),
CHEM_NAME_3 VARCHAR(64),
CHEM_NAME_4 VARCHAR(64),
CHEM_NAME_5 VARCHAR(64),
CHEM_NAME_6 VARCHAR(64),
CHEM_NAME_7 VARCHAR(64),
CHEM_NAME_8 VARCHAR(64),
CHEM_NAME_9 VARCHAR(64),
CHEM_NAME_10 VARCHAR(64),
CHEM_NAME_11 VARCHAR(64),
CHEM_NAME_12 VARCHAR(64),
CHEM_NAME_13 VARCHAR(64),
CHEM_NAME_14 VARCHAR(64),
CHEM_NAME_15 VARCHAR(64),
CHEM_NAME_16 VARCHAR(64),
CHEM_LOT_1 VARCHAR(64),
CHEM_LOT_2 VARCHAR(64),
CHEM_LOT_3 VARCHAR(64),
CHEM_LOT_4 VARCHAR(64),
CHEM_LOT_5 VARCHAR(64),
CHEM_LOT_6 VARCHAR(64),
CHEM_LOT_7 VARCHAR(64),
CHEM_LOT_8 VARCHAR(64),
CHEM_LOT_9 VARCHAR(64),
CHEM_LOT_10 VARCHAR(64),
CHEM_LOT_11 VARCHAR(64),
CHEM_LOT_12 VARCHAR(64),
CHEM_LOT_13 VARCHAR(64),
CHEM_LOT_14 VARCHAR(64),
CHEM_LOT_15 VARCHAR(64),
CHEM_LOT_16 VARCHAR(64),
SERVER_VERSION VARCHAR(64),
STATUS STATUS_DOMAIN);
CREATE TABLE VK_LOAD_PARTS (
PART_ID INTEGER NOT NULL,
LOAD_ID INTEGER,
MACHINE_ID INTEGER,
PART_NR SMALLINT,
PART_TYPE SMALLINT,
REFERENCE VARCHAR (64),
VAL_S1 VARCHAR (64),
VAL_S2 VARCHAR (64),
VAL_S3 VARCHAR (64),
VAL_S4 VARCHAR (64),
VAL_S5 VARCHAR (64),
VAL_S6 VARCHAR (64),
VAL_S7 VARCHAR (64),
VAL_S8 VARCHAR (64),
VAL_S9 VARCHAR (64),
VAL_S10 VARCHAR (64),
VAL_N1 INTEGER,
VAL_N2 INTEGER,
VAL_N3 INTEGER,
VAL_N4 INTEGER,
VAL_N5 INTEGER,
VAL_N6 INTEGER,
VAL_N7 INTEGER,
VAL_N8 INTEGER,
VAL_N9 INTEGER,
VAL_N10 INTEGER,
VAL_R1 FLOAT,
VAL_R2 FLOAT,
VAL_R3 FLOAT,
VAL_R4 FLOAT,
VAL_R5 FLOAT,
VAL_R6 FLOAT,
VAL_R7 FLOAT,
VAL_R8 FLOAT,
VAL_R9 FLOAT,
VAL_R10 FLOAT,
STATUS STATUS_DOMAIN);
CREATE TABLE VK_LOAD_TBS (
TB_ID INTEGER NOT NULL,
LOAD_ID INTEGER,
MACHINE_ID INTEGER,
TB_NB SMALLINT,
TB SMALLINT,
TB_NAME VARCHAR (32),
TB_POSITION SMALLINT,
TB_GROUP SMALLINT,
TB_CYCLE SMALLINT,
TB_TIME INTEGER,
TB_SINGLEPOS SMALLINT,
TB_RAMP SMALLINT,
TB_RAMP_TYPE SMALLINT,
TB_DENSITY FLOAT,
TB_THICKNESS FLOAT,
CHECK_SUM INTEGER,
STATUS STATUS_DOMAIN);
CREATE TABLE VK_MESSAGES (
MESSAGE_ID INTEGER NOT NULL,
LOAD_ID INTEGER,
MACHINE_ID INTEGER,
TYPE_ID INTEGER,
MSG_DATE DATE,
MSG_TIME TIME,
MSG_TIMESTAMP TIMESTAMP,
USER_ID INTEGER,
MACHINE_NB SMALLINT,
POSITION_NB SMALLINT,
ACTION_ID INTEGER,
VAL_N1 INTEGER,
VAL_N2 INTEGER,
VAL_N3 INTEGER,
VAL_N4 INTEGER,
VAL_N5 INTEGER,
VAL_N6 INTEGER,
VAL_N7 INTEGER,
VAL_N8 INTEGER,
VAL_N9 INTEGER,
VAL_N10 INTEGER,
VAL_R1 FLOAT,
VAL_R2 FLOAT,
VAL_R3 FLOAT,
VAL_R4 FLOAT,
VAL_R5 FLOAT,
VAL_R6 FLOAT,
VAL_R7 FLOAT,
VAL_R8 FLOAT,
VAL_R9 FLOAT,
VAL_R10 FLOAT,
VAL_S1 VARCHAR (80),
VAL_S2 VARCHAR (80),
VAL_TIME1 TIMESTAMP,
VAL_TIME2 TIMESTAMP,
CHECK_SUM INTEGER,
STATUS STATUS_DOMAIN);
CREATE TABLE VK_MSG_TYPES (
TYPE_ID INTEGER NOT NULL,
DESCRIPTION VARCHAR (80));
CREATE TABLE VK_BASKETS (
BASKET_ID INTEGER NOT NULL,
BASKET_REF VARCHAR(32),
PROGRAM_NR INTEGER,
MODE_NR INTEGER,
LOAD_ID INTEGER,
ORDERCOUNT INTEGER,
ORDER_1 VARCHAR(32),
ARTICLE_1 VARCHAR(32),
COUNT_1 INTEGER,
ORDER_2 VARCHAR(32),
ARTICLE_2 VARCHAR(32),
COUNT_2 INTEGER,
ORDER_3 VARCHAR(32),
ARTICLE_3 VARCHAR(32),
COUNT_3 INTEGER,
ORDER_4 VARCHAR(32),
ARTICLE_4 VARCHAR(32),
COUNT_4 INTEGER,
ORDER_5 VARCHAR(32),
ARTICLE_5 VARCHAR(32),
COUNT_5 INTEGER,
ORDER_6 VARCHAR(32),
ARTICLE_6 VARCHAR(32),
COUNT_6 INTEGER,
ORDER_7 VARCHAR(32),
ARTICLE_7 VARCHAR(32),
COUNT_7 INTEGER,
ORDER_8 VARCHAR(32),
ARTICLE_8 VARCHAR(32),
COUNT_8 INTEGER,
ORDER_9 VARCHAR(32),
ARTICLE_9 VARCHAR(32),
COUNT_9 INTEGER,
ORDER_10 VARCHAR(32),
ARTICLE_10 VARCHAR(32),
COUNT_10 INTEGER
);
CREATE TABLE VK_CIP (
CIP_ID INTEGER NOT NULL,
CYCLE_ID INTEGER,
MACHINE_ID INTEGER,
CREATE_DATE DATE,
CREATE_TIME TIME,
END_DATE DATE,
END_TIME TIME,
END_STATUS INTEGER,
VAL_N1 INTEGER,
VAL_N2 INTEGER,
VAL_N3 INTEGER,
VAL_N4 INTEGER,
VAL_N5 INTEGER,
VAL_R1 FLOAT,
VAL_R2 FLOAT,
VAL_R3 FLOAT,
VAL_R4 FLOAT,
VAL_R5 FLOAT,
VAL_S1 VARCHAR (80),
VAL_S2 VARCHAR (80)
);
CREATE TABLE VK_CIP_ACTIONS (
CIP_ACTION_ID INTEGER NOT NULL,
CYCLE_ID INTEGER,
MSG_DATE DATE,
MSG_TIME TIME,
MSG_TIMESTAMP TIMESTAMP,
ACTION_ID INTEGER,
VAL_N1 INTEGER,
VAL_N2 INTEGER,
VAL_N3 INTEGER,
VAL_N4 INTEGER,
VAL_N5 INTEGER,
VAL_R1 FLOAT,
VAL_R2 FLOAT,
VAL_R3 FLOAT,
VAL_R4 FLOAT,
VAL_R5 FLOAT,
VAL_S1 VARCHAR (80),
VAL_S2 VARCHAR (80)
);
INSERT INTO VK_ACTIONS (ACTION_ID, DESCRIPTION) VALUES (101, 'Take load');
INSERT INTO VK_ACTIONS (ACTION_ID, DESCRIPTION) VALUES (102, 'Drop load');
INSERT INTO VK_ACTIONS (ACTION_ID, DESCRIPTION) VALUES (103, 'Ah (real)');
INSERT INTO VK_ACTIONS (ACTION_ID, DESCRIPTION) VALUES (104, 'Ah (theoritical)');
INSERT INTO VK_ACTIONS (ACTION_ID, DESCRIPTION) VALUES (105, 'Mean current');
INSERT INTO VK_ACTIONS (ACTION_ID, DESCRIPTION) VALUES (106, 'Mean voltage');
INSERT INTO VK_ACTIONS (ACTION_ID, DESCRIPTION) VALUES (107, 'Max current');
INSERT INTO VK_ACTIONS (ACTION_ID, DESCRIPTION) VALUES (108, 'Max voltage');
INSERT INTO VK_ACTIONS (ACTION_ID, DESCRIPTION) VALUES (111, 'End job (Bath transfert)');
INSERT INTO VK_ACTIONS (ACTION_ID, DESCRIPTION) VALUES (112, 'Start job (Bath transfert)');
INSERT INTO VK_ACTIONS (ACTION_ID, DESCRIPTION) VALUES (201, 'Login');
INSERT INTO VK_ACTIONS (ACTION_ID, DESCRIPTION) VALUES (202, 'Logout');
INSERT INTO VK_ACTIONS (ACTION_ID, DESCRIPTION) VALUES (301, 'Alarm Return');
INSERT INTO VK_ACTIONS (ACTION_ID, DESCRIPTION) VALUES (302, 'Alarm Acknowlege');
INSERT INTO VK_ACTIONS (ACTION_ID, DESCRIPTION) VALUES (303, 'Alarm Alarm');
INSERT INTO VK_ACTIONS (ACTION_ID, DESCRIPTION) VALUES (401, 'Log item');
INSERT INTO VK_ACTIONS (ACTION_ID, DESCRIPTION) VALUES (402, 'Log rectifier');
INSERT INTO VK_ACTIONS (ACTION_ID, DESCRIPTION) VALUES (403, 'Log US');
INSERT INTO VK_ACTIONS (ACTION_ID, DESCRIPTION) VALUES (404, 'Log validation data');
INSERT INTO VK_ACTIONS (ACTION_ID, DESCRIPTION) VALUES (405, 'Log validation windows');
INSERT INTO VK_ACTIONS (ACTION_ID, DESCRIPTION) VALUES (501, 'Program mode');
INSERT INTO VK_ACTIONS (ACTION_ID, DESCRIPTION) VALUES (502, 'Buffer mode');
INSERT INTO VK_ACTIONS (ACTION_ID, DESCRIPTION) VALUES (503, 'Machine mode');
INSERT INTO VK_ACTIONS (ACTION_ID, DESCRIPTION) VALUES (504, 'Log counters');
INSERT INTO VK_ACTIONS (ACTION_ID, DESCRIPTION) VALUES (505, 'Log dosing');
INSERT INTO VK_ACTIONS (ACTION_ID, DESCRIPTION) VALUES (601, 'Message Return');
INSERT INTO VK_ACTIONS (ACTION_ID, DESCRIPTION) VALUES (602, 'Message Acknowlege');
INSERT INTO VK_ACTIONS (ACTION_ID, DESCRIPTION) VALUES (603, 'Message Alarm');
INSERT INTO VK_ACTIONS (ACTION_ID, DESCRIPTION) VALUES (701, 'Auto add chemical');
INSERT INTO VK_ACTIONS (ACTION_ID, DESCRIPTION) VALUES (702, 'Manu add chemical');
INSERT INTO VK_ACTIONS (ACTION_ID, DESCRIPTION) VALUES (801, 'Equipment control execute command');
INSERT INTO VK_ACTIONS (ACTION_ID, DESCRIPTION) VALUES (802, 'Equipment control start command');
COMMIT WORK;
INSERT INTO VK_MSG_TYPES (TYPE_ID, DESCRIPTION) VALUES (100, 'Take/Give load');
INSERT INTO VK_MSG_TYPES (TYPE_ID, DESCRIPTION) VALUES (200, 'Login/Logout');
INSERT INTO VK_MSG_TYPES (TYPE_ID, DESCRIPTION) VALUES (300, 'Alarm/Return/Ack');
INSERT INTO VK_MSG_TYPES (TYPE_ID, DESCRIPTION) VALUES (400, 'Logger');
INSERT INTO VK_MSG_TYPES (TYPE_ID, DESCRIPTION) VALUES (500, 'Modes');
INSERT INTO VK_MSG_TYPES (TYPE_ID, DESCRIPTION) VALUES (600, 'Message/Return/Ack');
INSERT INTO VK_MSG_TYPES (TYPE_ID, DESCRIPTION) VALUES (700, 'Chemicals');
INSERT INTO VK_MSG_TYPES (TYPE_ID, DESCRIPTION) VALUES (800, 'Equipments control');
COMMIT WORK;
/* Primary keys definition */
ALTER TABLE VK_ACTIONS ADD CONSTRAINT PK_VK_ACTIONS PRIMARY KEY (ACTION_ID);
ALTER TABLE VK_ALARM_GROUPS ADD CONSTRAINT PK_VK_ALARM_GROUPS PRIMARY KEY (REC_ID);
ALTER TABLE VK_ALARM_MESSAGES ADD CONSTRAINT PK_VK_ALARM_MESSAGES PRIMARY KEY (REC_ID);
ALTER TABLE VK_ALARM_TYPES ADD CONSTRAINT PK_VK_ALARM_TYPES PRIMARY KEY (REC_ID);
ALTER TABLE VK_LOADS ADD CONSTRAINT PK_VK_LOADS PRIMARY KEY (REC_ID);
ALTER TABLE VK_LOAD_PARTS ADD CONSTRAINT PK_VK_LOAD_PARTS PRIMARY KEY (PART_ID);
ALTER TABLE VK_LOAD_TBS ADD CONSTRAINT PK_VK_LOAD_TBS PRIMARY KEY (TB_ID);
ALTER TABLE VK_MESSAGES ADD CONSTRAINT PK_VK_MESSAGES PRIMARY KEY (MESSAGE_ID);
ALTER TABLE VK_MSG_TYPES ADD CONSTRAINT PK_VK_MSG_TYPES PRIMARY KEY (TYPE_ID);
ALTER TABLE VK_BASKETS ADD CONSTRAINT PK_VK_BASKETS PRIMARY KEY (BASKET_ID);
ALTER TABLE VK_CIP ADD CONSTRAINT PK_VK_CIP PRIMARY KEY (CIP_ID);
ALTER TABLE VK_CIP_ACTIONS ADD CONSTRAINT PK_VK_CIP_ACTIONS PRIMARY KEY (CIP_ACTION_ID);
/* Indices definition */
CREATE INDEX IDX_VK_ALARM_GROUPS ON VK_ALARM_GROUPS (ALAGROUP_ID,MACHINE_ID);
CREATE INDEX IDX_VK_ALARM_TYPES ON VK_ALARM_TYPES (ALATYPE_ID,MACHINE_ID);
CREATE INDEX IDX_VK_ALARM_MESSAGES ON VK_ALARM_MESSAGES (ALAMESSAGE_ID,MACHINE_ID);
CREATE INDEX IDX_VK_MESSAGES ON VK_MESSAGES (LOAD_ID,MACHINE_ID);
CREATE INDEX IDX_VK_MESSAGES1 ON VK_MESSAGES (ACTION_ID);
CREATE INDEX IDX_VK_MESSAGES2 ON VK_MESSAGES (TYPE_ID);
CREATE INDEX IDX_VK_MESSAGES3 ON VK_MESSAGES (MSG_DATE);
CREATE INDEX IDX_VK_LOADS ON VK_LOADS (LOAD_ID,MACHINE_ID);
CREATE INDEX IDX_VK_LOADS1 ON VK_LOADS (DEPARTEMENT);
CREATE INDEX IDX_VK_LOADS2 ON VK_LOADS (CREATE_DATE);
CREATE INDEX IDX_VK_BASKETS ON VK_BASKETS (LOAD_ID);
CREATE INDEX IDX_VK_BASKETS1 ON VK_BASKETS (BASKET_REF);
CREATE INDEX IDX_VK_CIP1 ON VK_CIP (CIP_ID,CYCLE_ID);
CREATE INDEX IDX_VK_CIP2 ON VK_CIP (CREATE_DATE);
CREATE INDEX IDX_VK_CIP_ACTIONS ON VK_CIP_ACTIONS (msg_date);
SET TERM ^ ;
/* Triggers definition */
/* Trigger: VK_ALARM_GROUPS_BI */
CREATE TRIGGER VK_ALARM_GROUPS_BI FOR VK_ALARM_GROUPS ACTIVE
BEFORE INSERT POSITION 0
AS
BEGIN
/* Trigger body */
if (New.rec_id IS NULL) then NEW.rec_id = GEN_ID(NEW_ALARM_GROUP,1);
if (NEW.status IS NULL) then NEW.STATUS = 'A';
END
^
/* Trigger: VK_ALARM_MESSAGES_BI */
CREATE TRIGGER VK_ALARM_MESSAGES_BI FOR VK_ALARM_MESSAGES ACTIVE
BEFORE INSERT POSITION 0
AS
BEGIN
/* Trigger body */
if (new.rec_id IS NULL) then NEW.rec_id = GEN_ID(NEW_ALARM_MESSAGE,1);
if (NEW.status IS NULL) then NEW.STATUS = 'A';
END
^
/* Trigger: VK_ALARM_TYPES_BI */
CREATE TRIGGER VK_ALARM_TYPES_BI FOR VK_ALARM_TYPES ACTIVE
BEFORE INSERT POSITION 0
AS
BEGIN
/* Trigger body */
if (new.rec_id IS NULL) then NEW.rec_id = GEN_ID(NEW_ALARM_TYPE,1);
if (NEW.status IS NULL) then NEW.STATUS = 'A';
END
^
/* Trigger: VK_LOADS_BI */
CREATE TRIGGER VK_LOADS_BI FOR VK_LOADS ACTIVE
BEFORE INSERT POSITION 0
AS
BEGIN
/* Trigger body */
if (NEW.REC_ID IS NULL) then NEW.REC_ID = GEN_ID(NEW_LOAD,1);
if (NEW.status IS NULL) then NEW.STATUS = 'A';
if (New.CREATE_date IS NULL) then New.CREATE_date = CURRENT_DATE;
if (NEW.CREATE_time IS NULL) then NEW.CREATE_time = CURRENT_TIME;
if (New.CREATE_timestamp IS NULL) then new.CREATE_timestamp = CURRENT_TIMESTAMP;
END
^
/* Trigger: VK_LOAD_PARTS_BI */
CREATE TRIGGER VK_LOAD_PARTS_BI FOR VK_LOAD_PARTS ACTIVE
BEFORE INSERT POSITION 0
AS
BEGIN
/* Trigger body */
NEW.PART_ID = GEN_ID(NEW_PART,1);
if (NEW.status IS NULL) then NEW.STATUS = 'A';
END
^
/* Trigger: VK_LOAD_TBS_BI */
CREATE TRIGGER VK_LOAD_TBS_BI FOR VK_LOAD_TBS ACTIVE
BEFORE INSERT POSITION 0
AS
BEGIN
/* Trigger body */
NEW.TB_ID = GEN_ID(NEW_TB,1);
if (NEW.status IS NULL) then NEW.STATUS = 'A';
END
^
/* Trigger: VK_MESSAGES_BI */
CREATE TRIGGER VK_MESSAGES_BI FOR VK_MESSAGES ACTIVE
BEFORE INSERT POSITION 0
AS
BEGIN
/* Trigger body */
NEW.MESSAGE_ID = GEN_ID(NEW_MSG,1);
if (NEW.status IS NULL) then NEW.STATUS = 'A';
if (New.msg_date IS NULL) then New.msg_date = CURRENT_DATE;
if (NEW.msg_time IS NULL) then NEW.msg_time = CURRENT_TIME;
if (New.msg_timestamp IS NULL) then new.msg_timestamp = CURRENT_TIMESTAMP;
END
^
/* Trigger: VK_BASKETS_BI */
CREATE TRIGGER VK_BASKETS_BI FOR VK_BASKETS ACTIVE
BEFORE INSERT POSITION 0
AS
BEGIN
/* Trigger body */
NEW.BASKET_ID = GEN_ID(NEW_BASKET,1);
END
^
/* Trigger: VK_CIP_BI */
CREATE TRIGGER VK_CIP_BI FOR VK_CIP ACTIVE
BEFORE INSERT POSITION 0
AS
BEGIN
/* Trigger body */
NEW.CIP_ID = GEN_ID(NEW_CIP,1);
if (New.create_date IS NULL) then New.create_date = CURRENT_DATE;
if (NEW.create_time IS NULL) then NEW.create_time = CURRENT_TIME;
END
^
/* Trigger: VK_CIP_BI */
CREATE TRIGGER VK_CIP_ACTION_BI FOR VK_CIP_ACTIONS ACTIVE
BEFORE INSERT POSITION 0
AS
BEGIN
/* Trigger body */
NEW.CIP_ACTION_ID = GEN_ID(NEW_CIP_ACTION,1);
if (New.msg_date IS NULL) then New.msg_date = CURRENT_DATE;
if (NEW.msg_time IS NULL) then NEW.msg_time = CURRENT_TIME;
if (New.msg_timestamp IS NULL) then new.msg_timestamp = CURRENT_TIMESTAMP;
END
^
SET TERM ; ^