Policies Configuration

policy_cfg

Anti-virus components configuration in the settings of policy current version.

Table fields

Field name

Field type

Description

id

VARCHAR(36) NOT NULL

policy 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

Table indexes

Index name

Index type

Fields list

policy_cfg_pkey

table primary key

clustering index

id, component, name, seq

Table references

Field name

Direction

Referenced table field

id

policy_list.id

policy_cfg_lst

Anti-virus components configuration in the settings of policy previous versions.

Table fields

Field name

Field type

Description

id

VARCHAR(36) NOT NULL

policy ID

version

NUMERIC(17) NOT NULL

policy version

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

Table indexes

Index name

Index type

Fields list

policy_cfg_lst_pkey

table primary key

clustering index

id, version, component, name, seq

Table references

Field name

Direction

Referenced table field

id

policy_list.id

policy_install

Installing components lists in the settings of policy current version.

Table fields

Field name

Field type

Description

id

VARCHAR(36) NOT NULL

policy ID

component

INTEGER NOT NULL

component ID

imode

INTEGER DEFAULT '1'

installation mode

Table indexes

Index name

Index type

Fields list

policy_install_pkey

table primary key

clustering index

id, component

Table references

Field name

Direction

Referenced table field

id

policy_list.id

policy_install_lst

Installing components lists in the settings of policy previous versions.

Table fields

Field name

Field type

Description

id

VARCHAR(36) NOT NULL

policy ID

version

NUMERIC(17) NOT NULL

policy version

component

INTEGER NOT NULL

component ID

imode

INTEGER DEFAULT '1'

installation mode

Table indexes

Index name

Index type

Fields list

policy_install_lst_pkey

table primary key

clustering index

id, version, component

Table references

Field name

Direction

Referenced table field

id

policy_list.id

policy_rights

Permissions of station users in the settings of policy current version.

Table fields

Field name

Field type

Description

id

VARCHAR(36) NOT NULL

policy 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 list

policy_rights_pkey

table primary key

clustering index

id, nright

Table references

Field name

Direction

Referenced table field

id

policy_list.id

policy_rights_lst

Permissions of station users in the settings of policy previous versions.

Table fields

Field name

Field type

Description

id

VARCHAR(36) NOT NULL

policy ID

version

NUMERIC(17) NOT NULL

policy version

nright

NUMERIC(19) NOT NULL

permission name

value

NUMERIC(19) DEFAULT '0'

permission value as a string

Table indexes

Index name

Index type

Fields list

policy_rights_lst_pkey

table primary key

clustering index

id, version, nright

Table references

Field name

Direction

Referenced table field

id

policy_list.id

policy_schedule

Tasks of station Scheduler in the settings of policy current version.

Table fields

Field name

Field type

Description

id

VARCHAR(36) NOT NULL

policy ID

item

VARCHAR(36) NOT NULL

task UUID

format

INTEGER DEFAULT '0'

option format

prefix

VARCHAR(64) NOT NULL

option prefix: is it 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 list

policy_schedule_0001

simple table index

id

policy_schedule_pkey

table primary key

clustering index

id, item, prefix, field, seq

Table references

Field name

Direction

Referenced table field

id

policy_list.id

policy_schedule_lst

Tasks of station Scheduler in the settings of policy previous versions.

Table fields

Field name

Field type

Description

id

VARCHAR(36) NOT NULL

policy ID

version

NUMERIC(17) NOT NULL

policy version

item

VARCHAR(36) NOT NULL

task UUID

format

INTEGER DEFAULT '0'

option format

prefix

VARCHAR(64) NOT NULL

option prefix: is it 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 list

policy_schedule_lst_pkey

table primary key

clustering index

id, version, item, prefix, field, seq

Table references

Field name

Direction

Referenced table field

id

policy_list.id

policy_updlimit

The chart of limitations on updates of stations from the Server in the settings of policy current version.

Table fields

Field name

Field type

Description

id

VARCHAR(36) NOT NULL

policy ID

seq

INTEGER NOT NULL

sequence number

bitmap

VARCHAR(768) DEFAULT ''

schedule with transfer restrictions for a week (bitmap)

bandwidth

INTEGER

maximal transmission speed

Table indexes

Index name

Index type

Fields list

policy_updlimit_pkey

table primary key

clustering index

id, seq

Table references

Field name

Direction

Referenced table field

id

policy_list.id

policy_updlimit_lst

The chart of limitations on updates of stations from the Server in the settings of policy previous versions.

Table fields

Field name

Field type

Description

id

VARCHAR(36) NOT NULL

policy ID

version

NUMERIC(17) NOT NULL

policy version

seq

INTEGER NOT NULL

sequence number

bitmap

VARCHAR(768) DEFAULT ''

schedule with transfer restrictions for a week (bitmap)

bandwidth

INTEGER

maximal transmission speed

Table indexes

Index name

Index type

Fields list

policy_updlimit_lst_pkey

table primary key

clustering index

id, version, seq

Table references

Field name

Direction

Referenced table field

id

policy_list.id

policy_updmap

Limitations on updates of stations from the Server in the settings of policy current version.

Table fields

Field name

Field type

Description

id

VARCHAR(36) NOT NULL

policy ID

policy

INTEGER DEFAULT '0'

update policy, see update-policy .ds/.h

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 the messages on aging of virus databases from stations

older_server_gap

NUMERIC(19)

interval when products at stations are considered relevant

downgrade

INTEGER DEFAULT '0'

allow components downgrade

Table indexes

Index name

Index type

Fields list

policy_updmap_pkey

table primary key

id

Table references

Field name

Direction

Referenced table field

id

policy_list.id

policy_updmap_lst

Limitations on updates of stations from the Server in the settings of policy previous versions.

Table fields

Field name

Field type

Description

id

VARCHAR(36) NOT NULL

policy ID

version

NUMERIC(17) NOT NULL

policy version

policy

INTEGER DEFAULT '0'

update policy, see update-policy .ds/.h

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 the messages on aging of virus databases from stations

older_server_gap

NUMERIC(19)

interval when products at stations are considered relevant

downgrade

INTEGER DEFAULT '0'

allow components downgrade

Table indexes

Index name

Index type

Fields list

policy_updmap_lst_pkey

table primary key

clustering index

id, version

Table references

Field name

Direction

Referenced table field

id

policy_list.id