-- Create Table Statement for 'Mpgs Auth Retail Transaction'
DROP TABLE IF EXISTS `MPGS_AUTH_RETAIL_TRANSACTION`;
CREATE TABLE `MPGS_AUTH_RETAIL_TRANSACTION` (
	ID bigint(20) NOT NULL,
	MERCHANT_ACCOUNT_CODE int(11),
	CHARGE_TRANSACTION_FK bigint(20),
	RETAIL_TRANSACTION_CYCLE_FK bigint(20),
	API_OPERATION varchar,
	AUTHENTICATION3DS_ACS_ECI varchar,
	AUTHENTICATION3DS_AUTHENTICATION_TOKEN varchar,
	AUTHENTICATION3DS_TRANSACTION_ID varchar,
	AUTHENTICATION3DS1PA_RES_STATUS varchar,
	AUTHENTICATION3DS1VE_RES_ENROLLED varchar,
	AUTHENTICATION3DS2PROTOCOL_VERSION varchar,
	AUTHENTICATION3DS2STATUS_REASON_CODE varchar,
	AUTHENTICATION3DS2TRANSACTION_STATUS varchar,
	TRANSACTION_ID varchar,
	BILLING_ADDRESS_CITY varchar,
	BILLING_ADDRESS_COUNTRY varchar,
	BILLING_ADDRESS_POSTCODE_ZIP varchar,
	BILLING_ADDRESS_STREET2 varchar,
	BILLING_ADDRESS_STATE_PROVINCE_CODE varchar,
	BILLING_ADDRESS_STREET varchar,
	CUSTOMER_EMAIL varchar,
	CUSTOMER_FIRST_NAME varchar,
	CUSTOMER_LAST_NAME varchar,
	CUSTOMER_PHONE varchar,
	CUSTOMER_TAX_REGISTRATION_ID varchar,
	MERCHANT varchar,
	ORDER_ACCEPT_PARTIAL_AMOUNT varchar,
	ORDER_AMOUNT varchar,
	ORDER_CASHBACK_AMOUNT varchar,
	ORDER_CURRENCY varchar,
	ORDER_CUSTOMER_REFERENCE varchar,
	ORDER_DESCRIPTION varchar,
	ORDER_REFERENCE varchar,
	ORDER_STATEMENT_DESCRIPTOR_ADDRESS_CITY varchar,
	ORDER_STATEMENT_DESCRIPTOR_ADDRESS_COMPANY varchar,
	ORDER_STATEMENT_DESCRIPTOR_ADDRESS_COUNTRY varchar,
	ORDER_STATEMENT_DESCRIPTOR_ADDRESS_POSTCODE_ZIP varchar,
	ORDER_STATEMENT_DESCRIPTOR_ADDRESS_STATE_PROVINCE varchar,
	ORDER_STATEMENT_DESCRIPTOR_ADDRESS_STREET varchar,
	ORDER_STATEMENT_DESCRIPTOR_ADDRESS_STREET2 varchar,
	ORDER_STATEMENT_DESCRIPTOR_NAME varchar,
	ORDER_STATEMENT_DESCRIPTOR_PHONE varchar,
	ORDER_SUB_MERCHANT_ADDRESS_CITY varchar,
	ORDER_SUB_MERCHANT_ADDRESS_COMPANY varchar,
	ORDER_SUB_MERCHANT_ADDRESS_COUNTRY varchar,
	ORDER_SUB_MERCHANT_ADDRESS_POSTCODE_ZIP varchar,
	ORDER_SUB_MERCHANT_ADDRESS_STATE_PROVINCE varchar,
	ORDER_SUB_MERCHANT_ADDRESS_STREET varchar,
	ORDER_SUB_MERCHANT_ADDRESS_STREET2 varchar,
	ORDER_SUB_MERCHANT_BANK_INDUSTRY_CODE varchar,
	ORDER_SUB_MERCHANT_EMAIL varchar,
	ORDER_SUB_MERCHANT_IDENTIFIER varchar,
	ORDER_SUB_MERCHANT_PHONE varchar,
	ORDER_SUB_MERCHANT_REGISTERED_NAME varchar,
	ORDER_SUB_MERCHANT_TRADING_NAME varchar,
	ORDER_ID varchar,
	SHIPPING_ADDRESS_CITY varchar,
	SHIPPING_ADDRESS_COUNTRY varchar,
	SHIPPING_ADDRESS_POSTCODE_ZIP varchar,
	SHIPPING_ADDRESS_STATE_PROVINCE_CODE varchar,
	SHIPPING_ADDRESS_STREET varchar,
	SOURCE_CARD_DEVICE_PAYMENT3_DSECURE_ECI_INDICATOR varchar,
	SOURCE_CARD_DEVICE_PAYMENT_CRYPTOGRAM_FORMAT varchar,
	SOURCE_TYPE varchar,
	RESPONSE_ORDER_AMOUNT varchar,
	RESPONSE_ORDER_CASHBACK_AMOUNT varchar,
	RESPONSE_ORDER_TOTAL_AUTHORIZED_AMOUNT varchar,
	RESPONSE_ORDER_TOTAL_CAPTURED_AMOUNT varchar,
	RESPONSE_ORDER_TOTAL_REFUNDED_AMOUNT varchar,
	RESPONSE_ORDER_CREATION_TIME varchar,
	RESPONSE_ORDER_STATUS varchar,
	RESPONSE_ACQUIRER_CODE varchar,
	RESPONSE_ACQUIRER_MESSAGE varchar,
	RESPONSE_CARD_SECURITY_CODE_ACQUIRER_CODE varchar,
	RESPONSE_CARD_SECURITY_CODE_GATEWAY_CODE varchar,
	RESPONSE_AVS_ACQUIRER_CODE varchar,
	RESPONSE_AVS_GATEWAY_CODE varchar,
	RESPONSE_GATEWAY_CODE varchar,
	RESPONSE_TRANSACTION_AMOUNT varchar,
	RESPONSE_TRANSACTION_TYPE varchar,
	RESULT varchar,
	ERROR_CAUSE varchar,
	ERROR_EXPLANATION varchar,
	ERROR_FIELD varchar,
	ERROR_SUPPORT_CODE varchar,
	ERROR_VALIDATION_TYPE varchar,
	AVAILABLE_BALANCE_FUNDS_AMOUNT varchar,
	AVAILABLE_BALANCE_FUNDS_CURRENCY varchar,
	BROWSER_PAYMENT_REDIRECT_URL varchar,
	SHIPPING_CONTACT_FIRST_NAME varchar,
	SHIPPING_CONTACT_LAST_NAME varchar,
	SHIPPING_ORIGIN_POSTCODE_ZIP varchar,
	SOURCE_CARD_STORED_ON_FILE varchar,
	TARGET_TRANSACTION_ID varchar,
	RESPONSE_TRANSACTION_AUTHORIZATION_CODE varchar,
	TRANSACTION_AMOUNT varchar,
	TRANSACTION_CURRENCY varchar,
	AUTHENTICATION_TRANSACTION_ID varchar,
	TRANSACTION_SOURCE varchar,
	ORDER_WALLET_PROVIDER varchar,
	RESPONSE_TRANSACTION_RECEIPT varchar,
	PRIMARY KEY (ID)
) ENGINE=InnoDB;