Table: UpdateNotification

Handles the Image update notification feature in version 14.9 and later

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));