-- Create Table Statement for 'PaySafe Auth Retail Transaction'
DROP TABLE IF EXISTS `PAYSAFE_AUTH_RETAIL_TRANSACTION`;
CREATE TABLE `PAYSAFE_AUTH_RETAIL_TRANSACTION` (
	ID bigint(20) NOT NULL,
	MERCHANT_ACCOUNT_CODE int(11) NOT NULL,
	TXN_TIME varchar,
	ACQUIRER_CVV2_RESULT varchar,
	SHIPPING_COUNTRY varchar,
	SHIPPING_STREET varchar,
	RECURRING varchar,
	ACQUIRER_REQUEST_ID varchar,
	AUTH_CODE varchar,
	STREET varchar,
	ERROR_FIELDS varchar,
	AVAILABLE_TO_SETTLE int(11),
	ACQUIRER_EFFECTIVE_DATE varchar,
	ACQUIRER_RESPONSE_ID varchar,
	SHIPPING_ZIP varchar,
	AMOUNT int(11),
	ACQUIRER_CODE varchar,
	ZIP varchar,
	RESPONSE_MESSAGE varchar,
	MERCHANT_REF_NUM varchar,
	RISK_REASON_CODE varchar,
	ACQUIRER_MID varchar,
	ACQUIRER_TXN_DATE_TIME varchar,
	ERROR_MESSAGE varchar,
	STATE varchar,
	ACQUIRER_PLAN varchar,
	STATUS varchar,
	ERROR_CODE varchar,
	DESCRIPTION varchar,
	COUNTRY varchar,
	CVV_VERIFICATION varchar,
	CURRENCY_CODE varchar,
	AVAILABLE_TO_REFUND int(11),
	DYNAMIC_DESCRIPTOR varchar,
	ACQUIRER_TERMINAL_ID varchar,
	ACQUIRER_AVS_CODE varchar,
	ACQUIRER_BATCH_NUMBER varchar,
	ACQUIRER_SEQ_NUMBER varchar,
	FIRST_NAME varchar,
	ACQUIRER_RESPONSE_CODE varchar,
	RESPONSE_AMOUNT int(11),
	CHILD_ACCOUNT_NUM varchar,
	ACCOUNT_NUMBER varchar,
	LAST_NUMBER varchar,
	RESPONSE_CODE varchar,
	ACQUIRER_GRACE_PERIOD varchar,
	REQUEST_TYPE varchar,
	CHARGE_TRANSACTION_FK bigint(20),
	ACQUIRER_BALANCE_RESPONSE varchar,
	AUTH_ID varchar,
	LAST_DIGITS varchar,
	SHIPPING_CITY varchar,
	SHIPPING_RECIPIENT_NAME varchar,
	RETAIL_TRANSACTION_CYCLE_FK bigint(20),
	PHONE varchar,
	EMAIL varchar,
	CARD_TYPE varchar,
	ACQUIRER_FINANCING_TYPE varchar,
	ACQUIRER_DESCRIPTION varchar,
	ACQUIRER_RESPONSE_REASON_CODE varchar,
	ACQUIRER_REFERENCE_NBR varchar,
	ACQUIRER_TERM varchar,
	SETTLE_WITH_AUTH varchar,
	CITY varchar,
	ACQUIRER_AUTH_CODE varchar,
	AVS_RESPONSE varchar,
	ERROR_DETAILS varchar,
	SHIPPING_STATE varchar,
	ECI varchar,
	SIGNATURE_STATUS varchar,
	THREE_D_ENROLLMENT varchar,
	THREE_D_RESULT varchar,
	LAST_NAME varchar,
	RETAIL_TRANSACTION_CYCLE_FK bigint(20),
	CHARGE_TRANSACTION_FK bigint(20),
	DIRECTORY_SERVER_TRANSACTION_ID varchar,
	THREE_DSECURE_VERSION varchar,
	RETAIL_TRANSACTION_CYCLE_FK bigint(20),
	DIRECTORY_SERVER_TRANSACTION_ID varchar,
	THREE_DSECURE_VERSION varchar,
	CHARGE_TRANSACTION_FK bigint(20),
	DIRECTORY_SERVER_TRANSACTION_ID varchar,
	THREE_DSECURE_VERSION varchar,
	PRIMARY KEY (ID)
) ENGINE=InnoDB;