-- Create Table Statement for 'Retail FirstData Compass Profile'
DROP TABLE IF EXISTS `RETAIL_FIRST_DATA_COMPASS_PROFILE`;
CREATE TABLE `RETAIL_FIRST_DATA_COMPASS_PROFILE` (
	ID bigint(20) NOT NULL,
	DIVISION_NUMBER varchar,
	MERCHANT_NAME varchar,
	PID varchar,
	PID_PASSWORD varchar,
	SID varchar,
	SID_PASSWORD varchar,
	CUSTOMER_SERVICE_PHONE_NUMBER varchar,
	ITEM_DESCRIPTION varchar,
	TPP_ID varchar,
	FILENAME varchar,
	MERCHANT_ID varchar,
	TERMINAL_ID varchar,
	SERVICE_ID varchar,
	DATAWIRE_ID varchar,
	APPLICATION_ID varchar,
	IS_TEST_MODE tinyint(1),
	MERCHANT_STREET varchar,
	MERCHANT_CITY varchar,
	MERCHANT_REGION varchar,
	MERCHANT_POSTAL_CODE varchar,
	MERCHANT_COUNTRY_CODE varchar,
	DESCRIPTOR_PREFIX varchar,
	DESCRIPTOR varchar,
	FOOD_AND_CONSUMER_NUMBER varchar,
	RETAIL_FIRST_DATA_COMPASS_PROFILE_CL varchar,
	MERCHANT_LOCATION_ID varchar,
	MERCHANT_EMAIL varchar,
	MERCHANT_CATEGORY_CODE varchar,
	FOOD_AND_CONSUMER_NUMBER varchar,
	RETAIL_FIRST_DATA_COMPASS_PROFILE_CL varchar,
	MERCHANT_LOCATION_ID varchar,
	MERCHANT_EMAIL varchar,
	MERCHANT_CATEGORY_CODE varchar,
	FOOD_AND_CONSUMER_NUMBER varchar,
	RETAIL_FIRST_DATA_COMPASS_PROFILE_CL varchar,
	MERCHANT_LOCATION_ID varchar,
	MERCHANT_EMAIL varchar,
	MERCHANT_CATEGORY_CODE varchar,
	AUTH_USERNAME varchar,
	AUTH_PASSWORD varchar,
	AUTH_USERNAME varchar,
	AUTH_PASSWORD varchar,
	AUTH_USERNAME varchar,
	AUTH_PASSWORD varchar,
	PRIMARY KEY (ID)
) ENGINE=InnoDB;