Auto-committed schema changes.

[wannabuild.git] / schema / wanna-build.sql

diff --git a/schema/wanna-build.sql b/schema/wanna-build.sql
index a93d83c8493d30dcba72b8c21c1ddaacdc6e0f3d..a3c89ee0ac03a32e80f6f9b0a4cb04dad063b16c 100644 (file)
--- a/schema/wanna-build.sql
+++ b/schema/wanna-build.sql
@@ -2282,7 +2282,7 @@ CREATE VIEW packages_public AS
 ALTER TABLE public.packages_public OWNER TO wbadm;
 
 --
--- Name: priorities; Type: TABLE; Schema: public; Owner: pkern; Tablespace: 
+-- Name: priorities; Type: TABLE; Schema: public; Owner: wbadm; Tablespace: 
 --
 
 CREATE TABLE priorities (
@@ -2292,7 +2292,7 @@ CREATE TABLE priorities (
 );
 
 
-ALTER TABLE public.priorities OWNER TO pkern;
+ALTER TABLE public.priorities OWNER TO wbadm;
 
 SET search_path = s390, pg_catalog;
 
@@ -2589,7 +2589,7 @@ ALTER TABLE ONLY pkg_history
 
 
 --
--- Name: priorities_pkey; Type: CONSTRAINT; Schema: public; Owner: pkern; Tablespace: 
+-- Name: priorities_pkey; Type: CONSTRAINT; Schema: public; Owner: wbadm; Tablespace: 
 --
 
 ALTER TABLE ONLY priorities
@@ -2625,6 +2625,13 @@ CREATE INDEX distributions_distribution ON distributions USING hash (distributio
 CREATE INDEX packages_arch_dist_state ON packages USING btree (architecture, distribution, upper((state)::text));
 
 
+--
+-- Name: packages_dist_pkg; Type: INDEX; Schema: public; Owner: wbadm; Tablespace: 
+--
+
+CREATE INDEX packages_dist_pkg ON packages USING btree (distribution, package);
+
+
 --
 -- Name: pkg_history_timestamp; Type: INDEX; Schema: public; Owner: wbadm; Tablespace: 
 --
@@ -5681,12 +5688,12 @@ GRANT SELECT ON TABLE packages_public TO PUBLIC;
 
 
 --
--- Name: priorities; Type: ACL; Schema: public; Owner: pkern
+-- Name: priorities; Type: ACL; Schema: public; Owner: wbadm
 --
 
 REVOKE ALL ON TABLE priorities FROM PUBLIC;
-REVOKE ALL ON TABLE priorities FROM pkern;
-GRANT ALL ON TABLE priorities TO pkern;
+REVOKE ALL ON TABLE priorities FROM wbadm;
+GRANT ALL ON TABLE priorities TO wbadm;
 GRANT SELECT ON TABLE priorities TO PUBLIC;