Create user and roles for aspnet identity

createdefaultuserandroles.sql

CREATE PROCEDURE AddUserAccount
(
	@Email AS NVARCHAR(256),
	@RoleId AS UNIQUEIDENTIFIER
)
AS
BEGIN
	DECLARE @UserId AS UNIQUEIDENTIFIER = NEWID();
	INSERT INTO AspNetUsers (ID, email, EmailConfirmed, PasswordHash, SecurityStamp, UserName, LockoutEnabled, AccessFailedCount, PhoneNumberConfirmed, TwoFactorEnabled, CreationDate, IsApproved, IsLockedOut)
	VALUES (@UserId, @Email, 0, 'AAwsxpbbay95Ig5UUtJfqrz5QQZDWbbJShgza2BVP9sZAEaDvoC+UZ6HP1ER3b94FQ==', '989acc4f-30bd-425d-9b20-7c7f85bee15b', @Email, 0, 0, 0, 0,GETDATE(), 1, 0);
	INSERT INTO AspNetUserRoles (RoleId, UserId) VALUES (@RoleId, @UserId);
END
GO

CREATE PROCEDURE CreateUserRole (@RoleName AS NVARCHAR(256), @RoleId AS NVARCHAR(128) OUTPUT)
AS
BEGIN
    SET @RoleId = NEWID();
    INSERT INTO AspNetRoles(Id, [Name]) VALUES(@RoleId, @RoleName);
END
GO

DECLARE @AdministratorsRoleId AS UNIQUEIDENTIFIER; EXEC CreateUserRole @RoleName = N'Administrators', @RoleId = @AdministratorsRoleId OUTPUT;
DECLARE @WebAdminsRoleId AS UNIQUEIDENTIFIER; EXEC CreateUserRole @RoleName = 'WebAdmins', @RoleId = @WebAdminsRoleId OUTPUT;
DECLARE @WebEditorsRoleId AS UNIQUEIDENTIFIER; EXEC CreateUserRole @RoleName = 'WebEditors', @RoleId = @WebEditorsRoleId OUTPUT;
DECLARE @OrderManagersRoleId AS UNIQUEIDENTIFIER; EXEC CreateUserRole @RoleName = 'Order Managers', @RoleId = @OrderManagersRoleId OUTPUT;
DECLARE @ShippingManagerRoleId AS UNIQUEIDENTIFIER; EXEC CreateUserRole @RoleName = 'Shipping Manager', @RoleId = @ShippingManagerRoleId OUTPUT;
DECLARE @OrderSupervisorRoleId AS UNIQUEIDENTIFIER; EXEC CreateUserRole @RoleName = 'Order Supervisor', @RoleId = @OrderSupervisorRoleId OUTPUT;
DECLARE @ReceivingManagerRoleId AS UNIQUEIDENTIFIER; EXEC CreateUserRole @RoleName = 'Receiving Manager', @RoleId = @ReceivingManagerRoleId OUTPUT;

EXEC AddUserAccount @Email = 'admin@example.com', @RoleId = @AdministratorsRoleId;
EXEC AddUserAccount @Email = 'webeditor@example.com', @RoleId = @WebEditorsRoleId;
EXEC AddUserAccount @Email = 'webadmin@example.com', @RoleId = @WebAdminsRoleId;
EXEC AddUserAccount @Email = 'ordermanager@example.com', @RoleId = @OrderManagersRoleId;
EXEC AddUserAccount @Email = 'shippingmanager@example.com', @RoleId = @ShippingManagerRoleId;
EXEC AddUserAccount @Email = 'ordersupervisor@example.com', @RoleId = @OrderSupervisorRoleId;
EXEC AddUserAccount @Email = 'receivingmanager@example.com', @RoleId = @ReceivingManagerRoleId;
GO

DROP PROCEDURE AddUserAccount;
GO

DROP PROCEDURE CreateUserRole;
GO