Auto-committed schema changes.

diff --git a/schema/roles.sql b/schema/roles.sql
index fb24983fa2eab8f1d4fb2472e56105e65472edbc..b01b6f7ea2cc3e3759e69c52a7d32e1937ed6c1e 100644 (file)
--- a/schema/roles.sql
+++ b/schema/roles.sql
@@ -219,7 +219,6 @@ GRANT wb_security TO jmm GRANTED BY wbadm;
 GRANT wb_security TO joey GRANTED BY wbadm;
 GRANT wb_security TO nion GRANTED BY wbadm;
 GRANT wb_security TO noahm GRANTED BY wbadm;
-GRANT wb_security TO pkern GRANTED BY wbadm;
 GRANT wb_security TO seb GRANTED BY wbadm;
 GRANT wb_security TO sf GRANTED BY wbadm;
 GRANT wb_security TO thijs GRANTED BY wbadm;

diff --git a/schema/wanna-build.sql b/schema/wanna-build.sql
index cdc334a56577d96beaa856bf46ac001fa77dbe0d..f3862fde59266f80d5c00955108081a2dc0700c5 100644 (file)
--- a/schema/wanna-build.sql
+++ b/schema/wanna-build.sql
@@ -2064,6 +2064,17 @@ ALTER TABLE powerpc_public.users OWNER TO wbadm;
 
 SET search_path = public, pg_catalog;
 
+--
+-- Name: architectures; Type: TABLE; Schema: public; Owner: wbadm; Tablespace: 
+--
+
+CREATE TABLE architectures (
+    architecture character varying NOT NULL
+);
+
+
+ALTER TABLE public.architectures OWNER TO wbadm;
+
 --
 -- Name: distribution_aliases; Type: TABLE; Schema: public; Owner: wbadm; Tablespace: 
 --
@@ -2308,6 +2319,14 @@ ALTER TABLE sparc_public.users OWNER TO wbadm;
 
 SET search_path = public, pg_catalog;
 
+--
+-- Name: architectures_pkey; Type: CONSTRAINT; Schema: public; Owner: wbadm; Tablespace: 
+--
+
+ALTER TABLE ONLY architectures
+    ADD CONSTRAINT architectures_pkey PRIMARY KEY (architecture);
+
+
 --
 -- Name: distribution_aliases_pkey; Type: CONSTRAINT; Schema: public; Owner: wbadm; Tablespace: 
 --
@@ -3481,6 +3500,14 @@ ALTER TABLE ONLY packages
     ADD CONSTRAINT distribution_architecture_fkey FOREIGN KEY (distribution, architecture) REFERENCES distribution_architectures(distribution, architecture);
 
 
+--
+-- Name: packages_architecture_fkey; Type: FK CONSTRAINT; Schema: public; Owner: wbadm
+--
+
+ALTER TABLE ONLY packages
+    ADD CONSTRAINT packages_architecture_fkey FOREIGN KEY (architecture) REFERENCES architectures(architecture);
+
+
 --
 -- Name: packages_distribution_fkey; Type: FK CONSTRAINT; Schema: public; Owner: wbadm
 --
@@ -5058,6 +5085,16 @@ GRANT SELECT ON TABLE users TO PUBLIC;
 
 SET search_path = public, pg_catalog;
 
+--
+-- Name: architectures; Type: ACL; Schema: public; Owner: wbadm
+--
+
+REVOKE ALL ON TABLE architectures FROM PUBLIC;
+REVOKE ALL ON TABLE architectures FROM wbadm;
+GRANT ALL ON TABLE architectures TO wbadm;
+GRANT SELECT ON TABLE architectures TO PUBLIC;
+
+
 --
 -- Name: distribution_aliases; Type: ACL; Schema: public; Owner: wbadm
 --
@@ -5078,6 +5115,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: lastlog; Type: ACL; Schema: public; Owner: wbadm
 --