-- Create Table Statement for 'Capture Info'
DROP TABLE IF EXISTS `CAPTURE_INFO`;
CREATE TABLE `CAPTURE_INFO` (
	ID bigint(20) NOT NULL,
	REF_CODE varchar,
	MERCHANT_ACCOUNT_CODE int(11) NOT NULL,
	COLLECTOR_ACCOUNT_CODE int(11),
	REQUEST_DATE datetime,
	HOLDER_NAME varchar,
	TAX_AMOUNT int(11),
	STREET varchar,
	CITY varchar,
	STATE varchar,
	PHONE varchar,
	ZIP_CODE varchar,
	EMAIL varchar,
	RESPONSE_CODE varchar,
	RESPONSE_DATE datetime,
	APPROVAL_CODE varchar,
	REFERENCE_NUMBER varchar,
	SYS_MESSAGE varchar,
	TOKEN_CODE varchar,
	TRANSACTION_CL varchar,
	CREATE_DATE datetime,
	ISSUER_BANK_NAME varchar,
	ISSUER_BANK_PHONE varchar,
	RISK_SCOPE int(11),
	RISK_EXPLANATION varchar,
	ENCODED_BIN varchar,
	IS_BIN_UNAVAILABLE tinyint(1),
	BILLING_HISTORY_FK bigint(20),
	PAYMENT_OPTION_FK bigint(20),
	BANK_INFO_FK int(11),
	COUNTRY_CODE varchar,
	NETWORK_TRANSACTION_ID varchar,
	ORIGINAL_NETWORK_TRANSACTION_ID varchar,
	SEQUENCE_COUNT int(11),
	SEQUENCE_NUMBER int(11),
	NETWORK_TRANSACTION_ID varchar,
	ORIGINAL_NETWORK_TRANSACTION_ID varchar,
	SEQUENCE_COUNT int(11),
	SEQUENCE_NUMBER int(11),
	NETWORK_TRANSACTION_ID varchar,
	ORIGINAL_NETWORK_TRANSACTION_ID varchar,
	SEQUENCE_COUNT int(11),
	SEQUENCE_NUMBER int(11),
	RESPONSE_MESSAGE varchar,
	ADDRESS varchar,
	RESPONSE_MESSAGE varchar,
	ADDRESS varchar,
	RESPONSE_MESSAGE varchar,
	ADDRESS varchar,
	BANK_INFO_FK int(11),
	BANK_INFO_FK int(11),
	PRIMARY KEY (ID)
) ENGINE=InnoDB;