text: ﻿CREATE TABLE [dbo].[UserRoles]
  (
      [UserId] NVARCHAR(128) NOT NULL,
      [RoleId] NVARCHAR(128) NOT NULL,
      CONSTRAINT [PK_UserRoles] PRIMARY KEY CLUSTERED ([UserId] ASC, [RoleId] ASC),
      CONSTRAINT [FK_UserRoles_Roles_RoleId] FOREIGN KEY ([RoleId]) REFERENCES [dbo].[Roles] ([Id]) ON DELETE CASCADE,
      CONSTRAINT [FK_UserRoles_Users_UserId] FOREIGN KEY ([UserId]) REFERENCES [dbo].[Users] ([Id]) ON DELETE CASCADE
  );
  
  GO
  CREATE NONCLUSTERED INDEX [IX_UserRoles_RoleId]
      ON [dbo].[UserRoles]([RoleId] ASC);
  