umbraco 13 - remove user.sql

/*
Use at your own risk. Thanks to https://umbracare.net/blog/how-to-delete-umbraco-user-permanently/ for inspiration.
*/

BEGIN TRAN

DECLARE @userId INT = (
		SELECT id
		FROM [dbo].[umbracoUser]
		WHERE userLogin = '[email protected]'
		);

PRINT 'User ID: ' + CAST(@userId AS VARCHAR);

UPDATE [dbo].[umbracoContentVersion]
SET userId = -1 -- infoweaver admin
WHERE userId = @userId;

UPDATE [dbo].[umbracoNode]
SET nodeUser = -1 -- infoweaver admin
WHERE nodeUser = @userId;

UPDATE [dbo].[umbracoLog]
SET userId = -1 -- infoweaver admin
WHERE userId = @userId;

DELETE
FROM [dbo].[umbracoUser2UserGroup]
WHERE userId = @userId;

DELETE
FROM [dbo].[umbracoUserLogin]
WHERE userId = @userId;

DELETE
FROM [dbo].[umbracoUser2NodeNotify]
WHERE userId = @userId;

DELETE
FROM [dbo].[umbracoUserStartNode]
WHERE userId = @userId;

DELETE
FROM [dbo].[umbracoUser]
WHERE id = @userId;

ROLLBACK TRAN 
--COMMIT TRAN