You can not select more than 25 topics
Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
69 lines
1.9 KiB
69 lines
1.9 KiB
IF COL_LENGTH('[dbo].[User]', 'MasterPasswordSalt') IS NULL |
|
BEGIN |
|
ALTER TABLE [dbo].[User] ADD [MasterPasswordSalt] NVARCHAR(256) NULL; |
|
END |
|
GO |
|
|
|
-- Update UserView to include MasterPasswordSalt |
|
CREATE OR ALTER VIEW [dbo].[UserView] |
|
AS |
|
SELECT |
|
[Id], |
|
[Name], |
|
[Email], |
|
[EmailVerified], |
|
[MasterPassword], |
|
[MasterPasswordHint], |
|
[Culture], |
|
[SecurityStamp], |
|
[TwoFactorProviders], |
|
[TwoFactorRecoveryCode], |
|
[EquivalentDomains], |
|
[ExcludedGlobalEquivalentDomains], |
|
[AccountRevisionDate], |
|
[Key], |
|
[PublicKey], |
|
[PrivateKey], |
|
[Premium], |
|
[PremiumExpirationDate], |
|
[RenewalReminderDate], |
|
[Storage], |
|
COALESCE([MaxStorageGbIncreased], [MaxStorageGb]) AS [MaxStorageGb], |
|
[Gateway], |
|
[GatewayCustomerId], |
|
[GatewaySubscriptionId], |
|
[ReferenceData], |
|
[LicenseKey], |
|
[ApiKey], |
|
[Kdf], |
|
[KdfIterations], |
|
[KdfMemory], |
|
[KdfParallelism], |
|
[CreationDate], |
|
[RevisionDate], |
|
[ForcePasswordReset], |
|
[UsesKeyConnector], |
|
[FailedLoginCount], |
|
[LastFailedLoginDate], |
|
[AvatarColor], |
|
[LastPasswordChangeDate], |
|
[LastKdfChangeDate], |
|
[LastKeyRotationDate], |
|
[LastEmailChangeDate], |
|
[VerifyDevices], |
|
[SecurityState], |
|
[SecurityVersion], |
|
[SignedPublicKey], |
|
[V2UpgradeToken], |
|
[MasterPasswordSalt] |
|
FROM |
|
[dbo].[User] |
|
GO |
|
|
|
-- Refresh views that depend on UserView to ensure they include the new MasterPasswordSalt column |
|
EXEC sp_refreshview N'[dbo].[EmergencyAccessDetailsView]'; |
|
EXEC sp_refreshview N'[dbo].[OrganizationUserUserDetailsView]'; |
|
EXEC sp_refreshview N'[dbo].[ProviderUserUserDetailsView]'; |
|
EXEC sp_refreshview N'[dbo].[UserEmailDomainView]'; |
|
EXEC sp_refreshview N'[dbo].[UserPremiumAccessView]'; |
|
GO
|
|
|