-- 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;