From 24fc45d393f9bac8317f5c9524e0a762deb46a89 Mon Sep 17 00:00:00 2001 From: Chris Sharp Date: Fri, 8 Nov 2019 07:54:15 -0500 Subject: [PATCH] LP#1851831 - Add permission descriptions where there are none. The new Angular perm group interface requires perm descriptions, so we do the very least we can do and update null descriptions to the perm code. Signed-off-by: Chris Sharp --- .../sql/Pg/upgrade/XXXX.data.fix_null_perm_descriptions.sql | 12 ++++++++++++ 1 file changed, 12 insertions(+) create mode 100644 Open-ILS/src/sql/Pg/upgrade/XXXX.data.fix_null_perm_descriptions.sql diff --git a/Open-ILS/src/sql/Pg/upgrade/XXXX.data.fix_null_perm_descriptions.sql b/Open-ILS/src/sql/Pg/upgrade/XXXX.data.fix_null_perm_descriptions.sql new file mode 100644 index 0000000000..6767953a31 --- /dev/null +++ b/Open-ILS/src/sql/Pg/upgrade/XXXX.data.fix_null_perm_descriptions.sql @@ -0,0 +1,12 @@ +BEGIN; + +SELECT evergreen.upgrade_deps_block_check('XXXX', :eg_version); + +-- The angular-ized permission group editor presumes that every +-- permission in permission.perm_list has a description. Ideally +-- staff would add these manually and make them useful, but with +-- the need for *something*, we just updated it to whatever the +-- code is. +UPDATE permission.perm_list SET description = code WHERE description IS NULL; + +COMMIT; -- 2.11.0