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.
65 lines
1.3 KiB
65 lines
1.3 KiB
-- Remove Column |
|
IF COL_LENGTH('[dbo].[ApiKey]', 'ClientSecret') IS NOT NULL |
|
BEGIN |
|
ALTER TABLE |
|
[dbo].[ApiKey] |
|
DROP COLUMN |
|
[ClientSecret] |
|
END |
|
GO |
|
|
|
-- Refresh views |
|
IF OBJECT_ID('[dbo].[ApiKeyDetailsView]') IS NOT NULL |
|
BEGIN |
|
EXECUTE sp_refreshview N'[dbo].[ApiKeyDetailsView]'; |
|
END |
|
GO |
|
|
|
IF OBJECT_ID('[dbo].[ApiKeyView]') IS NOT NULL |
|
BEGIN |
|
EXECUTE sp_refreshview N'[dbo].[ApiKeyView]'; |
|
END |
|
GO |
|
|
|
CREATE OR ALTER PROCEDURE [dbo].[ApiKey_Create] |
|
@Id UNIQUEIDENTIFIER OUTPUT, |
|
@ServiceAccountId UNIQUEIDENTIFIER, |
|
@Name VARCHAR(200), |
|
@ClientSecretHash VARCHAR(128), |
|
@Scope NVARCHAR(4000), |
|
@EncryptedPayload NVARCHAR(4000), |
|
@Key VARCHAR(MAX), |
|
@ExpireAt DATETIME2(7), |
|
@CreationDate DATETIME2(7), |
|
@RevisionDate DATETIME2(7) |
|
AS |
|
BEGIN |
|
SET NOCOUNT ON |
|
|
|
INSERT INTO [dbo].[ApiKey] |
|
( |
|
[Id], |
|
[ServiceAccountId], |
|
[Name], |
|
[ClientSecretHash], |
|
[Scope], |
|
[EncryptedPayload], |
|
[Key], |
|
[ExpireAt], |
|
[CreationDate], |
|
[RevisionDate] |
|
) |
|
VALUES |
|
( |
|
@Id, |
|
@ServiceAccountId, |
|
@Name, |
|
@ClientSecretHash, |
|
@Scope, |
|
@EncryptedPayload, |
|
@Key, |
|
@ExpireAt, |
|
@CreationDate, |
|
@RevisionDate |
|
) |
|
END
|
|
|