text: ﻿CREATE TABLE [dbo].[AspNetUsers] (
      [Id]                   UNIQUEIDENTIFIER     NOT NULL,
      [UserName]             NVARCHAR (256)     NULL,
      [NormalizedUserName]   NVARCHAR (256)     NULL,
  	[FirstName]			   NVARCHAR (256)	  NOT NULL,
  	[LastName]             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,
      [RefreshToken] NVARCHAR(512) NULL, 
      [RefreshTokenExpirationDate] DATETIME NULL, 
      CONSTRAINT [PK_AspNetUsers] PRIMARY KEY CLUSTERED ([Id] ASC)
  );
  
  
  GO
  CREATE NONCLUSTERED INDEX [EmailIndex]
      ON [dbo].[AspNetUsers]([NormalizedEmail] ASC);
  
  
  GO
  CREATE UNIQUE NONCLUSTERED INDEX [UserNameIndex]
      ON [dbo].[AspNetUsers]([NormalizedUserName] ASC) WHERE ([NormalizedUserName] IS NOT NULL);
  
  