-- Create Table Statement for 'Retail First Data Rapid Connect Profile'
DROP TABLE IF EXISTS `RETAIL_FIRST_DATA_RAPID_CONNECT_PROFILE`;
CREATE TABLE `RETAIL_FIRST_DATA_RAPID_CONNECT_PROFILE` (
	ID bigint(20) NOT NULL,
	TERMINAL_ID varchar,
	MERCHANT_ID varchar,
	ALTERNATE_MERCHANT_ID varchar,
	GROUP_ID varchar,
	MERCHANT_TAX_ID varchar,
	CUSTOMER_SERVICE_PHONE_NUMBER varchar,
	ECOMM_URL varchar,
	TPP_ID varchar,
	SECURE_CODE varchar,
	MERCHANT_NAME varchar,
	MERCHANT_STREET varchar,
	MERCHANT_CITY varchar,
	MERCHANT_STATE varchar,
	MERCHANT_ZIP_CODE varchar,
	CHARGE_DESCRIPTION varchar,
	APPLICATION_ID varchar,
	DATAWIRE_ID varchar,
	RETAIL_MERCHANT_CATEGORY_CODE varchar,
	RESTAURANT_MERCHANT_CATEGORY_CODE varchar,
	MOTO_MERCHANT_CATEGORY_CODE varchar,
	ECOMMERCE_MERCHANT_CATEGORY_CODE varchar,
	FILENAME varchar,
	SERVICE_ID varchar,
	IS_TEST_MODE tinyint(1),
	LODGING_MERCHANT_CATEGORY_CODE varchar,
	CAR_RENTAL_MERCHANT_CATEGORY_CODE varchar,
	MERCHANT_COUNTRY_CODE varchar,
	RETAIL_DATAWIRE_ID varchar,
	RESTAURANT_DATAWIRE_ID varchar,
	MOTO_DATAWIRE_ID varchar,
	ECOMMERCE_DATAWIRE_ID varchar,
	LODGING_DATAWIRE_ID varchar,
	CAR_RENTAL_DATAWIRE_ID varchar,
	RETAIL_MERCHANT_ID varchar,
	RESTAURANT_MERCHANT_ID varchar,
	MOTO_MERCHANT_ID varchar,
	ECOMMERCE_MERCHANT_ID varchar,
	LODGING_MERCHANT_ID varchar,
	CAR_RENTAL_MERCHANT_ID varchar,
	RETAIL_MERCHANT_ID_SETTLEMENT varchar,
	RESTAURANT_MERCHANT_ID_SETTLEMENT varchar,
	MOTO_MERCHANT_ID_SETTLEMENT varchar,
	ECOMMERCE_MERCHANT_ID_SETTLEMENT varchar,
	LODGING_MERCHANT_ID_SETTLEMENT varchar,
	CAR_RENTAL_MERCHANT_ID_SETTLEMENT varchar,
	RETAIL_TERMINAL_ID varchar,
	RESTAURANT_TERMINAL_ID varchar,
	MOTO_TERMINAL_ID varchar,
	ECOMMERCE_TERMINAL_ID varchar,
	LODGING_TERMINAL_ID varchar,
	CAR_RENTAL_TERMINAL_ID varchar,
	PETROLEUM_DATAWIRE_ID varchar,
	PETROLEUM_MERCHANT_CATEGORY_CODE varchar,
	PETROLEUM_MERCHANT_ID varchar,
	PETROLEUM_MERCHANT_ID_SETTLEMENT varchar,
	PETROLEUM_TERMINAL_ID varchar,
	MERCHANT_FNS_NUMBER varchar,
	DYNAMIC_MERCHANT_NAME varchar,
	DYNAMIC_MERCHANT_ADDRESS varchar,
	DYNAMIC_MERCHANT_CITY varchar,
	DYNAMIC_MERCHANT_STATE varchar,
	DYNAMIC_MERCHANT_COUNTY varchar,
	DYNAMIC_MERCHANT_ZIP varchar,
	DYNAMIC_MERCHANT_COUNTRY varchar,
	MERCHANT_ZIP_CODE varchar,
	MERCHANT_ZIP_CODE varchar,
	ECOMMERCE_MERCHANT_CATEGORY_CODE int(11),
	PRIMARY KEY (ID)
) ENGINE=InnoDB;