-- Create Table Statement for 'Reconciliation Profile'
DROP TABLE IF EXISTS `RECONCILIATION_PROFILE`;
CREATE TABLE `RECONCILIATION_PROFILE` (
	ID bigint(20) NOT NULL,
	RECONCILIATION_PROFILE_CL varchar,
	LAST_TRANSACTION_DETAIL_IMPORT_DATE datetime,
	LAST_FEE_DETAIL_IMPORT_DATE datetime,
	MERCHANT_ID varchar,
	PASSWORD varchar,
	CONNECTIVITY_MODE_CL varchar,
	CONNECTIVITY_MODE_CL varchar,
	CLIENT_ID varchar,
	CLIENT_SECRET varchar,
	API_KEY varchar,
	API_KEY_EXPIRATION_DATE datetime,
	ACCOUNT_NUMBER varchar,
	PROVIDER_NAME varchar,
	COUNTRY_CODE varchar,
	CLIENT_ID varchar,
	CLIENT_SECRET varchar,
	API_KEY varchar,
	API_KEY_EXPIRATION_DATE datetime,
	ACCOUNT_NUMBER varchar,
	PROVIDER_NAME varchar,
	COUNTRY_CODE varchar,
	CLIENT_ID varchar,
	CLIENT_SECRET varchar,
	API_KEY varchar,
	API_KEY_EXPIRATION_DATE datetime,
	ACCOUNT_NUMBER varchar,
	PROVIDER_NAME varchar,
	COUNTRY_CODE varchar,
	PRIMARY KEY (ID)
) ENGINE=InnoDB;