Nick Hoàng nick-hoang

Nick is a full-stack .net developer, Umbraco specialist and a self taught mobile app developer with 5+ years experience within digital agencies

nick-hoang / umbraco-clear-recycle-bin.sql

Last active September 21, 2018 20:55 — forked from kipusoep/umbraco-clear-recycle-bin.sql

	--Delete old nodes (keep recent 15 days) from Trash, Umbraco 7.7.6

	--deletes in Document
	--at this point all associated media files are deleted
	delete from umbracoDomains where id in (select id from umbracoNode where trashed = 1 and createDate < DATEADD(d, -15, getdate()));
	delete from cmsDocument where nodeId in (select id from umbracoNode where trashed = 1 and createDate < DATEADD(d, -15, getdate()));

	--deletes in Content
	delete from cmsPropertyData where contentNodeId in (select id from umbracoNode where trashed = 1 and createDate < DATEADD(d, -15, getdate()));
	delete from cmsPreviewXml where nodeId in (select id from umbracoNode where trashed = 1 and createDate < DATEADD(d, -15, getdate()));