appserver/tests/v2-tests/appserv-tests/devtests/cmp/partSupplier/sql/partSupplier_psql.sql

DROP TABLE SUPPLIERS cascade;
DROP TABLE PARTS cascade;

CREATE TABLE PARTS (
    PARTID INT PRIMARY KEY,
    NAME   VARCHAR(15),
    COLOR  VARCHAR(20),
    WEIGHT INT,
    PRICE  FLOAT
);

CREATE TABLE SUPPLIERS (
    PARTID     INT NOT NULL REFERENCES PARTS(PARTID),
    SUPPLIERID INT,
    NAME       VARCHAR(15), 
    STATUS     INT,
    CITY       VARCHAR(50),
    CONSTRAINT PK_SUPPLIERS primary key(SUPPLIERID, PARTID)
);

COMMIT;

quit;