SchemaVersion table
The SchemaVersion table is a single-row table that records version information about the UNICOM Intelligence Data Model components, to facilitate future enhancements to the schema. The SchemaVersion table is used in both the RDB DSC 2 and RDB DSC schemas.
Columns
CurVersionMajor
Column type: Smallint
The current major UNICOM Intelligence Data Model version number. For example, for UNICOM Intelligence Data Model 4.5, this is 4.
CurVersionMinor
Column type: Smallint
The current minor UNICOM Intelligence Data Model version number. For example, for UNICOM Intelligence Data Model 4.5, this is 5.
CurVersionComponent
Column type: Smallint
The current version number of the Relational MR Database CDSC component (mrRdbDsc.dll).
CurVersionBuild
Column type: Smallint
The current UNICOM Intelligence Data Model build number.
MinVersionMajor
Column type: Smallint
The minimum major UNICOM Intelligence Data Model version number required to operate on the database.
MinVersionMinor
Column type: Smallint
The minimum minor UNICOM Intelligence Data Model version number required to operate on the database.
MinVersionComponent
Column type: Smallint
The minimum version number of the Relational MR Database CDSC component required to operate on the database.
MinVersionBuild
Column type: Smallint
The minimum UNICOM Intelligence Data Model build number required to operate on the database.
Notes
The Relational MR Database CDSC updates the minimum version details in the SchemaVersion table before updating the database schema. Before Relational MR Database CDSC subsequently attempts to update the database, it checks the minimum version details in the SchemaVersion table. If Relational MR Database CDSC is the same or a later version, it inserts its version details in the current version columns.
See also