-- Create Table Statement for 'PayFacto Provisioning Transaction'
DROP TABLE IF EXISTS `PAYFACTO_PROVISIONING_TRANSACTION`;
CREATE TABLE `PAYFACTO_PROVISIONING_TRANSACTION` (
	ID bigint(20) NOT NULL,
	MERCHANT_ACCOUNT_CODE int(11) NOT NULL,
	MERCHANT_COMMAND varchar,
	MERCHANT_ID varchar,
	MERCHANT_NAME varchar,
	STREET varchar,
	CITY varchar,
	PROVINCE varchar,
	POSTAL_CODE varchar,
	PHONE_NUMBER varchar,
	EMAIL_ADDRESS varchar,
	CONTACT_NAME varchar,
	CURRENCY_CODE varchar,
	PROVISIONING_TRANSACTION_FK bigint(20),
	INTERAC_MVV varchar,
	VISA_ORIGINATOR_ID varchar,
	MC_ORIGINATOR_ID varchar,
	JCB_ORIGINATOR_ID varchar,
	AMEX_ORIGINATOR_ID varchar,
	DISCOVER_ORIGINATOR_ID varchar,
	MERCHANT_CATEGORY_CODE varchar,
	AMEX_DEPOSIT_MERCHANT_ID varchar,
	JCB_DEPOSIT_MERCHANT_ID varchar,
	DISCOVER_DEPOSIT_MERCHANT_ID varchar,
	VISA_DEPOSIT_MERCHANT_ID varchar,
	MC_DEPOSIT_MERCHANT_ID varchar,
	MERCHANT_RESULT_CODE varchar,
	MERCHANT_RESULT_TEXT varchar,
	CCARD_AMEX_RESULT_CODE varchar,
	CCARD_AMEX_RESULT_TEXT varchar,
	CCARD_JCB_RESULT_CODE varchar,
	CCARD_DISCOVER_RESULT_CODE varchar,
	CCARD_VISA_RESULT_CODE varchar,
	CCARD_MC_RESULT_CODE varchar,
	RESULT_CODE varchar,
	DCARD_RESULT_CODE varchar,
	CCARD_JCB_RESULT_TEXT varchar,
	CCARD_DISCOVER_RESULT_TEXT varchar,
	CCARD_VISA_RESULT_TEXT varchar,
	CCARD_MC_RESULT_TEXT varchar,
	DCARD_RESULT_TEXT varchar,
	RESULT_TEXT varchar,
	SET_LIKE_MERCHANT_ID varchar,
	PAYFACTO_PROVISIONING_FILE_BATCH_FK bigint(20),
	PRIMARY KEY (ID)
) ENGINE=InnoDB;