-- Create Table Statement for 'UniPay Provisioning Transaction'
DROP TABLE IF EXISTS `UNI_PAY_PROVISIONING_TRANSACTION`;
CREATE TABLE `UNI_PAY_PROVISIONING_TRANSACTION` (
	ID bigint(20) NOT NULL,
	MERCHANT_ACCOUNT_CODE int(11) NOT NULL,
	REQUEST_TYPE varchar,
	PROFILE_TYPE varchar,
	IS_EMBEDDED varchar,
	PAGE_FORMAT varchar,
	NOTIFY_URL varchar,
	CANCEL_URL varchar,
	RETURN_URL varchar,
	RETURN_URL_POLICY varchar,
	RESELLER_ID varchar,
	PORTFOLIO_ID int(11),
	MERCHANT_ID varchar,
	APPLICATION_CODE varchar,
	FEE_TEMPLATE_CODE varchar,
	PROCESSING_CONFIGURATION_SCRIPT varchar,
	OWNER_EMAIL varchar,
	OWNER_FIRST_NAME varchar,
	OWNER_LAST_NAME varchar,
	OWNER_STREET1 varchar,
	OWNER_STREET2 varchar,
	OWNER_CITY varchar,
	OWNER_STATE varchar,
	OWNER_ZIP_CODE varchar,
	OWNER_COUNTRY_CODE varchar,
	OWNER_BIRTH_DATE varchar,
	OWNER_SOCIAL_SECURITY varchar,
	OWNER_PHONE varchar,
	BUSINESS_BUSINESS_NAME varchar,
	BUSINESS_LEGAL_NAME varchar,
	BUSINESS_OWNERSHIP_STRUCTURE_TYPE varchar,
	BUSINESS_STREET1 varchar,
	BUSINESS_STREET2 varchar,
	BUSINESS_CITY varchar,
	BUSINESS_STATE varchar,
	BUSINESS_ZIP_CODE varchar,
	BUSINESS_COUNTRY_CODE varchar,
	BUSINESS_DESCRIPTOR_PHONE varchar,
	BUSINESS_TAX_ID varchar,
	BUSINESS_WEB_SITE varchar,
	BUSINESS_EMAIL varchar,
	BUSINESS_DESCRIPTION varchar,
	BUSINESS_MERCHANT_CATEGORY_CODE varchar,
	ESTIMATES_ANNUAL_DIRECT_DEBIT_VOLUME int(11),
	ESTIMATES_ANNUAL_CARDS_VOLUME int(11),
	ESTIMATES_AVG_DIRECT_DEBIT_TRANSACTION_AMOUNT int(11),
	ESTIMATES_AVG_CARDS_TRANSACTION_AMOUNT int(11),
	ESTIMATES_MAX_TRANSACTION_AMOUNT int(11),
	DEPOSIT_BANK_NAME varchar,
	DEPOSIT_HOLDER_NAME varchar,
	DEPOSIT_ACCOUNT_TYPE varchar,
	ACCOUNT_ID int(11),
	APPLICATION_ID bigint(20),
	CARDS_DESCRIPTOR varchar,
	DIRECT_DEBIT_DESCRIPTOR varchar,
	RESPONSE_CODE varchar,
	RESPONSE_MESSAGE varchar,
	PROVISIONING_TRANSACTION_FK bigint(20),
	RETAIL_TRANSACTION_CYCLE_FK bigint(20),
	BUSINESS_DRIVER_LICENSE varchar,
	BUSINESS_DRIVER_LICENSE_STATE varchar,
	BUSINESS_DRIVER_LICENSE_COUNTRY_CODE varchar,
	BUSINESS_CURRENCY_CODE varchar,
	BUSINESS_WORK_HOURS varchar,
	BUSINESS_REGISTRATION_YEAR int(11),
	BUSINESS_REGISTRATION_STATE varchar,
	BUSINESS_REGISTRATION_COUNTRY_CODE varchar,
	DISTRIBUTION_SCHEMA_CODE varchar,
	NOTIFICATION_POLICY varchar,
	BILLING_CONFIGURATION_SCRIPT varchar,
	MERCHANT_PROFILE varchar,
	BUSINESS_TIME_ZOME varchar,
	RELATIONSHIP_BEGIN_DATE varchar,
	PROFILE_ID varchar,
	PROFILE_ID varchar,
	CLIENT_HOST varchar,
	CLIENT_HOST varchar,
	RESPONSE_CODE varchar,
	RESPONSE_CODE varchar,
	PROFILE_ID varchar,
	CLIENT_HOST varchar,
	TERMINAL_REF_CODE varchar,
	MERCHANT_TYPE varchar,
	MERCHANT_TYPE varchar,
	TERMINALS varchar,
	TERMINALS varchar,
	MERCHANT_CODE varchar,
	MERCHANT_TYPE varchar,
	TERMINALS varchar,
	OWNER_STAKE_PERCENTAGE int(11),
	MERCHANT_CODE varchar,
	OWNER_STAKE_PERCENTAGE int(11),
	PROVIDER_RESPONSE_CODE varchar,
	PROVIDER_RESPONSE_MESSAGE varchar,
	CONTACT_INFO_PHONE varchar,
	TERMINAL_CODE varchar,
	INDUSTRY_TYPE varchar,
	OFFICER_ID varchar,
	OFFICER_CODE varchar,
	OWNER1_ID varchar,
	OWNER1_STATUS_CODE varchar,
	OWNER1_CODE varchar,
	OWNER2_ID varchar,
	OWNER2_STATUS_CODE varchar,
	OWNER2_CODE varchar,
	OWNER3_ID varchar,
	OWNER3_STATUS_CODE varchar,
	OWNER3_CODE varchar,
	OWNER4_ID varchar,
	OWNER4_STATUS_CODE varchar,
	OWNER4_CODE varchar,
	OWNER5_ID varchar,
	OWNER5_STATUS_CODE varchar,
	OWNER5_CODE varchar,
	OWNER6_ID varchar,
	OWNER6_STATUS_CODE varchar,
	OWNER6_CODE varchar,
	TERMINAL_SETUP varchar,
	TERMINAL_ID varchar,
	TERMINAL_STATUS varchar,
	RESPONSE_TERMINAL_ID varchar,
	MERCHANT_CODE varchar,
	OWNER_STAKE_PERCENTAGE int(11),
	OWNER_ID varchar,
	OWNER_CODE varchar,
	OWNER_TITLE varchar,
	PROVIDER_RESPONSE_CODE varchar,
	PROVIDER_RESPONSE_MESSAGE varchar,
	CONTACT_INFO_PHONE varchar,
	TERMINAL_CODE varchar,
	INDUSTRY_TYPE varchar,
	OFFICER_ID varchar,
	OFFICER_CODE varchar,
	OWNER1_ID varchar,
	OWNER1_STATUS_CODE varchar,
	OWNER1_CODE varchar,
	OWNER2_ID varchar,
	OWNER2_STATUS_CODE varchar,
	OWNER2_CODE varchar,
	OWNER3_ID varchar,
	OWNER3_STATUS_CODE varchar,
	OWNER3_CODE varchar,
	OWNER4_ID varchar,
	OWNER4_STATUS_CODE varchar,
	OWNER4_CODE varchar,
	OWNER5_ID varchar,
	OWNER5_STATUS_CODE varchar,
	OWNER5_CODE varchar,
	OWNER6_ID varchar,
	OWNER6_STATUS_CODE varchar,
	OWNER6_CODE varchar,
	TERMINAL_SETUP varchar,
	TERMINAL_ID varchar,
	TERMINAL_STATUS varchar,
	RESPONSE_TERMINAL_ID varchar,
	OWNER_ID varchar,
	OWNER_CODE varchar,
	OWNER_TITLE varchar,
	PROVIDER_RESPONSE_CODE varchar,
	PROVIDER_RESPONSE_MESSAGE varchar,
	CONTACT_INFO_PHONE varchar,
	TERMINAL_CODE varchar,
	INDUSTRY_TYPE varchar,
	OFFICER_ID varchar,
	OFFICER_CODE varchar,
	OWNER1_ID varchar,
	OWNER1_STATUS_CODE varchar,
	OWNER1_CODE varchar,
	OWNER2_ID varchar,
	OWNER2_STATUS_CODE varchar,
	OWNER2_CODE varchar,
	OWNER3_ID varchar,
	OWNER3_STATUS_CODE varchar,
	OWNER3_CODE varchar,
	OWNER4_ID varchar,
	OWNER4_STATUS_CODE varchar,
	OWNER4_CODE varchar,
	OWNER5_ID varchar,
	OWNER5_STATUS_CODE varchar,
	OWNER5_CODE varchar,
	OWNER6_ID varchar,
	OWNER6_STATUS_CODE varchar,
	OWNER6_CODE varchar,
	TERMINAL_SETUP varchar,
	TERMINAL_ID varchar,
	TERMINAL_STATUS varchar,
	RESPONSE_TERMINAL_ID varchar,
	OWNER_ID varchar,
	OWNER_CODE varchar,
	OWNER_TITLE varchar,
	PRIMARY KEY (ID)
) ENGINE=InnoDB;