-- Create Table Statement for 'EFT Profile'
DROP TABLE IF EXISTS `EFT_PROFILE`;
CREATE TABLE `EFT_PROFILE` (
ID bigint(20) NOT NULL,
MAX_RETRY_ATTEMPT int(11),
RETRY_INTERVAL int(11),
TEMPLATE varchar,
IS_AUTO_CAPTURE tinyint(1),
IS_REALTIME_PROCESSING_ENABLED tinyint(1),
SUPPORTED_CREDIT_POLICY_CL varchar,
EMULATION_MODE_CL varchar,
TRANSACTION_DATE_PROCESSING_CL varchar,
IS_SPLIT_BY_INDUSTRY_REQUIRED tinyint(1),
MAX_SETTLEMENT_TRANSACTION_COUNT int(11),
IS_SPLIT_BY_TERMINAL_CODE_REQUIRED tinyint(1),
MERCHANT_ACCOUNT_PROFILE_FK bigint(20),
IS_CONVENIENCE_FEE_REQUEST_ENABLED tinyint(1),
IS_PARTIAL_VOID_SUPPORTED tinyint(1),
SPLIT_POLICY varchar,
IS_CREDIT_AUTH_SUPPORTED tinyint(1),
IS_CREDIT_AUTH_SUPPORTED tinyint(1),
IS_CREDIT_AUTH_SUPPORTED tinyint(1),
IS_CAPTURE_REQUIRED tinyint(1),
SUPPORTED_CREDIT_POLICY_CL varchar,
IS_CAPTURE_REQUIRED tinyint(1),
EMULATION_MODE_CL varchar,
EMULATION_MODE_CL varchar,
EMULATION_MODE_CL varchar,
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_CAPTURE_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,
PRIMARY KEY (ID)
) ENGINE=InnoDB;