-- Create Table Statement for 'Account Updater FirstData Profile'
DROP TABLE IF EXISTS `ACCOUNT_UPDATER_FIRST_DATA_PROFILE`;
CREATE TABLE `ACCOUNT_UPDATER_FIRST_DATA_PROFILE` (
ID bigint(20) NOT NULL,
MERCHANT_NAME varchar,
MERCHANT_NUMBER varchar,
CARD_PROCESSOR_NAME varchar,
VISA_ACQUIRER_BIN varchar,
MASTER_CARD_ICA varchar,
DISCOVER_PID varchar,
DISCOVER_MAILBOX_ID varchar,
DISCOVER_SE varchar,
FILENAME varchar,
AU_FIRST_DATA_PROFILE_CL varchar,
MERCHANT_ID varchar,
IS_TEST_MODE tinyint(1),
PLATFORM_CL varchar,
PLATFORM_CL varchar,
PLATFORM_CL varchar,
SUB_MERCHANT_NAME varchar,
SUB_MERCHANT_NUMBER_MASTER_CARD varchar,
SUB_MERCHANT_NUMBER_VISA varchar,
SUB_MERCHANT_NAME varchar,
SUB_MERCHANT_NUMBER_MASTER_CARD varchar,
SUB_MERCHANT_NUMBER_VISA varchar,
SUB_MERCHANT_NAME varchar,
SUB_MERCHANT_NUMBER_MASTER_CARD varchar,
SUB_MERCHANT_NUMBER_VISA varchar,
TEST_FIELD3_ID varchar,
PAYMENT_FACILITATOR_NAME varchar,
PAYMENT_FACILITATOR_ID varchar,
PAYMENT_FACILITATOR_NAME varchar,
PAYMENT_FACILITATOR_ID varchar,
PAYMENT_FACILITATOR_NAME varchar,
PAYMENT_FACILITATOR_ID varchar,
PRIMARY KEY (ID)
) ENGINE=InnoDB;