X-Git-Url: https://git.donarmstrong.com/?a=blobdiff_plain;f=schema%2Fwanna-build.sql;fp=schema%2Fwanna-build.sql;h=ba6b0f58df0efa30467e5ed6136fa602614208dc;hb=c7027081dd29d75e2aaa237ed5ea7f1b42f15880;hp=58122512a60f8cd811c7d132d19a83196e2cbbe8;hpb=f182f92255fb1e71ae7c55e9a0259613f0ff0179;p=wannabuild.git diff --git a/schema/wanna-build.sql b/schema/wanna-build.sql index 5812251..ba6b0f5 100644 --- a/schema/wanna-build.sql +++ b/schema/wanna-build.sql @@ -2672,6 +2672,16 @@ CREATE VIEW distribution_architectures AS ALTER TABLE public.distribution_architectures OWNER TO wbadm; +-- +-- Name: distribution_architectures_statistics; Type: VIEW; Schema: public; Owner: wbadm +-- + +CREATE VIEW distribution_architectures_statistics AS + SELECT distribution_architectures.distribution, distribution_architectures.architecture, distribution_architectures.needsbuild, distribution_architectures.notinstalled FROM distribution_architectures; + + +ALTER TABLE public.distribution_architectures_statistics OWNER TO wbadm; + -- -- Name: distributions; Type: TABLE; Schema: public; Owner: wbadm; Tablespace: -- @@ -2775,16 +2785,6 @@ CREATE VIEW log AS ALTER TABLE public.log OWNER TO wbadm; --- --- Name: log_v2; Type: VIEW; Schema: public; Owner: pkern --- - -CREATE VIEW log_v2 AS - (((((((((((((SELECT pkg_history.package, pkg_history.distribution, pkg_history.version, pkg_history."timestamp", pkg_history.result, 'alpha'::character varying AS architecture FROM alpha_public.pkg_history UNION ALL SELECT pkg_history.package, pkg_history.distribution, pkg_history.version, pkg_history."timestamp", pkg_history.result, 'amd64'::character varying AS architecture FROM amd64_public.pkg_history) UNION ALL SELECT pkg_history.package, pkg_history.distribution, pkg_history.version, pkg_history."timestamp", pkg_history.result, 'arm'::character varying AS architecture FROM arm_public.pkg_history) UNION ALL SELECT pkg_history.package, pkg_history.distribution, pkg_history.version, pkg_history."timestamp", pkg_history.result, 'armel'::character varying AS architecture FROM armel_public.pkg_history) UNION ALL SELECT pkg_history.package, pkg_history.distribution, pkg_history.version, pkg_history."timestamp", pkg_history.result, 'hppa'::character varying AS architecture FROM hppa_public.pkg_history) UNION ALL SELECT pkg_history.package, pkg_history.distribution, pkg_history.version, pkg_history."timestamp", pkg_history.result, 'hurd-i386'::character varying AS architecture FROM "hurd-i386_public".pkg_history) UNION ALL SELECT pkg_history.package, pkg_history.distribution, pkg_history.version, pkg_history."timestamp", pkg_history.result, 'i386'::character varying AS architecture FROM i386_public.pkg_history) UNION ALL SELECT pkg_history.package, pkg_history.distribution, pkg_history.version, pkg_history."timestamp", pkg_history.result, 'ia64'::character varying AS architecture FROM ia64_public.pkg_history) UNION ALL SELECT pkg_history.package, pkg_history.distribution, pkg_history.version, pkg_history."timestamp", pkg_history.result, 'kfreebsd-amd64'::character varying AS architecture FROM "kfreebsd-amd64_public".pkg_history) UNION ALL SELECT pkg_history.package, pkg_history.distribution, pkg_history.version, pkg_history."timestamp", pkg_history.result, 'kfreebsd-i386'::character varying AS architecture FROM "kfreebsd-i386_public".pkg_history) UNION ALL SELECT pkg_history.package, pkg_history.distribution, pkg_history.version, pkg_history."timestamp", pkg_history.result, 'mips'::character varying AS architecture FROM mips_public.pkg_history) UNION ALL SELECT pkg_history.package, pkg_history.distribution, pkg_history.version, pkg_history."timestamp", pkg_history.result, 'mipsel'::character varying AS architecture FROM mipsel_public.pkg_history) UNION ALL SELECT pkg_history.package, pkg_history.distribution, pkg_history.version, pkg_history."timestamp", pkg_history.result, 'powerpc'::character varying AS architecture FROM powerpc_public.pkg_history) UNION ALL SELECT pkg_history.package, pkg_history.distribution, pkg_history.version, pkg_history."timestamp", pkg_history.result, 's390'::character varying AS architecture FROM s390_public.pkg_history) UNION ALL SELECT pkg_history.package, pkg_history.distribution, pkg_history.version, pkg_history."timestamp", pkg_history.result, 'sparc'::character varying AS architecture FROM sparc_public.pkg_history ORDER BY 4 DESC; - - -ALTER TABLE public.log_v2 OWNER TO pkern; - SET search_path = s390_public, pg_catalog; -- @@ -4478,6 +4478,7 @@ REVOKE ALL ON TABLE pkg_history FROM wbadm; GRANT ALL ON TABLE pkg_history TO wbadm; GRANT ALL ON TABLE pkg_history TO alpha; GRANT SELECT ON TABLE pkg_history TO wb_security; +GRANT SELECT,INSERT,UPDATE ON TABLE pkg_history TO wb_all; -- @@ -5637,6 +5638,16 @@ GRANT ALL ON TABLE distribution_architectures TO wbadm; GRANT SELECT ON TABLE distribution_architectures TO PUBLIC; +-- +-- Name: distribution_architectures_statistics; Type: ACL; Schema: public; Owner: wbadm +-- + +REVOKE ALL ON TABLE distribution_architectures_statistics FROM PUBLIC; +REVOKE ALL ON TABLE distribution_architectures_statistics FROM wbadm; +GRANT ALL ON TABLE distribution_architectures_statistics TO wbadm; +GRANT SELECT ON TABLE distribution_architectures_statistics TO PUBLIC; + + -- -- Name: distributions; Type: ACL; Schema: public; Owner: wbadm -- @@ -5719,16 +5730,6 @@ GRANT ALL ON TABLE log TO wbadm; GRANT SELECT ON TABLE log TO PUBLIC; --- --- Name: log_v2; Type: ACL; Schema: public; Owner: pkern --- - -REVOKE ALL ON TABLE log_v2 FROM PUBLIC; -REVOKE ALL ON TABLE log_v2 FROM pkern; -GRANT ALL ON TABLE log_v2 TO pkern; -GRANT SELECT ON TABLE log_v2 TO PUBLIC; - - SET search_path = s390_public, pg_catalog; --