From c0a0fc6e1298bf8921e0cb15039763127b1b70fe Mon Sep 17 00:00:00 2001 From: Ben Shum Date: Wed, 19 Feb 2014 14:22:37 -0500 Subject: [PATCH] LP1223903 - Stamping upgrade script for new authority_record_entry indexes Signed-off-by: Ben Shum --- ...cord_entry.sql => 0861.index.authority_record_entry.sql} | 6 ++++++ 1 file changed, 6 insertions(+) rename Open-ILS/src/sql/Pg/upgrade/{XXXX.index.authority_record_entry.sql => 0861.index.authority_record_entry.sql} (69%) diff --git a/Open-ILS/src/sql/Pg/upgrade/XXXX.index.authority_record_entry.sql b/Open-ILS/src/sql/Pg/upgrade/0861.index.authority_record_entry.sql similarity index 69% rename from Open-ILS/src/sql/Pg/upgrade/XXXX.index.authority_record_entry.sql rename to Open-ILS/src/sql/Pg/upgrade/0861.index.authority_record_entry.sql index 1c8e03c955..b94a54ab53 100644 --- a/Open-ILS/src/sql/Pg/upgrade/XXXX.index.authority_record_entry.sql +++ b/Open-ILS/src/sql/Pg/upgrade/0861.index.authority_record_entry.sql @@ -1,2 +1,8 @@ +BEGIN; + +SELECT evergreen.upgrade_deps_block_check('0861', :eg_version); + CREATE INDEX authority_record_entry_create_date_idx ON authority.record_entry ( create_date ); CREATE INDEX authority_record_entry_edit_date_idx ON authority.record_entry ( edit_date ); + +COMMIT; -- 2.43.2