-- Create Table Statement for 'Electronic Payments Auth Retail Transaction'
DROP TABLE IF EXISTS `ELECTRONIC_PAYMENTS_AUTH_RETAIL_TRANSACTION`;
CREATE TABLE `ELECTRONIC_PAYMENTS_AUTH_RETAIL_TRANSACTION` (
	ID bigint(20) NOT NULL,
	MERCHANT_ACCOUNT_CODE int(11) NOT NULL,
	TRANSACTION_CODE varchar,
	TRACK2_FORMAT_CODE varchar,
	MERCHANT_ID varchar,
	LOCATION_ID varchar,
	TERMINAL_ID varchar,
	TERMINAL_TYPE varchar,
	TERMINAL_APP_VERSION varchar,
	TIME_ZONE varchar,
	INDUSTRY_CODE varchar,
	TERMINAL_SERIAL_NUMBER varchar,
	ENTRY_MODE varchar,
	AMOUNT1 int(11),
	AMOUNT2 int(11),
	TEXT varchar,
	RESULT_CODE varchar,
	TRANSACTION_ID varchar,
	AMOUNT1_RESPONSE int(11),
	AMOUNT2_RESPONSE int(11),
	DECLINE_REASON varchar,
	TEXT_RESPONSE 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;