-- Create Table Statement for 'UniPay Token Transaction'
DROP TABLE IF EXISTS `UNI_PAY_TOKEN_TRANSACTION`;
CREATE TABLE `UNI_PAY_TOKEN_TRANSACTION` (
	ID bigint(20) NOT NULL,
	MERCHANT_ACCOUNT_CODE int(11) NOT NULL,
	REQUEST_TYPE varchar,
	PROVIDER_MERCHANT_ACCOUNT_CODE int(11),
	TRANSACTION_CODE varchar,
	ACCOUNT_TYPE varchar,
	HOLDER_TYPE varchar,
	HOLDER_NAME varchar,
	RESPONSE_TYPE varchar,
	REFERENCE_NUMBER varchar,
	TOKEN varchar,
	ERROR_CODE varchar,
	ERROR_MESSAGE varchar,
	FAILURE_CODE varchar,
	FAILURE_MESSAGE varchar,
	FAILED_REQUEST_TYPE varchar,
	EXCEPTION_PROCESSOR varchar,
	EXCEPTION_CAUSE varchar,
	EXCEPTION_LEVEL varchar,
	EXCEPTION_HINT varchar,
	EXCEPTION_FORMAT varchar,
	EXCEPTION_FIELD varchar,
	EXCEPTION_VALUE varchar,
	TOKEN_TRANSACTION_FK bigint(20),
	FAILURE_CODE varchar,
	FAILURE_CODE varchar,
	TOKEN varchar,
	TOKEN varchar,
	PRIMARY KEY (ID)
) ENGINE=InnoDB;