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: |
1f6bb250f849ccfceb3ca03d38391389 |
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, |
︙ | ︙ |