From: Andrew Dunstan Date: Mon, 11 Oct 2010 20:56:09 +0000 (+0000) Subject: remove redundant file X-Git-Url: https://git.exim.org/buildfarm-server.git/commitdiff_plain/05882f7025c36d8eb175bba2d4e6e1accd21e853?ds=sidebyside remove redundant file --- diff --git a/cgi-bin/bfschmema b/cgi-bin/bfschmema deleted file mode 100644 index 1af2bcf..0000000 --- a/cgi-bin/bfschmema +++ /dev/null @@ -1,274 +0,0 @@ --- --- PostgreSQL database dump --- - -SET client_encoding = 'SQL_ASCII'; -SET check_function_bodies = false; - -SET SESSION AUTHORIZATION 'pgbuildfarm'; - -SET search_path = public, pg_catalog; - --- --- TOC entry 21 (OID 46831) --- Name: plpgsql_call_handler(); Type: FUNC PROCEDURAL LANGUAGE; Schema: public; Owner: pgbuildfarm --- - -CREATE FUNCTION plpgsql_call_handler() RETURNS language_handler - AS '$libdir/plpgsql', 'plpgsql_call_handler' - LANGUAGE c; - - --- --- TOC entry 22 (OID 46833) --- Name: plperl_call_handler(); Type: FUNC PROCEDURAL LANGUAGE; Schema: public; Owner: pgbuildfarm --- - -CREATE FUNCTION plperl_call_handler() RETURNS language_handler - AS '$libdir/plperl', 'plperl_call_handler' - LANGUAGE c; - - -SET SESSION AUTHORIZATION DEFAULT; - --- --- TOC entry 16 (OID 46832) --- Name: plpgsql; Type: PROCEDURAL LANGUAGE; Schema: public; Owner: --- - -CREATE TRUSTED PROCEDURAL LANGUAGE plpgsql HANDLER plpgsql_call_handler; - - --- --- TOC entry 17 (OID 46834) --- Name: plperl; Type: PROCEDURAL LANGUAGE; Schema: public; Owner: --- - -CREATE TRUSTED PROCEDURAL LANGUAGE plperl HANDLER plperl_call_handler; - - --- --- TOC entry 18 (OID 46835) --- Name: plperlu; Type: PROCEDURAL LANGUAGE; Schema: public; Owner: --- - -CREATE PROCEDURAL LANGUAGE plperlu HANDLER plperl_call_handler; - - -SET SESSION AUTHORIZATION 'pgbuildfarm'; - --- --- TOC entry 4 (OID 2200) --- Name: public; Type: ACL; Schema: -; Owner: pgbuildfarm --- - -REVOKE ALL ON SCHEMA public FROM PUBLIC; -GRANT ALL ON SCHEMA public TO PUBLIC; - - -SET SESSION AUTHORIZATION 'pgbuildfarm'; - --- --- TOC entry 7 (OID 17150) --- Name: buildsystems; Type: TABLE; Schema: public; Owner: pgbuildfarm --- - -CREATE TABLE buildsystems ( - name text NOT NULL, - secret text NOT NULL, - operating_system text NOT NULL, - os_version text NOT NULL, - compiler text NOT NULL, - compiler_version text NOT NULL, - architecture text NOT NULL, - status text NOT NULL, - sys_owner text NOT NULL, - owner_email text NOT NULL, - status_ts timestamp without time zone DEFAULT (('now'::text)::timestamp(6) with time zone)::timestamp without time zone -); - - --- --- TOC entry 8 (OID 17150) --- Name: buildsystems; Type: ACL; Schema: public; Owner: pgbuildfarm --- - -REVOKE ALL ON TABLE buildsystems FROM PUBLIC; -GRANT INSERT,SELECT ON TABLE buildsystems TO pgbfweb; - - -SET SESSION AUTHORIZATION 'pgbuildfarm'; - --- --- TOC entry 9 (OID 17155) --- Name: build_status; Type: TABLE; Schema: public; Owner: pgbuildfarm --- - -CREATE TABLE build_status ( - sysname text NOT NULL, - snapshot timestamp without time zone NOT NULL, - status integer, - stage text, - log text, - conf_sum text, - branch text, - changed_this_run text, - changed_since_success text, - log_archive bytea, - log_archive_filenames text[], - build_flags text[] -); - - --- --- TOC entry 10 (OID 17155) --- Name: build_status; Type: ACL; Schema: public; Owner: pgbuildfarm --- - -REVOKE ALL ON TABLE build_status FROM PUBLIC; -GRANT INSERT,SELECT ON TABLE build_status TO pgbfweb; - - -SET SESSION AUTHORIZATION 'pgbuildfarm'; - --- --- TOC entry 19 (OID 17160) --- Name: approve(text, text); Type: FUNCTION; Schema: public; Owner: pgbuildfarm --- - -CREATE FUNCTION approve(text, text) RETURNS void - AS 'update buildsystems set name = $2, status =''approved'' where name = $1 and status = ''pending''' - LANGUAGE sql; - - --- --- TOC entry 5 (OID 17162) --- Name: pending; Type: TYPE; Schema: public; Owner: pgbuildfarm --- - -CREATE TYPE pending AS ( - name text, - operating_system text, - os_version text, - compiler text, - compiler_version text, - architecture text, - owner_email text -); - - --- --- TOC entry 20 (OID 17164) --- Name: approve2(text, text); Type: FUNCTION; Schema: public; Owner: pgbuildfarm --- - -CREATE FUNCTION approve2(text, text) RETURNS text - AS ' update buildsystems set name = $2, status = ''approved'' where name = $1 and status = ''pending''; select owner_email || '':'' || name || '':'' || secret from buildsystems where name = $2;' - LANGUAGE sql; - - --- --- TOC entry 6 (OID 47855) --- Name: pending2; Type: TYPE; Schema: public; Owner: pgbuildfarm --- - -CREATE TYPE pending2 AS ( - name text, - operating_system text, - os_version text, - compiler text, - compiler_version text, - architecture text, - owner_email text, - "owner" text, - status_ts timestamp without time zone -); - - --- --- TOC entry 23 (OID 47857) --- Name: pending(); Type: FUNCTION; Schema: public; Owner: pgbuildfarm --- - -CREATE FUNCTION pending() RETURNS SETOF pending2 - AS 'select name,operating_system,os_version,compiler,compiler_version,architecture,owner_email, sys_owner, status_ts from buildsystems where status = ''pending'' order by status_ts ' - LANGUAGE sql; - - --- --- TOC entry 11 (OID 49741) --- Name: list_subscriptions; Type: TABLE; Schema: public; Owner: pgbuildfarm --- - -CREATE TABLE list_subscriptions ( - addr text -); - - --- --- TOC entry 24 (OID 55330) --- Name: prevstat(text, text, timestamp without time zone); Type: FUNCTION; Schema: public; Owner: pgbuildfarm --- - -CREATE FUNCTION prevstat(text, text, timestamp without time zone) RETURNS text - AS ' - select coalesce((select distinct on (snapshot) stage - from build_status - where sysname = $1 and branch = $2 and snapshot < $3 - order by snapshot desc - limit 1), ''NEW'') as prev_status -' - LANGUAGE sql; - - --- --- TOC entry 13 (OID 23365) --- Name: bs_branch_snapshot_idx; Type: INDEX; Schema: public; Owner: pgbuildfarm --- - -CREATE INDEX bs_branch_snapshot_idx ON build_status USING btree (branch, snapshot); - - --- --- TOC entry 14 (OID 23366) --- Name: bs_sysname_branch_idx; Type: INDEX; Schema: public; Owner: pgbuildfarm --- - -CREATE INDEX bs_sysname_branch_idx ON build_status USING btree (sysname, branch); - - --- --- TOC entry 12 (OID 23367) --- Name: buildsystems_pkey; Type: CONSTRAINT; Schema: public; Owner: pgbuildfarm --- - -ALTER TABLE ONLY buildsystems - ADD CONSTRAINT buildsystems_pkey PRIMARY KEY (name); - - --- --- TOC entry 15 (OID 23369) --- Name: build_status_pkey; Type: CONSTRAINT; Schema: public; Owner: pgbuildfarm --- - -ALTER TABLE ONLY build_status - ADD CONSTRAINT build_status_pkey PRIMARY KEY (sysname, snapshot); - - --- --- TOC entry 25 (OID 23371) --- Name: bs_fk; Type: FK CONSTRAINT; Schema: public; Owner: pgbuildfarm --- - -ALTER TABLE ONLY build_status - ADD CONSTRAINT bs_fk FOREIGN KEY (sysname) REFERENCES buildsystems(name) ON UPDATE CASCADE ON DELETE CASCADE; - - --- --- TOC entry 3 (OID 2200) --- Name: SCHEMA public; Type: COMMENT; Schema: -; Owner: pgbuildfarm --- - -COMMENT ON SCHEMA public IS 'Standard public schema'; - -