projects
/
evergreen-equinox.git
/ commitdiff
commit
grep
author
committer
pickaxe
?
search:
re
summary
|
shortlog
|
log
|
commit
| commitdiff |
tree
raw
|
patch
(parent:
a7b0e21
)
Add an index using authority.simple_normalize_heading for search
author
Mike Rylander
<mrylander@gmail.com>
Mon, 9 May 2011 22:48:53 +0000 (18:48 -0400)
committer
Mike Rylander
<mrylander@gmail.com>
Mon, 9 May 2011 22:48:53 +0000 (18:48 -0400)
Open-ILS/src/sql/Pg/800.fkeys.sql
patch
|
blob
|
history
diff --git
a/Open-ILS/src/sql/Pg/800.fkeys.sql
b/Open-ILS/src/sql/Pg/800.fkeys.sql
index
619441d
..
7ccd9b8
100644
(file)
--- a/
Open-ILS/src/sql/Pg/800.fkeys.sql
+++ b/
Open-ILS/src/sql/Pg/800.fkeys.sql
@@
-116,5
+116,6
@@
ALTER TABLE config.org_unit_setting_type ADD CONSTRAINT view_perm_fkey FOREIGN K
ALTER TABLE config.org_unit_setting_type ADD CONSTRAINT update_perm_fkey FOREIGN KEY (update_perm) REFERENCES permission.perm_list (id) ON UPDATE CASCADE DEFERRABLE INITIALLY DEFERRED;
CREATE INDEX by_heading_and_thesaurus ON authority.record_entry (authority.normalize_heading(marc)) WHERE deleted IS FALSE or deleted = FALSE;
+CREATE INDEX by_heading ON authority.record_entry (authority.simple_normalize_heading(marc)) WHERE deleted IS FALSE or deleted = FALSE;
COMMIT;