From fe02e7ee3ba8829e4904af83bc1e196024d5dd15 Mon Sep 17 00:00:00 2001 From: Debian wanna-build admins Date: Thu, 29 Dec 2011 05:01:14 +0000 Subject: [PATCH] Auto-committed schema changes. --- schema/wanna-build.sql | 31 +++++++++++++++++++++++++++++++ 1 file changed, 31 insertions(+) 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; -- -- 2.39.2