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,
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);
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";
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;