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