From 9f15f6d282fb3ad92792a94c1b0310ca6958d2cf Mon Sep 17 00:00:00 2001 From: Debian wanna-build admins Date: Sat, 14 Jan 2012 05:01:16 +0000 Subject: [PATCH] Auto-committed schema changes. --- schema/wanna-build.sql | 7 +++++++ 1 file changed, 7 insertions(+) diff --git a/schema/wanna-build.sql b/schema/wanna-build.sql index d8409f3..a3c89ee 100644 --- a/schema/wanna-build.sql +++ b/schema/wanna-build.sql @@ -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: -- -- 2.39.2