From c9f179534b717ea3196a0653ae8caad3559f7ef1 Mon Sep 17 00:00:00 2001 From: Andreas Barth Date: Sun, 11 Apr 2010 12:53:46 +0000 Subject: [PATCH] add index on pkg_history, and allow people to read the public view of pkg_history --- schema/arches-tables.in | 4 +++- 1 file changed, 3 insertions(+), 1 deletion(-) 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; -- 2.39.2