X-Git-Url: https://git.donarmstrong.com/?a=blobdiff_plain;f=schema%2Fwanna-build.sql;h=a93d83c8493d30dcba72b8c21c1ddaacdc6e0f3d;hb=fe02e7ee3ba8829e4904af83bc1e196024d5dd15;hp=4630a9cee40c725c9ab09adc81982453a776b835;hpb=a754de844e18fc87a5a2902cf143cf7911703f24;p=wannabuild.git

diff --git a/schema/wanna-build.sql b/schema/wanna-build.sql
index 4630a9c..a93d83c 100644
--- a/schema/wanna-build.sql
+++ b/schema/wanna-build.sql
@@ -2281,6 +2281,19 @@ CREATE VIEW packages_public AS
 
 ALTER TABLE public.packages_public OWNER TO wbadm;
 
+--
+-- Name: priorities; Type: TABLE; Schema: public; Owner: pkern; Tablespace: 
+--
+
+CREATE TABLE priorities (
+    type character varying NOT NULL,
+    value character varying NOT NULL,
+    priority integer DEFAULT 0 NOT NULL
+);
+
+
+ALTER TABLE public.priorities OWNER TO pkern;
+
 SET search_path = s390, pg_catalog;
 
 --
@@ -2575,6 +2588,14 @@ ALTER TABLE ONLY pkg_history
     ADD CONSTRAINT pkg_history_pkey PRIMARY KEY (architecture, package, distribution, version, "timestamp");
 
 
+--
+-- Name: priorities_pkey; Type: CONSTRAINT; Schema: public; Owner: pkern; Tablespace: 
+--
+
+ALTER TABLE ONLY priorities
+    ADD CONSTRAINT priorities_pkey PRIMARY KEY (type, value);
+
+
 --
 -- Name: users_pkey; Type: CONSTRAINT; Schema: public; Owner: wbadm; Tablespace: 
 --
@@ -5659,6 +5680,16 @@ GRANT ALL ON TABLE packages_public TO wbadm;
 GRANT SELECT ON TABLE packages_public TO PUBLIC;
 
 
+--
+-- Name: priorities; Type: ACL; Schema: public; Owner: pkern
+--
+
+REVOKE ALL ON TABLE priorities FROM PUBLIC;
+REVOKE ALL ON TABLE priorities FROM pkern;
+GRANT ALL ON TABLE priorities TO pkern;
+GRANT SELECT ON TABLE priorities TO PUBLIC;
+
+
 SET search_path = s390, pg_catalog;
 
 --