USE u61;

CREATE TABLE my_Customers (
    customer_id INT AUTO_INCREMENT PRIMARY KEY,
    salutation VARCHAR(10),
    first_name VARCHAR(50),
    middle_initial CHAR(1),
    last_name VARCHAR(50),
    gender ENUM('Male', 'Female', 'Other'),
    email_address VARCHAR(100),
    phone_number VARCHAR(15),
    street_address VARCHAR(100),
    city VARCHAR(50),
    region VARCHAR(50),
    postal_code VARCHAR(20),
    registration_datetime DATETIME,
    user_login_name VARCHAR(50) UNIQUE,
    login_password VARCHAR(255)
);
