-- Create Table Statement for 'Investbank Auth Retail Transaction'
DROP TABLE IF EXISTS `INVESTBANK_AUTH_RETAIL_TRANSACTION`;
CREATE TABLE `INVESTBANK_AUTH_RETAIL_TRANSACTION` (
	ID bigint(20) NOT NULL,
	MERCHANT_ACCOUNT_CODE int(11) NOT NULL,
	OPERATION varchar,
	MERCHANT_CODE varchar,
	MERCHANT varchar,
	TR_ID bigint(20),
	AMOUNT int(11),
	CURRENCY varchar,
	DESCRIPTION varchar,
	NAME varchar,
	SURNAME varchar,
	SHIPPING_ADR varchar,
	BILLING_ADR varchar,
	PHONE varchar,
	EMAIL varchar,
	STATUS varchar,
	EXT_ERROR varchar,
	AUTH_CODE varchar,
	RRN varchar,
	ECI varchar,
	REL_DATA varchar,
	TIME varchar,
	CHARGE_TRANSACTION_FK bigint(20),
	RETAIL_TRANSACTION_CYCLE_FK bigint(20),
	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;