|
proxy_cfg
Configuration of Proxy servers connected to Dr.Web Server.
Table fields
Field name
|
Field type
|
Description
|
id
|
VARCHAR(36) NOT NULL
|
proxy ID
|
component
|
INTEGER NOT NULL
|
component ID (fake ID for complementing to standard structure. ID is always 146)
|
name
|
VARCHAR(255) NOT NULL
|
option name
|
seq
|
INTEGER NOT NULL
|
option sequence number
|
value
|
CLOB DEFAULT ''
|
option value
|
modtime
|
NUMERIC(17) DEFAULT '0'
|
record modification time
|
Table indexes
Index name
|
Index type
|
Fields
|
proxy_cfg_pkey
|
table primary key
clustering index
|
id, name, seq, component
|
Table references
Field name
|
Direction
|
Referenced table field
|
id
|
→
|
proxies.id
|
station_cfg
Configuration of Anti-virus components for stations.
Table fields
Field name
|
Field type
|
Description
|
id
|
VARCHAR(36) NOT NULL
|
station ID
|
component
|
INTEGER NOT NULL
|
component ID
|
name
|
VARCHAR(255) NOT NULL
|
option name
|
seq
|
INTEGER NOT NULL
|
option sequence number
|
value
|
CLOB DEFAULT ''
|
option value
|
modtime
|
NUMERIC(17) DEFAULT '0'
|
record modification time
|
Table indexes
Index name
|
Index type
|
Fields
|
station_cfg_pkey
|
table primary key
clustering index
|
id, component, name, seq
|
Table references
Field name
|
Direction
|
Referenced table field
|
id
|
→
|
stations.id
|
station_hash
Settings hashes of personal installation packages.
Table fields
Field name
|
Field type
|
Description
|
id
|
VARCHAR(36) NOT NULL
|
station ID
|
hash_code
|
VARCHAR(20) NOT NULL
|
hash of URL to personal installation package
|
createtime
|
NUMERIC(17) DEFAULT '0'
|
record creation time
|
Table indexes
Index name
|
Index type
|
Fields
|
station_hash_0001
|
simple table index
|
hash_code
|
station_hash_pkey
|
table primary key
|
id
|
Table references
Field name
|
Direction
|
Referenced table field
|
id
|
→
|
stations.id
|
station_install
Installing anti-virus components for stations.
Table fields
Field name
|
Field type
|
Description
|
id
|
VARCHAR(36) NOT NULL
|
station ID
|
component
|
INTEGER NOT NULL
|
component ID
|
imode
|
INTEGER DEFAULT '1'
|
installation mode, see module cmp-install
|
createtime
|
NUMERIC(17) DEFAULT '0'
|
record creation time
|
Table indexes
Index name
|
Index type
|
Fields
|
station_install_pkey
|
table primary key
clustering index
|
id, component
|
Table references
Field name
|
Direction
|
Referenced table field
|
id
|
→
|
stations.id
|
station_rights
User permissions for stations.
Table fields
Field name
|
Field type
|
Description
|
id
|
VARCHAR(36) NOT NULL
|
station ID
|
nright
|
NUMERIC(19) NOT NULL
|
permission name
|
value
|
NUMERIC(19) DEFAULT '0'
|
permission value as a string
|
Table indexes
Index name
|
Index type
|
Fields
|
station_rights_pkey
|
table primary key
clustering index
|
id, nright
|
Table references
Field name
|
Direction
|
Referenced table field
|
id
|
→
|
stations.id
|
station_schedule
Scheduler tasks for stations.
Table fields
Field name
|
Field type
|
Description
|
id
|
VARCHAR(36) NOT NULL
|
station ID
|
item
|
VARCHAR(36) NOT NULL
|
task UUID
|
format
|
INTEGER DEFAULT '0'
|
option format
|
prefix
|
VARCHAR(64) NOT NULL
|
option prefix: time or action
|
field
|
VARCHAR(64) NOT NULL
|
option name
|
seq
|
INTEGER NOT NULL
|
option sequence number
|
asnumber
|
NUMERIC(19) DEFAULT '0'
|
option value as a number
|
asstring
|
CLOB DEFAULT ''
|
option value as a string
|
Table indexes
Index name
|
Index type
|
Fields
|
station_schedule_0001
|
simple table index
|
id
|
station_schedule_pkey
|
table primary key
clustering index
|
id, item, prefix, field, seq
|
Table references
Field name
|
Direction
|
Referenced table field
|
id
|
→
|
stations.id
|
station_updlimit
The chart of limitations on updates from Dr.Web Server for stations.
Table fields
Field name
|
Field type
|
Description
|
id
|
VARCHAR(36) NOT NULL
|
station ID
|
seq
|
INTEGER NOT NULL
|
sequence number
|
bitmap
|
VARCHAR(768) DEFAULT ''
|
schedule with transfer restrictions for a week (bitmap)
|
bandwidth
|
INTEGER
|
maximal transmission speed
|
modtime
|
NUMERIC(17) DEFAULT '0'
|
record modification time
|
Table indexes
Index name
|
Index type
|
Fields
|
station_updlimit_pkey
|
table primary key
clustering index
|
id, seq
|
Table references
Field name
|
Direction
|
Referenced table field
|
id
|
→
|
stations.id
|
station_updmap
Limitations on updates from Dr.Web Server for stations.
Table fields
Field name
|
Field type
|
Description
|
id
|
VARCHAR(36) NOT NULL
|
station ID
|
policy
|
INTEGER DEFAULT '0'
|
update policy, see module update-policy
|
bandwidth
|
INTEGER
|
maximal transmission speed, NULL for unlimited
|
beactual
|
INTEGER DEFAULT '0'
|
send to stations all last updates instead of marked as current
|
older_agent_ignore
|
INTEGER
|
ignore messages on outdated virus databases from stations
|
older_server_gap
|
NUMERIC(19)
|
interval when products at stations are considered relevant
|
downgrade
|
INTEGER DEFAULT '0'
|
allow components downgrade
|
modtime
|
NUMERIC(17) DEFAULT '0'
|
record modification time
|
Table indexes
Index name
|
Index type
|
Fields
|
station_updmap_pkey
|
table primary key
|
id
|
Table references
Field name
|
Direction
|
Referenced table field
|
id
|
→
|
stations.id
|
|