Auto-committed schema changes.

diff --git a/schema/roles.sql b/schema/roles.sql
index 943373db66785e0d2642585e8735ce66de9fd5b9..4383e77341bbc579d42419803e105f6ff87fea8e 100644 (file)
--- a/schema/roles.sql
+++ b/schema/roles.sql
@@ -136,6 +136,8 @@ CREATE ROLE vorlon;
 ALTER ROLE vorlon WITH NOSUPERUSER INHERIT NOCREATEROLE NOCREATEDB LOGIN;
 CREATE ROLE waldi;
 ALTER ROLE waldi WITH NOSUPERUSER INHERIT NOCREATEROLE NOCREATEDB LOGIN;
+CREATE ROLE "wb-buildd";
+ALTER ROLE "wb-buildd" WITH NOSUPERUSER INHERIT NOCREATEROLE NOCREATEDB LOGIN;
 CREATE ROLE wb_all;
 ALTER ROLE wb_all WITH NOSUPERUSER INHERIT NOCREATEROLE NOCREATEDB NOLOGIN;
 CREATE ROLE wb_security;
@@ -205,6 +207,7 @@ GRANT wb_all TO riku GRANTED BY wbadm;
 GRANT wb_all TO sthibault GRANTED BY wbadm;
 GRANT wb_all TO vorlon GRANTED BY wbadm;
 GRANT wb_all TO waldi GRANTED BY wbadm;
+GRANT wb_all TO "wb-buildd" GRANTED BY wbadm;
 GRANT wb_all TO wbadm GRANTED BY wbadm;
 GRANT wb_all TO wookey GRANTED BY wbadm;
 GRANT wb_all TO wouter GRANTED BY wbadm;

diff --git a/schema/wanna-build.sql b/schema/wanna-build.sql
index aec0502f4365e478ca4410bd489b460efedece4a..4630a9cee40c725c9ab09adc81982453a776b835 100644 (file)
--- a/schema/wanna-build.sql
+++ b/schema/wanna-build.sql
@@ -2604,13 +2604,6 @@ 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_distribution_package; Type: INDEX; Schema: public; Owner: wbadm; Tablespace: 
---
-
-CREATE INDEX packages_distribution_package ON packages USING btree (distribution, package);
-
-
 --
 -- Name: pkg_history_timestamp; Type: INDEX; Schema: public; Owner: wbadm; Tablespace: 
 --