-- Create Table Statement for 'LPB Medoro Auth Retail Transaction'
DROP TABLE IF EXISTS `LPB_MEDORO_AUTH_RETAIL_TRANSACTION`;
CREATE TABLE `LPB_MEDORO_AUTH_RETAIL_TRANSACTION` (
	ID bigint(20) NOT NULL,
	MERCHANT_ACCOUNT_CODE int(11) NOT NULL,
	MERCHANT_INTERFACE varchar,
	KEY_INDEX int(11),
	MERCHANT_KEY varchar,
	GATEWAY_KEY varchar,
	ACTION varchar,
	AUTO_DEPOSIT varchar,
	MODE int(11),
	DESCRIPTOR varchar,
	PAYMENT_ID varchar,
	ORDER_ID varchar,
	ORDER_AMOUNT int(11),
	ORDER_CURRENCY varchar,
	ORDER_DESCRIPTION varchar,
	CARD_NAME varchar,
	BILLING_ADDRESS_NAME varchar,
	BILLING_ADDRESS_ADDRESS varchar,
	BILLING_ADDRESS_CITY varchar,
	BILLING_ADDRESS_COUNTRY varchar,
	BILLING_ADDRESS_POST_INDEX varchar,
	BILLING_ADDRESS_PHONE varchar,
	BILLING_ADDRESS_EMAIL varchar,
	REMOTE_ADDRESS varchar,
	DEPOSIT_AMOUNT int(11),
	REVERSAL_AMOUNT int(11),
	RESPONSE_PAYMENT_ID varchar,
	RESPONSE_PAYMENT_STATE int(11),
	RESPONSE_PAYMENT_START_DATE varchar,
	RESPONSE_APPROVAL_CODE varchar,
	RESPONSE_ACTION_CODE varchar,
	RESPONSE_DESCRIPTION varchar,
	ERROR_CODE varchar,
	ERROR_MESSAGE varchar,
	CHARGE_TRANSACTION_FK bigint(20),
	RETAIL_TRANSACTION_CYCLE_FK bigint(20),
	RESPONSE_PAYMENT_LAST_DATE varchar,
	RESPONSE_XID varchar,
	RESPONSE_TRANSACTION_DATE varchar,
	RESPONSE_ENROLLED varchar,
	RESPONSE_STATUS varchar,
	RESPONSE_CAVV varchar,
	RESPONSE_ECI varchar,
	RESPONSE_MESSAGE_ID varchar,
	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;