|
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
|
ID of news sections
|
createtime
|
NUMERIC(17) DEFAULT '0'
|
creation time
|
Table indexes
Index name
|
Index type
|
Fields
|
news_known_did_pkey
|
table primary key
clustering index
|
did, sid
|
news_readstatus
Read status of the 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
|
ID of news sections
|
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
|
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
Revision numbers in Dr.Web Server repository for the 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
|
news_revision_pkey
|
table primary key
clustering index
|
sid, revision
|
news_summary
General information on the section of the 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
|
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 Dr.Web Server.
Table fields
Field name
|
Field type
|
Description
|
id
|
VARCHAR(36) NOT NULL
|
Dr.Web Server ID
|
state
|
INTEGER DEFAULT '0'
|
Dr.Web Server state: 0 for offline
|
marker
|
NUMERIC(17) DEFAULT '0'
|
state timestamp
|
uptime
|
NUMERIC(19) DEFAULT '0'
|
time of uninterrupted operation, seconds
|
flavour
|
VARCHAR(512) DEFAULT ''
|
product: Enterprise/AV-Desk/etc
|
version
|
VARCHAR(512) DEFAULT ''
|
Dr.Web 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 Dr.Web 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 Dr.Web Servers now
|
total_proxies
|
NUMERIC(17) DEFAULT '0'
|
total Proxies now
|
bytes_in
|
NUMERIC(17) DEFAULT '0'
|
bytes recieved
|
bytes_out
|
NUMERIC(17) DEFAULT '0'
|
bytes sent
|
Table indexes
Index name
|
Index type
|
Fields
|
server_status_0001
|
simple table index
|
id
|
update_srv_delayed
The list of delayed updates in Dr.Web 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
|
update_srv_delayed_pkey
|
table primary key
|
product
|
|