-- Create Table Statement for 'WorldPay Auth Retail Transaction'
DROP TABLE IF EXISTS `WORLD_PAY_AUTH_RETAIL_TRANSACTION`;
CREATE TABLE `WORLD_PAY_AUTH_RETAIL_TRANSACTION` (
	ID bigint(20) NOT NULL,
	MERCHANT_ACCOUNT_CODE int(11) NOT NULL,
	MESSAGE_TYPE varchar,
	BIT3 varchar,
	BIT4 varchar,
	BIT7 varchar,
	BIT11 varchar,
	BIT12 varchar,
	BIT18 varchar,
	BIT22 varchar,
	BIT37 varchar,
	BIT38 varchar,
	BIT40 varchar,
	BIT42 varchar,
	BIT54 varchar,
	BIT59 varchar,
	BIT60 varchar,
	BIT61 varchar,
	BIT90 varchar,
	BIT95 varchar,
	BIT122 varchar,
	BIT15_SETTLEMENT_DATE varchar,
	BIT38_AUTHORIZATION_IDENTIFICATION_RESPONSE varchar,
	BIT39_WORLD_PAY_RESPONSE_DATA varchar,
	BIT44_RESPONSE_DATA varchar,
	BIT48_ADDRESS_VERIFICATION_RESULT varchar,
	BIT48_CARD_VERIFICATION_RESULT varchar,
	BIT48_AUTHENTICATION_VERIFICATION_VALUE_RESULT_CODE varchar,
	BIT48_CREDIT_RESPONSE_DATA varchar,
	BIT48_COMMERCIAL_CARD_RESPONSE varchar,
	BIT48_VISA_RESPONSE_DATA varchar,
	BIT48_MASTER_CARD_RESPONSE_DATA varchar,
	BIT48_AMERICAN_EXPRESS_RESPONSE_DATA varchar,
	BIT48_PREPAID_CARD_DATA varchar,
	BIT59_WORLD_RETRIEVAL_DATA varchar,
	BIT60_REASON_CODE varchar,
	BIT62_DEBIT_EBT_NETWORK_RESPONSE_DATA varchar,
	CHARGE_TRANSACTION_FK bigint(20),
	RETAIL_TRANSACTION_CYCLE_FK bigint(20),
	BIT13 varchar,
	BIT4_APPROVED_AMOUNT varchar,
	BIT54_ADDITIONAL_AMOUNTS varchar,
	BIT54_PARTIAL_APPROVED_AMOUNT varchar,
	BIT54_CASHBACK_AMOUNT varchar,
	BIT54_BALANCE varchar,
	BIT54_TIP_AMOUNT varchar,
	BIT127 varchar,
	BIT39 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;