task #6535
closed
MetaDataPropertyName from number to string in DB
Added by Andreas Müller about 7 years ago.
Updated almost 7 years ago.
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.
- Tracker changed from bug to task
- Status changed from New to In Progress
- Status changed from In Progress to Resolved
- % Done changed from 0 to 50
- Related to task #6699: Delete term version from CdmMetaData added
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 ;
Finally this should be fixed now.
- Status changed from Resolved to Closed
Also available in: Atom
PDF