-- Create Table Statement for 'Clearhaus Auth Retail Transaction'
DROP TABLE IF EXISTS `CLEARHAUS_AUTH_RETAIL_TRANSACTION`;
CREATE TABLE `CLEARHAUS_AUTH_RETAIL_TRANSACTION` (
	ID bigint(20) NOT NULL,
	MERCHANT_ACCOUNT_CODE int(11) NOT NULL,
	TYPE varchar,
	AMOUNT int(11),
	RECURRING varchar,
	TEXT_ON_STATEMENT varchar,
	REFERENCE varchar,
	RESPONSE_CODE varchar,
	RESPONSE_MESSAGE varchar,
	AUTH_ID varchar,
	CHARGE_TRANSACTION_FK bigint(20),
	RETAIL_TRANSACTION_CYCLE_FK bigint(20),
	URL_SUFFIX varchar,
	CURRENCY varchar,
	TRANSACTION_ID_RESPONSE varchar,
	PROCESSED_AT varchar,
	APPROVED_AMOUNT int(11),
	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;