From c8f66df1cbde403dfbac6a0d80c8cf171462ab36 Mon Sep 17 00:00:00 2001 From: scottmk Date: Fri, 5 Mar 2010 19:15:26 +0000 Subject: [PATCH] Add a new permission, ADMIN_ACQ_CANCEL_CAUSE Add two rows of seed data for acq.cancel_reason M Open-ILS/src/sql/Pg/002.schema.config.sql A Open-ILS/src/sql/Pg/upgrade/0180.data.acq.cancel-reasons.sql M Open-ILS/src/sql/Pg/950.data.seed-values.sql M Open-ILS/examples/fm_IDL.xml git-svn-id: svn://svn.open-ils.org/ILS/trunk@15717 dcc99617-32d9-48b4-a31d-7c20da2025e4 --- Open-ILS/examples/fm_IDL.xml | 6 ++++++ Open-ILS/src/sql/Pg/002.schema.config.sql | 2 +- Open-ILS/src/sql/Pg/950.data.seed-values.sql | 8 +++++++- .../Pg/upgrade/0180.data.acq.cancel-reasons.sql | 15 +++++++++++++++ 4 files changed, 29 insertions(+), 2 deletions(-) create mode 100644 Open-ILS/src/sql/Pg/upgrade/0180.data.acq.cancel-reasons.sql diff --git a/Open-ILS/examples/fm_IDL.xml b/Open-ILS/examples/fm_IDL.xml index ab89bb38b1..66df2e8ad0 100644 --- a/Open-ILS/examples/fm_IDL.xml +++ b/Open-ILS/examples/fm_IDL.xml @@ -5098,6 +5098,12 @@ Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301, USA + + + + + + diff --git a/Open-ILS/src/sql/Pg/002.schema.config.sql b/Open-ILS/src/sql/Pg/002.schema.config.sql index 6219e2c4f9..d9f3dbb28e 100644 --- a/Open-ILS/src/sql/Pg/002.schema.config.sql +++ b/Open-ILS/src/sql/Pg/002.schema.config.sql @@ -51,7 +51,7 @@ CREATE TABLE config.upgrade_log ( install_date TIMESTAMP WITH TIME ZONE NOT NULL DEFAULT NOW() ); -INSERT INTO config.upgrade_log (version) VALUES ('0179'); -- dbs +INSERT INTO config.upgrade_log (version) VALUES ('0180'); -- Scott McKellar 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 352889e9fc..a76dc65c72 100644 --- a/Open-ILS/src/sql/Pg/950.data.seed-values.sql +++ b/Open-ILS/src/sql/Pg/950.data.seed-values.sql @@ -1254,7 +1254,8 @@ INSERT INTO permission.perm_list VALUES (361, 'CAPTURE_RESERVATION', oils_i18n_gettext(361, 'Allows a user to capture booking reservations', 'ppl', 'description')), (362, 'MERGE_USERS', oils_i18n_gettext(362, 'Allows user records to be merged', 'ppl', 'description')), (363, 'ALLOW_ALT_TCN', oils_i18n_gettext(363, 'Allows staff to import a record using an alternate TCN to avoid conflicts', 'ppl', 'description')), - (364, 'ADMIN_TRIGGER_EVENT_DEF', oils_i18n_gettext(364, 'Allow a user to administer trigger event definitions', 'ppl', 'description')) + (364, 'ADMIN_TRIGGER_EVENT_DEF', oils_i18n_gettext(364, 'Allow a user to administer trigger event definitions', 'ppl', 'description')), + (365, 'ADMIN_ACQ_CANCEL_CAUSE', oils_i18n_gettext(365, 'Allow a user to create/update/delete reasons for order cancellations', 'ppl', 'description') ; SELECT SETVAL('permission.perm_list_id_seq'::TEXT, 1000); @@ -3933,3 +3934,8 @@ INSERT INTO acq.invoice_item_type (code,name) VALUES ('ITM',oils_i18n_gettext('I INSERT INTO acq.invoice_method (code,name) VALUES ('EDI',oils_i18n_gettext('EDI', 'EDI', 'acqim', 'name')); INSERT INTO acq.invoice_method (code,name) VALUES ('PPR',oils_i18n_gettext('PPR', 'Paper', 'acqit', 'name')); +INSERT INTO acq.cancel_reason ( id, org_unit, label, description ) VALUES ( + 1, 1, 'invalid_isbn', oils_i18n_gettext( 1, 'ISBN is unrecognizable', 'acqcr', 'label' )); +INSERT INTO acq.cancel_reason ( id, org_unit, label, description ) VALUES ( + 2, 1, 'postpone', oils_i18n_gettext( 2, 'Title has been postponed', 'acqcr', 'label' )); + diff --git a/Open-ILS/src/sql/Pg/upgrade/0180.data.acq.cancel-reasons.sql b/Open-ILS/src/sql/Pg/upgrade/0180.data.acq.cancel-reasons.sql new file mode 100644 index 0000000000..3b3f8333ce --- /dev/null +++ b/Open-ILS/src/sql/Pg/upgrade/0180.data.acq.cancel-reasons.sql @@ -0,0 +1,15 @@ +BEGIN; + +INSERT INTO config.upgrade_log (version) VALUES ('0180'); -- Scott McKellar + +INSERT INTO acq.cancel_reason ( id, org_unit, label, description ) VALUES ( + 1, 1, 'invalid_isbn', oils_i18n_gettext( 1, 'ISBN is unrecognizable', 'acqcr', 'label' )); + +INSERT INTO acq.cancel_reason ( id, org_unit, label, description ) VALUES ( + 2, 1, 'postpone', oils_i18n_gettext( 2, 'Title has been postponed', 'acqcr', 'label' )); + +INSERT INTO permission.perm_list (id, code, description) + VALUES (365, 'ADMIN_ACQ_CANCEL_CAUSE', + oils_i18n_gettext( 365, 'Allow a user to create/update/delete reasons for order cancellations', 'ppl', 'description' )); + +COMMIT; -- 2.43.2