-- Create Table Statement for 'Vantiv Lowell Principal'
DROP TABLE IF EXISTS `VANTIV_LOWELL_PRINCIPAL`;
CREATE TABLE `VANTIV_LOWELL_PRINCIPAL` (
	ID bigint(20) NOT NULL,
	MERCHANT_ACCOUNT_CODE int(11) NOT NULL,
	FIRST_NAME varchar,
	LAST_NAME varchar,
	SSN varchar,
	STREET_ADDRESS1 varchar,
	STREET_ADDRESS2 varchar,
	CITY varchar,
	STATE_PROVINCE varchar,
	POSTAL_CODE varchar,
	COUNTRY_CODE varchar,
	DATE_OF_BIRTH varchar,
	STAKE_PERCENT varchar,
	EMAIL_ADDRESS varchar,
	CONTACT_PHONE varchar,
	DRIVER_LICENSE varchar,
	DRIVER_LICENSE_STATE varchar,
	BUSINESS_OWNER_FK bigint(20),
	CREATE_DATE datetime,
	RESULT_DATA longtext,
	VANTIV_LOWELL_PROVISIONING_TRANSACTION_FK bigint(20),
	PRINCIPAL_ID varchar,
	RESPONSE_CODE varchar,
	RESPONSE_DESCRIPTION varchar,
	ERROR_MESSAGE varchar,
	ONBOARDING_OWNER_FK bigint(20),
	ONBOARDING_OWNER_FK bigint(20),
	TITLE varchar,
	PRIMARY KEY (ID)
) ENGINE=InnoDB;