sp_AddUpdateRoleDefinition

BEGIN

    DECLARE _existingRoleId INT(11);

    SET _existingRoleId = (SELECT RoleDefinitionId FROM RoleDefinitions WHERE RoleDetectionGuid = argRoleDetectionGuid);

​

    if ISNULL(_existingRoleId) THEN

        INSERT INTO `RoleDefinitions` (`RoleName`, `RoleType`, `RoleSubType`, `DetectionString`, `ComparisonOperator`, `ComparisonResult`, `SerialKeyString`, `ProductKeyString`, `RoleDetectionGuid`, `IsRemote`, `SearchId`, `IsSupport`, `ParentRoleDefinitionGuid`) 

                VALUES(argRoleName, argRoleType,argRoleSubType,argDetectionString,argComparisonOperator,argComparisonResult,argSerialKeyString,argProductKeyString,argRoleDetectionGuid,argIsRemote,argSearchId,argIsSupport,argParentRoleDefinitionGuid);

    ELSE

        Update RoleDefinitions 

        SET

            RoleName = argRoleName, RoleType = argRoleType, RoleSubType = argRoleSubType, DetectionString = argDetectionString,

            ComparisonOperator = argComparisonOperator, ComparisonResult = argComparisonResult, SerialKeyString = argSerialKeyString,

            ProductKeyString = argProductKeyString, RoleDetectionGuid = argRoleDetectionGuid, IsRemote = argIsRemote, SearchId = argSearchId, 

            IsSupport = argIsSupport, ParentRoleDefinitionGuid = argParentRoleDefinitionGuid

        WHERE

            RoleDefinitionId = _existingRoleId;

    END IF;

​

END