From 7cef76169d6c6f6f4ae3e6ea165d672783b34139 Mon Sep 17 00:00:00 2001 From: Mike Rylander Date: Mon, 2 Apr 2012 07:50:40 -0400 Subject: [PATCH] Stamping upgrade script for Copy Editor Field Hiding Signed-off-by: Mike Rylander --- Open-ILS/src/sql/Pg/002.schema.config.sql | 2 +- ...rg-setting-ui.hide_copy_editor_fields.sql} | 3 +-- .../Pg/version-upgrade/2.1-2.2-upgrade-db.sql | 25 +++++++++++++++++++ 3 files changed, 27 insertions(+), 3 deletions(-) rename Open-ILS/src/sql/Pg/upgrade/{XXXX.data.org-setting-ui.hide_copy_editor_fields.sql => 0699.data.org-setting-ui.hide_copy_editor_fields.sql} (66%) diff --git a/Open-ILS/src/sql/Pg/002.schema.config.sql b/Open-ILS/src/sql/Pg/002.schema.config.sql index 1c62469a38..eaf0e9fdb7 100644 --- a/Open-ILS/src/sql/Pg/002.schema.config.sql +++ b/Open-ILS/src/sql/Pg/002.schema.config.sql @@ -86,7 +86,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 ('0698', :eg_version); -- tsbere +INSERT INTO config.upgrade_log (version, applied_to) VALUES ('0699', :eg_version); -- phasefx/miker CREATE TABLE config.bib_source ( id SERIAL PRIMARY KEY, diff --git a/Open-ILS/src/sql/Pg/upgrade/XXXX.data.org-setting-ui.hide_copy_editor_fields.sql b/Open-ILS/src/sql/Pg/upgrade/0699.data.org-setting-ui.hide_copy_editor_fields.sql similarity index 66% rename from Open-ILS/src/sql/Pg/upgrade/XXXX.data.org-setting-ui.hide_copy_editor_fields.sql rename to Open-ILS/src/sql/Pg/upgrade/0699.data.org-setting-ui.hide_copy_editor_fields.sql index df06384b65..5d95f89344 100644 --- a/Open-ILS/src/sql/Pg/upgrade/XXXX.data.org-setting-ui.hide_copy_editor_fields.sql +++ b/Open-ILS/src/sql/Pg/upgrade/0699.data.org-setting-ui.hide_copy_editor_fields.sql @@ -1,6 +1,6 @@ BEGIN; -SELECT evergreen.upgrade_deps_block_check('XXXX', :eg_version); +SELECT evergreen.upgrade_deps_block_check('0699', :eg_version); INSERT INTO config.org_unit_setting_type ( name, label, description, datatype, grp ) VALUES ( @@ -23,6 +23,5 @@ INSERT INTO config.org_unit_setting_type ( name, label, description, datatype, g 'gui' ); --- DELETE FROM actor.org_unit_setting WHERE name = 'ui.hide_copy_editor_fields'; DELETE FROM config.org_unit_setting_type_log WHERE field_name = 'ui.hide_copy_editor_fields'; DELETE FROM config.org_unit_setting_type WHERE name = 'ui.hide_copy_editor_fields'; DELETE FROM config.upgrade_log WHERE version = 'XXXX'; 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 617b2061f1..2236318c08 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 @@ -15074,4 +15074,29 @@ INSERT into config.org_unit_setting_type 'bool', null) ; + +SELECT evergreen.upgrade_deps_block_check('0699', :eg_version); + +INSERT INTO config.org_unit_setting_type ( name, label, description, datatype, grp ) + VALUES ( + 'ui.hide_copy_editor_fields', + oils_i18n_gettext( + 'ui.hide_copy_editor_fields', + 'GUI: Hide these fields within the Item Attribute Editor', + 'coust', + 'label' + ), + oils_i18n_gettext( + 'ui.hide_copy_editor_fields', + 'This setting may be best maintained with the dedicated configuration' + || ' interface within the Item Attribute Editor. However, here it' + || ' shows up as comma separated list of field identifiers to hide.', + 'coust', + 'description' + ), + 'array', + 'gui' + ); + + COMMIT; -- 2.43.2