REG_LOG Table Cleanup Script

reg_log_cleanup.sql

CREATE TABLE REG_LOG_IDS_TO_KEEP (
             REG_LOG_ID INTEGER,
             REG_TENANT_ID INTEGER
);
 
INSERT INTO REG_LOG_IDS_TO_KEEP (REG_LOG_ID, REG_TENANT_ID)
SELECT MAX(REG_LOG_ID) AS REG_LOG_ID, REG_TENANT_ID FROM REG_LOG GROUP BY REG_PATH, REG_TENANT_ID;
 
DELETE FROM REG_LOG WHERE REG_LOG_ID NOT IN (SELECT REG_LOG_ID FROM REG_LOG_IDS_TO_KEEP);
DROP TABLE REG_LOG_IDS_TO_KEEP;
 
DELETE FROM REG_LOG WHERE REG_ACTION = 7;