CREATE TABLE my_customers (
    customer_id INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY,
    salutation VARCHAR(10) NOT NULL,
    first_name VARCHAR(50) NOT NULL,
    middle_initial VARCHAR(1),
    last_name VARCHAR(50) NOT NULL,
    gender VARCHAR(10) NOT NULL,
    email VARCHAR(100) UNIQUE NOT NULL,
    phone VARCHAR(20) UNIQUE  NULL, 
    street_address VARCHAR(100) NOT NULL,
    city VARCHAR(50) NOT NULL,
    region VARCHAR(10) NOT NULL,
    postal_code VARCHAR(10) NOT NULL,
    registration_datetime TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
    login_name VARCHAR(50) UNIQUE,
    password_hash VARCHAR(255)
);