c_stock.sql

The following command file creates the stock table:

CREATE TABLE stock
   (
   stock_num          SMALLINT,
   manu_code          CHAR(3),
   description        CHAR(15),
   unit_price         MONEY(6),
   unit               CHAR(4),
   unit_descr         CHAR(15),
   PRIMARY KEY (stock_num, manu_code),
   FOREIGN KEY (manu_code) REFERENCES manufact
   );