Server Status

news_known_did

The list of known news categories.

Table fields

Field name

Field type

Description

sid

VARCHAR(36) NOT NULL

server ID

did

VARCHAR(36) NOT NULL

news sections ID

createtime

NUMERIC(17) DEFAULT '0'

creation time

Table indexes

Index name

Index type

Fields list

news_known_did_pkey

table primary key

clustering index

did, sid

news_readstatus

Read status of Doctor Web company news.

Table fields

Field name

Field type

Description

sid

VARCHAR(36) NOT NULL

server ID

aid

VARCHAR(36) NOT NULL

admin UUID

did

VARCHAR(36) NOT NULL

news sections ID

nid

VARCHAR(36) NOT NULL

news article ID

ifile

VARCHAR(4000) NOT NULL

news article disk path

nstate

INTEGER NOT NULL

article state: 0—unread, 1—read

Table indexes

Index name

Index type

Fields list

news_readstatus_0001

simple table index

aid, nstate

news_readstatus_0002

simple table index

did, sid

news_readstatus_pkey

table primary key

clustering index

sid, aid, did, nid

Table references

Field name

Direction

Referenced table field

aid

admins.id

did

news_known_did.did

news_revision

Revisions numbers in the Server repository for Doctor Web company news.

Table fields

Field name

Field type

Description

sid

VARCHAR(36) NOT NULL

server ID

revision

NUMERIC(17) NOT NULL

revision number (DB time)

Table indexes

Index name

Index type

Fields list

news_revision_pkey

table primary key

clustering index

sid, revision

news_summary

General information on the section of Doctor Web company news.

Table fields

Field name

Field type

Description

sid

VARCHAR(36) NOT NULL

server ID

aid

VARCHAR(36) NOT NULL

admin UUID

unread

INTEGER DEFAULT '0'

number of unread articles

autosubscribe

INTEGER DEFAULT '1'

autosubscribe to new divisions

arrived

NUMERIC(17) DEFAULT '0'

unread news arrival time

Table indexes

Index name

Index type

Fields list

news_summary_pkey

table primary key

clustering index

aid, sid

Table references

Field name

Direction

Referenced table field

aid

admins.id

server_status

General information about the Server.

Table fields

Field name

Field type

Description

id

VARCHAR(36) NOT NULL

Server ID

state

INTEGER DEFAULT '0'

Server state: 0 for offline

marker

NUMERIC(17) DEFAULT '0'

alive time

uptime

NUMERIC(19) DEFAULT '0'

uptime, seconds

flavour

VARCHAR(512) DEFAULT ''

product: Enterprise/AV-Desk/etc

version

VARCHAR(512) DEFAULT ''

Server version

cpu

VARCHAR(512) DEFAULT ''

CPU type

os

VARCHAR(512) DEFAULT ''

operating system

platform

NUMERIC(12) DEFAULT '0'

host platform

os_full

VARCHAR(512) DEFAULT ''

full operating system (uname)

distrib

VARCHAR(512) DEFAULT ''

installed distributive

host

VARCHAR(512) DEFAULT ''

host name

clients_total

NUMERIC(17) DEFAULT '0'

connections from start

clients_maximum

NUMERIC(17) DEFAULT '0'

maximum connections

total_clients

NUMERIC(17) DEFAULT '0'

total clients now

total_agents

NUMERIC(17) DEFAULT '0'

total Agents now

total_newbies

NUMERIC(17) DEFAULT '0'

total newbies now

total_installs

NUMERIC(17) DEFAULT '0'

total installers now

total_links

NUMERIC(17) DEFAULT '0'

total neighbor Servers now

total_proxies

NUMERIC(17) DEFAULT '0'

total Proxies now

bytes_in

NUMERIC(17) DEFAULT '0'

bytes received

bytes_out

NUMERIC(17) DEFAULT '0'

bytes sent

Table indexes

Index name

Index type

Fields list

server_status_0001

simple table index

id

update_srv_delayed

The list of delayed updates in the Server repository.

Table fields

Field name

Field type

Description

product

VARCHAR(36) NOT NULL

product ID

revision

NUMERIC(17) NOT NULL

revision number (DB time)

duetime

NUMERIC(17) NOT NULL

delayed until

Table indexes

Index name

Index type

Fields list

update_srv_delayed_pkey

table primary key

product