U4-1353 - Prepare database for container document types changes

Created by Sebastiaan Janssen 26 Dec 2012, 12:10:09 Updated by Sebastiaan Janssen 31 Jan 2013, 15:31:19

Details on what Container Document Types are: http://our.umbraco.org/contribute/releases/4100/rfc/33203-Container-Document-Types

Breaking changes: cmsTab is renamed to cmsPropertyTypeGroup (new column: parentGroupId - this will allow for having fieldsets). This will break any package/custom code that queries the cmsTab table directly.

cmsPropertyType has a tabId column which has been renamed to propertyTypeGroupId. This will break any package/custom code that queries the tabId column directly.

2 Attachments

Download ManualDatabaseUpgrade600_SQLCE.txt

Download ManualDatabaseUpgrade600_SQLServer.txt


Sebastiaan Janssen 26 Dec 2012, 12:13:20

Make sure to use the umbraco.cms.businesslogic.propertytype.PropertyTypeGroup class instead of querying cmsTab directly.

Sebastiaan Janssen 28 Dec 2012, 10:21:31

For more info on the database changes, make sure to inspect the attached manual update scripts for SQL/SQL CE

Sebastiaan Janssen 15 Jan 2013, 09:20:44

All of the changes in human readable form: cmsTab is renamed to cmsPropertyType

cmsPropertyType has a new parentGroupId column used to support fieldsets (not used currently)

The tabId column in cmsPropertyType has been renamed to propertyTypeGroupId

cmsContentTypeAllowedContentType has a new sortOrder colum, not sure what that's used for but it is in use (defaults to 1)

cmsContentType has a new column isContainer to support container doctypes (currently not used)

cmsContentType has a new column allowAtRoot to limit the content types you can create directly under the "Content"/-1 node (currently not used)

The masterContentType column in cmsContentType has been removed in favor of the cmsContentType2ContentType table so that contentTypes can do mixins (have multiple contenttypes they inherit their properties from), this is in active use and all data from the masterContentType column will be migrated to this new table during upgrades.

Priority: Normal

Type: Task

State: Fixed


Difficulty: Normal


Backwards Compatible: False

Fix Submitted:

Affected versions: 6.0.0

Due in version: 6.0.0


Story Points: