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

drop table suppliers;
drop table parts;

create table parts (
    PARTID NUMERIC(12),
    NAME VARCHAR(15),
    COLOR VARCHAR(20),
    WEIGHT NUMERIC(4),
    PRICE FLOAT(23),
    PRIMARY KEY(PARTID)
);

create table suppliers (
    PARTID NUMERIC(12) not null references parts(PARTID),
    SUPPLIERID NUMERIC(12),
    NAME VARCHAR(15),
    STATUS NUMERIC(2),
    CITY VARCHAR(50),
    constraint pk_suppliers primary key(SUPPLIERID, PARTID)
);