-- Create Table Statement for 'Retail TSYS Profile'
DROP TABLE IF EXISTS `RETAIL_TSYS_PROFILE`;
CREATE TABLE `RETAIL_TSYS_PROFILE` (
	ID bigint(20) NOT NULL,
	ACQUIRER_BIN varchar,
	AGENT_BANK_NUMBER varchar,
	AGENT_CHAIN_NUMBER varchar,
	MERCHANT_NUMBER varchar,
	MERCHANT_CATEGORY varchar,
	MERCHANT_LOCATION_NUMBER varchar,
	DEVELOPER_ID varchar,
	VERSION_ID varchar,
	STORE_NUMBER varchar,
	TERMINAL_NUMBER varchar,
	TIME_ZONE_CL varchar,
	CITY_CODE varchar,
	MERCHANT_NAME varchar,
	MERCHANT_CITY varchar,
	MERCHANT_STATE varchar,
	TERMINAL_ID_NUMBER varchar,
	CONTACT_PHONE_NUMBER varchar,
	MERCHANT_ABA_NUMBER varchar,
	MERCHANT_SETTLEMENT_AGENT_NUMBER varchar,
	NETWORK_ID varchar,
	SHARING_GROUPS varchar,
	VAT_REGISTRATION_NUMBER varchar,
	RETAIL_MERCHANT_NUMBER varchar,
	RETAIL_MERCHANT_CATEGORY_CODE varchar,
	RETAIL_TERMINAL_ID_NUMBER varchar,
	RESTAURANT_MERCHANT_NUMBER varchar,
	RESTAURANT_MERCHANT_CATEGORY_CODE varchar,
	RESTAURANT_TERMINAL_ID_NUMBER varchar,
	ECOMMERCE_MERCHANT_NUMBER varchar,
	ECOMMERCE_MERCHANT_CATEGORY_CODE varchar,
	ECOMMERCE_TERMINAL_ID_NUMBER varchar,
	MOTO_MERCHANT_NUMBER varchar,
	MOTO_MERCHANT_CATEGORY_CODE varchar,
	MOTO_TERMINAL_ID_NUMBER varchar,
	PROCESSOR_CL varchar,
	FCS_ID varchar,
	KEY_SET_IDENTIFIER varchar,
	PAYMENT_FACILITATOR_ID_MASTER_CARD varchar,
	PAYMENT_FACILITATOR_NAME_AND_SUB_MERCHANT_NAME varchar,
	SUB_MERCHANT_ID varchar,
	SUB_MERCHANT_CITY varchar,
	SUB_MERCHANT_STATE_PROVINCE_CODE varchar,
	MERCHANT_COUNTRY_CODE varchar,
	MERCHANT_ZIP_CODE varchar,
	PRESTIGIOUS_PROPERTY_INDICATOR_CL varchar,
	MERCHANT_COUNTRY_CODE varchar,
	MERCHANT_ZIP_CODE varchar,
	MERCHANT_COUNTRY_CODE varchar,
	MERCHANT_ZIP_CODE varchar,
	PRESTIGIOUS_PROPERTY_INDICATOR_CL varchar,
	PRESTIGIOUS_PROPERTY_INDICATOR_CL varchar,
	DESCRIPTOR varchar,
	DESCRIPTOR_PREFIX varchar,
	PAYMENT_FACILITATOR_NAME_AND_SUB_MERCHANT_NAME varchar,
	DESCRIPTOR varchar,
	DESCRIPTOR_PREFIX varchar,
	PAYMENT_FACILITATOR_NAME_AND_SUB_MERCHANT_NAME varchar,
	PAYMENT_FACILITATOR_NAME_AND_SUB_MERCHANT_NAME varchar,
	DESCRIPTOR varchar,
	DESCRIPTOR_PREFIX varchar,
	MERCHANT_NUMBER_BACKEND varchar,
	PAYMENT_FACILITATOR_ID_VISA varchar,
	PAYMENT_FACILITATOR_ID_MASTER_CARD varchar,
	SUB_MERCHANT_ZIP_CODE varchar,
	SUB_MERCHANT_COUNTRY_CODE varchar,
	MERCHANT_STREET varchar,
	MERCHANT_EMAIL varchar,
	SELLER_ID varchar,
	PAYMENT_SERVICE_PROVIDER_NAME varchar,
	MERCHANT_NUMBER_BACKEND varchar,
	PAYMENT_FACILITATOR_ID_VISA varchar,
	PAYMENT_FACILITATOR_ID_MASTER_CARD varchar,
	SUB_MERCHANT_ZIP_CODE varchar,
	SUB_MERCHANT_COUNTRY_CODE varchar,
	MERCHANT_STREET varchar,
	MERCHANT_EMAIL varchar,
	SELLER_ID varchar,
	PAYMENT_SERVICE_PROVIDER_NAME varchar,
	MERCHANT_NUMBER_BACKEND varchar,
	PAYMENT_FACILITATOR_ID_VISA varchar,
	SUB_MERCHANT_ZIP_CODE varchar,
	SUB_MERCHANT_COUNTRY_CODE varchar,
	MERCHANT_STREET varchar,
	MERCHANT_EMAIL varchar,
	SELLER_ID varchar,
	PAYMENT_SERVICE_PROVIDER_NAME varchar,
	TIME_ZONE_CODE varchar,
	TIME_ZONE_CL varchar,
	TIME_ZONE_CL varchar,
	TIME_ZONE_CODE varchar,
	TIME_ZONE_CL varchar,
	TIME_ZONE_CODE varchar,
	TIME_ZONE_CL varchar,
	ECOMMERCE_MERCHANT_CATEGORY_CODE int(11),
	MERCHANT_NUMBER varchar,
	TERMINAL_NUMBER varchar,
	MERCHANT_NUMBER varchar,
	TERMINAL_NUMBER varchar,
	CONTACT_PHONE_NUMBER varchar,
	CONTACT_PHONE_NUMBER varchar,
	PRIMARY KEY (ID)
) ENGINE=InnoDB;