# Server cluster and configuration

<a id="database.server"></a>

## server

> **Warning:** This page was automatically generated from the database schema dump and may be incomplete or incorrect.

Registered server instances.

### Columns

| Name | Type | Length | Description |
|---|---|---|---|
| `id` | `int` | — |  |
| `name` | `nvarchar` | 50 |  |
| `comstring` | `nvarchar` | 50 |  |
| `port` | `int` | — |  |
| `instance` | `nvarchar` | 50 |  |
| `flag` | `int` | — |  |
| `group_id` | `int` | — |  |
| `account_id` | `int` | — |  |
| `osstorage` | `image` | 2147483647 |  |
| `abochecked` | `int` | — |  |

<a id="database.servergroup"></a>

## servergroup

> **Warning:** This page was automatically generated from the database schema dump and may be incomplete or incorrect.

Server-group master data.

### Columns

| Name | Type | Length | Description |
|---|---|---|---|
| `id` | `int` | — |  |
| `name` | `nvarchar` | 32 |  |
| `description` | `nvarchar` | 255 |  |

<a id="database.osserverfamily"></a>

## osserverfamily

> **Warning:** This page was automatically generated from the database schema dump and may be incomplete or incorrect.

Server-family configuration (cluster members).

### Columns

| Name | Type | Length | Description |
|---|---|---|---|
| `osguid` | `nvarchar` | 36 |  |
| `name` | `nvarchar` | 255 |  |

<a id="database.ossrvgrpprop"></a>

## ossrvgrpprop

> **Warning:** This page was automatically generated from the database schema dump and may be incomplete or incorrect.

Server-group properties (configuration per server group).

### Columns

| Name | Type | Length | Description |
|---|---|---|---|
| `groupid` | `int` | — |  |
| `propname` | `nvarchar` | 255 |  |
| `propvalue` | `nvarchar` | 255 |  |

<a id="database.osnamespace"></a>

## osnamespace

> **Warning:** This page was automatically generated from the database schema dump and may be incomplete or incorrect.

Namespace configuration of the Server-API.

### Columns

| Name | Type | Length | Description |
|---|---|---|---|
| `id` | `int` | — |  |
| `name` | `nvarchar` | 248 |  |

<a id="database.ospingtable"></a>

## ospingtable

> **Warning:** This page was automatically generated from the database schema dump and may be incomplete or incorrect.

Heartbeat/ping table of server cluster communication.

### Columns

| Name | Type | Length | Description |
|---|---|---|---|
| `serverid` | `int` | — |  |
| `lastping` | `nvarchar` | 32 |  |
| `lastpingtime` | `int` | — |  |
| `serverstatus` | `int` | — |  |

<a id="database.osredirjobs"></a>

## osredirjobs

> **Warning:** This page was automatically generated from the database schema dump and may be incomplete or incorrect.

Job-redirect configuration for multi-server setups.

### Columns

| Name | Type | Length | Description |
|---|---|---|---|
| `redirjobid` | `nvarchar` | 32 |  |
| `namespace` | `nvarchar` | 50 |  |
| `jobname` | `nvarchar` | 255 |  |
| `exclude` | `int` | — |  |
| `srcserverid` | `int` | — |  |
| `disablecount` | `int` | — |  |

<a id="database.osredirtargets"></a>

## osredirtargets

> **Warning:** This page was automatically generated from the database schema dump and may be incomplete or incorrect.

Redirect target servers.

### Columns

| Name | Type | Length | Description |
|---|---|---|---|
| `redirjobid` | `nvarchar` | 32 |  |
| `targetserverid` | `int` | — |  |
| `weight` | `int` | — |  |
| `calltimeout` | `int` | — |  |

<a id="database.osconf"></a>

## osconf

> **Warning:** This page was automatically generated from the database schema dump and may be incomplete or incorrect.

Global server configuration parameters (key/value).

### Columns

| Name | Type | Length | Description |
|---|---|---|---|
| `osconfuser` | `int` | — |  |
| `osconfstate` | `int` | — |  |
| `osconftype` | `int` | — |  |
| `osconfval` | `image` | 2147483647 |  |
| `osconfid` | `int` | — |  |
| `osconflink` | `int` | — |  |
| `osconfname` | `nvarchar` | 100 |  |

<a id="database.osproperties"></a>

## osproperties

> **Warning:** This page was automatically generated from the database schema dump and may be incomplete or incorrect.

Generic property storage (key/value pairs).

### Columns

