-- Create Table Statement for 'Pre Rule'
DROP TABLE IF EXISTS `PRE_RULE`;
CREATE TABLE `PRE_RULE` (
	ID bigint(20) NOT NULL,
	MERCHANT_ACCOUNT_CODE int(11) NOT NULL,
	BILLING_COUNTRY_CODE_LIST varchar,
	BILLING_STATE_CODE_LIST varchar,
	ISSUING_COUNTRY_CODE_LIST varchar,
	CARD_TYPE_LIST varchar,
	RULE_ACTION_CL varchar,
	AMOUNT int(11),
	USER_MESSAGE varchar,
	MERCHANT_ACCOUNT_PROFILE_FK bigint(20),
	MERCHANT_ACCOUNT_PROFILE_PRE_RULES_IDX int(11),
	IS_ACTIVE tinyint(1),
	RULE_OPERATOR_CL varchar,
	PRIMARY KEY (ID)
) ENGINE=InnoDB;