|
admin_attributes
Arbitrary attributes of Dr.Web Server administrator accounts.
Table fields
Field name
|
Field type
|
Description
|
id
|
VARCHAR(36) NOT NULL
|
admin UUID
|
attribute
|
INTEGER NOT NULL
|
attribute number
|
sequenceno
|
INTEGER NOT NULL
|
attribute sequence number
|
svalue
|
TEXT DEFAULT ''
|
attribute string value
|
nvalue
|
NUMERIC(19) DEFAULT '0'
|
attribute numeric value
|
Table indexes
Index name
|
Index type
|
Fields
|
admin_attributes_pkey
|
table primary key
clustering index
|
id, attribute, sequenceno
|
Table references
Field name
|
Direction
|
Referenced table field
|
id
|
→
|
admins.id
|
admin_flat_objects
Cache of objects available to administrators according to their permissions.
Table fields
Field name
|
Field type
|
Description
|
id_admin
|
VARCHAR(36) NOT NULL
|
admin UUID
|
nright
|
INTEGER NOT NULL
|
numeric code for administrative permission
|
id_object
|
VARCHAR(36) NOT NULL
|
administrated object ID
|
Table indexes
Index name
|
Index type
|
Fields
|
admin_flat_objects_pkey
|
table primary key
clustering index
|
id_admin, nright, id_object
|
Table references
Field name
|
Direction
|
Referenced table field
|
id_admin
|
→
|
admins.id
|
admin_group_objects
Objects of permissions for administrator groups.
Table fields
Field name
|
Field type
|
Description
|
id_group
|
VARCHAR(36) NOT NULL
|
group UUID
|
nright
|
INTEGER NOT NULL
|
numeric code for administrative permission
|
id_object
|
VARCHAR(36) NOT NULL
|
administrated object ID
|
Table indexes
Index name
|
Index type
|
Fields
|
admin_group_objects_pkey
|
table primary key
clustering index
|
id_group, nright, id_object
|
admin_group_parent
Parent groups of administrator groups.
Table fields
Field name
|
Field type
|
Description
|
id_group
|
VARCHAR(36) NOT NULL
|
group UUID
|
id_parent
|
VARCHAR(36) NOT NULL
|
parent group UUID
|
modtime
|
NUMERIC(17) DEFAULT '0'
|
last modification timestamp
|
inherit
|
INTEGER DEFAULT '1'
|
specifies whether group inherits parent attributes (1 for true)
|
Table indexes
Index name
|
Index type
|
Fields
|
admin_group_parent_0001
|
simple table index
|
id_parent
|
admin_group_parent_pkey
|
table primary key
|
id_group
|
admin_group_rights
Permissions for administrator groups.
Table fields
Field name
|
Field type
|
Description
|
id_group
|
VARCHAR(36) NOT NULL
|
group UUID
|
nright
|
INTEGER NOT NULL
|
numeric code for administrative permission
|
value
|
INTEGER DEFAULT '0'
|
value for administrative permission
|
modtime
|
NUMERIC(17) DEFAULT '0'
|
last modification timestamp
|
Table indexes
Index name
|
Index type
|
Fields
|
admin_group_rights_pkey
|
table primary key
|
id_group, nright
|
admin_groups
Groups of Dr.Web Server administrators.
Table fields
Field name
|
Field type
|
Description
|
id_group
|
VARCHAR(36) NOT NULL
|
group UUID
|
name
|
TEXT DEFAULT ''
|
human-readable name
|
descr
|
TEXT DEFAULT ''
|
human-readable description
|
modtime
|
NUMERIC(17) DEFAULT '0'
|
last modification timestamp
|
Table indexes
Index name
|
Index type
|
Fields
|
admin_groups_pkey
|
table primary key
|
id_group
|
admin_msg_lst
Content of messages sent by administrator to stations.
Table fields
Field name
|
Field type
|
Description
|
mid
|
VARCHAR(36) NOT NULL
|
message UUID
|
msg_body
|
TEXT DEFAULT ''
|
message body
|
msg_options
|
INTEGER DEFAULT '0'
|
message options, see module db-admin-msg-options
|
logo_url
|
TEXT DEFAULT ''
|
URL to open when clicking a user logo
|
logo_text
|
TEXT DEFAULT ''
|
text to display next to a user logo
|
logo_file
|
CLOB DEFAULT ''
|
path to a user logo file
|
link_url
|
TEXT DEFAULT ''
|
URL of a user link
|
link_text
|
TEXT DEFAULT ''
|
text to display as a name of a user link
|
created
|
NUMERIC(17) NOT NULL
|
message creation time
|
Table indexes
Index name
|
Index type
|
Fields
|
admin_msg_lst_pkey
|
table primary key
|
mid
|
admin_msg_templates
Templates of messages sent by administrator to stations.
Table fields
Field name
|
Field type
|
Description
|
template_id
|
VARCHAR(36) NOT NULL
|
template UUID
|
msg_body
|
TEXT DEFAULT ''
|
message body
|
msg_options
|
INTEGER DEFAULT '0'
|
message options, see module db-admin-msg-options
|
logo_url
|
TEXT DEFAULT ''
|
URL to open when clicking a user logo
|
logo_text
|
TEXT DEFAULT ''
|
text to display next to a user logo
|
logo_file
|
CLOB DEFAULT ''
|
path to a user logo file
|
link_url
|
TEXT DEFAULT ''
|
URL of a user link
|
link_text
|
TEXT DEFAULT ''
|
text to display as a name of a user link
|
admin
|
VARCHAR(36) NOT NULL
|
UUID of the administrator who created the message template
|
name
|
VARCHAR(100) DEFAULT ''
|
template name
|
Table indexes
Index name
|
Index type
|
Fields
|
admin_msg_templates_0001
|
simple table index
clustering index
|
admin
|
admin_msg_templates_pkey
|
table primary key
|
template_id
|
Table references
Field name
|
Direction
|
Referenced table field
|
admin
|
→
|
admins.id
|
admin_objects
Objects of permissions for administrators.
Table fields
Field name
|
Field type
|
Description
|
id_admin
|
VARCHAR(36) NOT NULL
|
administrator UUID
|
nright
|
INTEGER NOT NULL
|
numeric code for administrative permission
|
id_object
|
VARCHAR(36) NOT NULL
|
administrated objects ID
|
Table indexes
Index name
|
Index type
|
Fields
|
admin_objects_pkey
|
table primary key
clustering index
|
id_admin, nright, id_object
|
Table references
Field name
|
Direction
|
Referenced table field
|
id_admin
|
→
|
admins.id
|
admin_rights
Permissions for administrators.
Table fields
Field name
|
Field type
|
Description
|
id_admin
|
VARCHAR(36) NOT NULL
|
administrator UUID
|
nright
|
INTEGER NOT NULL
|
numeric code for administrative permission
|
value
|
INTEGER DEFAULT '0'
|
value for administrative permission
|
modtime
|
NUMERIC(17) DEFAULT '0'
|
last modification timestamp
|
Table indexes
Index name
|
Index type
|
Fields
|
admin_rights_pkey
|
table primary key
|
id_admin, nright
|
Table references
Field name
|
Direction
|
Referenced table field
|
id_admin
|
→
|
admins.id
|
admin_to_admin_group
Parent groups of administrators.
Table fields
Field name
|
Field type
|
Description
|
id_group
|
VARCHAR(36) NOT NULL
|
group UUID
|
id_admin
|
VARCHAR(36) NOT NULL
|
administrator UUID
|
modtime
|
NUMERIC(17) DEFAULT '0'
|
last modification timestamp
|
inherit
|
INTEGER DEFAULT '1'
|
specifies whether administrator inherits parent group attributes (1 for true)
|
Table indexes
Index name
|
Index type
|
Fields
|
admin_to_admin_group_pkey
|
table primary key
|
id_admin
|
Table references
Field name
|
Direction
|
Referenced table field
|
id_admin
|
→
|
admins.id
|
admins
Data of Dr.Web Server administrator accounts.
Table fields
Field name
|
Field type
|
Description
|
id
|
VARCHAR(36) NOT NULL
|
administrator UUID
|
login
|
VARCHAR(100) NOT NULL
|
login name
|
password
|
TEXT DEFAULT ''
|
password, plain or encrypted
|
fname
|
TEXT DEFAULT ''
|
first name
|
mname
|
TEXT DEFAULT ''
|
middle name
|
lname
|
TEXT DEFAULT ''
|
last name
|
descr
|
TEXT DEFAULT ''
|
description/notes/etc.
|
addr
|
TEXT DEFAULT ''
|
current network address
|
lastseenfrom
|
TEXT DEFAULT ''
|
network address of the last connection
|
lastseenat
|
NUMERIC(17) DEFAULT '0'
|
time of the last connection
|
createtime
|
NUMERIC(17) DEFAULT '0'
|
record creation time
|
modtime
|
NUMERIC(17) DEFAULT '0'
|
record modification time
|
externalauth
|
INTEGER DEFAULT '0'
|
autocreated using external authentication
|
langcode
|
VARCHAR(8) DEFAULT ''
|
interface language
|
datecode
|
VARCHAR(8) DEFAULT ''
|
date format
|
email
|
VARCHAR(256)
|
email address
|
timezone
|
VARCHAR(8)
|
local time zone
|
Table indexes
Index name
|
Index type
|
Fields
|
admins_0001
|
unique table index
|
id
|
admins_pkey
|
table primary key
|
login
|
|