Files
server/util/Migrator/DbScripts/2025-12-17_00_User_UpdateKeyConnectorUserKey.sql

Ignoring revisions in .git-blame-ignore-revs. Click here to bypass and see the normal blame view.

30 lines
656 B
MySQL
Raw Permalink Normal View History

CREATE OR ALTER PROCEDURE [dbo].[User_UpdateKeyConnectorUserKey]
@Id UNIQUEIDENTIFIER,
@Key VARCHAR(MAX),
@Kdf TINYINT,
@KdfIterations INT,
@KdfMemory INT,
@KdfParallelism INT,
@UsesKeyConnector BIT,
@RevisionDate DATETIME2(7),
@AccountRevisionDate DATETIME2(7)
AS
BEGIN
SET NOCOUNT ON
UPDATE
[dbo].[User]
SET
[Key] = @Key,
[Kdf] = @Kdf,
[KdfIterations] = @KdfIterations,
[KdfMemory] = @KdfMemory,
[KdfParallelism] = @KdfParallelism,
[UsesKeyConnector] = @UsesKeyConnector,
[RevisionDate] = @RevisionDate,
[AccountRevisionDate] = @AccountRevisionDate
WHERE
[Id] = @Id
END
GO