USP_FEATUREUNLOCKEDBYPRODUCTFLAGS_ADD

CREATE procedure dbo.USP_FEATUREUNLOCKEDBYPRODUCTFLAGS_ADD
(
    @ID uniqueidentifier = null output,
    @FEATURESPECID uniqueidentifier,
    @FEATURESPECTYPECODE tinyint,
    @UNLOCKED bit = 1
)
as
begin
        set nocount on;

        declare @FOUNDID as uniqueidentifier;        
        select @FOUNDID = ID from dbo.[FEATUREUNLOCKEDBYPRODUCTFLAGS] where [FEATURESPECID] = @FEATURESPECID and [FEATURESPECTYPECODE] = @FEATURESPECTYPECODE;

        begin try
            if @FOUNDID is not null
            begin
                set @ID = @FOUNDID;

                update dbo.[FEATUREUNLOCKEDBYPRODUCTFLAGS] 
                set UNLOCKED = @UNLOCKED
                where ID = @ID;
            end
            else
            begin

                if @ID is null
                    set @ID = newid();

                insert into dbo.[FEATUREUNLOCKEDBYPRODUCTFLAGS]
                (
                    [ID],
                    [FEATURESPECID], 
                    [FEATURESPECTYPECODE],
                    [UNLOCKED]
                )
                values 
                (
                    @ID, 
                    @FEATURESPECID, 
                    @FEATURESPECTYPECODE,
                    @UNLOCKED
                );
            end

        end try

        begin catch
            exec dbo.USP_RAISE_ERROR;
            return 1;
        end catch        

        return 0;

end