Auto-committed schema changes.

diff --git a/schema/roles.sql b/schema/roles.sql
index 88b3f0c7225f2ea276edd86a3399fb93e88aa902..b01b6f7ea2cc3e3759e69c52a7d32e1937ed6c1e 100644 (file)
--- a/schema/roles.sql
+++ b/schema/roles.sql
@@ -152,86 +152,64 @@ CREATE ROLE zobel;
 ALTER ROLE zobel WITH NOSUPERUSER INHERIT NOCREATEROLE NOCREATEDB LOGIN;
 CREATE ROLE zumbi;
 ALTER ROLE zumbi WITH NOSUPERUSER INHERIT NOCREATEROLE NOCREATEDB LOGIN;
 ALTER ROLE zobel WITH NOSUPERUSER INHERIT NOCREATEROLE NOCREATEDB LOGIN;
 CREATE ROLE zumbi;
 ALTER ROLE zumbi WITH NOSUPERUSER INHERIT NOCREATEROLE NOCREATEDB LOGIN;

-GRANT alpha TO buildd_alpha GRANTED BY wbadm;
-GRANT alpha TO kibi GRANTED BY wbadm;

 GRANT alpha TO wb_all GRANTED BY wbadm;
 GRANT alpha TO wb_all GRANTED BY wbadm;

-GRANT amd64 TO buildd_amd64 GRANTED BY wbadm;
-GRANT amd64 TO fs GRANTED BY wbadm;
-GRANT amd64 TO i386 GRANTED BY wbadm;
-GRANT amd64 TO kroeckx GRANTED BY wbadm;

 GRANT amd64 TO wb_all GRANTED BY wbadm;
 GRANT amd64 TO wb_all GRANTED BY wbadm;

-GRANT arm TO aurel32 GRANTED BY wbadm;
-GRANT arm TO buildd_arm GRANTED BY wbadm;
-GRANT arm TO colint GRANTED BY wbadm;
-GRANT arm TO riku GRANTED BY wbadm;

 GRANT arm TO wb_all GRANTED BY wbadm;
 GRANT arm TO wb_all GRANTED BY wbadm;

-GRANT arm TO wookey GRANTED BY wbadm;
-GRANT armel TO aurel32 GRANTED BY wbadm;
-GRANT armel TO buildd_armel GRANTED BY wbadm;
-GRANT armel TO colint GRANTED BY wbadm;
-GRANT armel TO riku GRANTED BY wbadm;

 GRANT armel TO wb_all GRANTED BY wbadm;
 GRANT armel TO wb_all GRANTED BY wbadm;

-GRANT armel TO wookey GRANTED BY wbadm;
-GRANT armel TO zumbi GRANTED BY wbadm;
-GRANT hppa TO buildd_hppa GRANTED BY wbadm;
-GRANT hppa TO dannf GRANTED BY wbadm;
-GRANT hppa TO lamont GRANTED BY wbadm;

 GRANT hppa TO wb_all GRANTED BY wbadm;
 GRANT hppa TO wb_all GRANTED BY wbadm;

-GRANT "hurd-i386" TO "buildd_hurd-i386" GRANTED BY wbadm;
-GRANT "hurd-i386" TO mbanck GRANTED BY wbadm;
-GRANT "hurd-i386" TO sthibault GRANTED BY wbadm;

 GRANT "hurd-i386" TO wb_all GRANTED BY wbadm;
 GRANT "hurd-i386" TO wb_all GRANTED BY wbadm;

-GRANT i386 TO buildd_i386 GRANTED BY wbadm;
-GRANT i386 TO kroeckx GRANTED BY wbadm;
-GRANT i386 TO pkern GRANTED BY wbadm;

 GRANT i386 TO wb_all GRANTED BY wbadm;
 GRANT i386 TO wb_all GRANTED BY wbadm;

-GRANT ia64 TO buildd_ia64 GRANTED BY wbadm;
-GRANT ia64 TO lamont GRANTED BY wbadm;

 GRANT ia64 TO wb_all GRANTED BY wbadm;
 GRANT ia64 TO wb_all GRANTED BY wbadm;

