From f3f63ece5acb4ebe820b6e643f19e60b4fb70192 Mon Sep 17 00:00:00 2001 From: Ben Shum Date: Wed, 17 Jun 2015 23:40:41 -0400 Subject: [PATCH] Forward-port 2.7.4-2.7.5 upgrade script Signed-off-by: Ben Shum --- .../Pg/version-upgrade/2.7.4-2.7.5-upgrade-db.sql | 32 ++++++++++++++++++++++ 1 file changed, 32 insertions(+) create mode 100644 Open-ILS/src/sql/Pg/version-upgrade/2.7.4-2.7.5-upgrade-db.sql diff --git a/Open-ILS/src/sql/Pg/version-upgrade/2.7.4-2.7.5-upgrade-db.sql b/Open-ILS/src/sql/Pg/version-upgrade/2.7.4-2.7.5-upgrade-db.sql new file mode 100644 index 0000000000..7e42f3c703 --- /dev/null +++ b/Open-ILS/src/sql/Pg/version-upgrade/2.7.4-2.7.5-upgrade-db.sql @@ -0,0 +1,32 @@ +--Upgrade Script for 2.7.4 to 2.7.5 +\set eg_version '''2.7.5''' +BEGIN; +INSERT INTO config.upgrade_log (version, applied_to) VALUES ('2.7.5', :eg_version); + +SELECT evergreen.upgrade_deps_block_check('0915', :eg_version); + +INSERT INTO permission.perm_list (id, code, description) +VALUES ( + 560, + 'TOTAL_HOLD_COPY_RATIO_EXCEEDED.override', + oils_i18n_gettext( + 560, + 'Override the TOTAL_HOLD_COPY_RATIO_EXCEEDED event', + 'ppl', + 'description' + ) +); + +INSERT INTO permission.perm_list (id, code, description) +VALUES ( + 561, + 'AVAIL_HOLD_COPY_RATIO_EXCEEDED.override', + oils_i18n_gettext( + 561, + 'Override the AVAIL_HOLD_COPY_RATIO_EXCEEDED event', + 'ppl', + 'description' + ) +); + +COMMIT; -- 2.11.0