appserver/tests/v2-tests/appserv-tests/devtests/cmp/unknownpkVC/sql/unknownpkVC_mysql.sql

DROP TRIGGER T_UNKNOWNPKVC1;
DROP TRIGGER T_UNKNOWNPKVC2;

DROP TABLE UNKNOWNPKVC1;
DROP TABLE UNKNOWNPKVC2;

CREATE TABLE UNKNOWNPKVC1
(
    ID     DECIMAL(38)              PRIMARY KEY,
    NAME   VARCHAR(32)     NULL,
    VERSION   DECIMAL(19)      NOT NULL
) engine=InnoDB;

CREATE TABLE UNKNOWNPKVC2
(
    ID     DECIMAL(38)              PRIMARY KEY,
    NAME   VARCHAR(32)     NULL,
    VERSION   DECIMAL(19)      NOT NULL
) engine=InnoDB;

commit;

CREATE TRIGGER T_UNKNOWNPKVC1
    BEFORE UPDATE ON UNKNOWNPKVC1
    FOR EACH ROW
       SET NEW.VERSION = OLD.VERSION + 1
;

CREATE TRIGGER T_UNKNOWNPKVC2
    BEFORE UPDATE ON UNKNOWNPKVC2
    FOR EACH ROW
       SET NEW.VERSION = OLD.VERSION + 1
;

commit;

quit;