mirror of
https://github.com/bitwarden/server.git
synced 2026-06-01 01:55:55 -05:00
feat: add MasterPasswordSalt to database responses and DTOs - Add Dapper migration scripts and update SQL project - Include MasterPasswordSalt in database response models and DTOs - Add null coalescing to User entity for MasterPasswordSalt - Update EF queries to return MasterPasswordSalt - Rename migrations for consistency - Add test coverage for affected repositories - Update EmergencyAccessTakeOverResponseModel tests
19 lines
307 B
Transact-SQL
19 lines
307 B
Transact-SQL
CREATE OR ALTER PROCEDURE [dbo].[User_ReadKdfByEmail]
|
|
@Email NVARCHAR(256)
|
|
AS
|
|
BEGIN
|
|
SET NOCOUNT ON
|
|
|
|
SELECT
|
|
[Kdf],
|
|
[KdfIterations],
|
|
[KdfMemory],
|
|
[KdfParallelism],
|
|
[MasterPasswordSalt]
|
|
FROM
|
|
[dbo].[User]
|
|
WHERE
|
|
[Email] = @Email
|
|
END
|
|
GO
|