From bd8e4f06e5451abab751cb6b0ff3b33588b28c20 Mon Sep 17 00:00:00 2001 From: Galen Charlton Date: Wed, 16 Nov 2016 11:46:40 -0500 Subject: [PATCH] LP#1615736: stamping schema update Signed-off-by: Galen Charlton --- Open-ILS/src/sql/Pg/002.schema.config.sql | 2 +- ..._history_index.sql => 1001.schema.action_usr_circ_history_index.sql} | 2 +- 2 files changed, 2 insertions(+), 2 deletions(-) rename Open-ILS/src/sql/Pg/upgrade/{XXXX.action_usr_circ_history_index.sql => 1001.schema.action_usr_circ_history_index.sql} (54%) diff --git a/Open-ILS/src/sql/Pg/002.schema.config.sql b/Open-ILS/src/sql/Pg/002.schema.config.sql index 5db1ee3cdc..1a80bc0f7b 100644 --- a/Open-ILS/src/sql/Pg/002.schema.config.sql +++ b/Open-ILS/src/sql/Pg/002.schema.config.sql @@ -91,7 +91,7 @@ CREATE TRIGGER no_overlapping_deps BEFORE INSERT OR UPDATE ON config.db_patch_dependencies FOR EACH ROW EXECUTE PROCEDURE evergreen.array_overlap_check ('deprecates'); -INSERT INTO config.upgrade_log (version, applied_to) VALUES ('1000', :eg_version); -- bshum/dbwells +INSERT INTO config.upgrade_log (version, applied_to) VALUES ('1001', :eg_version); -- stompro/gmcharlt CREATE TABLE config.bib_source ( id SERIAL PRIMARY KEY, diff --git a/Open-ILS/src/sql/Pg/upgrade/XXXX.action_usr_circ_history_index.sql b/Open-ILS/src/sql/Pg/upgrade/1001.schema.action_usr_circ_history_index.sql similarity index 54% rename from Open-ILS/src/sql/Pg/upgrade/XXXX.action_usr_circ_history_index.sql rename to Open-ILS/src/sql/Pg/upgrade/1001.schema.action_usr_circ_history_index.sql index 965d9832b7..47a4c89817 100644 --- a/Open-ILS/src/sql/Pg/upgrade/XXXX.action_usr_circ_history_index.sql +++ b/Open-ILS/src/sql/Pg/upgrade/1001.schema.action_usr_circ_history_index.sql @@ -1,6 +1,6 @@ BEGIN; --- SELECT evergreen.upgrade_deps_block_check('xxxx', :eg_version); +SELECT evergreen.upgrade_deps_block_check('1001', :eg_version); -- stompro/gmcharlt CREATE INDEX action_usr_circ_history_usr_idx ON action.usr_circ_history ( usr ); -- 2.11.0