dbo.version (Repository version) - Utils

Dataedo repository 7

- Dataedo repository 7
  - Modules
  - Tables

Documentation	Dataedo repository 7
Schema	dbo
Name	version
Title	Repository version
Module	Utils
Type	Internal
Status	Active

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

		Name	Data type	Attributes	Description	Type	Status
	1	version_entry_id	int	Identity	Row id	Internal	Active
Row id Identity Type: Internal Status: Active
	2	version	int		Dataedo version (eg. 4)	Internal	Active
Dataedo version (eg. 4) Type: Internal Status: Active
	3	update	int	Default: 0	Repository update. This is still the same version, but a patch has been applied. Eg. 4.1	Internal	Active
Repository update. This is still the same version, but a patch has been applied. Eg. 4.1 Default: 0 Type: Internal Status: Active
	4	release	int	Default: 0	Not used anymore	Internal	Cancelled
Not used anymore Default: 0 Type: Internal Status: Cancelled
	5	stable	bit		1 when installation/upgrade was performed sucessfuly, 0 when it was stopped for some reason.	Internal	Active
1 when installation/upgrade was performed sucessfuly, 0 when it was stopped for some reason. Type: Internal Status: Active
	6	installation_date	datetime	Default: getdate()	Time of repository installation/upgrade.	Internal	Active
Time of repository installation/upgrade. Default: getdate() Type: Internal Status: Active
	7	installed_by	nvarchar(100)	Default: suser_sname()	Name of Database/Dataedo user that upgraded repository.	Internal	Active
Name of Database/Dataedo user that upgraded repository. Default: suser_sname() Type: Internal Status: Active
	8	creation_date	datetime	Default: getdate()	Standard row creation timestamp	Metadata	Active
Standard row creation timestamp Default: getdate() Type: Metadata Status: Active
	9	created_by	nvarchar(1024)	Default: suser_sname()	Dataedo username that created row	Metadata	Active
Dataedo username that created row Default: suser_sname() Type: Metadata Status: Active
	10	last_modification_date	datetime	Default: getdate()	Standard row last update timestamp	Metadata	Active
Standard row last update timestamp Default: getdate() Type: Metadata Status: Active
	11	modified_by	nvarchar(1024)	Default: suser_sname()	Dataedo username that last updated row	Metadata	Active
Dataedo username that last updated row Default: suser_sname() Type: Metadata Status: Active

Unique keys

	Key name	Columns	Description
	PK_version	version_entry_id	Table primary key
Table primary key
	UK_version	version, update, release	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
-- ============================================= -- Author: Piotr Kononow -- Create date: 2014-08-06 -- Description: Updates last_modification_date, modified_by columns on insert or update -- ============================================= create TRIGGER [trg_version_Modify] ON [version] AFTER INSERT,UPDATE AS BEGIN UPDATE [version] SET last_modification_date = GETDATE(), modified_by = suser_sname() WHERE version_entry_id IN (SELECT DISTINCT version_entry_id FROM Inserted) END
Standard insert/update trigger setting last_modification_date, modified by columns
-- ============================================= -- Author: Piotr Kononow -- Create date: 2014-08-06 -- Description: Updates last_modification_date, modified_by columns on insert or update -- ============================================= create TRIGGER [trg_version_Modify] ON [version] AFTER INSERT,UPDATE AS BEGIN UPDATE [version] SET last_modification_date = GETDATE(), modified_by = suser_sname() WHERE version_entry_id IN (SELECT DISTINCT version_entry_id FROM Inserted) END

Uses

Name
dbo.trg_version_Modify
dbo.version (Repository version)

Used by

Name
dbo.version (Repository version)
dbo.trg_version_Modify

Exported: 2018-12-06 15:15, Last imported: 2018-11-21 15:07