CREATE TABLE my_customers (
    customer_id INT AUTO_INCREMENT PRIMARY KEY,
    salutation VARCHAR(10),
    first_name VARCHAR(50),
    middle_initial VARCHAR(1),
    last_name VARCHAR(50),
    gender ENUM('Male', 'Female', 'Other'),
    email VARCHAR(100) UNIQUE,
    phone_number VARCHAR(15),
    street_address VARCHAR(100),
    city VARCHAR(50),
    region VARCHAR(50),
    postal_code VARCHAR(10),
    registration_datetime DATETIME,
    username VARCHAR(50) UNIQUE,
    password VARCHAR(32) -- MD5 encrypted password
);
