-- Create Table Statement for 'CC MWE Batch'
DROP TABLE IF EXISTS `CC_MWE_BATCH`;
CREATE TABLE `CC_MWE_BATCH` (
	ID bigint(20) NOT NULL,
	MERCHANT_UUID varchar,
	API_KEY varchar,
	BATCH_NOTIFY_URL varchar,
	BATCH_RESPONSE_FILE_ATTACH varchar,
	BATCH_RESPONSE_FILE_COMPRESS varchar,
	BATCH_FILE varchar,
	RESPONSE_CODE varchar,
	RESPONSE_MESSAGE varchar,
	CURRENCY_CODE varchar,
	FILE_HASH varchar,
	URL_HASH varchar,
	BATCH_UUID varchar,
	IS_MWE_TOKEN_TRANSACTION_ONLY tinyint(1),
	TOTAL_COUNT int(11),
	TOTAL_AMOUNT int(11),
	PROVIDER_CHARGE_TRANSACTION_FK bigint(20),
	PRIMARY KEY (ID)
) ENGINE=InnoDB;