Table: dbo.version (Repository version)

Schema dbo
Name version
Title Repository version
Module Utils

Holds information about repository version and updates. Each update to a new version creates a new row in table.

If Version.update is greater than used Dataedo application version, you won't be able to connect to it.

Columns
PK Name Data type Null Attributes Description
1 version_entry_id int Identity / Auto increment column Row ID.
Row ID.
Identity / Auto increment column
2 version int Dataedo version (eg. 4).
Dataedo version (eg. 4).
3 update int Default: 0 Repository update. This is still the same version, but a patch has been applied. Eg. 4.1.
Repository update. This is still the same version, but a patch has been applied. Eg. 4.1.
Default: 0
4 stable bit 1 when installation/upgrade was performed sucessfuly, 0 when it was stopped for some reason.
1 when installation/upgrade was performed sucessfuly, 0 when it was stopped for some reason.
5 installation_date datetime Default: getdate() Time of repository installation/upgrade.
Time of repository installation/upgrade.
Default: getdate()
6 installed_by nvarchar(100) Default: NULL Name of Database/Dataedo user that upgraded repository.
Name of Database/Dataedo user that upgraded repository.
Default: NULL
7 creation_date datetime Default: getdate() Standard row creation timestamp.
Standard row creation timestamp.
Default: getdate()
8 created_by nvarchar(100) Default: NULL Database/Dataedo username that created row.
Database/Dataedo username that created row.
Default: NULL
9 last_modification_date datetime Default: getdate() Standard row last update timestamp.
Standard row last update timestamp.
Default: getdate()
10 modified_by nvarchar(100) Default: NULL Database/Dataedo username that last updated row.
Database/Dataedo username that last updated row.
Default: NULL
Unique keys
Key name Columns Description
PK_version version_entry_id Table primary key.
Table primary key.
UK_version version, update Version and update must be unique.
Version and update must be unique.
Triggers
Key name When Description
trg_version_Modify After Insert, Update Standard insert/update trigger setting last_modification_date, modified by columns
Standard insert/update trigger setting last_modification_date, modified by columns
Exported: 2017-05-15 08:09, Last imported: 2017-04-06 15:30