From 115595dca577d9192474ac3d620ca079b89f39cd Mon Sep 17 00:00:00 2001
From: Bill Erickson <berick@esilibrary.com>
Date: Fri, 4 May 2012 10:33:43 -0400
Subject: [PATCH] Adding a small pile of missing permissions
ADMIN_ADDRESS_ALERT
VIEW_ADDRESS_ALERT
ADMIN_COPY_LOCATION_GROUP
ADMIN_USER_ACTIVITY_TYPE
Signed-off-by: Bill Erickson <berick@esilibrary.com>
Signed-off-by: Lebbeous Fogle-Weekley <lebbeous@esilibrary.com>
---
Open-ILS/src/sql/Pg/002.schema.config.sql | 2 +-
Open-ILS/src/sql/Pg/950.data.seed-values.sql | 11 ++++-
.../Pg/upgrade/0709.data.misc_missing_perms.sql | 48 +++++++++++++++++++++
.../sql/Pg/version-upgrade/2.1-2.2-upgrade-db.sql | 49 ++++++++++++++++++++++
4 files changed, 108 insertions(+), 2 deletions(-)
create mode 100644 Open-ILS/src/sql/Pg/upgrade/0709.data.misc_missing_perms.sql
diff --git a/Open-ILS/src/sql/Pg/002.schema.config.sql b/Open-ILS/src/sql/Pg/002.schema.config.sql
index ff67979a30..2bf618d248 100644
--- a/Open-ILS/src/sql/Pg/002.schema.config.sql
+++ b/Open-ILS/src/sql/Pg/002.schema.config.sql
@@ -87,7 +87,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 ('0708', :eg_version); -- dbs/berick
+INSERT INTO config.upgrade_log (version, applied_to) VALUES ('0709', :eg_version); -- berick/senator
CREATE TABLE config.bib_source (
id SERIAL PRIMARY KEY,
diff --git a/Open-ILS/src/sql/Pg/950.data.seed-values.sql b/Open-ILS/src/sql/Pg/950.data.seed-values.sql
index 70e401dbb4..87c3eff9e2 100644
--- a/Open-ILS/src/sql/Pg/950.data.seed-values.sql
+++ b/Open-ILS/src/sql/Pg/950.data.seed-values.sql
@@ -1549,7 +1549,16 @@ INSERT INTO permission.perm_list ( id, code, description ) VALUES
( 529, 'ADMIN_IMPORT_MATCH_SET', oils_i18n_gettext( 529,
'Allows a user to create/retrieve/update/delete vandelay match sets', 'ppl', 'description' )),
( 530, 'VIEW_IMPORT_MATCH_SET', oils_i18n_gettext( 530,
- 'Allows a user to view vandelay match sets', 'ppl', 'description' ));
+ 'Allows a user to view vandelay match sets', 'ppl', 'description' )),
+ ( 531, 'ADMIN_ADDRESS_ALERT', oils_i18n_gettext( 531,
+ 'Allows a user to create/retrieve/update/delete address alerts', 'ppl', 'description' )),
+ ( 532, 'VIEW_ADDRESS_ALERT', oils_i18n_gettext( 532,
+ 'Allows a user to view address alerts', 'ppl', 'description' )),
+ ( 533, 'ADMIN_COPY_LOCATION_GROUP', oils_i18n_gettext( 533,
+ 'Allows a user to create/retrieve/update/delete copy location groups', 'ppl', 'description' )),
+ ( 534, 'ADMIN_USER_ACTIVITY_TYPE', oils_i18n_gettext( 534,
+ 'Allows a user to create/retrieve/update/delete user activity types', 'ppl', 'description' ));
+
SELECT SETVAL('permission.perm_list_id_seq'::TEXT, 1000);
diff --git a/Open-ILS/src/sql/Pg/upgrade/0709.data.misc_missing_perms.sql b/Open-ILS/src/sql/Pg/upgrade/0709.data.misc_missing_perms.sql
new file mode 100644
index 0000000000..dd419057d2
--- /dev/null
+++ b/Open-ILS/src/sql/Pg/upgrade/0709.data.misc_missing_perms.sql
@@ -0,0 +1,48 @@
+-- Evergreen DB patch 0709.data.misc_missing_perms.sql
+--
+-- Fixes a typo in the name of a global flag
+
+BEGIN;
+
+SELECT evergreen.upgrade_deps_block_check('0709', :eg_version);
+
+INSERT INTO permission.perm_list ( id, code, description )
+ VALUES (
+ 531,
+ 'ADMIN_ADDRESS_ALERT',
+ oils_i18n_gettext(
+ 531,
+ 'Allows a user to create/retrieve/update/delete address alerts',
+ 'ppl',
+ 'description'
+ )
+ ), (
+ 532,
+ 'VIEW_ADDRESS_ALERT',
+ oils_i18n_gettext(
+ 532,
+ 'Allows a user to view address alerts',
+ 'ppl',
+ 'description'
+ )
+ ), (
+ 533,
+ 'ADMIN_COPY_LOCATION_GROUP',
+ oils_i18n_gettext(
+ 533,
+ 'Allows a user to create/retrieve/update/delete copy location groups',
+ 'ppl',
+ 'description'
+ )
+ ), (
+ 534,
+ 'ADMIN_USER_ACTIVITY_TYPE',
+ oils_i18n_gettext(
+ 534,
+ 'Allows a user to create/retrieve/update/delete user activity types',
+ 'ppl',
+ 'description'
+ )
+ );
+
+COMMIT;
diff --git a/Open-ILS/src/sql/Pg/version-upgrade/2.1-2.2-upgrade-db.sql b/Open-ILS/src/sql/Pg/version-upgrade/2.1-2.2-upgrade-db.sql
index 4f8dff4ef7..3086b50cd1 100644
--- a/Open-ILS/src/sql/Pg/version-upgrade/2.1-2.2-upgrade-db.sql
+++ b/Open-ILS/src/sql/Pg/version-upgrade/2.1-2.2-upgrade-db.sql
@@ -16086,3 +16086,52 @@ INSERT INTO permission.perm_list ( id, code, description )
);
COMMIT;
+
+-- Evergreen DB patch 0709.data.misc_missing_perms.sql
+--
+-- Fixes a typo in the name of a global flag
+
+BEGIN;
+
+SELECT evergreen.upgrade_deps_block_check('0709', :eg_version);
+
+INSERT INTO permission.perm_list ( id, code, description )
+ VALUES (
+ 531,
+ 'ADMIN_ADDRESS_ALERT',
+ oils_i18n_gettext(
+ 531,
+ 'Allows a user to create/retrieve/update/delete address alerts',
+ 'ppl',
+ 'description'
+ )
+ ), (
+ 532,
+ 'VIEW_ADDRESS_ALERT',
+ oils_i18n_gettext(
+ 532,
+ 'Allows a user to view address alerts',
+ 'ppl',
+ 'description'
+ )
+ ), (
+ 533,
+ 'ADMIN_COPY_LOCATION_GROUP',
+ oils_i18n_gettext(
+ 533,
+ 'Allows a user to create/retrieve/update/delete copy location groups',
+ 'ppl',
+ 'description'
+ )
+ ), (
+ 534,
+ 'ADMIN_USER_ACTIVITY_TYPE',
+ oils_i18n_gettext(
+ 534,
+ 'Allows a user to create/retrieve/update/delete user activity types',
+ 'ppl',
+ 'description'
+ )
+ );
+
+COMMIT;
--
2.11.0