Index: mt-pg.sql ================================================================== --- mt-pg.sql +++ mt-pg.sql @@ -102,10 +102,18 @@ fail_count INTEGER DEFAULT 0, pass_count INTEGER DEFAULT 0, last_update INTEGER DEFAULT extract(epoch from now()), area_id INTEGER DEFAULT 0, CONSTRAINT runsconstraint UNIQUE (target,ttype_id,run_name, area_id)); + +create Table if not exists change_triggers ( + id SERIAL PRIMARY KEY, + target TEXT NOT NULL, + area TEXT NOT NULL, + iteration INTEGER NOT NULL, + iteration_timestamp TIMESTAMP WITHOUT TIME ZONE DEFAULT now(), + reason TEXT Not null); CREATE TABLE IF NOT EXISTS run_stats ( id SERIAL PRIMARY KEY, run_id INTEGER, state TEXT,