From 8b2d90115ce512df6ee69edcb0859ca77ab89428 Mon Sep 17 00:00:00 2001 From: miker Date: Fri, 10 Dec 2010 15:17:46 +0000 Subject: [PATCH] Prepping for 1.6.1.5 with initial upgrade script. Addressing https://bugs.launchpad.net/evergreen/+bug/638309 -- Thanks to Steve Callender for the original report and diagnosis. git-svn-id: svn://svn.open-ils.org/ILS/branches/rel_1_6_1@18962 dcc99617-32d9-48b4-a31d-7c20da2025e4 --- Open-ILS/src/sql/Pg/1.6.1.4-1.6.1.5-db-upgrade.sql | 54 ++++++++++++++++++++++ Open-ILS/src/sql/Pg/950.data.seed-values.sql | 36 +++++++++++++++ 2 files changed, 90 insertions(+) create mode 100644 Open-ILS/src/sql/Pg/1.6.1.4-1.6.1.5-db-upgrade.sql diff --git a/Open-ILS/src/sql/Pg/1.6.1.4-1.6.1.5-db-upgrade.sql b/Open-ILS/src/sql/Pg/1.6.1.4-1.6.1.5-db-upgrade.sql new file mode 100644 index 0000000000..82b504448c --- /dev/null +++ b/Open-ILS/src/sql/Pg/1.6.1.4-1.6.1.5-db-upgrade.sql @@ -0,0 +1,54 @@ +/* + * Copyright (C) 2010 Equinox Software, Inc. + * Mike Rylander + * + * This program is free software; you can redistribute it and/or + * modify it under the terms of the GNU General Public License + * as published by the Free Software Foundation; either version 2 + * of the License, or (at your option) any later version. + * + * This program is distributed in the hope that it will be useful, + * but WITHOUT ANY WARRANTY; without even the implied warranty of + * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the + * GNU General Public License for more details. + * + */ + +INSERT INTO config.upgrade_log(version) VALUES ('1.6.1.4'); + +INSERT INTO permission.perm_list (code) VALUES ('VIEW_GROUP_PENALTY_THRESHOLD'); +INSERT INTO permission.perm_list (code) VALUES ('ADMIN_CIRC_MATRIX_MATCHPOINT'); +INSERT INTO permission.perm_list (code) VALUES ('ADMIN_HOLD_MATRIX_MATCHPOINT'); +INSERT INTO permission.perm_list (code) VALUES ('ADMIN_GROUP_PENALTY_THRESHOLD'); +INSERT INTO permission.perm_list (code) VALUES ('ADMIN_SURVEY'); +INSERT INTO permission.perm_list (code) VALUES ('ADMIN_STANDING_PENALTY'); +INSERT INTO permission.perm_list (code) VALUES ('ADMIN_BOOKING_RESERVATION_ATTR_MAP'); +INSERT INTO permission.perm_list (code) VALUES ('ADMIN_ACQ_DISTRIB_FORMULA'); +INSERT INTO permission.perm_list (code) VALUES ('ADMIN_ACQ_FISCAL_YEAR'); +INSERT INTO permission.perm_list (code) VALUES ('ADMIN_ACQ_FUND_TAG'); +INSERT INTO permission.perm_list (code) VALUES ('ADMIN_ACQ_FUND'); +INSERT INTO permission.perm_list (code) VALUES ('VIEW_FUND'); +INSERT INTO permission.perm_list (code) VALUES ('MANAGE_FUND'); +INSERT INTO permission.perm_list (code) VALUES ('ADMIN_AGE_PROTECT_RULE'); +INSERT INTO permission.perm_list (code) VALUES ('ADMIN_CIRC_MATRIX_MATCHPOINT'); +INSERT INTO permission.perm_list (code) VALUES ('VIEW_CIRC_MATRIX_MATCHPOINT'); +INSERT INTO permission.perm_list (code) VALUES ('ADMIN_CIRC_MOD'); +INSERT INTO permission.perm_list (code) VALUES ('ADMIN_FIELD_DOC'); +INSERT INTO permission.perm_list (code) VALUES ('ADMIN_FUNDING_SOURCE'); +INSERT INTO permission.perm_list (code) VALUES ('MANAGE_FUNDING_SOURCE'); +INSERT INTO permission.perm_list (code) VALUES ('VIEW_FUNDING_SOURCE'); +INSERT INTO permission.perm_list (code) VALUES ('ADMIN_HOLD_CANCEL_CAUSE'); +INSERT INTO permission.perm_list (code) VALUES ('VIEW_HOLD_MATRIX_MATCHPOINT'); +INSERT INTO permission.perm_list (code) VALUES ('ADMIN_IDENT_TYPE'); +INSERT INTO permission.perm_list (code) VALUES ('ADMIN_MARC_CODE'); +INSERT INTO permission.perm_list (code) VALUES ('ADMIN_MAX_FINE_RULE'); +INSERT INTO permission.perm_list (code) VALUES ('ADMIN_PROVIDER'); +INSERT INTO permission.perm_list (code) VALUES ('MANAGE_PROVIDER'); +INSERT INTO permission.perm_list (code) VALUES ('VIEW_PROVIDER'); +INSERT INTO permission.perm_list (code) VALUES ('ADMIN_RECURING_FINE_RULE'); +INSERT INTO permission.perm_list (code) VALUES ('ADMIN_STANDING_PENALTY'); +INSERT INTO permission.perm_list (code) VALUES ('VIEW_STANDING_PENALTY'); +INSERT INTO permission.perm_list (code) VALUES ('ADMIN_TRIGGER_EVENT_DEF'); +INSERT INTO permission.perm_list (code) VALUES ('VIEW_TRIGGER_EVENT_DEF'); +INSERT INTO permission.perm_list (code) VALUES ('ADMIN_Z3950_SOURCE'); + 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 4484b384eb..6654ab45dd 100644 --- a/Open-ILS/src/sql/Pg/950.data.seed-values.sql +++ b/Open-ILS/src/sql/Pg/950.data.seed-values.sql @@ -1378,6 +1378,42 @@ INSERT INTO permission.perm_list (code) VALUES ('UPDATE_IMPORT_ITEM'); INSERT INTO permission.perm_list (code) VALUES ('UPDATE_IMPORT_ITEM_ATTR_DEF'); INSERT INTO permission.perm_list (code) VALUES ('UPDATE_IMPORT_TRASH_FIELD'); +INSERT INTO permission.perm_list (code) VALUES ('VIEW_GROUP_PENALTY_THRESHOLD'); +INSERT INTO permission.perm_list (code) VALUES ('ADMIN_CIRC_MATRIX_MATCHPOINT'); +INSERT INTO permission.perm_list (code) VALUES ('ADMIN_HOLD_MATRIX_MATCHPOINT'); +INSERT INTO permission.perm_list (code) VALUES ('ADMIN_GROUP_PENALTY_THRESHOLD'); +INSERT INTO permission.perm_list (code) VALUES ('ADMIN_SURVEY'); +INSERT INTO permission.perm_list (code) VALUES ('ADMIN_STANDING_PENALTY'); +INSERT INTO permission.perm_list (code) VALUES ('ADMIN_BOOKING_RESERVATION_ATTR_MAP'); +INSERT INTO permission.perm_list (code) VALUES ('ADMIN_ACQ_DISTRIB_FORMULA'); +INSERT INTO permission.perm_list (code) VALUES ('ADMIN_ACQ_FISCAL_YEAR'); +INSERT INTO permission.perm_list (code) VALUES ('ADMIN_ACQ_FUND_TAG'); +INSERT INTO permission.perm_list (code) VALUES ('ADMIN_ACQ_FUND'); +INSERT INTO permission.perm_list (code) VALUES ('VIEW_FUND'); +INSERT INTO permission.perm_list (code) VALUES ('MANAGE_FUND'); +INSERT INTO permission.perm_list (code) VALUES ('ADMIN_AGE_PROTECT_RULE'); +INSERT INTO permission.perm_list (code) VALUES ('ADMIN_CIRC_MATRIX_MATCHPOINT'); +INSERT INTO permission.perm_list (code) VALUES ('VIEW_CIRC_MATRIX_MATCHPOINT'); +INSERT INTO permission.perm_list (code) VALUES ('ADMIN_CIRC_MOD'); +INSERT INTO permission.perm_list (code) VALUES ('ADMIN_FIELD_DOC'); +INSERT INTO permission.perm_list (code) VALUES ('ADMIN_FUNDING_SOURCE'); +INSERT INTO permission.perm_list (code) VALUES ('MANAGE_FUNDING_SOURCE'); +INSERT INTO permission.perm_list (code) VALUES ('VIEW_FUNDING_SOURCE'); +INSERT INTO permission.perm_list (code) VALUES ('ADMIN_HOLD_CANCEL_CAUSE'); +INSERT INTO permission.perm_list (code) VALUES ('VIEW_HOLD_MATRIX_MATCHPOINT'); +INSERT INTO permission.perm_list (code) VALUES ('ADMIN_IDENT_TYPE'); +INSERT INTO permission.perm_list (code) VALUES ('ADMIN_MARC_CODE'); +INSERT INTO permission.perm_list (code) VALUES ('ADMIN_MAX_FINE_RULE'); +INSERT INTO permission.perm_list (code) VALUES ('ADMIN_PROVIDER'); +INSERT INTO permission.perm_list (code) VALUES ('MANAGE_PROVIDER'); +INSERT INTO permission.perm_list (code) VALUES ('VIEW_PROVIDER'); +INSERT INTO permission.perm_list (code) VALUES ('ADMIN_RECURING_FINE_RULE'); +INSERT INTO permission.perm_list (code) VALUES ('ADMIN_STANDING_PENALTY'); +INSERT INTO permission.perm_list (code) VALUES ('VIEW_STANDING_PENALTY'); +INSERT INTO permission.perm_list (code) VALUES ('ADMIN_TRIGGER_EVENT_DEF'); +INSERT INTO permission.perm_list (code) VALUES ('VIEW_TRIGGER_EVENT_DEF'); +INSERT INTO permission.perm_list (code) VALUES ('ADMIN_Z3950_SOURCE'); + -- ORG UNIT Settings INSERT INTO permission.perm_list (code) VALUES ('UPDATE_ORG_UNIT_SETTING_ALL'); INSERT INTO permission.perm_list (code) VALUES ('UPDATE_ORG_UNIT_SETTING.circ.lost_materials_processing_fee'); -- 2.11.0