License Management

available_keys

The list of license keys added to the Server.

Table fields

Field name

Field type

Description

id

VARCHAR(36) NOT NULL

license key ID

value

CLOB DEFAULT ''

file content

type

INTEGER DEFAULT '0'

type, see db-key-type

created

NUMERIC(17) DEFAULT '0'

record creation time

Table indexes

Index name

Index type

Fields list

available_keys_pkey

table primary key

id

group_key

Information on license keys of station groups.

Table fields

Field name

Field type

Description

id

VARCHAR(36) NOT NULL

group ID

kid

VARCHAR(36) NOT NULL

license key ID

modtime

NUMERIC(17) DEFAULT '0'

record modification time

Table indexes

Index name

Index type

Fields list

group_key_0001

simple table index

clustering index

id

group_key_pkey

table primary key

id, kid

Table references

Field name

Direction

Referenced table field

id

groups_list.id

key_components

The list of anti-virus components allowed by a license key.

Table fields

Field name

Field type

Description

id

VARCHAR(36) NOT NULL

license key ID

component

INTEGER NOT NULL

component number

created

NUMERIC(17) DEFAULT '0'

record creation time

Table indexes

Index name

Index type

Fields list

key_components_pkey

table primary key

clustering index

id, component

key_exchange

Data on licenses propagated on interserver connections.

Table fields

Field name

Field type

Description

lid

VARCHAR(36) NOT NULL

interserver connection UUID

kid

VARCHAR(36) NOT NULL

license key ID

count

NUMERIC(10) DEFAULT '0'

number of licenses

expiration

NUMERIC(19) DEFAULT '0'

session expiration time

valid_thru

NUMERIC(19) DEFAULT '0'

absolute expiration time

state

INTEGER

exchange state, see db-key-exchange

modtime

NUMERIC(17) DEFAULT '0'

record modification time

rp_period

INTEGER DEFAULT '0'

period to send license usage report

st_period

INTEGER DEFAULT '0'

period to mark stations as active

rp_delivered

INTEGER DEFAULT '0'

flag that license usage report was delivered

Table indexes

Index name

Index type

Fields list

key_exchange_pkey

table primary key

clustering index

lid, kid

key_renew_exchange

Data on updates of licenses propagated on interserver connections.

Table fields

Field name

Field type

Description

okid

VARCHAR(36) NOT NULL

old license key ID

nkid

VARCHAR(36) DEFAULT ''

new license key ID

lid

VARCHAR(36) NOT NULL

interserver connection UUID

created

NUMERIC(17) DEFAULT '0'

record creation time

Table indexes

Index name

Index type

Fields list

key_renew_exchange_pkey

table primary key

clustering index

lid, okid

key_usage_reports

Report on licenses propagated on interserver connections. General information.

Table fields

Field name

Field type

Description

rid

VARCHAR(36) NOT NULL

report UUID

kid

VARCHAR(36) NOT NULL

license key ID

lid

VARCHAR(36) DEFAULT ''

interserver connection UUID of a message sender or empty if it is an own report

osid

VARCHAR(36) NOT NULL

originator Server ID

oname

TEXT DEFAULT ''

Server name

created

NUMERIC(17) DEFAULT '0'

time of report creation on the originator Server

Table indexes

Index name

Index type

Fields list

key_usage_reports_0001

simple table index

kid

key_usage_reports_pkey

table primary key

rid

key_usage_reports_grp

Report on licenses propagated on interserver connections. Licenses propagated by the report creator to its station groups.

Table fields

Field name

Field type

Description

rid

VARCHAR(36) NOT NULL

report UUID

obj_name

TEXT DEFAULT ''

group or neighbor Server name

count_all

NUMERIC(10) DEFAULT '0'

number of total licenses propagated to groups

count_act

NUMERIC(10)

number of active stations in groups

Table indexes

Index name

Index type

Fields list

key_usage_reports_grp_0001

simple table index

rid

Table references

Field name

Direction

Referenced table field

rid

key_usage_reports.rid

key_usage_reports_srv

Report on licenses propagated on interserver connections. Licenses granted by the report creator to its child Servers.

Table fields

Field name

Field type

Description

rid

VARCHAR(36) NOT NULL

report UUID

obj_name

TEXT DEFAULT ''

group or neighbor Server name

count

NUMERIC(10) DEFAULT '0'

number of propagated licenses

state

INTEGER

see db-key-exchange-state.h

Table indexes

Index name

Index type

Fields list

key_usage_reports_srv_0001

simple table index

rid

Table references

Field name

Direction

Referenced table field

rid

key_usage_reports.rid

policy_key

License keys of policy current version.

Table fields

Field name

Field type

Description

id

VARCHAR(36) NOT NULL

policy ID

kid

VARCHAR(36) NOT NULL

license key ID

Table indexes

Index name

Index type

Fields list

policy_key_0001

simple table index

clustering index

id

policy_key_pkey

table primary key

id, kid

Table references

Field name

Direction

Referenced table field

id

policy_list.id

policy_key_lst

License keys 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

kid

VARCHAR(36) NOT NULL

license key ID

Table indexes

Index name

Index type

Fields list

policy_key_lst_pkey

table primary key

clustering index

id, version, kid

Table references

Field name

Direction

Referenced table field

id

policy_list.id

station_key

Information on license keys of stations.

Table fields

Field name

Field type

Description

id

VARCHAR(36) NOT NULL

station ID

kid

VARCHAR(36) NOT NULL

license key ID

modtime

NUMERIC(17) DEFAULT '0'

record modification time

Table indexes

Index name

Index type

Fields list

station_key_0001

simple table index

clustering index

id

station_key_pkey

table primary key

id, kid

Table references

Field name

Direction

Referenced table field

id

stations.id