-- Create Table Statement for 'Provider'
DROP TABLE IF EXISTS `PROVIDER`;
CREATE TABLE `PROVIDER` (
	ID bigint(20) NOT NULL,
	NAME varchar,
	TYPE varchar,
	IS_ACTIVE tinyint(1),
	PROCESSING_CUTOFF int(11),
	CONNECTION_LIMIT int(11),
	IS_ONLINE_PIN_SUPPORTED tinyint(1),
	APPLICATION_ID_POLICY varchar,
	PROVIDER_CONFIGURATION_FK bigint(20),
	VERSION int(11),
	EMV_PARAM_DATA varchar,
	TEST_KSI varchar,
	TEST_BDK varchar,
	IS_TRANSACTION_RECONCILIATION_ENABLED tinyint(1),
	LAST_CA_KEY_UPDATE_DATE datetime,
	KEY_REGISTRY_FK bigint(20),
	PLATFORM varchar,
	PLATFORM varchar,
	PLATFORM varchar,
	CONTACT_TERMINAL_CONFIGURATION_FK bigint(20),
	CONTACTLESS_TERMINAL_CONFIGURATION_FK bigint(20),
	CA_KEYS_CHECKSUM varchar,
	CONTACT_TERMINAL_CONFIGURATION_FK bigint(20),
	CONTACTLESS_TERMINAL_CONFIGURATION_FK bigint(20),
	CA_KEYS_CHECKSUM varchar,
	CONTACT_TERMINAL_CONFIGURATION_FK bigint(20),
	CONTACTLESS_TERMINAL_CONFIGURATION_FK bigint(20),
	CA_KEYS_CHECKSUM varchar,
	ACCESSIBILITY_POLICY varchar,
	PROFILE_GROUP varchar,
	TAG_LIST varchar,
	TAG_LIST varchar,
	COUNTRY_CODE_LIST varchar,
	COUNTRY_CODE_LIST varchar,
	ACCESSIBILITY_POLICY varchar,
	PROFILE_GROUP varchar,
	GROUP_CODE varchar,
	TAG_LIST varchar,
	COUNTRY_CODE_LIST varchar,
	ACCESSIBILITY_POLICY varchar,
	PROFILE_GROUP varchar,
	GROUP_CODE varchar,
	COUNTRY_CODE_LIST varchar,
	COUNTRY_CODE_LIST varchar,
	COUNTRY_CODE_LIST varchar,
	COUNTRY_CODE_LIST varchar,
	GROUP_CODE varchar,
	COUNTRY_CODE_LIST varchar,
	COUNTRY_CODE_LIST varchar,
	ZPK_KEY_REGISTRY_FK bigint(20),
	ZPK_KEY_REGISTRY_FK bigint(20),
	ZPK_KEY_REGISTRY_FK bigint(20),
	TERMINAL_LIST varchar,
	CONTACT_TERMINAL_CONFIGURATION_TEST_FK bigint(20),
	CONTACTLESS_TERMINAL_CONFIGURATION_TEST_FK bigint(20),
	TERMINAL_LIST varchar,
	CONTACT_TERMINAL_CONFIGURATION_TEST_FK bigint(20),
	CONTACTLESS_TERMINAL_CONFIGURATION_TEST_FK bigint(20),
	TERMINAL_LIST varchar,
	CONTACT_TERMINAL_CONFIGURATION_TEST_FK bigint(20),
	CONTACTLESS_TERMINAL_CONFIGURATION_TEST_FK bigint(20),
	IS_DEPRECATED tinyint(1),
	IS_DEPRECATED tinyint(1),
	NAME varchar,
	PROCESSING_CUTOFF int(11),
	CONNECTION_LIMIT int(11),
	TERMINAL_LIST varchar,
	ZPK_KEY_REGISTRY_FK bigint(20),
	ID bigint(20) NOT NULL,
	NAME varchar,
	PROCESSING_CUTOFF int(11),
	CONNECTION_LIMIT int(11),
	TERMINAL_LIST varchar,
	ID bigint(20) NOT NULL,
	PRIMARY KEY (ID, ID, ID)
) ENGINE=InnoDB;