CREATE TABLE service_list_members (
	id 				INT PRIMARY KEY AUTO_INCREMENT,
	company_name 			VARCHAR(128) NOT NULL,
	first_name 			VARCHAR(128) NOT NULL,
	last_lname 			VARCHAR(128) NOT NULL,
	title 				VARCHAR(128) NOT NULL,
	email 				VARCHAR(128) NOT NULL,
	company_url			VARCHAR(128) NOT NULL,
	phone 				VARCHAR(128) NOT NULL,
	address1 			VARCHAR(128) NOT NULL,
	address2 			VARCHAR(128) NOT NULL,
	city 				VARCHAR(64) NOT NULL,
	state_prov 			VARCHAR(64) NOT NULL,
	postal 				VARCHAR(32) NOT NULL,
	country 			VARCHAR(128) NOT NULL,
	comments			TEXT,
	date_added			DATETIME,
	opt_in 				ENUM('yes', 'no'),
	contact_type_id 		INT NOT NULL,
	status 				VARCHAR(32) DEFAULT 'enabled'
);

CREATE TABLE service_list_history (
	id 				INT PRIMARY KEY AUTO_INCREMENT,
	member_id			INT NOT NULL,
	create_date			DATETIME,
	modify_date			DATETIME,
	action_date			DATETIME,
	action				TEXT,
	status 				VARCHAR(32) DEFAULT 'enabled'
);

CREATE TABLE contact_types (
	id 				INT PRIMARY KEY AUTO_INCREMENT,
	contact_type			VARCHAR(128),
	status 				VARCHAR(32) DEFAULT 'enabled'
);