# Create Customer Table

USE u36;
DROP TABLE IF EXISTS my_Customer;
CREATE TABLE my_Customer (
    customer_id INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY,
    salutation VARCHAR(4) NOT NULL,
    first_name VARCHAR(30) NOT NULL,
    middle_initial CHAR(1) NULL,
    last_name VARCHAR(30) NOT NULL,
    gender VARCHAR(6) NOT NULL,
    email VARCHAR(50) NOT NULL UNIQUE KEY,
    phone_number VARCHAR(20) NULL,
    street_address VARCHAR(50) NOT NULL,
    city VARCHAR(20) NOT NULL,
    region VARCHAR(2) NOT NULL,
    postal_code VARCHAR(10) NOT NULL,
    date_time DATETIME NOT NULL,
    login_name VARCHAR(20) NOT NULL,
    login_password VARCHAR(32) NOT NULL 
);