Skip to content

Instantly share code, notes, and snippets.

@gdyrrahitis

gdyrrahitis/UserClaims.sql Secret

Created February 24, 2018 19:00
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save gdyrrahitis/8b4142ad37e2df4467e37aea49843302 to your computer and use it in GitHub Desktop.
Save gdyrrahitis/8b4142ad37e2df4467e37aea49843302 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
UserClaims.sql
CREATE TABLE [dbo].[UserClaims](
[Id] [int] IDENTITY(1,1) NOT NULL,
[UserId] [int] NOT NULL,
[Type] [varchar](200) NOT NULL,
[Value] [varchar](max) NOT NULL,
[ValueType] varchar(255) NULL default('http://www.w3.org/2001/XMLSchema#string'),
[Issuer] varchar(255) NULL default('Custom Authority')
PRIMARY KEY(Id),
CONSTRAINT FK_UserClaims FOREIGN KEY(UserId)
REFERENCES [User]([Id]) ON DELETE CASCADE
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment