-- Create Table Statement for 'Pago Auth Retail Transaction'
DROP TABLE IF EXISTS `PAGO_AUTH_RETAIL_TRANSACTION`;
CREATE TABLE `PAGO_AUTH_RETAIL_TRANSACTION` (
	ID bigint(20) NOT NULL,
	MERCHANT_ACCOUNT_CODE int(11) NOT NULL,
	CHARGE_TRANSACTION_FK bigint(20),
	RETAIL_TRANSACTION_CYCLE_FK bigint(20),
	MERCHANT_ID varchar,
	URL_SUFFIX varchar,
	AMOUNT varchar,
	CURRENCY varchar,
	ORDER_ID varchar,
	CUSTOMER_IP varchar,
	CUSTOMER_EMAIL varchar,
	CUSTOMER_PHONE varchar,
	CUSTOMER_FIRST_NAME varchar,
	CUSTOMER_LAST_NAME varchar,
	CUSTOMER_ADDRESS1 varchar,
	CUSTOMER_CITY varchar,
	CUSTOMER_ZIP_CODE varchar,
	CUSTOMER_STATE_PROVINCE varchar,
	CUSTOMER_COUNTRY varchar,
	CUSTOMER_DOB varchar,
	CARD_HOLDER_NAME varchar,
	DESCRIPTION varchar,
	THREE_D_SECURE_INFO varchar,
	TRANSACTION_ID varchar,
	REFUND_AMOUNT varchar,
	RESPONSE_CODE varchar,
	REASON_CODE varchar,
	RESPONSE_TRANSACTION_ID varchar,
	RESPONSE_AMOUNT varchar,
	RESPONSE_EXECUTED varchar,
	RESPONSE_ERROR_INFO varchar,
	RESPONSE_REFUND_TRANSACTION_ID varchar,
	RESPONSE_UPDATED varchar,
	RESPONSE_UPDATED_TRANSACTION_ID varchar,
	RETAIL_TRANSACTION_CYCLE_FK bigint(20),
	RETAIL_TRANSACTION_CYCLE_FK bigint(20),
	PRIMARY KEY (ID)
) ENGINE=InnoDB;