-- -- PostgreSQL database dump -- -- Dumped from database version 9.6.7 -- Dumped by pg_dump version 9.6.7 SET statement_timeout = 0; SET lock_timeout = 0; SET idle_in_transaction_session_timeout = 0; SET client_encoding = 'UTF8'; SET standard_conforming_strings = on; SET check_function_bodies = false; SET client_min_messages = warning; SET row_security = off; -- -- Name: plpgsql; Type: EXTENSION; Schema: -; Owner: -- CREATE EXTENSION IF NOT EXISTS plpgsql WITH SCHEMA pg_catalog; -- -- Name: EXTENSION plpgsql; Type: COMMENT; Schema: -; Owner: -- COMMENT ON EXTENSION plpgsql IS 'PL/pgSQL procedural language'; SET search_path = public, pg_catalog; SET default_tablespace = ''; SET default_with_oids = false; -- -- Name: flights; Type: TABLE; Schema: public; Owner: osstest -- CREATE TABLE flights ( flight integer NOT NULL, started integer DEFAULT 0 NOT NULL, blessing text DEFAULT 'unknown'::text NOT NULL, branch text NOT NULL, intended text ); ALTER TABLE flights OWNER TO osstest; -- -- Name: flights_flight_seq; Type: SEQUENCE; Schema: public; Owner: osstest -- CREATE SEQUENCE flights_flight_seq START WITH 50001 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1; ALTER TABLE flights_flight_seq OWNER TO osstest; -- -- Name: flights_flight_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: osstest -- ALTER SEQUENCE flights_flight_seq OWNED BY flights.flight; -- -- Name: flights_harness_touched; Type: TABLE; Schema: public; Owner: osstest -- CREATE TABLE flights_harness_touched ( flight integer NOT NULL, harness text NOT NULL ); ALTER TABLE flights_harness_touched OWNER TO osstest; -- -- Name: hostflags; Type: TABLE; Schema: public; Owner: osstest -- CREATE TABLE hostflags ( hostname text NOT NULL, hostflag text NOT NULL ); ALTER TABLE hostflags OWNER TO osstest; -- -- Name: jobs; Type: TABLE; Schema: public; Owner: osstest -- CREATE TABLE jobs ( flight integer NOT NULL, job character varying NOT NULL, recipe text, status text DEFAULT 'stopped'::text NOT NULL ); ALTER TABLE jobs OWNER TO osstest; -- -- Name: resource_properties; Type: TABLE; Schema: public; Owner: osstest -- CREATE TABLE resource_properties ( restype text NOT NULL, resname text NOT NULL, name text NOT NULL, val text NOT NULL ); ALTER TABLE resource_properties OWNER TO osstest; -- -- Name: resource_sharing; Type: TABLE; Schema: public; Owner: osstest -- CREATE TABLE resource_sharing ( restype text NOT NULL, resname text NOT NULL, sharetype text NOT NULL, wear integer DEFAULT 0 NOT NULL, state text NOT NULL, harness character varying ); ALTER TABLE resource_sharing OWNER TO osstest; -- -- Name: resources; Type: TABLE; Schema: public; Owner: osstest -- CREATE TABLE resources ( restype text NOT NULL, resname text NOT NULL, shareix integer DEFAULT 0 NOT NULL, owntaskid integer NOT NULL, subtask text DEFAULT ''::text NOT NULL, CONSTRAINT resources_check CHECK (((shareix = 0) OR (restype ~~ 'share-%'::text))) ); ALTER TABLE resources OWNER TO osstest; -- -- Name: runvars; Type: TABLE; Schema: public; Owner: osstest -- CREATE TABLE runvars ( flight integer NOT NULL, job character varying NOT NULL, name character varying NOT NULL, val character varying, synth boolean NOT NULL ); ALTER TABLE runvars OWNER TO osstest; -- -- Name: schema_updates; Type: TABLE; Schema: public; Owner: osstest -- CREATE TABLE schema_updates ( updatename text NOT NULL, applytime integer NOT NULL ); ALTER TABLE schema_updates OWNER TO osstest; -- -- Name: steps; Type: TABLE; Schema: public; Owner: osstest -- CREATE TABLE steps ( flight integer NOT NULL, job character varying NOT NULL, stepno integer NOT NULL, step character varying NOT NULL, status character varying NOT NULL, testid text NOT NULL, started integer, finished integer, logfile text NOT NULL ); ALTER TABLE steps OWNER TO osstest; -- -- Name: tasks_taskid_seq; Type: SEQUENCE; Schema: public; Owner: osstest -- CREATE SEQUENCE tasks_taskid_seq START WITH 10 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1; ALTER TABLE tasks_taskid_seq OWNER TO osstest; -- -- Name: tasks; Type: TABLE; Schema: public; Owner: osstest -- CREATE TABLE tasks ( taskid integer DEFAULT nextval('tasks_taskid_seq'::regclass) NOT NULL, type text NOT NULL, refkey text NOT NULL, username text, comment text, live boolean NOT NULL, refinfo text ); ALTER TABLE tasks OWNER TO osstest; -- -- Name: flights flight; Type: DEFAULT; Schema: public; Owner: osstest -- ALTER TABLE ONLY flights ALTER COLUMN flight SET DEFAULT nextval('flights_flight_seq'::regclass); -- -- Name: flights_harness_touched flights_harness_touched_pkey; Type: CONSTRAINT; Schema: public; Owner: osstest -- ALTER TABLE ONLY flights_harness_touched ADD CONSTRAINT flights_harness_touched_pkey PRIMARY KEY (flight, harness); -- -- Name: flights flights_pkey; Type: CONSTRAINT; Schema: public; Owner: osstest -- ALTER TABLE ONLY flights ADD CONSTRAINT flights_pkey PRIMARY KEY (flight); -- -- Name: jobs jobs_pkey; Type: CONSTRAINT; Schema: public; Owner: osstest -- ALTER TABLE ONLY jobs ADD CONSTRAINT jobs_pkey PRIMARY KEY (flight, job); -- -- Name: resource_properties resource_properties_pkey; Type: CONSTRAINT; Schema: public; Owner: osstest -- ALTER TABLE ONLY resource_properties ADD CONSTRAINT resource_properties_pkey PRIMARY KEY (restype, resname, name); -- -- Name: resource_sharing resource_sharing_pkey; Type: CONSTRAINT; Schema: public; Owner: osstest -- ALTER TABLE ONLY resource_sharing ADD CONSTRAINT resource_sharing_pkey PRIMARY KEY (restype, resname); -- -- Name: resources resources_pkey; Type: CONSTRAINT; Schema: public; Owner: osstest -- ALTER TABLE ONLY resources ADD CONSTRAINT resources_pkey PRIMARY KEY (restype, resname, shareix); -- -- Name: runvars runvars_pkey; Type: CONSTRAINT; Schema: public; Owner: osstest -- ALTER TABLE ONLY runvars ADD CONSTRAINT runvars_pkey PRIMARY KEY (flight, job, name); -- -- Name: schema_updates schema_updates_pkey; Type: CONSTRAINT; Schema: public; Owner: osstest -- ALTER TABLE ONLY schema_updates ADD CONSTRAINT schema_updates_pkey PRIMARY KEY (updatename); -- -- Name: steps steps_flight_key; Type: CONSTRAINT; Schema: public; Owner: osstest -- ALTER TABLE ONLY steps ADD CONSTRAINT steps_flight_key UNIQUE (flight, job, testid); -- -- Name: steps steps_pkey; Type: CONSTRAINT; Schema: public; Owner: osstest -- ALTER TABLE ONLY steps ADD CONSTRAINT steps_pkey PRIMARY KEY (flight, job, stepno); -- -- Name: tasks tasks_pkey; Type: CONSTRAINT; Schema: public; Owner: osstest -- ALTER TABLE ONLY tasks ADD CONSTRAINT tasks_pkey PRIMARY KEY (taskid); -- -- Name: hostflags_flag_index; Type: INDEX; Schema: public; Owner: osstest -- CREATE INDEX hostflags_flag_index ON hostflags USING btree (hostflag); -- -- Name: hostflags_host_flag_index; Type: INDEX; Schema: public; Owner: osstest -- CREATE INDEX hostflags_host_flag_index ON hostflags USING btree (hostname, hostflag); -- -- Name: tasks_type_refkey_live_index; Type: INDEX; Schema: public; Owner: osstest -- CREATE UNIQUE INDEX tasks_type_refkey_live_index ON tasks USING btree (type, refkey) WHERE live; -- -- Name: tasks_type_taskid; Type: INDEX; Schema: public; Owner: osstest -- CREATE INDEX tasks_type_taskid ON tasks USING btree (type, taskid); -- -- Name: resources resources_owntaskid_fkey; Type: FK CONSTRAINT; Schema: public; Owner: osstest -- ALTER TABLE ONLY resources ADD CONSTRAINT resources_owntaskid_fkey FOREIGN KEY (owntaskid) REFERENCES tasks(taskid); -- -- Name: steps steps_flight_fkey; Type: FK CONSTRAINT; Schema: public; Owner: osstest -- ALTER TABLE ONLY steps ADD CONSTRAINT steps_flight_fkey FOREIGN KEY (flight, job) REFERENCES jobs(flight, job); -- -- Name: TABLE flights; Type: ACL; Schema: public; Owner: osstest -- GRANT SELECT ON TABLE flights TO osstest_ro; -- -- Name: SEQUENCE flights_flight_seq; Type: ACL; Schema: public; Owner: osstest -- GRANT SELECT ON SEQUENCE flights_flight_seq TO osstest_ro; -- -- Name: TABLE flights_harness_touched; Type: ACL; Schema: public; Owner: osstest -- GRANT SELECT ON TABLE flights_harness_touched TO osstest_ro; -- -- Name: TABLE hostflags; Type: ACL; Schema: public; Owner: osstest -- GRANT SELECT ON TABLE hostflags TO osstest_ro; -- -- Name: TABLE jobs; Type: ACL; Schema: public; Owner: osstest -- GRANT SELECT ON TABLE jobs TO osstest_ro; -- -- Name: TABLE resource_properties; Type: ACL; Schema: public; Owner: osstest -- GRANT SELECT ON TABLE resource_properties TO osstest_ro; -- -- Name: TABLE resource_sharing; Type: ACL; Schema: public; Owner: osstest -- GRANT SELECT ON TABLE resource_sharing TO osstest_ro; -- -- Name: TABLE resources; Type: ACL; Schema: public; Owner: osstest -- GRANT SELECT ON TABLE resources TO osstest_ro; -- -- Name: TABLE runvars; Type: ACL; Schema: public; Owner: osstest -- GRANT SELECT ON TABLE runvars TO osstest_ro; -- -- Name: TABLE steps; Type: ACL; Schema: public; Owner: osstest -- GRANT SELECT ON TABLE steps TO osstest_ro; -- -- Name: SEQUENCE tasks_taskid_seq; Type: ACL; Schema: public; Owner: osstest -- GRANT SELECT ON SEQUENCE tasks_taskid_seq TO osstest_ro; -- -- Name: TABLE tasks; Type: ACL; Schema: public; Owner: osstest -- GRANT SELECT ON TABLE tasks TO osstest_ro; -- -- PostgreSQL database dump complete --