| Name | Type | Length | Description |
|---|---|---|---|
| `id` | `int` | — |  |
| `object_id` | `int` | — |  |
| `value` | `nvarchar` | 248 |  |

<a id="database.path"></a>

## path

> **Warning:** This page was automatically generated from the database schema dump and may be incomplete or incorrect.

Directory/path configuration for server-side file storage locations.

### Columns

| Name | Type | Length | Description |
|---|---|---|---|
| `server_id` | `int` | — |  |
| `name` | `nvarchar` | 200 |  |
| `flag` | `int` | — |  |
| `osguid` | `nvarchar` | 32 |  |
| `template` | `nvarchar` | 255 |  |
| `status` | `int` | — |  |
| `pathorder` | `int` | — |  |
| `make_read_only` | `int` | — |  |
| `retention_time` | `int` | — |  |
| `alias` | `nvarchar` | 255 |  |
| `make_lastacdate` | `smallint` | — |  |

<a id="database.osresources"></a>

## osresources

> **Warning:** This page was automatically generated from the database schema dump and may be incomplete or incorrect.

Server-resources table (system files such as `as.cfg`, see [adm.GetSystemFile](../adm.md#adm.GetSystemFile)).

### Columns

| Name | Type | Length | Description |
|---|---|---|---|
| `resourceid` | `nvarchar` | 32 |  |
| `resourcename` | `nvarchar` | 255 |  |
| `resourcetype` | `int` | — |  |
| `description` | `nvarchar` | 255 |  |
| `maxpreserve` | `int` | — |  |
| `servergroupid` | `int` | — |  |

<a id="database.osmimetypes"></a>

## osmimetypes

> **Warning:** This page was automatically generated from the database schema dump and may be incomplete or incorrect.

MIME-type master data (mapping ID ↔ content type), see [dms.GetOsMimetypes](../dms.md#dms.GetOsMimetypes).

### Columns

| Name | Type | Length | Description |
|---|---|---|---|
| `mimetypeid` | `int` | — |  |
| `mimetype` | `nvarchar` | 100 |  |
| `extension` | `nvarchar` | 255 |  |
| `mimetypegroup` | `nvarchar` | 100 |  |
| `osiconid` | `int` | — |  |

<a id="database.osmaintenance"></a>

## osmaintenance

> **Warning:** This page was automatically generated from the database schema dump and may be incomplete or incorrect.

Maintenance-job configuration and status.

### Columns

| Name | Type | Length | Description |
|---|---|---|---|
| `osmaintguid` | `nvarchar` | 32 |  |
| `description` | `nvarchar` | 255 |  |
| `osverguid` | `nvarchar` | 32 |  |

<a id="database.osspooler"></a>

## osspooler

> **Warning:** This page was automatically generated from the database schema dump and may be incomplete or incorrect.

Spooler table (print jobs / async processing).

### Columns

| Name | Type | Length | Description |
|---|---|---|---|
| `id` | `nvarchar` | 32 |  |
| `taskid` | `int` | — |  |
| `owner` | `nvarchar` | 255 |  |
| `serverid` | `int` | — |  |
| `creationtime` | `int` | — |  |
| `scheduledtime` | `int` | — |  |
| `starttime` | `int` | — |  |
| `endtime` | `int` | — |  |
| `state` | `int` | — |  |
| `autodelete` | `int` | — |  |
| `anyserver` | `int` | — |  |
| `orgid` | `nvarchar` | 32 |  |
| `task` | `image` | 2147483647 |  |

<a id="database.ospreparedjobs"></a>

## ospreparedjobs

> **Warning:** This page was automatically generated from the database schema dump and may be incomplete or incorrect.

Prepared (scheduled) server jobs.

### Columns

| Name | Type | Length | Description |
|---|---|---|---|
| `jobguid` | `nvarchar` | 32 |  |
| `JobParams` | `image` | 2147483647 |  |
| `description` | `nvarchar` | 128 |  |
| `isfiles` | `int` | — |  |
| `serverid` | `int` | — |  |
| `groupid` | `int` | — |  |
| `timewrite` | `int` | — |  |
| `timestart` | `int` | — |  |
| `callsrvid` | `int` | — |  |
| `sessionguid` | `nvarchar` | 32 |  |
| `jobcontext` | `nvarchar` | 255 |  |
| `notifytype` | `int` | — |  |
| `locksrvid` | `int` | — |  |
| `username` | `nvarchar` | 255 |  |
| `statname` | `nvarchar` | 255 |  |
| `instname` | `nvarchar` | 255 |  |
| `userguid` | `nvarchar` | 32 |  |
| `statguid` | `nvarchar` | 32 |  |
| `sysrole_001_032` | `int` | — |  |
| `sysrole_033_064` | `int` | — |  |
| `sysrole_065_096` | `int` | — |  |
| `sysrole_097_128` | `int` | — |  |
| `userid` | `int` | — |  |
| `supervisor` | `int` | — |  |
| `langid` | `int` | — |  |
| `namespace` | `nvarchar` | 8 |  |
| `jobname` | `nvarchar` | 64 |  |
| `personality` | `int` | — |  |

<a id="database.oscpmqueue"></a>

## oscpmqueue

Queue table for content and processing messages (CP). Holds the pending jobs for external
service instances (full-text indexer, rendition cache, page-count service, ...).

Usage and lifecycle of the messages are described under
[Capture and Processing Messages (CP)](../std.md); reads and writes happen
exclusively through the `std.**CPMessage**` jobs of the
[Standard Engine](../std.md).

### Columns

| Name | Type | Length | Description |
|---|---|---|---|
| `messageguid` | `nvarchar` | 32 | Unique message ID (hex GUID, no separators). Primary key of the table and reference value<br>for [std.DispatchCPMessage](../std.md#std.DispatchCPMessage). |
| `queuename` | `nvarchar` | 128 | Logical queue name (e.g. `FULLTEXTIDX`, `FULLTEXTDOC`, `RENDITION`). Determines which<br>service instance picks up the message. |
| `osid` | `int` | — | ID of the DMS object the job refers to. |
| `ostype` | `int` | — | Numeric object type ID. |
| `created` | `datetime` | — | Creation timestamp of the message. Used to determine pickup order — the message with the<br>most recent `created` value is delivered first. |
| `lock_service` | `nvarchar` | 128 | `ServiceName` of the service instance currently holding the reservation. `NULL` =<br>unreserved (free for pickup). Set on pickup and cleared again by<br>[std.DispatchCPMessage](../std.md#std.DispatchCPMessage) (removes the message) or by<br>[std.ResetServiceCPMessages](../std.md#std.ResetServiceCPMessages) (releases the<br>reservation). |
| `checkguid` | `nvarchar` | 32 | Verification GUID, randomly generated on pickup and stored together with `lock_service`.<br>Allows the server to detect competing reservation attempts from two service instances<br>(optimistic locking). |

<a id="database.oscounters"></a>

## oscounters

> **Warning:** This page was automatically generated from the database schema dump and may be incomplete or incorrect.

Counter master data (backing `krn.GetCounter` / `krn.GetNextIndex`).

### Columns

| Name | Type | Length | Description |
|---|---|---|---|
| `counterguid` | `nvarchar` | 32 |  |
| `countertype` | `int` | — |  |
| `countertime` | `int` | — |  |
| `countervalue` | `int` | — |  |

<a id="database.osnextindex"></a>

## osnextindex

> **Warning:** This page was automatically generated from the database schema dump and may be incomplete or incorrect.

Index counters for unique IDs (backing table for `krn.GetNextIndex`).

### Columns

| Name | Type | Length | Description |
|---|---|---|---|
| `id` | `int` | — |  |
| `serverid` | `int` | — |  |
| `time` | `int` | — |  |

<a id="database.osapplication"></a>

## osapplication

> **Warning:** This page was automatically generated from the database schema dump and may be incomplete or incorrect.

Registered third-party applications.

### Columns

| Name | Type | Length | Description |
|---|---|---|---|
| `id` | `int` | — |  |
| `flags` | `int` | — |  |
| `name` | `nvarchar` | 248 |  |
| `path` | `nvarchar` | 260 |  |

<a id="database.sets"></a>

## sets

> **Warning:** This page was automatically generated from the database schema dump and may be incomplete or incorrect.

Set/group definitions (e.g. for media sets, permission sets).

### Columns

| Name | Type | Length | Description |
|---|---|---|---|
| `id` | `int` | — |  |
| `name` | `nvarchar` | 200 |  |
| `systemid` | `int` | — |  |
| `alias` | `nvarchar` | 248 |  |
| `server_id` | `int` | — |  |
| `status` | `int` | — |  |
| `main_path` | `nvarchar` | 32 |  |
| `mirr_path` | `nvarchar` | 32 |  |
| `main_template` | `nvarchar` | 64 |  |
| `mirr_template` | `nvarchar` | 64 |  |
| `medien_size` | `int` | — |  |
| `cluster_size` | `int` | — |  |