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