-
-
Save kipusoep/bf5bde5ed85a896afda25df6b465ce76 to your computer and use it in GitHub Desktop.
--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; |
Please try the following scripts if you haven't found the work around yet, works well with v8.13.1
--deletes in Document
--at this point all associated media files are deleted
delete from umbracoDomain where id in (select id from umbracoNode where path like '%-20%' and id!=-20);
delete from umbracoDocument where nodeId in (select id from umbracoNode where path like '%-20%' and id!=-20);
--deletes in Content
delete from umbracoPropertyData where versionId in (select id from umbracoContentVersion where nodeId in (select id from umbracoNode where path like '%-20%' and id!=-20));
delete from umbracoDocumentVersion where id in (select id from umbracoContentVersion where nodeId in (select id from umbracoNode where path like '%-20%' and id!=-20));
delete from umbracoContentVersion where nodeId in (select id from umbracoNode where path like '%-20%' and id!=-20);
delete from cmsContentNu 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 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 umbracoUserGroup2NodePermission where nodeId in (select id from umbracoNode where path like '%-20%' and id!=-20);
delete from umbracoContent where nodeId in (select id from umbracoNode where path like '%-20%' and id!=-20);
delete from umbracoContentSchedule where nodeId in (select id from umbracoNode where path like '%-20%' and id!=-20)
delete from umbracoRedirectUrl where contentKey in (select uniqueId from umbracoNode where path like '%-20%' and id!=-20)
delete from umbracoNode where path like '%-20%' and id!=-20;
Updated for Umbraco 11.4.2 (to include VersionCulture tables):
--deletes in Document
--at this point all associated media files are deleted
delete from umbracoDomain where id in (select id from umbracoNode where path like '%-20%' and id!=-20);
delete from umbracoDocument where nodeId in (select id from umbracoNode where path like '%-20%' and id!=-20);
delete from umbracoDocumentVersion where id in (select id from umbracoContentVersion where nodeId in (select id from umbracoNode where path like '%-20%' and id!=-20));
delete from umbracoDocumentCultureVariation where nodeid in (select id from umbracoNode where path like '%-20%' and id!=-20);
--deletes in Content
delete from umbracoPropertyData where versionId in (select id from umbracoContentVersion where nodeId in (select id from umbracoNode where path like '%-20%' and id!=-20));
delete from umbracoContentVersionCultureVariation where versionid in (select id from umbracoContentVersion where nodeId in (select id from umbracoNode where path like '%-20%' and id!=-20));
delete from umbracoContentVersion where nodeId in (select id from umbracoNode where path like '%-20%' and id!=-20);
delete from cmsContentNu 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 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 umbracoUserGroup2NodePermission where nodeId in (select id from umbracoNode where path like '%-20%' and id!=-20);
delete from umbracoContent where nodeId in (select id from umbracoNode where path like '%-20%' and id!=-20);
delete from umbracoContentSchedule where nodeId in (select id from umbracoNode where path like '%-20%' and id!=-20)
delete from umbracoRedirectUrl where contentKey in (select uniqueId from umbracoNode where path like '%-20%' and id!=-20)
delete from umbracoNode where path like '%-20%' and id!=-20;
I have a couple of issues..
When I get to
delete from umbracoNode where path like '%-20%' and id!=-20;
when there are nodes in the recycle bin with access restrictions the FK constraints on nodeId, loginNodeId and noAccessNodeId prevent deletes.
I also get an error about parentId on node SameTable constraint stops delete ??
Any work around?