BEGIN;

UPDATE
    backend.autodetect_custom_metrics
SET
    metric = REPLACE(metric, 'Unique.SrcAddr', 'Unique.SrcAddr.In')
WHERE
    metric LIKE '%.Unique.SrcAddr.On'
    OR metric LIKE '%.Unique.SrcAddr.Off'
    OR metric LIKE '%.Unique.SrcAddr.Diff';
    
UPDATE
    backend.autodetect_custom_metrics
SET
    metric = REPLACE(metric, 'PerSrcAddrBps', 'PerSrcAddrInBps')
WHERE
    metric LIKE '%.PerSrcAddrBps.On'
    OR metric LIKE '%.PerSrcAddrBps.Off';  
    
UPDATE
    backend.autodetect_custom_metrics
SET
    metric = REPLACE(metric, 'PerSrcAddrPps', 'PerSrcAddrInPps')
WHERE
    metric LIKE '%.PerSrcAddrPps.On'
    OR metric LIKE '%.PerSrcAddrPps.Off';  

COMMIT;
