CREATE TABLE IF NOT EXISTS ei_remediation_actions (id INTEGER PRIMARY KEY AUTOINCREMENT, object BLOB NOT NULL);
CREATE TABLE IF NOT EXISTS ei_remediation_counters (id TEXT PRIMARY KEY, cnt INT NOT NULL);
INSERT OR IGNORE INTO ei_remediation_counters(id, cnt) VALUES ('blob_size', 0), ('blob_cnt', 0);

CREATE TRIGGER IF NOT EXISTS update_counters_on_ei_remediation_insert
AFTER INSERT ON ei_remediation_actions FOR EACH ROW
BEGIN
    UPDATE ei_remediation_counters SET cnt = cnt + length(NEW.object) WHERE id = 'blob_size';
    UPDATE ei_remediation_counters SET cnt = cnt + 1 WHERE id = 'blob_cnt';
END;

CREATE TRIGGER IF NOT EXISTS update_counters_on_ei_remediation_delete
AFTER DELETE ON ei_remediation_actions FOR EACH ROW
BEGIN
    UPDATE ei_remediation_counters SET cnt = cnt - length(OLD.object) WHERE id = 'blob_size';
    UPDATE ei_remediation_counters SET cnt = cnt - 1 WHERE id = 'blob_cnt';
END;