#createCustomerTable.sql
#Table structure for table 'my_Customer'

DROP TABLE IF EXISTS my_Customer;
CREATE TABLE my_Customer
(
	customer_id INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY,
	salutation VARCHAR(4) NOT NULL,
	first_name VARCHAR(15) NOT NULL,
	middle_initial CHAR(2) NULL,
	last_name VARCHAR(15) NOT NULL,
	gender VARCHAR(6) NOT NULL,
	email VARCHAR(30) NOT NULL UNIQUE KEY,
	phone_number VARCHAR(15) NULL,
	street_address VARCHAR(30) NOT NULL,
	city VARCHAR(15) NOT NULL,
	region VARCHAR(2) NOT NULL,
	postal_code VARCHAR(7) NOT NULL,
	date_time DATETIME NOT NULL,
	login_name VARCHAR(15) NOT NULL,
	login_password VARCHAR(32) NOT NULL
);

