-- 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,
	TSA varchar,
	SDK varchar,
	EMV tinyint(1),
	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),
	CERTIFICATE_FILES tinyint(1),
	PARAMETERS_FILE 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,
	PRIMARY KEY (ID)
) ENGINE=InnoDB;