patch-testrun.sql
No OneTemporary
Actions

Size

958 B

Referenced Files

None

Subscribers

None

patch-testrun.sql
View Options

	--
	-- 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);