Stations Configuration

proxy_cfg

Configuration of Proxy servers connected to the 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 list

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

Anti-virus components configuration 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 list

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 list

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 cmp-install.ds

createtime

NUMERIC(17) DEFAULT '0'

record creation time

Table indexes

Index name

Index type

Fields list

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 list

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: 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

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

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 the Server for stations.

Table fields

Field name

Field type

Description

id

VARCHAR(36) NOT NULL

station 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

modtime

NUMERIC(17) DEFAULT '0'

record modification time

Table indexes

Index name

Index type

Fields list

station_updmap_pkey

table primary key

id

Table references

Field name

Direction

Referenced table field

id

stations.id