From 06a06ea5410749cd982647e4b16dd19be28ed6d4 Mon Sep 17 00:00:00 2001 From: Chris Sharp Date: Wed, 28 Oct 2020 15:57:42 -0400 Subject: [PATCH] LP#1325704: stamping upgrade script Signed-off-by: Chris Sharp --- Open-ILS/src/sql/Pg/002.schema.config.sql | 2 +- .../1242.schema.lost_lo_claimsret_descrip.sql | 54 ++++++++++++++++++++++ 2 files changed, 55 insertions(+), 1 deletion(-) create mode 100644 Open-ILS/src/sql/Pg/upgrade/1242.schema.lost_lo_claimsret_descrip.sql diff --git a/Open-ILS/src/sql/Pg/002.schema.config.sql b/Open-ILS/src/sql/Pg/002.schema.config.sql index d52b1c9546..a78a2a063c 100644 --- a/Open-ILS/src/sql/Pg/002.schema.config.sql +++ b/Open-ILS/src/sql/Pg/002.schema.config.sql @@ -92,7 +92,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 ('1241', :eg_version); -- JBoyer/csharp +INSERT INTO config.upgrade_log (version, applied_to) VALUES ('1242', :eg_version); -- remingtron/terranm CREATE TABLE config.bib_source ( id SERIAL PRIMARY KEY, diff --git a/Open-ILS/src/sql/Pg/upgrade/1242.schema.lost_lo_claimsret_descrip.sql b/Open-ILS/src/sql/Pg/upgrade/1242.schema.lost_lo_claimsret_descrip.sql new file mode 100644 index 0000000000..ab418af71b --- /dev/null +++ b/Open-ILS/src/sql/Pg/upgrade/1242.schema.lost_lo_claimsret_descrip.sql @@ -0,0 +1,54 @@ +BEGIN; + +-- check whether patch can be applied +SELECT evergreen.upgrade_deps_block_check('1242', :eg_version); + +-- Long Overdue +UPDATE config.org_unit_setting_type +SET description = oils_i18n_gettext( + 'ui.circ.items_out.longoverdue', +'Value is a numeric code, describing: A. In which tab ("Items Checked Out", '|| +'or "Other/Special Circulations") the circulation '|| +'should appear while checked out, and B. Whether the circulation should '|| +'continue to appear in the "Other" tab when checked in with '|| +'oustanding fines. '|| +'1 = (A) "Items", (B) "Other". 2 = (A) "Other", (B) "Other". ' || +'5 = (A) "Items", (B) do not display. 6 = (A) "Other", (B) do not display.', + 'coust', + 'description' + ) +WHERE NAME = 'ui.circ.items_out.longoverdue'; + +-- Lost +UPDATE config.org_unit_setting_type +SET description = oils_i18n_gettext( + 'ui.circ.items_out.lost', +'Value is a numeric code, describing: A. In which tab ("Items Checked Out", '|| +'or "Other/Special Circulations") the circulation '|| +'should appear while checked out, and B. Whether the circulation should '|| +'continue to appear in the "Other" tab when checked in with '|| +'oustanding fines. '|| +'1 = (A) "Items", (B) "Other". 2 = (A) "Other", (B) "Other". ' || +'5 = (A) "Items", (B) do not display. 6 = (A) "Other", (B) do not display.', + 'coust', + 'description' + ) +WHERE NAME = 'ui.circ.items_out.lost'; + +-- Claims Returned +UPDATE config.org_unit_setting_type +SET description = oils_i18n_gettext( + 'ui.circ.items_out.claimsreturned', +'Value is a numeric code, describing: A. In which tab ("Items Checked Out", '|| +'or "Other/Special Circulations") the circulation '|| +'should appear while checked out, and B. Whether the circulation should '|| +'continue to appear in the "Other" tab when checked in with '|| +'oustanding fines. '|| +'1 = (A) "Items", (B) "Other". 2 = (A) "Other", (B) "Other". ' || +'5 = (A) "Items", (B) do not display. 6 = (A) "Other", (B) do not display.', + 'coust', + 'description' + ) +WHERE NAME = 'ui.circ.items_out.claimsreturned'; + +COMMIT; -- 2.11.0