CREATE TABLE [dbo].[{LOGINPROTECTION_ATTEMPTS}](
	[id] [int] IDENTITY(1,1) NOT NULL,
	[identity_type] [varchar](16) NOT NULL,
	[identity_value] [varchar](191) NOT NULL,
	[identity_hash] [char](64) NOT NULL,
	[failed_attempts] [int] NOT NULL DEFAULT 0,
	[locked_until] [int] NOT NULL DEFAULT 0,
	[first_attempt_at] [int] NOT NULL DEFAULT 0,
	[last_attempt_at] [int] NOT NULL DEFAULT 0,
	[created_at] [int] NOT NULL DEFAULT 0,
	[updated_at] [int] NOT NULL DEFAULT 0,
	CONSTRAINT [PK_LOGINPROTECTION_ATTEMPTS] PRIMARY KEY CLUSTERED ([id] ASC),
	CONSTRAINT [UQ_LOGINPROTECTION_ATTEMPTS_IDENTITY] UNIQUE ([identity_type], [identity_hash])
)
