declare @adminToolsCanvasId int, @userModuleId int = -1, @userCanvasId int = -1;
select @adminToolsCanvasId = recid from pal_Canvas where name = 'AdminTools'
select @userModuleId = recId from pal_Module where module = 'Users'
select @userCanvasId = recId from pal_Canvas where name = 'UserAdministration'

delete from pal_CanvasMetaData where canvasId = @userCanvasId and moduleId = @userModuleId
delete from pal_Canvas where recId = @userCanvasId

INSERT INTO [dbo].[pal_Canvas]
(parentId, display, name, description, seoTitle, seoDescription, seoKeywords, seoAnalyticsCode, isActive, isVisible, isExternal, externalPath, sequence, dateCreated, dateUpdated, userTypes, isVisibleFooter, isRestricted, isRightAligned, isDefaultToForm, isComposite, isAccessible, isPanelShown, isSecureLandingPage, hideNavigation, isSummary, summary, customUsers)
VALUES
(@adminToolsCanvasId, 'User Administration', 'UserAdministration', '', '', '', '', '', 1, 1, 0, '', 19, GETDATE(), GETDATE(), 4, 0, 1, 0, 0, 0, 1, 0, 0, 0, 0, '', '')

INSERT INTO [dbo].[pal_CanvasMetaData]
(canvasId, moduleId, entityId, isActive, sequence)
VALUES
(@@IDENTITY, @userModuleId, 0, 1, 10)

update pal_Module set control = 'admin/users.ascx' where recId = @userModuleId