|
activity_data
Attributes of audit of administrator actions.
Table fields
Field name
|
Field type
|
Description
|
record
|
VARCHAR(36) NOT NULL
|
record UUID
|
item
|
TEXT DEFAULT ''
|
parameter number
|
value
|
CLOB DEFAULT ''
|
parameter value
|
createtime
|
NUMERIC(17) NOT NULL
|
record creation time
|
Table indexes
Index name
|
Index type
|
Fields
|
activity_data_0001
|
simple table index
clustering index
|
record
|
activity_data_0002
|
simple table index
|
createtime
|
Table references
Field name
|
Direction
|
Referenced table field
|
record
|
→
|
admin_activity.record
|
admin_activity
Audit of administrator actions.
Table fields
Field name
|
Field type
|
Description
|
record
|
VARCHAR(36) NOT NULL
|
record UUID
|
login
|
VARCHAR(36) DEFAULT ''
|
administrator login name
|
address
|
TEXT DEFAULT ''
|
administrator network address
|
subsys
|
INTEGER DEFAULT '0'
|
operation initiator, see module adm-subsys
|
objid
|
VARCHAR(36) DEFAULT ''
|
administrated object (group/station) ID
|
oper
|
INTEGER DEFAULT '0'
|
operation
|
status
|
INTEGER DEFAULT '0'
|
operation status, see module adm-status
|
createtime
|
NUMERIC(17) NOT NULL
|
record creation time
|
Table indexes
Index name
|
Index type
|
Fields
|
admin_activity_0001
|
simple table index
clustering index
|
createtime
|
admin_activity_pkey
|
table primary key
|
record
|
admin_msg_log
Log of messages sent by administrator to stations.
Table fields
Field name
|
Field type
|
Description
|
sid
|
VARCHAR(36) NOT NULL
|
ID of the station to which the message was sent
|
mid
|
VARCHAR(36) NOT NULL
|
message UUID
|
admin
|
VARCHAR(36) NOT NULL
|
UUID of the administrator who sent the message
|
subsys
|
INTEGER DEFAULT '0'
|
operation initiator, see module adm-subsys
|
delivered
|
NUMERIC(17) DEFAULT '0'
|
message delivery time
|
Table indexes
Index name
|
Index type
|
Fields
|
admin_msg_log_0001
|
simple table index
|
mid
|
admin_msg_log_0002
|
simple table index
|
sid
|
admin_msg_log_0003
|
simple table index
|
admin
|
admin_msg_log_pkey
|
table primary key
|
sid, mid
|
Table references
Field name
|
Direction
|
Referenced table field
|
admin
|
→
|
admins.id
|
mid
|
↔
|
admin_msg_lst.mid
|
group_history
Log of operations with tariff groups (Dr.Web AV-Desk only).
Table fields
Field name
|
Field type
|
Description
|
id
|
VARCHAR(36) NOT NULL
|
group ID
|
oper
|
INTEGER DEFAULT '0'
|
operations, see module st-history-values
|
parent
|
VARCHAR(36) DEFAULT ''
|
parent ID
|
date1
|
NUMERIC(17) DEFAULT '0'
|
component number when changing installed components
|
date2
|
NUMERIC(17) DEFAULT '0'
|
value for group_install.imode
|
created
|
NUMERIC(17) DEFAULT '0'
|
record creation time
|
Table indexes
Index name
|
Index type
|
Fields
|
group_history_0001
|
simple table index
clustering index
|
id
|
online_statistics
Statistics on detected threats sent to the Doctor Web company.
Table fields
Field name
|
Field type
|
Description
|
station
|
VARCHAR(36) DEFAULT ''
|
originator station ID
|
sid
|
VARCHAR(36) DEFAULT ''
|
not empty if being processed now
|
recordtime
|
NUMERIC(12) NOT NULL
|
unix timestamp, rounded to an hour
|
virus
|
VARCHAR(4000) DEFAULT ''
|
empty if it is a `scanned` record
|
amount
|
NUMERIC(19) DEFAULT '1'
|
amount
|
Table indexes
Index name
|
Index type
|
Fields
|
online_statistics_0001
|
simple table index
clustering index
|
sid, recordtime
|
server_jobs_log
Log of task execution on Dr.Web Server.
Table fields
Field name
|
Field type
|
Description
|
id
|
VARCHAR(36) NOT NULL
|
record originator (Dr.Web Server ID)
|
name
|
INTEGER DEFAULT '0'
|
task name, reference to table cat_job
|
done
|
INTEGER DEFAULT '0'
|
0 if the task failed, != 0 if OK
|
completed
|
NUMERIC(17) NOT NULL
|
task completion time
|
error
|
INTEGER DEFAULT '0'
|
error message
|
Table indexes
Index name
|
Index type
|
Fields
|
server_jobs_log_0001
|
simple table index
clustering index
|
completed, id
|
Table references
Field name
|
Direction
|
Referenced table field
|
error
|
↔
|
cat_job_srv.id
|
name
|
↔
|
cat_job.id
|
station_history
Operation log for financial report on stations (Dr.Web AV-Desk only).
Table fields
Field name
|
Field type
|
Description
|
id
|
VARCHAR(36) NOT NULL
|
station ID
|
oper
|
INTEGER DEFAULT '0'
|
operations, see module st-history-values
|
rate
|
VARCHAR(36) DEFAULT ''
|
tariff ID
|
date1
|
NUMERIC(17) DEFAULT '0'
|
1st date for the period start (station creation, station expiration) or grace period duration
|
date2
|
NUMERIC(17) DEFAULT '0'
|
2nd date for the period end
|
created
|
NUMERIC(17) NOT NULL
|
record creation time
|
Table indexes
Index name
|
Index type
|
Fields
|
station_history_0001
|
simple table index
clustering index
|
created, id
|
station_history_0002
|
simple table index
|
id
|
station_history_0003
|
simple table index
|
id, oper
|
update_srv_files
Log of updates of Dr.Web Server repository files.
Table fields
Field name
|
Field type
|
Description
|
id
|
VARCHAR(36) NOT NULL
|
update UUID, see table update_srv_history
|
filename
|
INTEGER DEFAULT '0'
|
file name
|
filehash
|
TEXT DEFAULT ''
|
file hash
|
filesize
|
NUMERIC(19) DEFAULT '0'
|
file size
|
fileaction
|
INTEGER DEFAULT '0'
|
action: 0—add, 1—replace, 2—delete
|
starttime
|
NUMERIC(17) DEFAULT '0'
|
update start time, see table update_srv_history
|
Table indexes
Index name
|
Index type
|
Fields
|
update_srv_files_0001
|
simple table index
|
id
|
update_srv_files_0002
|
simple table index
clustering index
|
starttime
|
Table references
Field name
|
Direction
|
Referenced table field
|
filename
|
↔
|
cat_upd_files.id
|
id
|
→
|
update_srv_history.id
|
update_srv_history
Log of Dr.Web Server repository updates.
Table fields
Field name
|
Field type
|
Description
|
id
|
VARCHAR(36) NOT NULL
|
update UUID
|
sid
|
VARCHAR(36) NOT NULL
|
server ID
|
login
|
INTEGER DEFAULT '0'
|
administrator login name
|
address
|
TEXT DEFAULT ''
|
administrator network address
|
src
|
INTEGER DEFAULT '0'
|
initiator, see module update-source
|
product
|
INTEGER DEFAULT '0'
|
product ID
|
descr
|
INTEGER DEFAULT '0'
|
product description
|
starttime
|
NUMERIC(17) DEFAULT '0'
|
start date
|
endtime
|
NUMERIC(17) DEFAULT '0'
|
end date
|
rc
|
INTEGER DEFAULT '0'
|
completion code
|
crevision
|
NUMERIC(17) DEFAULT '0'
|
current revision (DB time)
|
nrevision
|
NUMERIC(17) DEFAULT '0'
|
new revision (DB time)
|
Table indexes
Index name
|
Index type
|
Fields
|
update_srv_history_0001
|
simple table index
clustering index
|
starttime
|
update_srv_history_pkey
|
table primary key
|
id
|
Table references
Field name
|
Direction
|
Referenced table field
|
descr
|
↔
|
cat_upd_descr.id
|
login
|
↔
|
cat_upd_admin.id
|
product
|
↔
|
cat_upd_product.id
|
user_activity
Audit of actions of Subscriptions Control Center users (Dr.Web AV-Desk only).
Table fields
Field name
|
Field type
|
Description
|
record
|
VARCHAR(36) NOT NULL
|
record UUID
|
login
|
VARCHAR(36) DEFAULT ''
|
user login name
|
address
|
TEXT DEFAULT ''
|
user network address
|
subsys
|
INTEGER DEFAULT '0'
|
operation initiator, see module adm-subsys
|
objid
|
VARCHAR(36) DEFAULT ''
|
user object (group/station) ID
|
oper
|
INTEGER DEFAULT '0'
|
operation
|
status
|
INTEGER DEFAULT '0'
|
operation status, see module adm-status
|
createtime
|
NUMERIC(17) NOT NULL
|
record creation time
|
Table indexes
Index name
|
Index type
|
Fields
|
user_activity_0001
|
simple table index
clustering index
|
createtime
|
user_activity_pkey
|
table primary key
|
record
|
user_activity_data
Attributes of actions audit of Subscriptions Control Center users (Dr.Web AV-Desk only).
Table fields
Field name
|
Field type
|
Description
|
record
|
VARCHAR(36) NOT NULL
|
record UUID
|
item
|
TEXT DEFAULT ''
|
parameter number
|
value
|
CLOB DEFAULT ''
|
parameter value
|
createtime
|
NUMERIC(17) NOT NULL
|
record creation time
|
Table indexes
Index name
|
Index type
|
Fields
|
user_activity_data_0001
|
simple table index
clustering index
|
record
|
user_activity_data_0002
|
simple table index
|
createtime
|
Table references
Field name
|
Direction
|
Referenced table field
|
record
|
→
|
user_activity.record
|
|