From 51ebf1b6945841a470de91e3fac9626fa51e2b43 Mon Sep 17 00:00:00 2001 From: Debian wanna-build admins Date: Tue, 14 Jun 2011 05:01:04 +0000 Subject: [PATCH] Auto-committed schema changes. --- schema/roles.sql | 1 - schema/wanna-build.sql | 47 ++++++++++++++++++++++++++++++++++++++++++ 2 files changed, 47 insertions(+), 1 deletion(-) diff --git a/schema/roles.sql b/schema/roles.sql index fb24983..b01b6f7 100644 --- 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 cdc334a..f3862fd 100644 --- 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 -- -- 2.39.2