server/util/Migrator/DbScripts/2024-11-21_00_AddUserAsymmetricKeysRegenerate.sql

CREATE OR ALTER PROCEDURE [dbo].[UserAsymmetricKeys_Regenerate]
    @UserId UNIQUEIDENTIFIER,
    @PublicKey VARCHAR(MAX),
    @PrivateKey VARCHAR(MAX)
AS
BEGIN
    SET NOCOUNT ON
    DECLARE @UtcNow DATETIME2(7) = GETUTCDATE();

    UPDATE [dbo].[User]
    SET [PublicKey] = @PublicKey,
        [PrivateKey] = @PrivateKey,
        [RevisionDate] = @UtcNow,
        [AccountRevisionDate] = @UtcNow
    WHERE [Id] = @UserId
END