Project

General

Profile

Actions

task #6535

closed

MetaDataPropertyName from number to string in DB

Added by Andreas Müller almost 7 years ago. Updated almost 7 years ago.

Status:
Closed
Priority:
Highest
Category:
cdm
Target version:
Start date:
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

Related to EDIT - task #6699: Delete term version from CdmMetaDataClosedAndreas Müller

Actions
Actions #1

Updated by Andreas Müller almost 7 years ago

  • Tracker changed from bug to task
Actions #2

Updated by Andreas Müller almost 7 years ago

  • Status changed from New to In Progress
Actions #3

Updated by Andreas Müller almost 7 years ago

  • Status changed from In Progress to Resolved
  • % Done changed from 0 to 50
Actions #4

Updated by Andreas Müller almost 7 years ago

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

Updated by Andreas Müller almost 7 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 ;
Actions #6

Updated by Andreas Müller almost 7 years ago

Finally this should be fixed now.

Actions #7

Updated by Andreas Müller almost 7 years ago

  • Status changed from Resolved to Closed
Actions

Also available in: Atom PDF