-- Create Table Statement for 'CC First Data Compass Batch'
DROP TABLE IF EXISTS `CC_FIRST_DATA_COMPASS_BATCH`;
CREATE TABLE `CC_FIRST_DATA_COMPASS_BATCH` (
	ID bigint(20) NOT NULL,
	MERCHANT_NAME varchar,
	PID varchar,
	SID varchar,
	CREATION_DATE varchar,
	MERCHANT_SPACE varchar,
	CUSTOMER_SERVICE_PHONE_NUMBER varchar,
	SALES_AMOUNT varchar,
	REFUNDS_AMOUNT varchar,
	ORDER_COUNT varchar,
	BATCH_RECORD_COUNT varchar,
	FILE_RECORD_COUNT varchar,
	TOTAL_AMOUNT varchar,
	TPP_ID varchar,
	TOKEN_TYPE varchar,
	MERCHANT_STREET varchar,
	MERCHANT_REGION varchar,
	MERCHANT_POSTAL_CODE varchar,
	MERCHANT_COUNTRY_CODE varchar,
	MERCHANT_CITY varchar,
	UNIQUE_FILE_ID varchar,
	MERCHANT_CATEGORY_CODE varchar,
	MERCHANT_ID varchar,
	UNIQUE_FILE_ID varchar,
	UNIQUE_FILE_ID varchar,
	MERCHANT_CITY varchar,
	MERCHANT_CATEGORY_CODE varchar,
	MERCHANT_ID varchar,
	MERCHANT_CITY varchar,
	MERCHANT_CATEGORY_CODE varchar,
	MERCHANT_ID varchar,
	PRIMARY KEY (ID)
) ENGINE=InnoDB;