X-Git-Url: https://git.donarmstrong.com/?p=wannabuild.git;a=blobdiff_plain;f=schema%2Fwanna-build.sql;h=a3c89ee0ac03a32e80f6f9b0a4cb04dad063b16c;hp=d8409f3f3e606cabb791d2f43476ae1294d229eb;hb=9f15f6d282fb3ad92792a94c1b0310ca6958d2cf;hpb=1fa3e310692f1499af36eb54526f2e23766847d5

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: 
 --