USE u33;
DROP TABLE IF EXISTS u33.my_Customers;

CREATE TABLE my_Customers (
customerID INTEGER PRIMARY KEY AUTO_INCREMENT,
salutation VARCHAR(6),
firstName VARCHAR(30) NOT NULL,
middleInitial CHAR(1),
lastName VARCHAR(30) NOT NULL,
gender VARCHAR(20),
email VARCHAR(50) UNIQUE NOT NULL,
phone VARCHAR(15),
address VARCHAR(100) NOT NULL,
city VARCHAR(20) NOT NULL,
region VARCHAR(30) NOT NULL,
registrationTime DATETIME,
username VARCHAR(40) UNIQUE NOT NULL,
password VARCHAR(25) NOT NULL
);
