Created
December 20, 2016 12:25
-
-
Save kipusoep/bf5bde5ed85a896afda25df6b465ce76 to your computer and use it in GitHub Desktop.
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
--deletes in Document | |
--at this point all associated media files are deleted | |
delete from umbracoDomains where id in (select id from umbracoNode where path like '%-20%' and id!=-20); | |
delete from cmsDocument where nodeId in (select id from umbracoNode where path like '%-20%' and id!=-20); | |
--deletes in Content | |
delete from cmsPropertyData where contentNodeId in (select id from umbracoNode where path like '%-20%' and id!=-20); | |
delete from cmsPreviewXml where nodeId in (select id from umbracoNode where path like '%-20%' and id!=-20); | |
delete from cmsContentVersion where ContentId in (select id from umbracoNode where path like '%-20%' and id!=-20); | |
delete from cmsContentXml where NodeId in (select id from umbracoNode where path like '%-20%' and id!=-20); | |
--deletes in CMSNode | |
delete from umbracoRelation where parentId in (select id from umbracoNode where path like '%-20%' and id!=-20); | |
delete from umbracoRelation where childId in (select id from umbracoNode where path like '%-20%' and id!=-20); | |
delete from cmsTask where nodeId in (select id from umbracoNode where path like '%-20%' and id!=-20); | |
delete from umbracoUser2NodeNotify where nodeId in (select id from umbracoNode where path like '%-20%' and id!=-20); | |
delete from cmsTagRelationship where nodeId in (select id from umbracoNode where path like '%-20%' and id!=-20); | |
delete from umbracoUser2NodePermission where nodeId in (select id from umbracoNode where path like '%-20%' and id!=-20); | |
delete from cmsContent where nodeId in (select id from umbracoNode where path like '%-20%' and id!=-20); | |
delete from umbracoNode where path like '%-20%' and id!=-20; |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
Updated for Umbraco 11.4.2 (to include VersionCulture tables):