-- createCustomerTable.sql
USE u18;
DROP TABLE IF EXISTS my_Customer;
CREATE TABLE my_Customer
(
  customer_id INT NOT NULL AUTO_INCREMENT,
  salutation VARCHAR(4) NOT NULL,
  first_name VARCHAR(25) NOT NULL,
  middle_initial VARCHAR(2),
  last_name VARCHAR(25) NOT NULL,
  gender VARCHAR(6) NOT NULL,
  email VARCHAR(60) NOT NULL,
  phone VARCHAR(13),
  street VARCHAR(50) NOT NULL,
  city VARCHAR(50) NOT NULL,
  region VARCHAR(2) NOT NULL,
  postal_code VARCHAR(7) NOT NULL,
  date_time DATETIME NOT NULL,
  login_name VARCHAR(15) NOT NULL,
  login_password VARCHAR(32) NOT NULL,
  UNIQUE(email),
  PRIMARY KEY (customer_id)
);