-- Create Table Statement for 'MWE Auth Retail Transaction'
DROP TABLE IF EXISTS `MWE_AUTH_RETAIL_TRANSACTION`;
CREATE TABLE `MWE_AUTH_RETAIL_TRANSACTION` (
	ID bigint(20) NOT NULL,
	MERCHANT_ACCOUNT_CODE int(11) NOT NULL,
	METHOD varchar,
	MERCHANT_UUID varchar,
	TRANSACTION_AMOUNT varchar,
	REFUND_AMOUNT varchar,
	CAPTURE_AMOUNT varchar,
	TRANSACTION_CURRENCY varchar,
	TRANSACTION_PRODUCT varchar,
	TRANSACTION_REFERENCE_ID varchar,
	CUSTOMER_COUNTRY varchar,
	CUSTOMER_STATE varchar,
	CUSTOMER_CITY varchar,
	CUSTOMER_ADDRESS varchar,
	CUSTOMER_POST_CODE varchar,
	CUSTOMER_PHONE varchar,
	CUSTOMER_EMAIL varchar,
	PAYMENT_CARD_NAME varchar,
	CUSTOM1 varchar,
	CUSTOM2 varchar,
	CUSTOM3 varchar,
	HASH varchar,
	RESPONSE_CODE varchar,
	RESPONSE_MESSAGE varchar,
	TRANSACTION_ID_REQUEST varchar,
	AUTH_CODE varchar,
	AUTH_MESSAGE varchar,
	AUTH_RESPONSE_CODE varchar,
	CHARGE_TRANSACTION_FK bigint(20),
	RETAIL_TRANSACTION_CYCLE_FK bigint(20),
	API_KEY varchar,
	TRANSACTION_ID_RESPONSE varchar,
	RECEIPT_NO varchar,
	AUTH_SETTLED_DATE varchar,
	CARD_ID varchar,
	RETAIL_TRANSACTION_CYCLE_FK bigint(20),
	CHARGE_TRANSACTION_FK bigint(20),
	RETAIL_TRANSACTION_CYCLE_FK bigint(20),
	CHARGE_TRANSACTION_FK bigint(20),
	PRIMARY KEY (ID)
) ENGINE=InnoDB;