task #6535
MetaDataPropertyName from number to string in DB
50%
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
Associated revisions
fix #6535 change CdmMetaData.propertyName from int to string
fix #6535 change CdmMetaData.propertyName from int to string, adapt test schema and test
ref #6535 add quotation marks for hardcoded SQL propertyname parameter
ref #6535 adapt TaxEdtior to new CdmMetaDataPropertyName
ref #6535 final adaptations to CdmMetaDataPropertyName in taxEditor
ref #6535 fix update script for renaming CdmMetaData.propertyName and remove old column
ref #6535 fix strange bug in SQL that reads all records from CdmMetaData for propertyname = 0
ref #6535 fix calls to version number from other places
ref #6535 fix updated test H2 in cdmlib
ref #6535 fix updated test H2 in vaadin
ref #6535 fix updated test H2 in taxeditor
ref #6535 fix updated test H2 in taxeditor
History
#1 Updated by Andreas Müller about 4 years ago
- Tracker changed from bug to task
#2 Updated by Andreas Müller almost 4 years ago
- Status changed from New to In Progress
#3 Updated by Andreas Müller almost 4 years ago
- Status changed from In Progress to Resolved
- % Done changed from 0 to 50
Applied in changeset cdmlib|cfe723e5bc6869c8bc0416308c54bd5caad20d2a.
#4 Updated by Andreas Müller almost 4 years ago
- Related to task #6699: Delete term version from CdmMetaData added
#5 Updated by Andreas Müller almost 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 ;
#6 Updated by Andreas Müller almost 4 years ago
Finally this should be fixed now.
#7 Updated by Andreas Müller almost 4 years ago
- Status changed from Resolved to Closed