-GRANT "kfreebsd-amd64" TO aurel32 GRANTED BY wbadm;
-GRANT "kfreebsd-amd64" TO "buildd_kfreebsd-amd64" GRANTED BY wbadm;
-GRANT "kfreebsd-amd64" TO christoph GRANTED BY wbadm;
-GRANT "kfreebsd-amd64" TO kibi GRANTED BY wbadm;

 GRANT "kfreebsd-amd64" TO wb_all GRANTED BY wbadm;
 GRANT "kfreebsd-amd64" TO wb_all GRANTED BY wbadm;

-GRANT "kfreebsd-i386" TO aurel32 GRANTED BY wbadm;
-GRANT "kfreebsd-i386" TO "buildd_kfreebsd-i386" GRANTED BY wbadm;
-GRANT "kfreebsd-i386" TO christoph GRANTED BY wbadm;
-GRANT "kfreebsd-i386" TO kibi GRANTED BY wbadm;

 GRANT "kfreebsd-i386" TO wb_all GRANTED BY wbadm;
 GRANT "kfreebsd-i386" TO wb_all GRANTED BY wbadm;

-GRANT mips TO aba GRANTED BY wbadm;
-GRANT mips TO buildd_mips GRANTED BY wbadm;
-GRANT mips TO p2 GRANTED BY wbadm;

 GRANT mips TO wb_all GRANTED BY wbadm;
 GRANT mips TO wb_all GRANTED BY wbadm;

-GRANT mipsel TO aba GRANTED BY wbadm;
-GRANT mipsel TO buildd_mipsel GRANTED BY wbadm;

 GRANT mipsel TO wb_all GRANTED BY wbadm;
 GRANT mipsel TO wb_all GRANTED BY wbadm;

-GRANT powerpc TO buildd_powerpc GRANTED BY wbadm;
-GRANT powerpc TO pkern GRANTED BY wbadm;

 GRANT powerpc TO wb_all GRANTED BY wbadm;
 GRANT powerpc TO wb_all GRANTED BY wbadm;

-GRANT powerpc TO wouter GRANTED BY wbadm;
-GRANT s390 TO buildd_s390 GRANTED BY wbadm;
-GRANT s390 TO pkern GRANTED BY wbadm;
-GRANT s390 TO waldi GRANTED BY wbadm;

 GRANT s390 TO wb_all GRANTED BY wbadm;
 GRANT s390 TO wb_all GRANTED BY wbadm;

-GRANT sparc TO buildd_sparc GRANTED BY wbadm;
-GRANT sparc TO he GRANTED BY wbadm;
-GRANT sparc TO kibi GRANTED BY wbadm;

 GRANT sparc TO wb_all GRANTED BY wbadm;
 GRANT sparc TO wb_all GRANTED BY wbadm;

-GRANT sparc TO zobel GRANTED BY wbadm;

 GRANT wb_all TO adsb GRANTED BY wbadm;
 GRANT wb_all TO aurel32 GRANTED BY wbadm;
 GRANT wb_all TO adsb GRANTED BY wbadm;
 GRANT wb_all TO aurel32 GRANTED BY wbadm;

+GRANT wb_all TO buildd_alpha GRANTED BY wbadm;
+GRANT wb_all TO buildd_amd64 GRANTED BY wbadm;
+GRANT wb_all TO buildd_arm GRANTED BY wbadm;
+GRANT wb_all TO buildd_armel GRANTED BY wbadm;
+GRANT wb_all TO buildd_hppa GRANTED BY wbadm;
+GRANT wb_all TO "buildd_hurd-i386" GRANTED BY wbadm;
+GRANT wb_all TO buildd_i386 GRANTED BY wbadm;
+GRANT wb_all TO buildd_ia64 GRANTED BY wbadm;
+GRANT wb_all TO "buildd_kfreebsd-amd64" GRANTED BY wbadm;
+GRANT wb_all TO "buildd_kfreebsd-i386" GRANTED BY wbadm;
+GRANT wb_all TO buildd_mips GRANTED BY wbadm;
+GRANT wb_all TO buildd_mipsel GRANTED BY wbadm;
+GRANT wb_all TO buildd_powerpc GRANTED BY wbadm;
+GRANT wb_all TO buildd_s390 GRANTED BY wbadm;
+GRANT wb_all TO buildd_sparc GRANTED BY wbadm;
+GRANT wb_all TO christoph GRANTED BY wbadm;
+GRANT wb_all TO colint GRANTED BY wbadm;
+GRANT wb_all TO dannf GRANTED BY wbadm;
+GRANT wb_all TO fs GRANTED BY wbadm;

 GRANT wb_all TO glondu GRANTED BY wbadm;
 GRANT wb_all TO glondu GRANTED BY wbadm;

