Advertisement
otkalce

MVC auth db structure

May 17th, 2023
346
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
C# 0.50 KB | Source Code | 0 0
  1. CREATE TABLE [dbo].[User](
  2.     [Id] [int] IDENTITY(1,1) NOT NULL,
  3.     [CreatedAt] [datetime2](7) NOT NULL,
  4.     [DeletedAt] [datetime2](7) NULL,
  5.     [Username] [nvarchar](50) NOT NULL,
  6.     [FirstName] [nvarchar](256) NOT NULL,
  7.     [LastName] [nvarchar](256) NOT NULL,
  8.     [Email] [nvarchar](256) NOT NULL,
  9.     [PwdHash] [nvarchar](256) NOT NULL,
  10.     [PwdSalt] [nvarchar](256) NOT NULL,
  11.     [IsConfirmed] [bit] NOT NULL,
  12.     [SecurityToken] [nvarchar](256) NULL,
  13.     CONSTRAINT [PK_User] PRIMARY KEY CLUSTERED
  14.     (
  15.         [Id] ASC
  16.     )
  17. )
  18.  
Tags: mvc-auth
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement