CREATE TABLE products (
  sku        VARCHAR(20) NOT NULL PRIMARY KEY,
  mfg_pn     VARCHAR(30),
  name       VARCHAR(50),
  descr      VARCHAR(255),
  stock      INT,
  unit       VARCHAR(10),
  image      VARCHAR(50),
  vend_num   INT,
  price      VARCHAR(15)
);


CREATE TABLE vendors (
  vend_num   INT NOT NULL PRIMARY KEY AUTO_INCREMENT,
  address    VARCHAR(50),
  address2   VARCHAR(50),
  city       VARCHAR(50),
  state      VARCHAR(2),
  zip        VARCHAR(10),
  phone      VARCHAR(25),
  email      VARCHAR(150),
  url        VARCHAR(150),
  vname      VARCHAR(100)
);