appserver/tests/v2-tests/appserv-tests/devtests/cmp/inheritedpk/sql/inheritedpk_ifx.sql

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


CREATE TABLE A
(
    id     INT          PRIMARY KEY,
    lastName  VARCHAR(32) ,
    firstName VARCHAR(32) ,
    hireDate  DATE         ,
    birthDate DATE         ,
    salary    FLOAT        NOT NULL 
);

CREATE TABLE B
(
    id DATE          PRIMARY KEY,
    name   VARCHAR(32) 
);

CREATE TABLE C
(
    id INT          PRIMARY KEY,
    name   VARCHAR(32) 
);

commit;

quit;