Cacher is the code snippet organizer for pro developers

DECLARE @userId int;

SET @userId = $userId; -- set desire delete user Id

-- don't nuke these records, but can re-assign back to "admin" master user (or whoever else)
UPDATE umbracoNode SET nodeUser = 0 WHERE nodeUser = @userId
UPDATE cmsDocument SET documentUser = 0 WHERE documentUser = @userId
-- these can be nuked
DELETE FROM umbracoLog WHERE userId = @userId
DELETE FROM umbracoUser2App WHERE [user] = @userId
DELETE FROM umbracoUserLogins WHERE userID = @userId

-- 加入客制table

  --單位
  DELETE FROM UmbracoUser2Department WHERE UserId = @userId

  Delete FROM umbracoUser2Group WHERE UserId = @userId

	Delete FROM umbracoUserParm WHERE UserId = @userId
-- 結束加入客制table

DELETE FROM umbracoUser WHERE id = @userId

DECLARE @userId int;

SET @userId = $userId; -- set desire delete user Id

-- don't nuke these records, but can re-assign back to "admin" master user (or whoever else)
SELECT * from umbracoNode  WHERE nodeUser = @userId
SELECT * from cmsDocument WHERE documentUser = @userId

-- these can be nuked

SELECT * FROM umbracoLog WHERE userId = @userId
SELECT * FROM umbracoUser2App WHERE [user] = @userId

-- 加入客制table

	--單位
	SELECT * FROM UmbracoUser2Department WHERE UserId = @userId

	SELECT * FROM umbracoUser2Group WHERE UserId = @userId

	SELECT * FROM umbracoUserParm WHERE UserId = @userId

-- 結束加入客制table

SELECT * FROM umbracoUser WHERE id = @userId