--Create customre information table

DROP TABLE IF EXISTS my_customers;
CREATE TABLE my_customers 
(
	cust_id INT PRIMARY KEY AUTO_INCREMENT,
	salutation VARCHAR(4) NOT NULL,
	first_name VARCHAR(30) NOT NULL,
	middle_ini VARCHAR(5) DEFAULT NULL,
	last_name VARCHAR(30) NOT NULL,
	gender	VARCHAR(6)NOT NULL,
	email VARCHAR(60) NOT NULL UNIQUE,
	phone VARCHAR(13) DEFAULT NULL,
	street VARCHAR(30) NOT NULL,
	city VARCHAR(20) NOT NULL,
	region CHAR(2)NOT NULL,
	postal CHAR(6)NOT NULL,
	login_name VARCHAR(30) NOT NULL UNIQUE,
	password VARCHAR(60) NOT NULL
);