-- Create Table Statement for 'Provisioning Profile'
DROP TABLE IF EXISTS `PROVISIONING_PROFILE`;
CREATE TABLE `PROVISIONING_PROFILE` (
	ID bigint(20) NOT NULL,
	MODE_CL varchar,
	DATA_POLICY varchar,
	FACILITATOR_ID varchar,
	FACILITATOR_ATTRIBUTE1 varchar,
	FACILITATOR_ATTRIBUTE2 varchar,
	STATUS_UPDATE_PERIOD int(11),
	NAME varchar,
	STATUS_UPDATE_PERIOD int(11),
	NAME varchar,
	STATUS_UPDATE_PERIOD int(11),
	PROFILE_NAME varchar,
	STATUS_UPDATE_PERIOD int(11),
	IS_AFFILIATE_MERCHANT_REQUEST_ALLOWED tinyint(1),
	IS_AFFILIATE_MERCHANT_REQUEST_ALLOWED tinyint(1),
	IS_AFFILIATE_MERCHANT_REQUEST_ALLOWED tinyint(1),
	STATUS_UPDATE_PERIOD int(11),
	MODE_CL varchar,
	IS_TERMINAL_SUPPORTED tinyint(1),
	IS_TERMINAL_SUPPORTED tinyint(1),
	IS_UPDATE_OPERATION_SUPPORTED tinyint(1),
	IS_UPDATE_OPERATION_SUPPORTED tinyint(1),
	IS_FEE_SETUP_REQUIRED tinyint(1),
	MODE_CL varchar,
	IS_REMITTANCE_SUPPORTED tinyint(1),
	IS_VERIFICATION_ENABLED tinyint(1),
	IS_VERIFICATION_ENABLED tinyint(1),
	IS_AFFILIATE_MERCHANT_REQUEST_ALLOWED tinyint(1),
	IS_TERMINAL_SUPPORTED tinyint(1),
	IS_UPDATE_OPERATION_SUPPORTED tinyint(1),
	GROUP_CODE varchar,
	IS_FEE_SETUP_REQUIRED tinyint(1),
	IS_TERMINAL_SUPPORTED tinyint(1),
	TERMINAL_SUPPORT_MODE_CL varchar,
	IS_REMITTANCE_SUPPORTED tinyint(1),
	IS_VERIFICATION_ENABLED tinyint(1),
	COUNTRY_CODE varchar,
	PROFILE_NAME varchar,
	PROFILE_NAME varchar,
	IS_STATUS_OPERATION_SUPPORTED tinyint(1),
	IS_TERMINAL_UPDATE_SUPPORTED tinyint(1),
	IS_FEE_SETUP_REQUIRED tinyint(1),
	IS_REMITTANCE_SUPPORTED tinyint(1),
	IS_VERIFICATION_ENABLED tinyint(1),
	IS_OWNER_OPERATION_SUPPORTED tinyint(1),
	GROUP_CODE varchar,
	COUNTRY_CODE varchar,
	IS_TERMINAL_UPDATE_SUPPORTED tinyint(1),
	IS_OWNER_OPERATION_SUPPORTED tinyint(1),
	IS_TERMINAL_SUPPORTED tinyint(1),
	TERMINAL_SUPPORT_MODE_CL varchar,
	IS_STATUS_OPERATION_SUPPORTED tinyint(1),
	SIGNATURE_MODE varchar,
	GROUP_CODE varchar,
	COUNTRY_CODE varchar,
	IS_TERMINAL_UPDATE_SUPPORTED tinyint(1),
	IS_OWNER_OPERATION_SUPPORTED tinyint(1),
	TERMINAL_SUPPORT_MODE_CL varchar,
	IS_STATUS_OPERATION_SUPPORTED tinyint(1),
	DEFAULT_TERMINAL_RETAIL_CODE int(11),
	DEFAULT_TERMINAL_RESTAURANT_CODE int(11),
	DEFAULT_TERMINAL_DIRECT_MARKETING_CODE int(11),
	DEFAULT_TERMINAL_ECOMMERCE_CODE int(11),
	DEFAULT_TERMINAL_RETAIL_CODE int(11),
	DEFAULT_TERMINAL_RESTAURANT_CODE int(11),
	DEFAULT_TERMINAL_DIRECT_MARKETING_CODE int(11),
	DEFAULT_TERMINAL_ECOMMERCE_CODE int(11),
	DEFAULT_TERMINAL_RETAIL_CODE int(11),
	DEFAULT_TERMINAL_RESTAURANT_CODE int(11),
	DEFAULT_TERMINAL_DIRECT_MARKETING_CODE int(11),
	DEFAULT_TERMINAL_ECOMMERCE_CODE int(11),
	IS_ACCOUNT_CREATION_SUPPORTED tinyint(1),
	IS_ACCOUNT_CREATION_SUPPORTED tinyint(1),
	SIGNATURE_MODE varchar,
	IS_ACCOUNT_CREATION_SUPPORTED tinyint(1),
	SIGNATURE_MODE varchar,
	IS_ECHECK_ENABLED tinyint(1),
	IS_ECHECK_ENABLED tinyint(1),
	IS_ECHECK_ENABLED tinyint(1),
	REF_CODE varchar,
	REF_CODE varchar,
	REF_CODE varchar,
	PRIMARY KEY (ID)
) ENGINE=InnoDB;