-- Create Table Statement for 'Retail ISO8583 Profile'
DROP TABLE IF EXISTS `RETAIL_ISO8583_PROFILE`;
CREATE TABLE `RETAIL_ISO8583_PROFILE` (
	ID bigint(20) NOT NULL,
	SECURE_CODE varchar,
	MERCHANT_NAME varchar,
	MERCHANT_CITY varchar,
	MERCHANT_STATE varchar,
	MERCHANT_ZIP_CODE varchar,
	CUSTOMER_SERVICE_PHONE varchar,
	CHARGE_DESCRIPTION varchar,
	FILENAME varchar,
	RETAIL_MERCHANT_CATEGORY_CODE varchar,
	RETAIL_MERCHANT_ID varchar,
	RETAIL_TERMINAL_ID varchar,
	RETAIL_DATAWIRE_ID varchar,
	MOTO_MERCHANT_CATEGORY_CODE varchar,
	MOTO_MERCHANT_ID varchar,
	MOTO_TERMINAL_ID varchar,
	MOTO_DATAWIRE_ID varchar,
	ECOMMERCE_MERCHANT_CATEGORY_CODE varchar,
	ECOMMERCE_MERCHANT_ID varchar,
	ECOMMERCE_TERMINAL_ID varchar,
	ECOMMERCE_DATAWIRE_ID varchar,
	RESTAURANT_MERCHANT_CATEGORY_CODE varchar,
	RESTAURANT_MERCHANT_ID varchar,
	RESTAURANT_TERMINAL_ID varchar,
	RESTAURANT_DATAWIRE_ID varchar,
	SERVICE_ID varchar,
	APPLICATION_ID varchar,
	IS_TEST_MODE tinyint(1),
	TPP_ID varchar,
	APPLICATION_INFORMATION varchar,
	ACQUIRER_INSTITUTION_ID varchar,
	PROCESS_MODE varchar,
	TERMINAL_TYPE varchar,
	NETWORK_ROUTING varchar,
	LANE_NUMBER varchar,
	USER_NAME varchar,
	PASSWORD varchar,
	CHECK_DIGIT varchar,
	LODGING_MERCHANT_CATEGORY_CODE varchar,
	LODGING_MERCHANT_ID varchar,
	LODGING_TERMINAL_ID varchar,
	LODGING_DATAWIRE_ID varchar,
	HEADER_MERCHANT_ID varchar,
	MERCHANT_STREET varchar,
	MERCHANT_EMAIL varchar,
	AGGREGATOR_NAME varchar,
	MERCHANT_TAX_ID varchar,
	PETROLEUM_MERCHANT_CATEGORY_CODE varchar,
	PETROLEUM_MERCHANT_ID varchar,
	PETROLEUM_TERMINAL_ID varchar,
	PETROLEUM_DATAWIRE_ID varchar,
	PROCESSOR_CL varchar,
	MERCHANT_FNS_NUMBER varchar,
	MERCHANT_COUNTRY_CODE varchar,
	PROCESSOR_ID varchar,
	PROCESSOR_NAME varchar,
	PROCESSOR_BUILDING_NUMBER varchar,
	PROCESSOR_STREET varchar,
	PROCESSOR_CITY varchar,
	PROCESSOR_COUNTRY_CODE varchar,
	PROCESSOR_ZIP_CODE varchar,
	PROCESSOR_PHONE_NUMBER varchar,
	EMAIL_ADDRESS varchar,
	MERCHANT_GROUP_IDENTIFIER varchar,
	CAR_RENTAL_DATAWIRE_ID varchar,
	CAR_RENTAL_MERCHANT_CATEGORY_CODE varchar,
	CAR_RENTAL_MERCHANT_ID varchar,
	CAR_RENTAL_TERMINAL_ID varchar,
	COUNTRY_CODE varchar,
	DYNAMIC_MERCHANT_NAME varchar,
	DYNAMIC_MERCHANT_CITY varchar,
	DYNAMIC_MERCHANT_STREET varchar,
	DYNAMIC_MERCHANT_ZIP varchar,
	DYNAMIC_MERCHANT_STATE varchar,
	DYNAMIC_MERCHANT_COUNTRY varchar,
	DYNAMIC_SUB_MERCHANT_ID varchar,
	MERCHANT_NAME_ABBREVIATION varchar,
	KEY_ID varchar,
	TOKEN_TYPE varchar,
	AGGREGATOR_MERCHANT_SUB_MERCHANT_ID varchar,
	DPC_NUMBER varchar,
	MC_ASSIGNED_ID varchar,
	VISA_MERCHANT_VERIFICATION_VALUE varchar,
	TRANS_ARMOR_KEY_ID varchar,
	TRANS_ARMOR_TOKEN_TYPE varchar,
	TOKEN_REQUESTOR_ID varchar,
	VISA_BIN varchar,
	MC_BIN varchar,
	USE_LEGACY_FILE_HEADER tinyint(1),
	MERCHANT_NUMBER varchar,
	RETAIL_CHECK_DIGIT varchar,
	MOTO_CHECK_DIGIT varchar,
	ECOMMERCE_CHECK_DIGIT varchar,
	RESTAURANT_CHECK_DIGIT varchar,
	PETROLEUM_CHECK_DIGIT varchar,
	APPLICATION_HEADER varchar,
	ECOMM_URL varchar,
	RETAIL_MERCHANT_NUMBER varchar,
	MOTO_MERCHANT_NUMBER varchar,
	ECOMMERCE_MERCHANT_NUMBER varchar,
	RESTAURANT_MERCHANT_NUMBER varchar,
	LODGING_MERCHANT_NUMBER varchar,
	PETROLEUM_MERCHANT_NUMBER varchar,
	CAR_RENTAL_MERCHANT_NUMBER varchar,
	RETAIL_MERCHANT_NUMBER varchar,
	MOTO_MERCHANT_NUMBER varchar,
	ECOMMERCE_MERCHANT_NUMBER varchar,
	RESTAURANT_MERCHANT_NUMBER varchar,
	LODGING_MERCHANT_NUMBER varchar,
	PETROLEUM_MERCHANT_NUMBER varchar,
	CAR_RENTAL_MERCHANT_NUMBER varchar,
	RETAIL_MERCHANT_NUMBER varchar,
	MOTO_MERCHANT_NUMBER varchar,
	ECOMMERCE_MERCHANT_NUMBER varchar,
	RESTAURANT_MERCHANT_NUMBER varchar,
	LODGING_MERCHANT_NUMBER varchar,
	PETROLEUM_MERCHANT_NUMBER varchar,
	CAR_RENTAL_MERCHANT_NUMBER varchar,
	ECOMM_URL varchar,
	ECOMM_URL varchar,
	MERCHANT_ZIP_CODE varchar,
	MERCHANT_ZIP_CODE varchar,
	DYNAMIC_SUB_MERCHANT_MCC varchar,
	DYNAMIC_MERCHANT_EMAIL varchar,
	DYNAMIC_MERCHANT_TAX_ID varchar,
	DYNAMIC_SUB_MERCHANT_MCC varchar,
	DYNAMIC_MERCHANT_EMAIL varchar,
	DYNAMIC_MERCHANT_TAX_ID varchar,
	DYNAMIC_SUB_MERCHANT_MCC varchar,
	DYNAMIC_MERCHANT_EMAIL varchar,
	DYNAMIC_MERCHANT_TAX_ID varchar,
	RETAIL_TERMINAL_ID varchar,
	RETAIL_MERCHANT_ID varchar,
	MOTO_MERCHANT_ID varchar,
	MOTO_TERMINAL_ID varchar,
	ECOMMERCE_MERCHANT_ID varchar,
	ECOMMERCE_TERMINAL_ID varchar,
	LODGING_MERCHANT_ID varchar,
	LODGING_TERMINAL_ID varchar,
	RETAIL_TERMINAL_ID varchar,
	RETAIL_MERCHANT_ID varchar,
	MOTO_MERCHANT_ID varchar,
	MOTO_TERMINAL_ID varchar,
	ECOMMERCE_MERCHANT_ID varchar,
	ECOMMERCE_TERMINAL_ID varchar,
	LODGING_MERCHANT_ID varchar,
	LODGING_TERMINAL_ID varchar,
	PRIMARY KEY (ID)
) ENGINE=InnoDB;