|
available_keys
The list of license keys added to Dr.Web Server.
Table fields
Field name
|
Field type
|
Description
|
id
|
VARCHAR(36) NOT NULL
|
license key ID
|
value
|
CLOB DEFAULT ''
|
file content
|
type
|
INTEGER DEFAULT '0'
|
type, see module db-key-type
|
created
|
NUMERIC(17) DEFAULT '0'
|
record creation time
|
used_stations
|
NUMERIC(10) DEFAULT '0'
|
number of licenses used by stations
|
used_neighbors
|
NUMERIC(10) DEFAULT '0'
|
number of licenses used by neighbor Dr.Web Servers
|
Table indexes
Index name
|
Index type
|
Fields
|
available_keys_pkey
|
table primary key
|
id
|
group_key
Information on license keys of station groups.
Table fields
Field name
|
Field type
|
Description
|
id
|
VARCHAR(36) NOT NULL
|
group ID
|
kid
|
VARCHAR(36) NOT NULL
|
license key ID
|
modtime
|
NUMERIC(17) DEFAULT '0'
|
record modification time
|
Table indexes
Index name
|
Index type
|
Fields
|
group_key_0001
|
simple table index
clustering index
|
id
|
group_key_pkey
|
table primary key
|
id, kid
|
Table references
Field name
|
Direction
|
Referenced table field
|
id
|
→
|
groups_list.id
|
key_components
The list of anti-virus components allowed by a license key.
Table fields
Field name
|
Field type
|
Description
|
id
|
VARCHAR(36) NOT NULL
|
license key ID
|
component
|
INTEGER NOT NULL
|
component number
|
created
|
NUMERIC(17) DEFAULT '0'
|
record creation time
|
Table indexes
Index name
|
Index type
|
Fields
|
key_components_pkey
|
table primary key
clustering index
|
id, component
|
key_exchange
Data on licenses propagated on interserver connections.
Table fields
Field name
|
Field type
|
Description
|
lid
|
VARCHAR(36) NOT NULL
|
interserver connection ID
|
kid
|
VARCHAR(36) NOT NULL
|
license key ID
|
count
|
NUMERIC(10) DEFAULT '0'
|
number of licenses
|
expiration
|
NUMERIC(19) DEFAULT '0'
|
session expiration time
|
valid_thru
|
NUMERIC(19) DEFAULT '0'
|
absolute expiration time
|
state
|
INTEGER
|
exchange status, see module db-key-exchange-state
|
modtime
|
NUMERIC(17) DEFAULT '0'
|
record modification time
|
rp_period
|
INTEGER DEFAULT '0'
|
period to send license usage report
|
st_period
|
INTEGER DEFAULT '0'
|
period to mark stations as active
|
rp_delivered
|
INTEGER DEFAULT '0'
|
flag that license usage report was delivered
|
Table indexes
Index name
|
Index type
|
Fields
|
key_exchange_pkey
|
table primary key
clustering index
|
lid, kid
|
key_renew_exchange
Data on updates of licenses propagated on interserver connections.
Table fields
Field name
|
Field type
|
Description
|
okid
|
VARCHAR(36) NOT NULL
|
old license key ID
|
nkid
|
VARCHAR(36) DEFAULT ''
|
new license key ID
|
lid
|
VARCHAR(36) NOT NULL
|
interserver connection ID
|
created
|
NUMERIC(17) DEFAULT '0'
|
record creation time
|
Table indexes
Index name
|
Index type
|
Fields
|
key_renew_exchange_pkey
|
table primary key
clustering index
|
lid, okid
|
key_usage_reports
Report on licenses propagated on interserver connections. General information.
Table fields
Field name
|
Field type
|
Description
|
rid
|
VARCHAR(36) NOT NULL
|
report UUID
|
kid
|
VARCHAR(36) NOT NULL
|
license key ID
|
lid
|
VARCHAR(36) DEFAULT ''
|
interserver connection ID of the message sender or empty if it is a self-report
|
osid
|
VARCHAR(36) NOT NULL
|
originator Dr.Web Server ID
|
oname
|
TEXT DEFAULT ''
|
Dr.Web Server name
|
created
|
NUMERIC(17) DEFAULT '0'
|
time of report creation on the originator Dr.Web Server
|
Table indexes
Index name
|
Index type
|
Fields
|
key_usage_reports_0001
|
simple table index
|
kid
|
key_usage_reports_pkey
|
table primary key
|
rid
|
key_usage_reports_grp
Report on licenses propagated on interserver connections. Licenses propagated by the report creator to its station groups.
Table fields
Field name
|
Field type
|
Description
|
rid
|
VARCHAR(36) NOT NULL
|
report UUID
|
obj_name
|
TEXT DEFAULT ''
|
group or neighbor Dr.Web Server name
|
count_all
|
NUMERIC(10) DEFAULT '0'
|
number of total licenses propagated to groups
|
count_act
|
NUMERIC(10)
|
number of active stations in groups
|
Table indexes
Index name
|
Index type
|
Fields
|
key_usage_reports_grp_0001
|
simple table index
|
rid
|
Table references
Field name
|
Direction
|
Referenced table field
|
rid
|
↔
|
key_usage_reports.rid
|
key_usage_reports_srv
Report on licenses propagated on interserver connections. Licenses granted by the report creator to its child Dr.Web Servers.
Table fields
Field name
|
Field type
|
Description
|
rid
|
VARCHAR(36) NOT NULL
|
report UUID
|
obj_name
|
TEXT DEFAULT ''
|
group or neighbor Dr.Web Server name
|
count
|
NUMERIC(10) DEFAULT '0'
|
number of propagated licenses
|
state
|
INTEGER
|
status, see module db-key-exchange-state
|
Table indexes
Index name
|
Index type
|
Fields
|
key_usage_reports_srv_0001
|
simple table index
|
rid
|
Table references
Field name
|
Direction
|
Referenced table field
|
rid
|
↔
|
key_usage_reports.rid
|
policy_key
License keys of current policy version.
Table fields
Field name
|
Field type
|
Description
|
id
|
VARCHAR(36) NOT NULL
|
policy ID
|
kid
|
VARCHAR(36) NOT NULL
|
license key ID
|
Table indexes
Index name
|
Index type
|
Fields
|
policy_key_0001
|
simple table index
clustering index
|
id
|
policy_key_pkey
|
table primary key
|
id, kid
|
Table references
Field name
|
Direction
|
Referenced table field
|
id
|
→
|
policy_list.id
|
policy_key_lst
License keys of previous policy versions.
Table fields
Field name
|
Field type
|
Description
|
id
|
VARCHAR(36) NOT NULL
|
policy ID
|
version
|
NUMERIC(17) NOT NULL
|
policy version
|
kid
|
VARCHAR(36) NOT NULL
|
license key ID
|
Table indexes
Index name
|
Index type
|
Fields
|
policy_key_lst_pkey
|
table primary key
clustering index
|
id, version, kid
|
Table references
Field name
|
Direction
|
Referenced table field
|
id
|
→
|
policy_list.id
|
station_key
Information on license keys of stations.
Table fields
Field name
|
Field type
|
Description
|
id
|
VARCHAR(36) NOT NULL
|
station ID
|
kid
|
VARCHAR(36) NOT NULL
|
license key ID
|
modtime
|
NUMERIC(17) DEFAULT '0'
|
record modification time
|
Table indexes
Index name
|
Index type
|
Fields
|
station_key_0001
|
simple table index
clustering index
|
id
|
station_key_pkey
|
table primary key
|
id, kid
|
Table references
Field name
|
Direction
|
Referenced table field
|
id
|
→
|
stations.id
|
|