U4-3015 - Tags db structure updated

Created by Shannon Deminick 02 Oct 2013, 00:37:51 Updated by Martin Griffiths 24 Jan 2014, 10:07:01

Relates to: U4-4133

Subtask of: U4-2851

Need to update the db structure for tags so that tags are referenced to a property not a document

  • Changing cmsTagRelationship columns ** Adds propertyTypeId column ** Migrates the data in to that column appropriately ** Adds relationship to PropertyType table ** Changes pk to be across all 3 cols: nodeId, tagId, propertyTypeId ** Changes foreign key for nodeId to be related to cmsContent.nodeId instead of umbracoNode.id

  • Change cmsTags ** Adds foreign key to ParentId column to cmsTags.id

The tagRelationship table will no longer be compatible with non Content/Media/Members in case people were storing their own custom tags data in there that only referenced umbracoNode.

During the upgrade, any tagRelation found that doesn't have a referenced item in the cmsContent table will be deleted and a warning logged.


Priority: Normal

Type: Bug

State: Fixed

Assignee: Shannon Deminick

Difficulty: Normal


Backwards Compatible: True

Fix Submitted:

Affected versions:

Due in version: 7.0.0


Story Points: