DROP PROCEDURE IF EXISTS hst_prodfix_addnew
GO
 
CREATE PROCEDURE `hst_prodfix_addnew` (
    IN `__vtmp_nHostId` BIGINT,
    IN `__vtmp_nProductId` INT,
    IN `__vtmp_wstrDN` VARCHAR(256) UNICODE,
    IN `__vtmp_strID` VARCHAR(64),
    IN `__vtmp_nOrder` INT,
    IN `__vtmp_tmTimestamp` DATETIME(3),
    IN `__vtmp_nVServerId` INT)
BEGIN
   
    DECLARE _st_AutoCommit INT;
 
    SELECT @@session.autocommit INTO _st_AutoCommit;
    IF (`__vtmp_strID` NOT LIKE _utf8'PDKPATCH_%' ) THEN
        IF 0 <> _st_AutoCommit THEN SET AUTOCOMMIT = 0; END IF ;
        IF EXISTS (SELECT *  FROM `Hosts` WHERE `nId` = `__vtmp_nHostId`  FOR UPDATE ) THEN
            INSERT INTO `hst_host_prd_fixes` ( `nHostId` , `nProductId` , `wstrDN` , `strID` , `nOrder` ) VALUES ( `__vtmp_nHostId` , `__vtmp_nProductId` , `__vtmp_wstrDN` , `__vtmp_strID` , `__vtmp_nOrder` );
            CALL `klupd_add_kscp_installed` ( `__vtmp_nHostId`, `__vtmp_nProductId`, `__vtmp_wstrDN`, `__vtmp_strID`, `__vtmp_tmTimestamp`, `__vtmp_nVServerId`);
        END IF;
        IF 0 <> _st_AutoCommit THEN COMMIT; SET AUTOCOMMIT = 1; END IF ;
    END IF;
END
GO
 
 
DROP PROCEDURE IF EXISTS ptch_fix_old_pdk_patches
GO
 
CREATE PROCEDURE `ptch_fix_old_pdk_patches` ()
BEGIN
    DELETE FROM `klupd_update` WHERE `strKscpUid` LIKE _utf8'PDKPATCH_%' ;
END
GO
 
CALL `ptch_fix_old_pdk_patches` ();