-- Create Table Statement for 'Terminal Data'
DROP TABLE IF EXISTS `TERMINAL_DATA`;
CREATE TABLE `TERMINAL_DATA` (
	ID bigint(20) NOT NULL,
	MERCHANT_ACCOUNT_CODE int(11) NOT NULL,
	TERMINAL_CODE bigint(20),
	MODEL_CL varchar,
	SERIAL_NUMBER varchar,
	IP_ADDRESS varchar,
	TERMINAL_KEY_FK bigint(20),
	TERMINAL_CAPABILITIES_MASK bigint(20),
	ADDITIONAL_TERMINAL_CAPABILITIES_MASK bigint(20),
	TERMINAL_TYPE_MASK bigint(20),
	PROVIDER_CODE bigint(20),
	PAY_WAVE_TTQ_MASK bigint(20),
	INTERAC_TTI_MASK bigint(20),
	NEW_MERCHANT_ACCOUNT_CODE int(11),
	NEW_TERMINAL_CODE bigint(20),
	FULFILLMENT_CENTER_FK bigint(20),
	VERSION int(11),
	SERIAL_NUMBER_LIST varchar,
	SERIAL_NUMBER_LIST varchar,
	SERIAL_NUMBER_LIST varchar,
	CONFIGURATION_VERSION_CONTACT bigint(20),
	CONFIGURATION_VERSION_CONTACTLESS bigint(20),
	CONFIGURATION_VERSION_CONTACT bigint(20),
	CONFIGURATION_VERSION_CONTACTLESS bigint(20),
	CONFIGURATION_VERSION_CONTACT bigint(20),
	CONFIGURATION_VERSION_CONTACTLESS bigint(20),
	SERIAL_NUMBER varchar,
	SERIAL_NUMBER varchar,
	SERIAL_NUMBER_LIST varchar,
	SERIAL_NUMBER_LIST varchar,
	ACTIVATION_DATE datetime,
	DEACTIVATION_DATE datetime,
	IS_ACTIVE tinyint(1),
	DESCRIPTION varchar,
	ACTIVATION_DATE datetime,
	DEACTIVATION_DATE datetime,
	IS_ACTIVE tinyint(1),
	DESCRIPTION varchar,
	ATTESTATION_CODE varchar,
	SERIAL_NUMBER varchar,
	SERIAL_NUMBER_LIST varchar,
	BDK_KEY_REGISTRY_FK bigint(20),
	BDK_KEY_REGISTRY_FK bigint(20),
	ATTESTATION_CODE varchar,
	SERIAL_NUMBER varchar,
	SERIAL_NUMBER_LIST varchar,
	IS_ACTIVE tinyint(1),
	ACTIVATION_DATE datetime,
	DEACTIVATION_DATE datetime,
	IS_ACTIVE tinyint(1),
	DESCRIPTION varchar,
	BDK_KEY_REGISTRY_FK bigint(20),
	ATTESTATION_CODE varchar,
	FULFILLMENT_CENTER_FK bigint(20),
	FULFILLMENT_CENTER_FK bigint(20),
	MERCHANT_ACCOUNT_CODE int(11),
	MODEL_CL varchar,
	MODEL_CL varchar,
	PRIMARY KEY (ID)
) ENGINE=InnoDB;