Give kibi access to alpha.

[wannabuild.git] / schema / arches-tables.in

diff --git a/schema/arches-tables.in b/schema/arches-tables.in
index bc4c57c83b900d444520c1960c431463446c28e3..8a327e100e63ad57d0df7bb67fd74b3f6c017234 100644 (file)
--- a/schema/arches-tables.in
+++ b/schema/arches-tables.in
@@ -29,7 +29,9 @@ create table "ARCH".packages
     depends character varying,
     rel character varying,
     bd_problem text,
-    primary key (package, distribution)
+    primary key (package, distribution),
+    extra_depends character varying,
+    extra_conflicts character varying
 );
 
 create index "idx_ARCH_state" on "ARCH".packages (state);
@@ -66,6 +68,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 +87,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;