From: Andreas Barth <aba@not.so.argh.org>
Date: Sun, 11 Apr 2010 12:53:46 +0000 (+0000)
Subject: add index on pkg_history, and allow people to read the public view of pkg_history
X-Git-Url: https://git.donarmstrong.com/?p=wannabuild.git;a=commitdiff_plain;h=c9f179534b717ea3196a0653ae8caad3559f7ef1

add index on pkg_history, and allow people to read the public view of pkg_history
---

diff --git a/schema/arches-tables.in b/schema/arches-tables.in
index bc4c57c..ec38ccc 100644
--- a/schema/arches-tables.in
+++ b/schema/arches-tables.in
@@ -66,6 +66,8 @@ CREATE TABLE "ARCH".pkg_history (
     primary key (package, distribution, version, "timestamp")
 );
 
+create index pkg_history_index on "ARCH".pkg_history (package, distribution, timestamp desc, result);
+
 grant all on "ARCH".packages to "ARCH";
 grant all on "ARCH".users to "ARCH";
 grant insert, select on "ARCH".transactions to "ARCH";
@@ -83,5 +85,5 @@ create view "ARCH_public".pkg_history as select * from "ARCH".pkg_history where
 grant select on "ARCH_public".packages to public;
 grant select on "ARCH_public".users to public;
 grant select on "ARCH_public".transactions to public;
-#grant select on "ARCH_public".pkg_history to public;
+grant select on "ARCH_public".pkg_history to public;