-- Create Table Statement for 'Ezidebit Auth Retail Transaction'
DROP TABLE IF EXISTS `EZIDEBIT_AUTH_RETAIL_TRANSACTION`;
CREATE TABLE `EZIDEBIT_AUTH_RETAIL_TRANSACTION` (
	ID bigint(20) NOT NULL,
	MERCHANT_ACCOUNT_CODE int(11) NOT NULL,
	NAME_ON_CREDIT_CARD varchar,
	PAYMENT_AMOUNT_IN_CENTS int(11),
	CUSTOMER_NAME varchar,
	PAYMENT_REFERENCE varchar,
	BANK_RECEIPT_ID varchar,
	EXCHANGE_PAYMENT_ID varchar,
	PAYMENT_RESULT varchar,
	PAYMENT_RESULT_CODE varchar,
	PAYMENT_RESULT_TEXT varchar,
	RETAIL_TRANSACTION_CYCLE_FK bigint(20),
	ERROR varchar,
	ERROR_MESSAGE varchar,
	SUBMISSION_CL varchar,
	YOUR_SYSTEM_REFERENCE varchar,
	YOUR_GENERAL_REFERENCE varchar,
	LAST_NAME varchar,
	FIRST_NAME varchar,
	EMAIL_ADDRESS varchar,
	MOBILE_PHONE_NUMBER varchar,
	DEBIT_DATE varchar,
	SMS_PAYMENT_REMINDER varchar,
	SMS_FAILED_NOTIFICATION varchar,
	SMS_EXPIRED_CARD varchar,
	CUSTOMER_REF varchar,
	REFUND_AMOUNT_IN_CENTS int(11),
	PAYMENT_ID varchar,
	REFUND_BANK_RECEIPT_ID varchar,
	CHARGE_TRANSACTION_FK bigint(20),
	BANK_RECEIPT_ID varchar,
	BANK_RECEIPT_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;