maintenance/postgres/archives/patch-testrun.sql


1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30

--
-- Optional tables for parserTests recording mode
-- With --record option, success data will be saved to these tables,
-- and comparisons of what's changed from the previous run will be
-- displayed at the end of each run.
--
-- This file is for the Postgres version of the tables
--

-- Note: "if exists" will not work on older versions of Postgres
DROP TABLE IF EXISTS testitem;
DROP TABLE IF EXISTS testrun;
DROP SEQUENCE IF EXISTS testrun_id_seq;

CREATE SEQUENCE testrun_id_seq;
CREATE TABLE testrun (
  tr_id           INTEGER PRIMARY KEY NOT NULL DEFAULT nextval('testrun_id_seq'),
  tr_date         TIMESTAMPTZ,
  tr_mw_version   TEXT,
  tr_php_version  TEXT,
  tr_db_version   TEXT,
  tr_uname        TEXT
);

CREATE TABLE testitem (
  ti_run      INTEGER   NOT NULL REFERENCES testrun(tr_id) ON DELETE CASCADE,
  ti_name     TEXT      NOT NULL,
  ti_success  SMALLINT  NOT NULL
);  
CREATE UNIQUE INDEX testitem_uniq ON testitem(ti_run, ti_name);