-- Create Table Statement for 'Retail Mpgs Profile'
DROP TABLE IF EXISTS `RETAIL_MPGS_PROFILE`;
CREATE TABLE `RETAIL_MPGS_PROFILE` (
	MERCHANT varchar,
	DESCRIPTOR_ADDRESS_CITY varchar,
	DESCRIPTOR_ADDRESS_COMPANY varchar,
	DESCRIPTOR_ADDRESS_COUNTRY varchar,
	DESCRIPTOR_ADDRESS_POSTCODE_ZIP varchar,
	DESCRIPTOR_ADDRESS_STATE_PROVINCE varchar,
	DESCRIPTOR_ADDRESS_STREET varchar,
	DESCRIPTOR_ADDRESS_STREET2 varchar,
	DESCRIPTOR_NAME varchar,
	DESCRIPTOR_PHONE varchar,
	SUB_MERCHANT_ADDRESS_CITY varchar,
	SUB_MERCHANT_ADDRESS_COMPANY varchar,
	SUB_MERCHANT_ADDRESS_COUNTRY varchar,
	SUB_MERCHANT_ADDRESS_POSTCODE_ZIP varchar,
	SUB_MERCHANT_ADDRESS_STATE_PROVINCE varchar,
	SUB_MERCHANT_ADDRESS_STREET varchar,
	SUB_MERCHANT_ADDRESS_STREET2 varchar,
	SUB_MERCHANT_BANK_INDUSTRY_CODE varchar,
	SUB_MERCHANT_EMAIL varchar,
	SUB_MERCHANT_IDENTIFIER varchar,
	SUB_MERCHANT_PHONE varchar,
	SUB_MERCHANT_REGISTERED_NAME varchar,
	SUB_MERCHANT_TRADING_NAME varchar,
	PRIMARY KEY ()
) ENGINE=InnoDB;