-- Create Table Statement for 'Processing Profile'
DROP TABLE IF EXISTS `PROCESSING_PROFILE`;
CREATE TABLE `PROCESSING_PROFILE` (
	ID bigint(20) NOT NULL,
	NAME varchar,
	IS_ACTIVE tinyint(1),
	PROVIDER_CODE bigint(20),
	MERCHANT_ACCOUNT_CODE int(11) NOT NULL,
	DEPOSIT_CL varchar,
	PROVIDER_ACCOUNT_FK bigint(20),
	IS_AGGREGATION_ENABLED tinyint(1),
	IS_CREDIT_ENABLED tinyint(1),
	IS_TWO_PHASE_PROCESSING_ENABLED tinyint(1),
	AUTHORIZATION_CURRENCY_CODE_CL varchar,
	CAPTURE_CURRENCY_CODE_CL varchar,
	TYPE varchar,
	SECONDARY_PROVIDER_ACCOUNT_FK bigint(20),
	AGGREGATION_CYCLE_FK bigint(20),
	PORTFOLIO_CODE int(11),
	PROFILE_CL varchar,
	ACCOUNT_PROCESSING_POLICY varchar,
	IDENTITY varchar,
	IDENTITY varchar,
	IDENTITY varchar,
	IS_UNMATCHED_PROCESSING_MODE tinyint(1),
	CREDIT_PROCESSING_MODE_CL varchar,
	IS_UNMATCHED_PROCESSING_MODE tinyint(1),
	IS_UNMATCHED_PROCESSING_MODE tinyint(1),
	TRANSACTION_SPLIT_POLICY varchar,
	TRANSACTION_SUB_BATCH_LIMIT int(11),
	TRANSACTION_SPLIT_POLICY varchar,
	TRANSACTION_SUB_BATCH_LIMIT int(11),
	NAME varchar,
	TRANSACTION_SPLIT_POLICY varchar,
	TRANSACTION_SUB_BATCH_LIMIT int(11),
	TRANSACTION_SPLIT_POLICY varchar,
	TRANSACTION_SUB_BATCH_LIMIT int(11),
	ACCOUNT_PROCESSING_POLICY varchar,
	ACCOUNT_PROCESSING_POLICY varchar,
	ACCOUNT_PROCESSING_POLICY varchar,
	ACCOUNT_PROCESSING_POLICY varchar,
	CREDIT_PROCESSING_MODE_CL varchar,
	CREDIT_PROCESSING_MODE_CL varchar,
	CREDIT_PROCESSING_MODE_CL varchar,
	CREDIT_PROCESSING_MODE_CL varchar,
	ACCOUNT_PROCESSING_POLICY varchar,
	ACCOUNT_PROCESSING_POLICY varchar,
	IS_AGGREGATABLE tinyint(1),
	IS_AGGREGATABLE tinyint(1),
	IS_AGGREGATABLE tinyint(1),
	PRIMARY KEY (ID)
) ENGINE=InnoDB;