From fe0888063e329eb9afe241f7d0c0127397c9b136 Mon Sep 17 00:00:00 2001 From: Mike Rylander Date: Tue, 28 Jun 2011 14:06:49 -0400 Subject: [PATCH] Update upgrade script and correct version number in 0561 Signed-off-by: Mike Rylander --- Open-ILS/src/sql/Pg/2.0.6-2.0.7-upgrade-db.sql | 4 ++++ Open-ILS/src/sql/Pg/upgrade/0561.schema.tnf_index.sql | 2 +- 2 files changed, 5 insertions(+), 1 deletion(-) diff --git a/Open-ILS/src/sql/Pg/2.0.6-2.0.7-upgrade-db.sql b/Open-ILS/src/sql/Pg/2.0.6-2.0.7-upgrade-db.sql index 7df04acb34..97d79dcc9c 100644 --- a/Open-ILS/src/sql/Pg/2.0.6-2.0.7-upgrade-db.sql +++ b/Open-ILS/src/sql/Pg/2.0.6-2.0.7-upgrade-db.sql @@ -942,4 +942,8 @@ SELECT biblio.reingest_uris(); -- Hopefully this isn't something we'll need to run again DROP FUNCTION biblio.reingest_uris(); +INSERT INTO config.upgrade_log (version) VALUES ('0561'); -- miker + +CREATE INDEX metabib_full_rec_tnf_idx ON metabib.real_full_rec (record, tag, subfield) WHERE tag = 'tnf' AND subfield = 'a'; + COMMIT; diff --git a/Open-ILS/src/sql/Pg/upgrade/0561.schema.tnf_index.sql b/Open-ILS/src/sql/Pg/upgrade/0561.schema.tnf_index.sql index bbc1c8dbc4..cb21ad2824 100644 --- a/Open-ILS/src/sql/Pg/upgrade/0561.schema.tnf_index.sql +++ b/Open-ILS/src/sql/Pg/upgrade/0561.schema.tnf_index.sql @@ -1,6 +1,6 @@ BEGIN; -INSERT INTO config.upgrade_log (version) VALUES ('0560'); -- miker +INSERT INTO config.upgrade_log (version) VALUES ('0561'); -- miker CREATE INDEX metabib_full_rec_tnf_idx ON metabib.real_full_rec (record, tag, subfield) WHERE tag = 'tnf' AND subfield = 'a'; -- 2.11.0