From 753968ae0393cb10e2c4a0ec8cbff0a5351bb268 Mon Sep 17 00:00:00 2001 From: Debian wanna-build admins Date: Sat, 26 Nov 2011 05:01:14 +0000 Subject: [PATCH] Auto-committed schema changes. --- schema/roles.sql | 3 +++ schema/wanna-build.sql | 7 ------- 2 files changed, 3 insertions(+), 7 deletions(-) diff --git a/schema/roles.sql b/schema/roles.sql index 943373d..4383e77 100644 --- 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 aec0502..4630a9c 100644 --- 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: -- -- 2.39.2