USE u28;
DROP TABLE IF EXISTS my_Customer;
CREATE TABLE my_Customer
(
    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), 
    last_name VARCHAR(50) NOT NULL,
    gender ENUM('Male', 'Female', 'Other') NOT NULL, 
    email VARCHAR(255) NOT NULL UNIQUE, 
    phone VARCHAR(20), 
    street VARCHAR(100), 
    city VARCHAR(50), 
    region VARCHAR(50), 
    postal_code VARCHAR(10), 
    login_name VARCHAR(30) NOT NULL UNIQUE, 
    password VARCHAR(255) NOT NULL,
    registration_datetime DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP
);
