text: -- -----------------------------------------
  -- Sams Teach Yourself SQL in 10 Minutes
  -- http://forta.com/books/0672336073/
  -- Example table creation scripts for MySQL.
  -- -----------------------------------------
  SET NAMES utf8mb4;
  SET FOREIGN_KEY_CHECKS = 0;
  
  -- Create Database
  -- ----------------------------
  CREATE DATABASE IF NOT EXISTS `sqlin10mins` CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci;
  USE `sqlin10mins`;
  
  -- ----------------------
  -- Create Customers table
  -- ----------------------
  CREATE TABLE Customers
  (
    cust_id      char(10)  NOT NULL ,
    cust_name    char(50)  NOT NULL ,
    cust_address char(50)  NULL ,
    cust_city    char(50)  NULL ,
    cust_state   char(5)   NULL ,
    cust_zip     char(10)  NULL ,
    cust_country char(50)  NULL ,
    cust_contact char(50)  NULL ,
    cust_email   char(255) NULL 
  );
  
  -- -----------------------
  -- Create OrderItems table
  -- -----------------------
  CREATE TABLE OrderItems
  (
    order_num  int          NOT NULL ,
    order_item int          NOT NULL ,
    prod_id    char(10)     NOT NULL ,
    quantity   int          NOT NULL ,
    item_price decimal(8,2) NOT NULL 
  );
  
  
  -- -------------------
  -- Create Orders table
  -- -------------------
  CREATE TABLE Orders
  (
    order_num  int      NOT NULL ,
    order_date datetime NOT NULL ,
    cust_id    char(10) NOT NULL 
  );
  
  -- ---------------------
  -- Create Products table
  -- ---------------------
  CREATE TABLE Products
  (
    prod_id    char(10)      NOT NULL ,
    vend_id    char(10)      NOT NULL ,
    prod_name  char(255)     NOT NULL ,
    prod_price decimal(8,2)  NOT NULL ,
    prod_desc  text          NULL 
  );
  
  -- --------------------
  -- Create Vendors table
  -- --------------------
  CREATE TABLE Vendors
  (
    vend_id      char(10) NOT NULL ,
    vend_name    char(50) NOT NULL ,
    vend_address char(50) NULL ,
    vend_city    char(50) NULL ,
    vend_state   char(5)  NULL ,
    vend_zip     char(10) NULL ,
    vend_country char(50) NULL 
  );
  
  
  -- -------------------
  -- Define primary keys
  -- -------------------
  ALTER TABLE Customers ADD PRIMARY KEY (cust_id);
  ALTER TABLE OrderItems ADD PRIMARY KEY (order_num, order_item);
  ALTER TABLE Orders ADD PRIMARY KEY (order_num);
  ALTER TABLE Products ADD PRIMARY KEY (prod_id);
  ALTER TABLE Vendors ADD PRIMARY KEY (vend_id);
  
  
  -- -------------------
  -- Define foreign keys
  -- -------------------
  ALTER TABLE OrderItems ADD CONSTRAINT FK_OrderItems_Orders FOREIGN KEY (order_num) REFERENCES Orders (order_num);
  ALTER TABLE OrderItems ADD CONSTRAINT FK_OrderItems_Products FOREIGN KEY (prod_id) REFERENCES Products (prod_id);
  ALTER TABLE Orders ADD CONSTRAINT FK_Orders_Customers FOREIGN KEY (cust_id) REFERENCES Customers (cust_id);
  ALTER TABLE Products ADD CONSTRAINT FK_Products_Vendors FOREIGN KEY (vend_id) REFERENCES Vendors (vend_id);
  