SET FOREIGN_KEY_CHECKS=0;




CREATE TABLE SIMPLE_MYSQL_CONTACT
(
	contact_id MEDIUMINT NOT NULL AUTO_INCREMENT,
	first_name VARCHAR(50) NOT NULL,
	last_name VARCHAR(50) NOT NULL,
	email VARCHAR(50) NOT NULL,
	phone VARCHAR(50),
	street_addr1 VARCHAR(50),
	street_addr2 VARCHAR(50),
	city VARCHAR(50),
	state VARCHAR(50),
	postal_code VARCHAR(50),
	PRIMARY KEY (contact_id)
) 
;



SET FOREIGN_KEY_CHECKS=1;
