From 0cd91034c1c5acaf303272b6ad5c891720f20f06 Mon Sep 17 00:00:00 2001 From: miker Date: Sat, 19 Apr 2008 00:11:10 +0000 Subject: [PATCH] more head conflict removal git-svn-id: svn://svn.open-ils.org/ILS/branches/acq-experiment@9383 dcc99617-32d9-48b4-a31d-7c20da2025e4 --- Open-ILS/src/sql/Pg/006.schema.permissions.sql | 2 ++ 1 file changed, 2 insertions(+) diff --git a/Open-ILS/src/sql/Pg/006.schema.permissions.sql b/Open-ILS/src/sql/Pg/006.schema.permissions.sql index b8b42eb387..254c220d7b 100644 --- a/Open-ILS/src/sql/Pg/006.schema.permissions.sql +++ b/Open-ILS/src/sql/Pg/006.schema.permissions.sql @@ -49,6 +49,8 @@ CREATE TABLE permission.usr_object_perm_map ( CONSTRAINT perm_usr_obj_once UNIQUE (usr,perm,object_type,object_id) ); +CREATE INDEX uopm_usr_idx ON permission.usr_object_perm_map (usr); + CREATE TABLE permission.usr_grp_map ( id SERIAL PRIMARY KEY, usr INT NOT NULL REFERENCES actor.usr (id) ON DELETE CASCADE, -- 2.11.0