-- Create Table Statement for 'Retail Profile'
DROP TABLE IF EXISTS `RETAIL_PROFILE`;
CREATE TABLE `RETAIL_PROFILE` (
	ID bigint(20) NOT NULL,
	IS_SEND_VOID_AUTHORIZATION tinyint(1),
	IS_SEND_VOID_CREDIT tinyint(1),
	IS_SEND_CREDIT_AUTHORIZATION tinyint(1),
	IS_AUTO_CAPTURE tinyint(1),
	IS_TOKENIZATION_REQUIRED tinyint(1),
	AUTHORIZATION_EXPIRATION_PERIOD int(11),
	IS_DEBIT_CARD_PROCESSING_ENABLED tinyint(1),
	IS_EBT_CARD_SUPPORTED tinyint(1),
	IS_BANK_DEBIT_CARD_SUPPORTED tinyint(1),
	IS_DINNERS_CARD_SUPPORTED tinyint(1),
	IS_CASH_BACK_AMOUNT_SUPPORTED tinyint(1),
	IS_SEND_VOICE_AUTHORIZATION tinyint(1),
	IS_VOICE_AUTHORIZATION_SUPPORTED tinyint(1),
	IS_CARD_VERIFICATION_SUPPORTED tinyint(1),
	IS_BALANCE_INQUIRY_SUPPORTED tinyint(1),
	IS_SEND_VOID_VOICE_AUTHORIZATION tinyint(1),
	IS_TIP_AMOUNT_SUPPORTED tinyint(1),
	IS_PARTIAL_VOID_SUPPORTED tinyint(1),
	IS_TIP_AMOUNT_CAPTURE_ENABLED tinyint(1),
	IS_GIFT_CARD_SUPPORTED tinyint(1),
	IS_PINLESS_DEBIT_SUPPORTED tinyint(1),
	IS_CAPTURE_REQUIRED tinyint(1),
	IS_TIP_ADJUSTMENT_SUPPORTED tinyint(1),
	IS_DISCOVER_CASHBACK_ENABLED tinyint(1),
	IS_PETROLEUM_INDUSTRY_SUPPORTED tinyint(1),
	IS_CYCLE_CONCURRENCY_SUPPORTED tinyint(1),
	CYCLE_PROCESSING_MODE_CL varchar,
	IS_VOID_SUPPORTED tinyint(1),
	IS_LODGING_INDUSTRY_SUPPORTED tinyint(1),
	PRESTIGIOUS_PROPERTY_INDICATOR_CL varchar,
	AUTHORIZATION_CURRENCY_CODE_CL varchar,
	CAPTURE_CURRENCY_CODE_CL varchar,
	IS_SETTLEMENT_DELAY_SUPPORTED tinyint(1),
	IS_EMPTY_SETTLEMENT_REQUIRED tinyint(1),
	IS_CONVENIENCE_FEE_REQUEST_ENABLED tinyint(1),
	SUPPORTED_CREDIT_POLICY_CL varchar,
	IS_SETTLEMENT_INITIATION_REQUIRED tinyint(1),
	IS_AUTH_REVERSAL_REQUIRED tinyint(1),
	IS_TRANSFER_SUPPORTED tinyint(1),
	IS_GIFT_CARD_ALIAS_SUPPORTED tinyint(1),
	IS_INFO_REQUEST_SUPPORTED tinyint(1),
	CONNECTION_MODE_CL varchar,
	SETTLEMENT_MODE_CL varchar,
	IS_STATUS_VERIFICATION_SUPPORTED tinyint(1),
	IS_EMV_OFFLINE_SUPPORTED tinyint(1),
	IS_SEND_EMV_OFFLINE_AUTHORIZATION tinyint(1),
	IS_CAR_RENTAL_INDUSTRY_SUPPORTED tinyint(1),
	IS_SPLIT_BY_INDUSTRY_REQUIRED tinyint(1),
	MAX_SETTLEMENT_TRANSACTION_COUNT int(11),
	FACILITATOR_CODE bigint(20),
	IS_THREE_D_SECURE_SUPPORTED tinyint(1),
	IS_TERMINAL_PROCESSING_SUPPORTED tinyint(1),
	IS_KEY_LOADING_SUPPORTED tinyint(1),
	IS_SPLIT_BY_TERMINAL_CODE_REQUIRED tinyint(1),
	IS_CARD_MANAGEMENT_SUPPORTED tinyint(1),
	IS_PROFILING_SUPPORTED tinyint(1),
	SPLIT_POLICY varchar,
	IS_SPLIT_PAYMENT_PROCESSING_SUPPORTED tinyint(1),
	IS_SPLIT_PAYMENT_PROCESSING_SUPPORTED tinyint(1),
	IS_SETTLEMENT_CARD_DATA_REQUIRED tinyint(1),
	IS_SETTLEMENT_CARD_DATA_REQUIRED tinyint(1),
	CAPTURE_PROCESSING_MODE_CL varchar,
	CAPTURE_PROCESSING_MODE_CL varchar,
	IS_REFERRAL_DECLINE_SUPPORTED tinyint(1),
	IS_REFERRAL_DECLINE_SUPPORTED tinyint(1),
	IS_SPLIT_PAYMENT_PROCESSING_SUPPORTED tinyint(1),
	IS_SETTLEMENT_CARD_DATA_REQUIRED tinyint(1),
	CAPTURE_PROCESSING_MODE_CL varchar,
	IS_REFERRAL_DECLINE_SUPPORTED tinyint(1),
	IS_CREDIT_AUTH_SUPPORTED tinyint(1),
	IS_UNCAPTURED_REVERSAL_REQUIRED tinyint(1),
	IS_BATCH_CAPTURE_ENABLED tinyint(1),
	IS_CREDIT_AUTH_SUPPORTED tinyint(1),
	IS_UNCAPTURED_REVERSAL_REQUIRED tinyint(1),
	IS_CREDIT_AUTH_SUPPORTED tinyint(1),
	IS_UNCAPTURED_REVERSAL_REQUIRED tinyint(1),
	IS_BATCH_CAPTURE_ENABLED tinyint(1),
	IS_BATCH_CAPTURE_ENABLED tinyint(1),
	PRESTIGIOUS_PROPERTY_INDICATOR_CL varchar,
	CAPTURE_PROCESSING_MODE_CL varchar,
	CAPTURE_PROCESSING_MODE_CL varchar,
	IS_TOKENIZATION_REQUIRED tinyint(1),
	IS_TOKENIZATION_REQUIRED tinyint(1),
	PRESTIGIOUS_PROPERTY_INDICATOR_CL varchar,
	IS_TERMINAL_CONFIGURATION_REQUEST_ENABLED tinyint(1),
	IS_TERMINAL_CONFIGURATION_REQUEST_ENABLED tinyint(1),
	SUPPORTED_CREDIT_POLICY_CL varchar,
	IS_PREVALIDATION_REQUIRED tinyint(1),
	IS_PREVALIDATION_REQUIRED tinyint(1),
	IS_TERMINAL_CONFIGURATION_REQUEST_ENABLED tinyint(1),
	IS_PREVALIDATION_REQUIRED tinyint(1),
	FACILITATOR_CODE bigint(20),
	FACILITATOR_CODE bigint(20),
	FACILITATOR_CODE bigint(20),
	SPLIT_POLICY varchar,
	MAX_SETTLEMENT_TRANSACTION_COUNT int(11),
	IS_SPLIT_BY_TERMINAL_CODE_REQUIRED tinyint(1),
	IS_SPLIT_BY_INDUSTRY_REQUIRED tinyint(1),
	SPLIT_POLICY varchar,
	MAX_SETTLEMENT_TRANSACTION_COUNT int(11),
	IS_SPLIT_BY_TERMINAL_CODE_REQUIRED tinyint(1),
	IS_SPLIT_BY_INDUSTRY_REQUIRED tinyint(1),
	SPLIT_POLICY varchar,
	MAX_SETTLEMENT_TRANSACTION_COUNT int(11),
	IS_SPLIT_BY_TERMINAL_CODE_REQUIRED tinyint(1),
	IS_SPLIT_BY_INDUSTRY_REQUIRED tinyint(1),
	IS_CREDIT_AUTH_SUPPORTED tinyint(1),
	IS_CREDIT_AUTH_SUPPORTED tinyint(1),
	IS_CREDIT_AUTH_SUPPORTED tinyint(1),
	SUPPORTED_CREDIT_POLICY_CL varchar,
	AUTHORIZATION_EXPIRATION_PERIOD tinyint(1),
	PRIMARY KEY (ID)
) ENGINE=InnoDB;