2.2.7.11 Versions

The Versions table stores information used for object versioning during upgrade operations. The table is defined using T-SQL syntax, as follows.

 TABLE Versions(
       VersionId                     uniqueidentifier NOT NULL,
       Version                       nvarchar(64) NOT NULL,
       Id                            int IDENTITY(1,1) NOT NULL,
       UserName                      nvarchar(255) NULL,
       TimeStamp                     datetime NULL,
       FinalizeTimeStamp             datetime NULL,
       Mode                          int NULL,
       ModeStack                     int NULL,
       Updates                       int NOT NULL DEFAULT((0)),
       Notes                         nvarchar (1024) NULL
 );

VersionId: A GUID that identifies the version.

Version: The actual version string in the format "<major>.<minor>.<build>.<iteration>" (for example, "3.0.106.0").

Id: An integer value that is an SQL identity column.

UserName: A string containing the user name adding or updating the version.

TimeStamp: A time stamp in UTC format indicating when the version was added or updated.

FinalizeTimeStamp: Unused.

Mode: Unused.

ModeStack: Unused.

Updates: An integer value tracking the number of updates applied to a particular version. This value MUST be initialized to 1 when inserted and incremented each time the version is updated.

Notes: A string containing optional notes associated with the version.