text: ﻿CREATE TABLE [dbo].[aspnet_Roles] (
      [ApplicationId]   UNIQUEIDENTIFIER NOT NULL,
      [RoleId]          UNIQUEIDENTIFIER CONSTRAINT [DF_aspnet_Roles_RoleId] DEFAULT (newid()) NOT NULL,
      [RoleName]        NVARCHAR (256)   NOT NULL,
      [LoweredRoleName] NVARCHAR (256)   NOT NULL,
      [Description]     NVARCHAR (256)   NULL,
      CONSTRAINT [PK_aspnet_Roles] PRIMARY KEY NONCLUSTERED ([RoleId] ASC),
      CONSTRAINT [FK_aspnet_Roles_ApplicationId] FOREIGN KEY ([ApplicationId]) REFERENCES [dbo].[aspnet_Applications] ([ApplicationId])
  );
  
  
  GO
  CREATE UNIQUE CLUSTERED INDEX [aspnet_Roles_index1]
      ON [dbo].[aspnet_Roles]([ApplicationId] ASC, [LoweredRoleName] ASC);
  
  