DROP TRIGGER ORDER_EVENT;
	DROP TRIGGER ORDER_CREATE;
	DROP TRIGGER ORDER_UPDATE;
	DROP TABLE ORDER;

        CREATE TABLE ORDER (
            ORDER_ID  INTEGER NOT NULL PRIMARY KEY,
            DESC      VARCHAR(255),
            QTY       INTEGER,
        );

        CREATE TABLE ORDER_EVENT (
            EVENT_ID         INTEGER NOT NULL GENERATED ALWAYS AS IDENTITY 
                             (START WITH 1, INCREMENT BY 1, NO CACHE ) PRIMARY KEY,
            OBJECT_KEY       INTEGER NOT NULL,
            OBJECT_NAME      VARCHAR(40) NOT NULL,
            OBJECT_FUNCTION  VARCHAR(40) NOT NULL,
            EVENT_PRIORITY   INT NOT NULL,
            EVENT_TIME       TIMESTAMP DEFAULT CURRENT TIMESTAMP NOT NULL,
            EVENT_STATUS     INT NOT NULL,
            EVENT_COMMENT    VARCHAR(100)
        );
        
        CREATE TRIGGER event_create 
        AFTER INSERT ON ORDER REFERENCING NEW AS N 
        FOR EACH ROW MODE DB2SQL
	INSERT INTO ORDER_EVENT 
            (object_key, object_name, object_function, event_priority, event_status)
        VALUES 
            (N.ORDER_ID, 'Db2adminOrderBG', 'Create', 1, 0);
        
        CREATE TRIGGER event_update
        AFTER UPDATE ON ORDER REFERENCING NEW AS N
        FOR EACH ROW MODE DB2SQL
	INSERT INTO ORDER_EVENT 
            (object_key, object_name, object_function, event_priority, event_status)
        VALUES 
            (N.ORDER_ID, 'Db2adminOrderBG', 'Update', 1, 0);
        
        CREATE TRIGGER event_delete
        AFTER DELETE ON ORDER REFERENCING OLD AS O
        FOR EACH ROW MODE DB2SQL
	INSERT INTO ORDER_EVENT 
            (object_key, object_name, object_function, event_priority, event_status)
        VALUES 
            (O.ORDER_ID, 'Db2adminOrderBG', 'Delete', 1, 0);