From e0a936729ada587e33ab3a701901c3d0a1ed3acb Mon Sep 17 00:00:00 2001 From: Jason Etheridge Date: Thu, 1 Dec 2011 16:02:29 -0500 Subject: [PATCH] pin a version number for the patron card editor upgrade script Signed-off-by: Jason Etheridge --- Open-ILS/src/sql/Pg/002.schema.config.sql | 2 +- .../{XXXX.patron_card_editor.sql => 0654.patron_card_editor.sql} | 5 +++++ 2 files changed, 6 insertions(+), 1 deletion(-) rename Open-ILS/src/sql/Pg/upgrade/{XXXX.patron_card_editor.sql => 0654.patron_card_editor.sql} (81%) diff --git a/Open-ILS/src/sql/Pg/002.schema.config.sql b/Open-ILS/src/sql/Pg/002.schema.config.sql index 9930af5dfb..54865b3a16 100644 --- a/Open-ILS/src/sql/Pg/002.schema.config.sql +++ b/Open-ILS/src/sql/Pg/002.schema.config.sql @@ -86,7 +86,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 ('0653', :eg_version); -- berick/miker +INSERT INTO config.upgrade_log (version, applied_to) VALUES ('0654', :eg_version); -- phasefx/tsbere CREATE TABLE config.bib_source ( id SERIAL PRIMARY KEY, diff --git a/Open-ILS/src/sql/Pg/upgrade/XXXX.patron_card_editor.sql b/Open-ILS/src/sql/Pg/upgrade/0654.patron_card_editor.sql similarity index 81% rename from Open-ILS/src/sql/Pg/upgrade/XXXX.patron_card_editor.sql rename to Open-ILS/src/sql/Pg/upgrade/0654.patron_card_editor.sql index 2c7cd3ab6a..06c40e8390 100644 --- a/Open-ILS/src/sql/Pg/upgrade/XXXX.patron_card_editor.sql +++ b/Open-ILS/src/sql/Pg/upgrade/0654.patron_card_editor.sql @@ -1,6 +1,11 @@ +BEGIN; + +SELECT evergreen.upgrade_deps_block_check('0654', :eg_version); + INSERT INTO permission.perm_list ( id, code, description ) VALUES ( 514, 'UPDATE_PATRON_ACTIVE_CARD', oils_i18n_gettext( 514, 'Allows a user to manually adjust a patron''s active cards', 'ppl', 'description')), ( 515, 'UPDATE_PATRON_PRIMARY_CARD', oils_i18n_gettext( 515, 'Allows a user to manually adjust a patron''s primary card', 'ppl', 'description')); +COMMIT; -- 2.11.0