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

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


/* 
DIFFERENT FORM
USE u10;

DROP TABLE IF EXISTS my_Customer;

CREATE TABLE my_Customer
(
    customer_id INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY,
    salutation VARCHAR(30) NOT NULL,
    first_name VARCHAR(30) NOT NULL,
    middle_initial CHAR(2) NOT NULL,
    last_name VARCHAR(30) NOT NULL,
    gender ENUM('Male', 'Female', 'Other') NOT NULL,
    email VARCHAR(70) NOT NULL,
    phone VARCHAR(20) NOT NULL,
    street_address VARCHAR(100) NOT NULL,
    city VARCHAR(50) NOT NULL,
    region VARCHAR(50) NOT NULL,
    postal_code VARCHAR(20) NOT NULL,
    user_login_name VARCHAR(50) NOT NULL,
    login_password VARCHAR(32) NOT NULL,
    datetime_of_registration DATETIME
); 

CURRENTLY USING
CREATE TABLE my_Customers
(
    customer_id INT(4) NOT NULL AUTO_INCREMENT PRIMARY KEY,
    salutation VARCHAR(4) NOT NULL,
    first_name VARCHAR(15) NOT NULL,
    middle_initial VARCHAR(2) DEFAULT NULL,
    last_name VARCHAR(15) NOT NULL,
    gender VARCHAR(6) NOT NULL,
    email VARCHAR(30) NOT NULL UNIQUE,
    phone_number VARCHAR(15) DEFAULT NULL,
    street_address VARCHAR(30) NOT NULL,
    city VARCHAR(15) NOT NULL,
    region VARCHAR(2) NOT NULL,
    postal_code VARCHAR(7) NOT NULL,
    datetime_of_registration DATETIME NOT NULL,
    user_login_name VARCHAR(15) NOT NULL,
    login_password VARCHAR(32) NOT NULL
);

*/