X-Git-Url: https://git.donarmstrong.com/?p=wannabuild.git;a=blobdiff_plain;f=schema%2Fwanna-build.sql;h=f3862fde59266f80d5c00955108081a2dc0700c5;hp=cdc334a56577d96beaa856bf46ac001fa77dbe0d;hb=51ebf1b6945841a470de91e3fac9626fa51e2b43;hpb=d06ca9bc270320f65501f46d3789c9233b84ec12

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
 --