|
cluster_message
Long commands transmitted between nodes of Dr.Web Servers cluster.
Table fields
Field name
|
Field type
|
Description
|
sid
|
VARCHAR(36) NOT NULL
|
destination station ID
|
mid
|
NUMERIC(19) NOT NULL
|
message ID
|
command
|
CLOB NOT NULL
|
message body
|
Table indexes
Index name
|
Index type
|
Fields
|
cluster_message_pkey
|
table primary key
|
mid
|
env_fwd_hash
List of hashes of environment categories which were generated by Dr.Web Server to be forwarded to the neighbor.
Table fields
Field name
|
Field type
|
Description
|
osid
|
VARCHAR(36) NOT NULL
|
server ID
|
id
|
VARCHAR(36) NOT NULL
|
station ID
|
category
|
INTEGER NOT NULL
|
environment category
|
hash
|
VARCHAR(128) NOT NULL
|
environment category hash
|
createtime
|
NUMERIC(17) DEFAULT ''
|
record creation time
|
Table indexes
Index name
|
Index type
|
Fields
|
env_fwd_hash_pkey
|
table primary key
clustering index
|
osid, id, category
|
oauth_clients
Credentials of external applications for the OAuth authorization.
Table fields
Field name
|
Field type
|
Description
|
id
|
VARCHAR(255) NOT NULL
|
identifier
|
secret
|
VARCHAR(255) NOT NULL
|
shared secret
|
title
|
VARCHAR(255) NOT NULL
|
short name
|
description
|
TEXT DEFAULT ''
|
description
|
icon_url
|
TEXT DEFAULT ''
|
icon URL
|
homepage
|
TEXT DEFAULT ''
|
home page (promo page)
|
created
|
NUMERIC(17) NOT NULL
|
creation time
|
token_ttl
|
INTEGER DEFAULT '3600' NOT NULL
|
TTL (sec) for new tokens
|
code_ttl
|
INTEGER DEFAULT '600' NOT NULL
|
TTL (sec) for new authorization codes
|
user_id
|
VARCHAR(255) DEFAULT ''
|
owner identifier, for built-in applications must be empty
|
client_type
|
INTEGER DEFAULT '0' NOT NULL
|
client type: 0—built-in, 1—custom
|
client_status
|
INTEGER DEFAULT '0' NOT NULL
|
client current status: 0—disabled, 1—enabled
|
Table indexes
Index name
|
Index type
|
Fields
|
oauth_clients_0001
|
unique table index
|
secret
|
oauth_clients_pkey
|
table primary key
|
id
|
oauth_codes
Authorization codes of external applications for the OAuth authorization.
Table fields
Field name
|
Field type
|
Description
|
client_id
|
VARCHAR(255) NOT NULL
|
identifier of an application for which the code is issued
|
user_id
|
VARCHAR(255) NOT NULL
|
identifier of a user who requested a code
|
code
|
VARCHAR(40) NOT NULL
|
authorization code
|
created
|
NUMERIC(17) NOT NULL
|
creation time
|
expires
|
NUMERIC(17) NOT NULL
|
expiration time (oauth_codes.created + oauth_clients.code_ttl)
|
redirect_uri
|
TEXT NOT NULL
|
redirect URI from user request. Used to verify a request when exchanging a code to a token
|
state
|
TEXT DEFAULT ''
|
custom field from user request. Used to verify a request when exchanging a code to a token
|
Table indexes
Index name
|
Index type
|
Fields
|
oauth_codes_pkey
|
table primary key
|
code
|
Table references
Field name
|
Direction
|
Referenced table field
|
client_id
|
→
|
oauth_clients.id
|
oauth_tokens
Access tokens to external applications for the OAuth authorization.
Table fields
Field name
|
Field type
|
Description
|
token_access
|
VARCHAR(40) NOT NULL
|
access token
|
token_refresh
|
VARCHAR(40) NOT NULL
|
refresh token
|
created
|
NUMERIC(17) NOT NULL
|
creation time
|
expires
|
NUMERIC(17) NOT NULL
|
expiration time (oauth_tokens.created + oauth_clients.token_ttl)
|
user_id
|
VARCHAR(255) NOT NULL
|
identifier of a user for which the token is issued
|
client_id
|
VARCHAR(255) NOT NULL
|
identifier of an application for which the code is issued
|
Table indexes
Index name
|
Index type
|
Fields
|
oauth_tokens_0001
|
simple table index
|
token_refresh
|
oauth_tokens_pkey
|
table primary key
|
token_access
|
Table references
Field name
|
Direction
|
Referenced table field
|
client_id
|
→
|
oauth_clients.id
|
report_auto
Financial reports sent automatically by a task from Dr.Web Server schedule (Dr.Web AV-Desk only).
Table fields
Field name
|
Field type
|
Description
|
period
|
NUMERIC(6) NOT NULL
|
year and month (YYYYMM)
|
xmlvalue
|
CLOB DEFAULT ''
|
XML value
|
gendate
|
NUMERIC(17) DEFAULT '0'
|
generation date
|
sent
|
NUMERIC(17) DEFAULT '0'
|
sent date (0 if was not sent)
|
errmessage
|
CLOB DEFAULT ''
|
error message (if was not sent)
|
gentime
|
INTEGER DEFAULT '0'
|
generation time in seconds
|
Table indexes
Index name
|
Index type
|
Fields
|
report_auto_pkey
|
table primary key
|
period
|
report_data
Data on financial reports about tariffs usage (Dr.Web AV-Desk only).
Table fields
Field name
|
Field type
|
Description
|
rate
|
VARCHAR(36) NOT NULL
|
tariff group ID
|
id
|
VARCHAR(36) NOT NULL
|
ID of a station where the tariff was used
|
aid
|
VARCHAR(36) NOT NULL
|
UUID of an administrator who ordered to create the report
|
days
|
INTEGER DEFAULT '0'
|
number of days when the tariff was used
|
user_id
|
VARCHAR(36) DEFAULT ''
|
ID of a user using this tariff
|
gid
|
VARCHAR(36) DEFAULT ''
|
user group ID
|
created
|
NUMERIC(17) DEFAULT '0'
|
record creation time
|
report_id
|
VARCHAR(36) NOT NULL
|
report UUID
|
Table indexes
Index name
|
Index type
|
Fields
|
report_data_pkey
|
table primary key
clustering index
|
aid, rate, id, report_id
|
Table references
Field name
|
Direction
|
Referenced table field
|
aid
|
→
|
admins.id
|
report_done_ids
Identifiers of sent financial reports (Dr.Web AV-Desk only).
Table fields
Field name
|
Field type
|
Description
|
id
|
VARCHAR(36) NOT NULL
|
ID of a station where the tariff was used
|
aid
|
VARCHAR(36) NOT NULL
|
UUID of an administrator who created the report
|
report_id
|
VARCHAR(36) NOT NULL
|
report UUID
|
Table indexes
Index name
|
Index type
|
Fields
|
report_done_ids_pkey
|
table primary key
clustering index
|
report_id, aid, id
|
Table references
Field name
|
Direction
|
Referenced table field
|
aid
|
→
|
admins.id
|
report_id
|
→
|
report_data.report_id
|
report_manual
Financial reports sent manually by administrator and reports manually moved to the archive (Dr.Web AV-Desk only).
Table fields
Field name
|
Field type
|
Description
|
periodbeg
|
NUMERIC(17) NOT NULL
|
report start date
|
periodend
|
NUMERIC(17) DEFAULT '0'
|
report end date
|
id
|
VARCHAR(36) NOT NULL
|
UUID of an administrator who created the report or report archive ID for reports moved to the archive
|
xmlvalue
|
CLOB DEFAULT ''
|
XML value
|
gendate
|
NUMERIC(17) NOT NULL
|
generation date
|
gentime
|
INTEGER DEFAULT '0'
|
generation time in seconds
|
Table indexes
Index name
|
Index type
|
Fields
|
report_manual_0001
|
simple table index
clustering index
|
id, gendate
|
Table references
Field name
|
Direction
|
Referenced table field
|
id
|
→
|
admins.id
|
reporting_ids
Identifiers of financial reports about tariff usage (Dr.Web AV-Desk only).
Table fields
Field name
|
Field type
|
Description
|
id
|
VARCHAR(36) NOT NULL
|
ID of a station where the tariff was used
|
aid
|
VARCHAR(36) NOT NULL
|
UUID of an administrator who created the report
|
company_id
|
VARCHAR(36) DEFAULT ''
|
user company ID
|
user_id
|
VARCHAR(36) DEFAULT ''
|
ID of a user using this tariff
|
report_id
|
VARCHAR(36) NOT NULL
|
report UUID
|
Table indexes
Index name
|
Index type
|
Fields
|
reporting_ids_0001
|
simple table index
clustering index
|
report_id, aid
|
reporting_ids_pkey
|
table primary key
|
id, aid, report_id
|
Table references
Field name
|
Direction
|
Referenced table field
|
aid
|
→
|
admins.id
|
report_id
|
→
|
report_data.report_id
|
station_offline_cmd
Saved commands that must be sent to stations after their connection to Dr.Web Server.
Table fields
Field name
|
Field type
|
Description
|
id
|
VARCHAR(36) NOT NULL
|
station ID
|
rid
|
VARCHAR(36) NOT NULL
|
command UUID
|
cmd
|
VARCHAR(256)
|
command (see Appendix B)
|
data
|
CLOB DEFAULT ''
|
command data
|
created
|
NUMERIC(17) NOT NULL
|
record creation
|
min_proto
|
NUMERIC(5) DEFAULT '0'
|
minimal protocol version, e.g. 0x0301 is 3.1
|
Table indexes
Index name
|
Index type
|
Fields
|
station_offline_cmd_0001
|
simple table index
|
created
|
station_offline_cmd_0002
|
simple table index
clustering index
|
id
|
station_offline_cmd_0003
|
simple table index
|
rid
|
Table references
Field name
|
Direction
|
Referenced table field
|
id
|
→
|
stations.id
|
temporary_tables
The list of temporary tables.
Table fields
Field name
|
Field type
|
Description
|
table_name
|
VARCHAR(128) NOT NULL
|
temporary table name
|
createtime
|
NUMERIC(17) DEFAULT '0'
|
creation time
|
date1
|
NUMERIC(17) DEFAULT '0'
|
start date for statistics data in the table
|
date2
|
NUMERIC(17) DEFAULT '0'
|
end date for statistics data in the table
|
Table indexes
Index name
|
Index type
|
Fields
|
temporary_tables_pkey
|
table primary key
|
table_name
|
webmin
Internal data of the Web interface of Dr.Web Security Control Center.
Table fields
Field name
|
Field type
|
Description
|
id
|
VARCHAR(36) NOT NULL
|
record owner (admin.id)
|
rkey
|
VARCHAR(128) NOT NULL
|
record key
|
data
|
CLOB DEFAULT ''
|
record data
|
created
|
NUMERIC(17) DEFAULT '0'
|
record creation time
|
seq
|
INTEGER NOT NULL
|
record sequence number for big data sets
|
Table indexes
Index name
|
Index type
|
Fields
|
webmin_pkey
|
table primary key
clustering index
|
id, rkey, seq
|
Table references
Field name
|
Direction
|
Referenced table field
|
id
|
→
|
admins.id
|
|