# Create my_Customers table

USE u26;
DROP TABLE IF EXISTS my_Customers;
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 CHAR(1), -- Assuming only one character for middle initial
    last_name VARCHAR(50) NOT NULL,
    gender ENUM('Male', 'Female', 'Other') NOT NULL, -- ENUM type for predefined values
    email VARCHAR(255) NOT NULL UNIQUE, -- Assuming emails are unique and potentially long
    phone VARCHAR(20), -- Adjusted length to accommodate different phone formats
    street VARCHAR(100), -- Assuming street address may be longer
    city VARCHAR(50), -- Adjusted length for city names
    region VARCHAR(50), -- Assuming region names can vary in length
    postal_code VARCHAR(10), -- Adjusted length to accommodate various postal code formats
    login_name VARCHAR(30) NOT NULL UNIQUE, -- Assuming login names are unique
    password VARCHAR(255) NOT NULL -- Assuming hashed passwords which can be quite long
);

