Scout Database Model (CR)

Table: UpdateNotification

March 25, 2025

Contributed by:

Handles the image update notification feature

ColumnName	DataType	Key	Not Null	Default	Comment
UpdateNotificationID	INTEGER IDENTITY (1,1)	PK	NN		Unique ID of notification
[Type]	INTEGER		NN	0	Defines if a notification is an update or delivery notification
Options	INTEGER		NN		Bit field for update notification options - SCD_OPTION_FORMAT_BEFORE_UPDATE 0x40; SCD_OPTION_USERINFO; 0x04 SCD_OPTION_CANREFUSE; 0x08
ConfirmTimeout	INTEGER		NN	0
Modified	DATETIME		NN	GETUTCDATE()	Internal use
ReservedString1	NVARCHAR(255)
ReservedInt1	NVARCHAR(255)
ReservedInt2	NVARCHAR(255)

IndexName	IndexType	Columns
PRIMARY	PRIMARY	UpdateNotificationID

How to create

    CREATE TABLE ServerOptions(
    UpdateNotificationID INTEGER IDENTITY (1,1)NOT NULL DEFAULT(0),
    [Type] INTEGER NOT NULL DEFAULT(0),
    Options INTEGER NOT NULL,`

    `ConfirmTimeout INTEGER NOT NULL DEFAULT(0),
    Modified DATETIME NOT NULL DEFAULT(GETUTCDATE()),
    ReservedString1 NVARCHAR(255),
    ReservedInt1 INTEGER,
    ReservedInt2 INTEGER,
    CONSTRAINT PK_UpdateNotification
    PRIMARY KEY (UpdateNotificationID));
  

The official version of this content is in English. Some of the Cloud Software Group documentation content is machine translated for your convenience only. Cloud Software Group has no control over machine-translated content, which may contain errors, inaccuracies or unsuitable language. No warranty of any kind, either expressed or implied, is made as to the accuracy, reliability, suitability, or correctness of any translations made from the English original into any other language, or that your Cloud Software Group product or service conforms to any machine translated content, and any warranty provided under the applicable end user license agreement or terms of service, or any other agreement with Cloud Software Group, that the product or service conforms with any documentation shall not apply to the extent that such documentation has been machine translated. Cloud Software Group will not be held responsible for any damage or issues that may arise from using machine-translated content.

Was this helpful

Table: UpdateNotification

March 25, 2025

Contributed by:

Table: UpdateNotification

How to create

In this article