+GRANT wb_all TO he GRANTED BY wbadm;

 GRANT wb_all TO jcristau GRANTED BY wbadm;
 GRANT wb_all TO jwilk GRANTED BY wbadm;
 GRANT wb_all TO kibi GRANTED BY wbadm;
 GRANT wb_all TO kitterman GRANTED BY wbadm;
 GRANT wb_all TO kroeckx GRANTED BY wbadm;
 GRANT wb_all TO jcristau GRANTED BY wbadm;
 GRANT wb_all TO jwilk GRANTED BY wbadm;
 GRANT wb_all TO kibi GRANTED BY wbadm;
 GRANT wb_all TO kitterman GRANTED BY wbadm;
 GRANT wb_all TO kroeckx GRANTED BY wbadm;

+GRANT wb_all TO lamont GRANTED BY wbadm;

 GRANT wb_all TO luk GRANTED BY wbadm;
 GRANT wb_all TO luk GRANTED BY wbadm;

+GRANT wb_all TO mbanck GRANTED BY wbadm;

 GRANT wb_all TO mehdi GRANTED BY wbadm;
 GRANT wb_all TO nomeata GRANTED BY wbadm;
 GRANT wb_all TO mehdi GRANTED BY wbadm;
 GRANT wb_all TO nomeata GRANTED BY wbadm;

+GRANT wb_all TO p2 GRANTED BY wbadm;
+GRANT wb_all TO riku GRANTED BY wbadm;
+GRANT wb_all TO sthibault GRANTED BY wbadm;

 GRANT wb_all TO vorlon GRANTED BY wbadm;
 GRANT wb_all TO vorlon GRANTED BY wbadm;

+GRANT wb_all TO waldi GRANTED BY wbadm;

 GRANT wb_all TO wbadm GRANTED BY wbadm;
 GRANT wb_all TO wbadm GRANTED BY wbadm;

+GRANT wb_all TO wookey GRANTED BY wbadm;
+GRANT wb_all TO wouter GRANTED BY wbadm;

 GRANT wb_all TO zobel GRANTED BY wbadm;
 GRANT wb_all TO zobel GRANTED BY wbadm;

+GRANT wb_all TO zumbi GRANTED BY wbadm;

 GRANT wb_security TO dannf GRANTED BY wbadm;
 GRANT wb_security TO devin GRANTED BY wbadm;
 GRANT wb_security TO fw GRANTED BY wbadm;
 GRANT wb_security TO dannf GRANTED BY wbadm;
 GRANT wb_security TO devin GRANTED BY wbadm;
 GRANT wb_security TO fw GRANTED BY wbadm;

diff --git a/schema/wanna-build.sql b/schema/wanna-build.sql
index 58122512a60f8cd811c7d132d19a83196e2cbbe8..ba6b0f58df0efa30467e5ed6136fa602614208dc 100644 (file)
--- 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;
 
 
 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: 
 --
 --
 -- Name: distributions; Type: TABLE; Schema: public; Owner: wbadm; Tablespace: 
 --


@@ -2775,16 +2785,6 @@ CREATE VIEW log AS
 
 ALTER TABLE public.log OWNER TO wbadm;
 
 
 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;
 
 --
 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 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;
 
 
 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
 --
 --
 -- 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;
 
 
 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;
 
 --
 SET search_path = s390_public, pg_catalog;
 
 --