The c_custom.sql command file

The following command file creates the customer table:

CREATE TABLE customer
   (
   customer_num       SERIAL(101),
   fname              CHAR(15),
   lname              CHAR(15),
   company            CHAR(20),
   address1           CHAR(20),
   address2           CHAR(20),
   city               CHAR(15),
   state              CHAR(2),
   zipcode            CHAR(5),
   phone              CHAR(18),
   PRIMARY KEY (customer_num)
   );