task #6535: MetaDataPropertyName from number to string in DB - Edit - Redmine

Actions

Copy link

task #6535

closed

MetaDataPropertyName from number to string in DB

Added by Andreas Müller almost 5 years ago. Updated over 4 years ago.

Status:

Closed

Priority:

Highest

Assignee:

Andreas Müller

Category:

cdm

Target version:

CDM UML 4.7

Start date:

03/23/2017

Due date:

% Done:

50%

Estimated time:

Severity:

normal

Description

MetaDataPropertyName is stored as number in CdmMetaData. We use string for TermType at other places and should do so here, too. This allows reordering the enum.

Related issues

Actions

Copy link

Updated by Andreas Müller almost 5 years ago

Tracker changed from bug to task

Actions

Copy link

Updated by Andreas Müller over 4 years ago

Status changed from New to In Progress

Actions

Copy link

Updated by Andreas Müller over 4 years ago

Status changed from In Progress to Resolved
% Done changed from 0 to 50

Applied in changeset cdmlib|cfe723e5bc6869c8bc0416308c54bd5caad20d2a.

Actions

Copy link

Updated by Andreas Müller over 4 years ago

Related to task #6699: Delete term version from CdmMetaData added

Actions

Copy link

Updated by Andreas Müller over 4 years ago

Update script for incorrect update

UPDATE CdmMetaData SET PropertyName = 'TERM_VERSION' WHERE PropertyNameOld = 0;

UPDATE CdmMetaData SET PropertyName = 'SCHEMA_VERSION' WHERE PropertyNameOld = 1;

UPDATE CdmMetaData SET PropertyName = 'CREATED' WHERE PropertyNameOld = 2;

ALTER TABLE CdmMetaData  DROP COLUMN PropertyNameOld ;