From e1fed77625304adff3cdc6f386bf472901003119 Mon Sep 17 00:00:00 2001 From: miker Date: Sat, 21 Aug 2010 18:07:45 +0000 Subject: [PATCH] backport of r17299: we need an index on LOWER(barcode) with r17018 git-svn-id: svn://svn.open-ils.org/ILS/branches/rel_1_6_1@17301 dcc99617-32d9-48b4-a31d-7c20da2025e4 --- Open-ILS/src/sql/Pg/005.schema.actors.sql | 1 + Open-ILS/src/sql/Pg/1.6.1.1-1.6.1.2-upgrade-db.sql | 1 + 2 files changed, 2 insertions(+) diff --git a/Open-ILS/src/sql/Pg/005.schema.actors.sql b/Open-ILS/src/sql/Pg/005.schema.actors.sql index 11063ab7ce..b029de7d8a 100644 --- a/Open-ILS/src/sql/Pg/005.schema.actors.sql +++ b/Open-ILS/src/sql/Pg/005.schema.actors.sql @@ -312,6 +312,7 @@ COMMENT ON TABLE actor.card IS $$ $$; CREATE INDEX actor_card_usr_idx ON actor.card (usr); +CREATE INDEX actor_card_barcode_lower_idx ON actor.card (lower(barcode)); CREATE TABLE actor.org_unit_type ( id SERIAL PRIMARY KEY, diff --git a/Open-ILS/src/sql/Pg/1.6.1.1-1.6.1.2-upgrade-db.sql b/Open-ILS/src/sql/Pg/1.6.1.1-1.6.1.2-upgrade-db.sql index e0cbdbbd9c..77ae2c3ee0 100644 --- a/Open-ILS/src/sql/Pg/1.6.1.1-1.6.1.2-upgrade-db.sql +++ b/Open-ILS/src/sql/Pg/1.6.1.1-1.6.1.2-upgrade-db.sql @@ -599,6 +599,7 @@ $func$ LANGUAGE plpgsql; COMMIT; +CREATE INDEX actor_card_barcode_lower_idx ON actor.card (lower(barcode)); CREATE INDEX atev_target_def_idx ON action_trigger.event (target,event_def); -- Give circulation staff the ability to handle day-to-day booking/reservation tasks INSERT INTO permission.grp_perm_map (grp, perm, depth, grantable) SELECT 5, id, 2, false FROM permission.perm_list WHERE code = 'ADMIN_BOOKING_RESERVATION'; -- 2.11.0