CREATE TABLE my_customers (
    customer_id INT AUTO_INCREMENT PRIMARY KEY,
    salutation VARCHAR(10),
    first_name VARCHAR(50) NOT NULL,
    middle_initial CHAR(1),
    last_name VARCHAR(50) NOT NULL,
    gender ENUM('M', 'F', 'O') NOT NULL,
    email_address VARCHAR(100) NOT NULL,
    phone_number VARCHAR(20),
    street_address VARCHAR(100),
    city VARCHAR(50),
    region VARCHAR(50),
    postal_code VARCHAR(20),
    registration_date DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
    user_login_name VARCHAR(50) NOT NULL,
    login_password VARCHAR(255) NOT NULL
);