-- Create Table Statement for 'First Data Account Update Batch'
DROP TABLE IF EXISTS `FIRST_DATA_ACCOUNT_UPDATE_BATCH`;
CREATE TABLE `FIRST_DATA_ACCOUNT_UPDATE_BATCH` (
	ID bigint(20) NOT NULL,
	MERCHANT_NAME varchar,
	MERCHANT_NUMBER varchar,
	FILE_CREATION_DATE varchar,
	VISA_ACQUIRER_BIN varchar,
	CARD_PROCESSOR_NAME varchar,
	MASTER_CARD_ICA varchar,
	DISCOVER_PID varchar,
	DISCOVER_MAILBOX_ID varchar,
	MERCHANT_TRACE_ID varchar,
	DISCOVER_SE varchar,
	RECORD_COUNT varchar,
	MERCHANT_ID varchar,
	TRANS_ARMOR_INDICATOR varchar,
	TRANS_ARMOR_TOKEN_TYPE varchar,
	MERCHANT_REFERENCE_NUMBER_PREFIX varchar,
	FIRST_DATA_ACCOUNT_UPDATE_TRANSACTION_FK bigint(20),
	IS_AMEX_SUPPORTED tinyint(1),
	TEST_PROD_INDICATOR varchar,
	MERCHANT_NUMBER varchar,
	VISA_SUB_MERCHANT_NUMBER varchar,
	VISA_MASTER_MERCHANT_ID varchar,
	VISA_SUB_MERCHANT_NAME varchar,
	MC_SUB_MERCHANT_NUMBER varchar,
	MC_MASTER_MERCHANT_ID varchar,
	IS_AMEX_SUPPORTED tinyint(1),
	TEST_PROD_INDICATOR varchar,
	MERCHANT_NUMBER varchar,
	VISA_SUB_MERCHANT_NUMBER varchar,
	VISA_MASTER_MERCHANT_ID varchar,
	VISA_SUB_MERCHANT_NAME varchar,
	MC_SUB_MERCHANT_NUMBER varchar,
	MC_MASTER_MERCHANT_ID varchar,
	IS_AMEX_SUPPORTED tinyint(1),
	TEST_PROD_INDICATOR varchar,
	VISA_SUB_MERCHANT_NUMBER varchar,
	VISA_MASTER_MERCHANT_ID varchar,
	VISA_SUB_MERCHANT_NAME varchar,
	MC_SUB_MERCHANT_NUMBER varchar,
	MC_MASTER_MERCHANT_ID varchar,
	SUMMARY_MERCHANT_NAME varchar,
	SUMMARY_MERCHANT_NUMBER varchar,
	SUMMARY_MERCHANT_NAME varchar,
	SUMMARY_MERCHANT_NUMBER varchar,
	SUMMARY_MERCHANT_NAME varchar,
	SUMMARY_MERCHANT_NUMBER varchar,
	PRIMARY KEY (ID)
) ENGINE=InnoDB;