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