Megatest

Check-in [1f6bb250f8]
Login
Overview
Comment:Adding table change_triggers to mt-pg.scm
Downloads: Tarball | ZIP archive | SQL archive
Timelines: family | ancestors | descendants | both | v1.65
Files: files | file ages | folders
SHA1: 1f6bb250f849ccfceb3ca03d383913896c7ca04b
User & Date: mrwellan on 2019-01-23 12:05:32
Other Links: branch diff | manifest | tags
Context
2019-01-23
15:16
fixed bug check-in: 430f66247c user: bjbarcla tags: v1.65, v1.6519
12:05
Adding table change_triggers to mt-pg.scm check-in: 1f6bb250f8 user: mrwellan tags: v1.65
2019-01-22
17:08
enabled strict syncing of last_update field check-in: 6d8663e151 user: bjbarcla tags: v1.65
Changes

Modified mt-pg.sql from [e33a6e6073] to [1ebd25a5ad].

100
101
102
103
104
105
106








107
108
109
110
111
112
113
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121







+
+
+
+
+
+
+
+







       event_time INTEGER DEFAULT extract(epoch from now()),
       comment    TEXT DEFAULT '',
       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,
       status TEXT,
       count  INTEGER,