]> git.evergreen-ils.org Git - Evergreen.git/blob - Open-ILS/src/sql/Pg/version-upgrade/2.2.1-2.2.2-upgrade-db.sql
LP#1772028 Add some FK violation functions just in case they are missing
[Evergreen.git] / Open-ILS / src / sql / Pg / version-upgrade / 2.2.1-2.2.2-upgrade-db.sql
1 --Upgrade Script for 2.2.1 to 2.2.2
2 \set eg_version '''2.2.2'''
3 BEGIN;
4 INSERT INTO config.upgrade_log (version, applied_to) VALUES ('2.2.2', :eg_version);
5
6 SELECT evergreen.upgrade_deps_block_check('0736', :eg_version);
7
8 INSERT INTO permission.perm_list (id, code, description)
9     VALUES (539, 'UPDATE_ORG_UNIT_SETTING.ui.hide_copy_editor_fields', 'Allows staff to edit displayed copy editor fields');
10
11 UPDATE config.org_unit_setting_type SET update_perm = 539 WHERE name = 'ui.hide_copy_editor_fields';
12
13
14 COMMIT;