]> git.evergreen-ils.org Git - Evergreen.git/blob - Open-ILS/src/sql/Pg/upgrade/0437.schema.bytea-index-label_sortkey.sql
LP1779158 Vandelay workstation setting repairs/additions
[Evergreen.git] / Open-ILS / src / sql / Pg / upgrade / 0437.schema.bytea-index-label_sortkey.sql
1
2 BEGIN;
3
4 INSERT INTO config.upgrade_log (version) VALUES ('0437'); -- miker
5
6 DROP INDEX asset.asset_call_number_label_sortkey;
7 CREATE INDEX asset_call_number_label_sortkey ON asset.call_number(cast(label_sortkey as bytea));
8
9 COMMIT;