Auto-committed schema changes.

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

diff --git a/schema/arches-tables.in b/schema/arches-tables.in
index bc4c57c83b900d444520c1960c431463446c28e3..a7b649baef1a3028b2776f31580258bfdfa15a02 100644 (file)
--- a/schema/arches-tables.in
+++ b/schema/arches-tables.in
@@ -8,6 +8,7 @@ grant usage on schema "ARCH_public" to "ARCH", public;
 grant usage on schema "ARCH" to wb_security;
 
 create table "ARCH".packages
+(
     package character varying NOT NULL,
     distribution character varying NOT NULL,
     version character varying,
@@ -29,7 +30,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 +69,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 +88,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;