text: ﻿CREATE TABLE [dbo].[AspNetUsers] (
      [Id]                   NVARCHAR (450)     NOT NULL,
      [AccessFailedCount]    INT                NOT NULL DEFAULT 0,
      [ConcurrencyStamp]     NVARCHAR (MAX)     NULL,
      [Email]                NVARCHAR (256)     NULL,
      [EmailConfirmed]       BIT                NOT NULL DEFAULT 0,
      [LockoutEnabled]       BIT                NOT NULL DEFAULT 1,
      [LockoutEnd]           DATETIMEOFFSET (7) NULL,
      [NormalizedEmail]      NVARCHAR (256)     NULL,
      [NormalizedUserName]   NVARCHAR (256)     NOT NULL,
      [PasswordHash]         NVARCHAR (MAX)     NULL,
      [PersonID]             NVARCHAR (MAX)     NULL,
      [PhoneNumber]          NVARCHAR (MAX)     NULL,
      [PhoneNumberConfirmed] BIT                NOT NULL DEFAULT 0,
      [SecurityStamp]        NVARCHAR (MAX)     NULL,
      [TwoFactorEnabled]     BIT                NOT NULL DEFAULT 0,
      [UserName]             NVARCHAR (256)     NULL,
      [GroupPin] NVARCHAR(20) NOT NULL, 
      CONSTRAINT [PK_AspNetUsers] PRIMARY KEY CLUSTERED ([Id] ASC)
  );
  
  
  GO
  CREATE UNIQUE NONCLUSTERED INDEX [UserNameIndex]
      ON [dbo].[AspNetUsers]([NormalizedUserName] ASC);
  
  
  GO
  CREATE NONCLUSTERED INDEX [EmailIndex]
      ON [dbo].[AspNetUsers]([NormalizedEmail] ASC);
  
  