/* create the my_customers table */
DROP TABLE IF EXISTS my_customers;
CREATE TABLE my_customers(
    customer_id INT NOT NULL AUTO_INCREMENT,
    salutation ENUM('Ms.', 'Mrs.', 'Mr.', 'Dr.') NOT NULL,
    first_name VARCHAR(20) NOT NULL,
    middle_initial VARCHAR(5),
    last_name VARCHAR(20) NOT NULL,
    gender ENUM('Male', 'Female', 'Other') NOT NULL,
    email VARCHAR(50) NOT NULL UNIQUE,
    phone VARCHAR(15),
    street_address VARCHAR(30) NOT NULL,
    city VARCHAR(20) NOT NULL,
    province_territory ENUM('AB', 'BC', 'MB', 'NB', 'NL', 'NS', 'ON', 'PE', 'QC', 'SK', 'NT', 'NU', 'YU') NOT NULL,
    postal_code VARCHAR(7) NOT NULL,
    date_time_registered DATETIME NOT NULL,
    user_login VARCHAR(15) NOT NULL,
    user_password VARCHAR(50) NOT NULL,
    PRIMARY KEY(customer_id));