-- Create Table Statement for 'Merchant Account Profile'
DROP TABLE IF EXISTS `MERCHANT_ACCOUNT_PROFILE`;
CREATE TABLE `MERCHANT_ACCOUNT_PROFILE` (
	ID bigint(20) NOT NULL,
	NAME varchar,
	MERCHANT_ACCOUNT_CODE int(11) NOT NULL,
	MIN_TRANSACTION_AMOUNT int(11),
	MAX_TRANSACTION_AMOUNT int(11),
	MAX_MERCHANT_TRANSACTION_COUNT_PER_HOUR int(11),
	MAX_MERCHANT_TRANSACTION_COUNT_PER_DAY int(11),
	MAX_CLIENT_TRANSACTION_COUNT_PER_HOUR int(11),
	MAX_CLIENT_TRANSACTION_COUNT_PER_DAY int(11),
	MAX_RISK_SCORE int(11),
	DUPLICATE_POLICY_CL varchar,
	IP_FILTERING_POLICY_CL varchar,
	IP_FILTER_LIST varchar,
	CC_PROFILE_FK bigint(20),
	EFT_PROFILE_FK bigint(20),
	RETAIL_PROFILE_FK bigint(20),
	EMAIL_PROFILE_FK bigint(20),
	LETTER_PROFILE_FK bigint(20),
	PHONE_CALL_PROFILE_FK bigint(20),
	CREDIT_AGENCY_PROFILE_FK bigint(20),
	CHARGEBACK_PROFILE_FK bigint(20),
	TOKEN_REGISTER_PROFILE_FK bigint(20),
	ACCOUNT_UPDATER_PROFILE_FK bigint(20),
	RETURN_PROFILE_FK bigint(20),
	AMEX_PROFILE_FK bigint(20),
	SKIP_TRACING_PROFILE_FK bigint(20),
	CARDS_COST_PROFILE_FK bigint(20),
	DEBIT_REALTIME_PROFILE_FK bigint(20),
	REALTIME_PERIOD int(11),
	IS_REALTIME_FIXED_TIME tinyint(1),
	IS_REALTIME_MANUAL_CLIENT_CAPTURE tinyint(1),
	AMEX_REALTIME_PROFILE_FK bigint(20),
	AMEX_CHARGEBACK_PROFILE_FK bigint(20),
	IS_FILE_NOTIFICATION_ENABLED tinyint(1),
	IS_SETTLEMENT_NOTIFICATION_ENABLED tinyint(1),
	IS_DAILY_SUMMARY_NOTIFICATION_ENABLED tinyint(1),
	EFT_REALTIME_PROFILE_FK bigint(20),
	CC_PROFILE_TYPE varchar,
	EFT_PROFILE_TYPE varchar,
	AMEX_PROFILE_TYPE varchar,
	RETAIL_PROFILE_TYPE varchar,
	AMEX_REALTIME_PROFILE_TYPE varchar,
	DEBIT_REALTIME_PROFILE_TYPE varchar,
	EFT_REALTIME_PROFILE_TYPE varchar,
	CHARGEBACK_PROFILE_TYPE varchar,
	AMEX_CHARGEBACK_PROFILE_TYPE varchar,
	RETURN_PROFILE_TYPE varchar,
	TOKEN_REGISTER_PROFILE_TYPE varchar,
	ACCOUNT_UPDATER_PROFILE_TYPE varchar,
	EMAIL_PROFILE_TYPE varchar,
	LETTER_PROFILE_TYPE varchar,
	PHONE_CALL_PROFILE_TYPE varchar,
	CREDIT_AGENCY_PROFILE_TYPE varchar,
	SKIP_TRACING_PROFILE_TYPE varchar,
	CARDS_COST_PROFILE_TYPE varchar,
	KEY_REGISTRY_FK bigint(20),
	DEFAULT_POST_RULE_ACTION_CL varchar,
	DECRYPTION_KEY_NAME varchar,
	DECRYPTION_KEY_NAME varchar,
	GIFT_REALTIME_PROFILE_TYPE varchar,
	GIFT_REALTIME_PROFILE_FK bigint(20),
	FRAUD_PROFILE_TYPE varchar,
	FRAUD_PROFILE_FK bigint(20),
	MERCHANT_CATEGORY_CODE varchar,
	CARD_DESCRIPTOR varchar,
	AMEX_MID varchar,
	DISCOVER_MID varchar,
	ECHECK_DESCRIPTOR varchar,
	ECHECK_MERCHANT_NAME varchar,
	CUSTOMER_SERVICE_PHONE varchar,
	EMV_REALTIME_PROFILE_TYPE varchar,
	EMV_REALTIME_PROFILE_FK bigint(20),
	IS_TRANSACTION_CONFIRMATION_ENABLED tinyint(1),
	DEFAULT_PRE_RULE_ACTION_CL varchar,
	PRE_RULE_USER_MESSAGE varchar,
	POST_RULE_USER_MESSAGE varchar,
	THREE_D_SECURE_PROFILE_FK bigint(20),
	THREE_D_SECURE_PROFILE_TYPE varchar,
	AMEX_ACCOUNT_UPDATER_PROFILE_TYPE varchar,
	ACCOUNT_UPDATER_AMEX_PROFILE_FK bigint(20),
	FULFILLMENT_PROFILE_TYPE varchar,
	FULFILLMENT_PROFILE_FK bigint(20),
	SETTLEMENT_MODE_CL varchar,
	IS_AMEX_OPT_BLUE_ACQUIRED tinyint(1),
	PROCESSING_POLICY_CL varchar,
	TERMINALS bigint(20),
	CONVENIENCE_FEE_FK bigint(20),
	PRE_RULES bigint(20),
	POST_RULES bigint(20),
	IS_ECHECK_ENABLED tinyint(1),
	TRANSACTION_DUPLICATE_POLICY varchar,
	CLIENT_ABORT_ACTION_CL varchar,
	TRANSACTION_DUPLICATE_POLICY varchar,
	CLIENT_ABORT_ACTION_CL varchar,
	TRANSACTION_DUPLICATE_POLICY varchar,
	CLIENT_ABORT_ACTION_CL varchar,
	ACH_REALTIME_PERIOD int(11),
	ACH_REALTIME_PERIOD int(11),
	ACH_REALTIME_PERIOD int(11),
	DECRYPTION_KEY_NAME varchar,
	IS_ECHECK_ENABLED tinyint(1),
	IS_TRANSACTION_CONFIRMATION_ENABLED tinyint(1),
	DECRYPTION_KEY_NAME varchar,
	IS_ECHECK_ENABLED tinyint(1),
	IS_TRANSACTION_CONFIRMATION_ENABLED tinyint(1),
	DECRYPTION_KEY_NAME varchar,
	IS_ECHECK_ENABLED tinyint(1),
	IS_TRANSACTION_CONFIRMATION_ENABLED tinyint(1),
	TEST_FIELD varchar,
	PRIMARY KEY (ID)
) ENGINE=InnoDB;