-- Create Table Statement for 'Terminal Diagnostics'
DROP TABLE IF EXISTS `TERMINAL_DIAGNOSTICS`;
CREATE TABLE `TERMINAL_DIAGNOSTICS` (
	ID bigint(20) NOT NULL,
	MERCHANT_ACCOUNT_CODE int(11) NOT NULL,
	TERMINAL_CODE bigint(20) NOT NULL,
	LIBRARY varchar,
	SDK varchar,
	EMV varchar,
	KSN varchar,
	MAC tinyint(1),
	CONNECTIVITY_GATEWAY int(11),
	CONNECTIVITY_TMS int(11),
	CONNECTIVITY_CLOUD tinyint(1),
	TCP_CONNECT tinyint(1),
	TCP_SEND tinyint(1),
	CERTIFICATES tinyint(1),
	PARAMETERS tinyint(1),
	PASSWORD_FILE tinyint(1),
	SECRET_KEY_FILE tinyint(1),
	TERMINAL_TIME varchar,
	TERMINAL_DEVICE_STATUS_CL varchar,
	SERIAL_NUMBER varchar,
	TERMINAL_KEY bigint(20),
	UPDATE_VERSION varchar,
	PROCESSING_APPLICATION varchar,
	ADMINISTRATION_APPLICATION varchar,
	UPDATE_APPLICATION varchar,
	RECOVERY_APPLICATION varchar,
	IP_ADDRESS varchar,
	IP_ADDRESS_CL varchar,
	SUBNET_MASK varchar,
	DEFAULT_GATEWAY varchar,
	DNS1 varchar,
	DNS2 varchar,
	PING tinyint(1),
	LAST_UPDATE_DATE datetime,
	UPDATE_PROFILE varchar,
	SDK varchar,
	SDK varchar,
	HARDWARE varchar,
	SECURITY varchar,
	LIBRARY varchar,
	EMV varchar,
	CERTIFICATES tinyint(1),
	PARAMETERS tinyint(1),
	UPDATE_PROFILE varchar,
	PASSWORD_FILE tinyint(1),
	SECRET_KEY_FILE tinyint(1),
	HARDWARE varchar,
	SECURITY varchar,
	EMV varchar,
	CERTIFICATES tinyint(1),
	PARAMETERS tinyint(1),
	UPDATE_PROFILE varchar,
	PASSWORD_FILE tinyint(1),
	SECRET_KEY_FILE tinyint(1),
	PASSWORD_FILE tinyint(1),
	SECRET_KEY_FILE tinyint(1),
	HARDWARE varchar,
	SECURITY varchar,
	SERIAL_NUMBER varchar,
	SERIAL_NUMBER varchar,
	UPDATE_PROFILE varchar,
	UPDATE_PROFILE varchar,
	TIME_ZONE varchar,
	SERVICES_ACTIVATE_TERMINAL varchar,
	SERVICES_GET_CREDENTIALS varchar,
	SERVICES_LOG_CREDENTIALS varchar,
	SERVICES_GET_TIME varchar,
	SERVICES_GET_CONFIGURATION varchar,
	SERVICES_LOG_STATE varchar,
	SERVICES_LOG_DIAGNOSTICS varchar,
	SERVICES_UPLOAD_LOG varchar,
	SERVICES_GET_UPDATE varchar,
	SERVICES_GET_KEY varchar,
	SERVICES_GET_PARAMETERS varchar,
	SERVICES_MERCHANT_INFO varchar,
	SERVICES_PING varchar,
	SERVICES_SET_PARAMETERS varchar,
	TIME_ZONE varchar,
	SERVICES_ACTIVATE_TERMINAL varchar,
	SERVICES_GET_CREDENTIALS varchar,
	SERVICES_LOG_CREDENTIALS varchar,
	SERVICES_GET_TIME varchar,
	SERVICES_GET_CONFIGURATION varchar,
	SERVICES_LOG_STATE varchar,
	SERVICES_LOG_DIAGNOSTICS varchar,
	SERVICES_UPLOAD_LOG varchar,
	SERVICES_GET_UPDATE varchar,
	SERVICES_GET_KEY varchar,
	SERVICES_GET_PARAMETERS varchar,
	SERVICES_MERCHANT_INFO varchar,
	SERVICES_PING varchar,
	SERVICES_SET_PARAMETERS varchar,
	TIME_ZONE varchar,
	SERVICES_ACTIVATE_TERMINAL varchar,
	SERVICES_GET_CREDENTIALS varchar,
	SERVICES_LOG_CREDENTIALS varchar,
	SERVICES_GET_TIME varchar,
	SERVICES_GET_CONFIGURATION varchar,
	SERVICES_LOG_STATE varchar,
	SERVICES_LOG_DIAGNOSTICS varchar,
	SERVICES_UPLOAD_LOG varchar,
	SERVICES_GET_UPDATE varchar,
	SERVICES_GET_KEY varchar,
	SERVICES_GET_PARAMETERS varchar,
	SERVICES_MERCHANT_INFO varchar,
	SERVICES_PING varchar,
	SERVICES_SET_PARAMETERS varchar,
	HARDWARE varchar,
	LIBRARY varchar,
	TIME_ZONE varchar,
	HARDWARE varchar,
	LIBRARY varchar,
	TIME_ZONE varchar,
	SERIAL_NUMBER varchar,
	SERIAL_NUMBER varchar,
	LIBRARY varchar,
	HARDWARE varchar,
	HARDWARE varchar,
	PRIMARY KEY (ID)
) ENGINE=InnoDB;