CREATE TABLE TS$CONNECTION (
    ID                       DR$CONNECTION$ID /* DR$CONNECTION$ID = BIGINT NOT NULL */,
    MON$ATTACHMENT_ID        DR$MON$ATTACHMENT_ID /* DR$MON$ATTACHMENT_ID = INTEGER NOT NULL */,
    CONNECTION_TIMESTAMP     DR$TIMESTAMP /* DR$TIMESTAMP = TIMESTAMP NOT NULL */,
    DISCONNECTION_TIMESTAMP  DN$TIMESTAMP /* DN$TIMESTAMP = TIMESTAMP */,
    TERMINATED               DR$BOOL /* DR$BOOL = BOOLEAN NOT NULL */,
    MON$CHARACTER_SET_ID     DR$MON$CHARACTER_SET_ID /* DR$MON$CHARACTER_SET_ID = SMALLINT */,
    MON$SERVER_PID           DR$MON$SERVER_PID /* DR$MON$SERVER_PID = INTEGER NOT NULL */,
    MON$REMOTE_PID           DR$MON$REMOTE_PID /* DR$MON$REMOTE_PID = INTEGER NOT NULL */,
    MON$REMOTE_PROTOCOL      DR$MON$REMOTE_PROTOCOL /* DR$MON$REMOTE_PROTOCOL = VARCHAR(10) NOT NULL */,
    MON$USER                 DR$DBMS_OBJECT /* DR$DBMS_OBJECT = VARCHAR(31) NOT NULL */,
    MON$ROLE                 DN$DBMS_OBJECT /* DN$DBMS_OBJECT = VARCHAR(31) */,
    MON$REMOTE_OS_USER       DR$MON$REMOTE_OS_USER /* DR$MON$REMOTE_OS_USER = VARCHAR(255) NOT NULL */,
    MON$REMOTE_ADDRESS       DR$MON$REMOTE_ADDRESS /* DR$MON$REMOTE_ADDRESS = VARCHAR(255) NOT NULL */,
    MON$REMOTE_HOST          DR$MON$REMOTE_HOST /* DR$MON$REMOTE_HOST = VARCHAR(255) NOT NULL */,
    MON$REMOTE_PROCESS       DR$MON$REMOTE_PROCESS /* DR$MON$REMOTE_PROCESS = VARCHAR(255) NOT NULL */,
    MON$REMOTE_VERSION       DR$MON$REMOTE_VERSION /* DR$MON$REMOTE_VERSION = VARCHAR(255) NOT NULL */,
    MON$CLIENT_VERSION       DR$MON$CLIENT_VERSION /* DR$MON$CLIENT_VERSION = VARCHAR(255) NOT NULL */
);


INSERT INTO TS$CONNECTION (
      ID
    , MON$ATTACHMENT_ID
    , CONNECTION_TIMESTAMP
    , DISCONNECTION_TIMESTAMP
    , MON$CHARACTER_SET_ID
    , MON$SERVER_PID
    , MON$REMOTE_PID
    , MON$REMOTE_PROTOCOL
    , MON$USER
    , MON$ROLE
    , MON$REMOTE_OS_USER
    , MON$REMOTE_ADDRESS
    , MON$REMOTE_HOST
    , MON$REMOTE_PROCESS
    , MON$REMOTE_VERSION
    , MON$CLIENT_VERSION) VALUES (
      67
    , 372
    , '2014-12-29 11:15:08'
    , '2014-12-29 11:22:42'
    , 4
    , 1928
    , 328
    , 'TCPv6'
    , 'SYSDBA                         '
    , 'NONE                           '
    , 'user'
    , '::1'
    , 'host'
    , 'D:\ibe\IBExpert.exe'
    , 'P13'
    , 'WI-T3.0.0.31445 Firebird 3.0 Beta 1'
    );