-- 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;