appserver/tests/v2-tests/appserv-tests/devtests/cmp/cascadeDelete/sql/cascadeDelete_mysql.sql

DROP TABLE D;
DROP TABLE C;
DROP TABLE B;
DROP TABLE A;


CREATE TABLE A
(
    ID INT          PRIMARY KEY,
    NAME   VARCHAR(32) NULL
) ENGINE=INNODB;

CREATE TABLE B
(
    ID     INT          PRIMARY KEY,
    NAME   VARCHAR(32) NULL,
    AID    INT          NULL,
    FOREIGN KEY (AID)   REFERENCES A (ID)
) ENGINE=INNODB;

CREATE TABLE C
(
    ID   INT          PRIMARY KEY,
    NAME VARCHAR(32) NULL,
    AID   INT          NULL,
    BID   INT          NULL,
    FOREIGN KEY (AID)  REFERENCES A (ID),
    FOREIGN KEY (BID)  REFERENCES B (ID),
    UNIQUE (BID)
) ENGINE=INNODB;

CREATE TABLE D
(
    ID   INT          PRIMARY KEY,
    NAME VARCHAR(32) NULL,
    AID   INT          NULL,
    BID   INT          NULL,
    CID   INT          NULL,
    FOREIGN KEY (AID)  REFERENCES A (ID),
    FOREIGN KEY (BID)  REFERENCES B (ID),
    FOREIGN KEY (CID)  REFERENCES C (ID)
) ENGINE=INNODB;

commit;

quit;