-- ------------------------------------------------------------------------------------------------------------------------------------
-- updated for 502 (PST5-122)

IF OBJECT_ID('[sp_info_updateLicence]', 'P') IS NOT NULL
DROP PROC [sp_info_updateLicence]
GO

-- Designed for use with Palace Stock Tracker only
-- Do not edit this stored procedure because it may be updated and changes will be lost
-- (C) 2021 Palace IT Limited
/*
Example:
EXEC sp_info_updateLicence @registrantName='Some Reuse Organisation' @keyCode='123456'
*/

CREATE PROCEDURE [dbo].[sp_info_updateLicence]
	@registrantName varchar(128) = NULL,
    @keyCode varchar(64) = NULL

AS
    IF @registrantName IS NULL
    BEGIN
        RAISERROR('@registrantName is required', 16, 1)
        RETURN
    END

    IF @keyCode IS NULL
    BEGIN
        RAISERROR('@keyCode is required', 16, 1)
        RETURN
    END

    UPDATE [_info] SET
    [RegistrantName] = @registrantName,
    [KeyCode] = @keyCode

GO

-- ------------------------------------------------------------------------------------------------------------------------------------