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.
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 |
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. |
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 |