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
       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 run_stats (
       id     SERIAL PRIMARY KEY,
       run_id INTEGER,
       state  TEXT,
       status TEXT,
       count  INTEGER,







>
>
>
>
>
>
>
>







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,