-- 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;