-- Create Table Statement for 'Sigma Gateway Auth Retail Transaction'
DROP TABLE IF EXISTS `SIGMA_GATEWAY_AUTH_RETAIL_TRANSACTION`;
CREATE TABLE `SIGMA_GATEWAY_AUTH_RETAIL_TRANSACTION` (
	ID bigint(20) NOT NULL,
	MERCHANT_ACCOUNT_CODE int(11) NOT NULL,
	RESPONSE_CODE varchar,
	REFERENCE_NUMBER varchar,
	AUTHORIZATION_NUMBER varchar,
	TIME varchar,
	DATE varchar,
	BALLOT_NUMBER varchar,
	PROC_CODE varchar,
	MERCHANT varchar,
	TERMINAL varchar,
	AMOUNT varchar,
	CURRENCY_CODE varchar,
	CARDHOLDER varchar,
	SHIP_ADDRESS varchar,
	SHIP_CITY varchar,
	SHIP_COUNTRY varchar,
	SHIP_STATE varchar,
	SHIP_ZIP_CODE varchar,
	SHIP_PHONE_NUMBER varchar,
	BILL_ADDRESS varchar,
	BILL_CITY varchar,
	BILL_COUNTRY varchar,
	BILL_STATE varchar,
	BILL_ZIP_CODE varchar,
	BILL_PHONE_NUMBER varchar,
	SITE_IP_ADDRESS varchar,
	EMAIL varchar,
	TRACKING varchar,
	BALLOT varchar,
	CHARGE_TRANSACTION_FK bigint(20),
	RETAIL_TRANSACTION_CYCLE_FK bigint(20),
	RETAIL_TRANSACTION_CYCLE_FK bigint(20),
	RETAIL_TRANSACTION_CYCLE_FK bigint(20),
	PRIMARY KEY (ID)
) ENGINE=InnoDB;