Identity tables

IdentityTables.sql

SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE TABLE [dbo].[Role] (
  [Id] [uniqueidentifier] NOT NULL,
  [Name] [nvarchar](256) NULL,
  [NormalizedName] [nvarchar](256) NULL,
  [ConcurrencyStamp] [nvarchar](max) NULL,
  CONSTRAINT [PK_Role] PRIMARY KEY CLUSTERED ([Id] ASC) WITH (
    PAD_INDEX = OFF,
    STATISTICS_NORECOMPUTE = OFF,
    IGNORE_DUP_KEY = OFF,
    ALLOW_ROW_LOCKS = ON,
    ALLOW_PAGE_LOCKS = ON,
    OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF
    ) ON [PRIMARY]
  ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO

SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE TABLE [dbo].[RoleClaim] (
  [Id] [uniqueidentifier] NOT NULL,
  [RoleId] [uniqueidentifier] NOT NULL,
  [ClaimType] [nvarchar](max) NULL,
  [ClaimValue] [nvarchar](max) NULL,
  CONSTRAINT [PK_RoleClaim] PRIMARY KEY CLUSTERED ([Id] ASC) WITH (
    PAD_INDEX = OFF,
    STATISTICS_NORECOMPUTE = OFF,
    IGNORE_DUP_KEY = OFF,
    ALLOW_ROW_LOCKS = ON,
    ALLOW_PAGE_LOCKS = ON,
    OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF
    ) ON [PRIMARY]
  ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO

SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE TABLE [dbo].[User] (
  [Id] [uniqueidentifier] NOT NULL,
  [UserName] [nvarchar](256) NULL,
  [NormalizedUserName] [nvarchar](256) NULL,
  [Email] [nvarchar](256) NULL,
  [NormalizedEmail] [nvarchar](256) NULL,
  [EmailConfirmed] [bit] NOT NULL,
  [PasswordHash] [nvarchar](max) NULL,
  [SecurityStamp] [nvarchar](max) NULL,
  [ConcurrencyStamp] [nvarchar](max) NULL,
  [PhoneNumber] [nvarchar](max) NULL,
  [PhoneNumberConfirmed] [bit] NOT NULL,
  [TwoFactorEnabled] [bit] NOT NULL,
  [LockoutEnd] [datetimeoffset](7) NULL,
  [LockoutEnabled] [bit] NOT NULL,
  [AccessFailedCount] [int] NOT NULL,
  CONSTRAINT [PK_User] PRIMARY KEY CLUSTERED ([Id] ASC) WITH (
    PAD_INDEX = OFF,
    STATISTICS_NORECOMPUTE = OFF,
    IGNORE_DUP_KEY = OFF,
    ALLOW_ROW_LOCKS = ON,
    ALLOW_PAGE_LOCKS = ON,
    OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF
    ) ON [PRIMARY]
  ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO

SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE TABLE [dbo].[UserClaim] (
  [Id] [uniqueidentifier] NOT NULL,
  [UserId] [uniqueidentifier] NOT NULL,
  [ClaimType] [nvarchar](max) NULL,
  [ClaimValue] [nvarchar](max) NULL,
  CONSTRAINT [PK_UserClaim] PRIMARY KEY CLUSTERED ([Id] ASC) WITH (
    PAD_INDEX = OFF,
    STATISTICS_NORECOMPUTE = OFF,
    IGNORE_DUP_KEY = OFF,
    ALLOW_ROW_LOCKS = ON,
    ALLOW_PAGE_LOCKS = ON,
    OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF
    ) ON [PRIMARY]
  ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO

SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE TABLE [dbo].[UserLogin] (
  [LoginProvider] [uniqueidentifier] NOT NULL,
  [ProviderKey] [uniqueidentifier] NOT NULL,
  [ProviderDisplayName] [nvarchar](max) NULL,
  [UserId] [uniqueidentifier] NOT NULL,
  CONSTRAINT [PK_UserLogin] PRIMARY KEY CLUSTERED (
    [LoginProvider] ASC,
    [ProviderKey] ASC
    ) WITH (
    PAD_INDEX = OFF,
    STATISTICS_NORECOMPUTE = OFF,
    IGNORE_DUP_KEY = OFF,
    ALLOW_ROW_LOCKS = ON,
    ALLOW_PAGE_LOCKS = ON,
    OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF
    ) ON [PRIMARY]
  ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO

SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE TABLE [dbo].[UserRole] (
  [UserId] [uniqueidentifier] NOT NULL,
  [RoleId] [uniqueidentifier] NOT NULL,
  CONSTRAINT [PK_UserRole] PRIMARY KEY CLUSTERED (
    [UserId] ASC,
    [RoleId] ASC
    ) WITH (
    PAD_INDEX = OFF,
    STATISTICS_NORECOMPUTE = OFF,
    IGNORE_DUP_KEY = OFF,
    ALLOW_ROW_LOCKS = ON,
    ALLOW_PAGE_LOCKS = ON,
    OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF
    ) ON [PRIMARY]
  ) ON [PRIMARY]
GO

SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE TABLE [dbo].[UserToken] (
  [UserId] [uniqueidentifier] NOT NULL,
  [LoginProvider] [uniqueidentifier] NOT NULL,
  [Name] [uniqueidentifier] NOT NULL,
  [Value] [nvarchar](max) NULL,
  CONSTRAINT [PK_UserToken] PRIMARY KEY CLUSTERED (
    [UserId] ASC,
    [LoginProvider] ASC,
    [Name] ASC
    ) WITH (
    PAD_INDEX = OFF,
    STATISTICS_NORECOMPUTE = OFF,
    IGNORE_DUP_KEY = OFF,
    ALLOW_ROW_LOCKS = ON,
    ALLOW_PAGE_LOCKS = ON,
    OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF
    ) ON [PRIMARY]
  ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO

ALTER TABLE [dbo].[Role] ADD CONSTRAINT [DF_Role_Id] DEFAULT(newid())
FOR [Id]
GO

ALTER TABLE [dbo].[RoleClaim] ADD CONSTRAINT [DF_RoleClaim_Id] DEFAULT(newid())
FOR [Id]
GO

ALTER TABLE [dbo].[User] ADD CONSTRAINT [DF_User_Id] DEFAULT(newid())
FOR [Id]
GO

ALTER TABLE [dbo].[UserClaim] ADD CONSTRAINT [DF_UserClaim_Id] DEFAULT(newid())
FOR [Id]
GO

ALTER TABLE [dbo].[RoleClaim]
  WITH CHECK ADD CONSTRAINT [FK_RoleClaim_Role_RoleId] FOREIGN KEY ([RoleId]) REFERENCES [dbo].[Role]([Id]) ON

DELETE CASCADE
GO

ALTER TABLE [dbo].[RoleClaim] CHECK CONSTRAINT [FK_RoleClaim_Role_RoleId]
GO

ALTER TABLE [dbo].[UserClaim]
  WITH CHECK ADD CONSTRAINT [FK_UserClaim_User_UserId] FOREIGN KEY ([UserId]) REFERENCES [dbo].[User]([Id]) ON

DELETE CASCADE
GO

ALTER TABLE [dbo].[UserClaim] CHECK CONSTRAINT [FK_UserClaim_User_UserId]
GO

ALTER TABLE [dbo].[UserLogin]
  WITH CHECK ADD CONSTRAINT [FK_UserLogin_User_UserId] FOREIGN KEY ([UserId]) REFERENCES [dbo].[User]([Id]) ON

DELETE CASCADE
GO

ALTER TABLE [dbo].[UserLogin] CHECK CONSTRAINT [FK_UserLogin_User_UserId]
GO

ALTER TABLE [dbo].[UserRole]
  WITH CHECK ADD CONSTRAINT [FK_UserRole_Role_RoleId] FOREIGN KEY ([RoleId]) REFERENCES [dbo].[Role]([Id]) ON

DELETE CASCADE
GO

ALTER TABLE [dbo].[UserRole] CHECK CONSTRAINT [FK_UserRole_Role_RoleId]
GO

ALTER TABLE [dbo].[UserRole]
  WITH CHECK ADD CONSTRAINT [FK_UserRole_User_UserId] FOREIGN KEY ([UserId]) REFERENCES [dbo].[User]([Id]) ON

DELETE CASCADE
GO

ALTER TABLE [dbo].[UserRole] CHECK CONSTRAINT [FK_UserRole_User_UserId]
GO

ALTER TABLE [dbo].[UserToken]
  WITH CHECK ADD CONSTRAINT [FK_UserToken_User_UserId] FOREIGN KEY ([UserId]) REFERENCES [dbo].[User]([Id]) ON

DELETE CASCADE
GO

ALTER TABLE [dbo].[UserToken] CHECK CONSTRAINT [FK_UserToken_User_UserId]
GO