From 6e13cf72fae54271601259ea6cccfd41c64297d3 Mon Sep 17 00:00:00 2001 From: Bill Erickson Date: Fri, 24 May 2019 14:52:58 -0400 Subject: [PATCH] LP1819181 Stamping upgrade: DoB example setting Signed-off-by: Bill Erickson --- Open-ILS/src/sql/Pg/002.schema.config.sql | 2 +- .../Pg/upgrade/1165.data.lp1819181-example-dob.sql | 12 ++++++++++++ .../Pg/upgrade/XXXX.data.lp1819181-example-dob.sql | 12 ------------ 3 files changed, 13 insertions(+), 13 deletions(-) create mode 100644 Open-ILS/src/sql/Pg/upgrade/1165.data.lp1819181-example-dob.sql delete mode 100644 Open-ILS/src/sql/Pg/upgrade/XXXX.data.lp1819181-example-dob.sql diff --git a/Open-ILS/src/sql/Pg/002.schema.config.sql b/Open-ILS/src/sql/Pg/002.schema.config.sql index 14f4852c3a..3b96c9f136 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 ('1164', :eg_version); -- mmorgan/berick +INSERT INTO config.upgrade_log (version, applied_to) VALUES ('1165', :eg_version); -- jboyer/berick CREATE TABLE config.bib_source ( id SERIAL PRIMARY KEY, diff --git a/Open-ILS/src/sql/Pg/upgrade/1165.data.lp1819181-example-dob.sql b/Open-ILS/src/sql/Pg/upgrade/1165.data.lp1819181-example-dob.sql new file mode 100644 index 0000000000..9502134923 --- /dev/null +++ b/Open-ILS/src/sql/Pg/upgrade/1165.data.lp1819181-example-dob.sql @@ -0,0 +1,12 @@ +BEGIN; + +SELECT evergreen.upgrade_deps_block_check('1165', :eg_version); + +INSERT INTO config.org_unit_setting_type (name,label,grp,description,datatype) +VALUES ('ui.patron.edit.au.dob.example',oils_i18n_gettext('ui.patron.edit.au.dob.example', + 'Example dob field on patron registration', 'coust', 'label'),'gui', + oils_i18n_gettext('ui.patron.edit.au.dob.example', + 'The Example for validation on the dob field in patron registration.', 'coust', 'description'), + 'string'); + +COMMIT; diff --git a/Open-ILS/src/sql/Pg/upgrade/XXXX.data.lp1819181-example-dob.sql b/Open-ILS/src/sql/Pg/upgrade/XXXX.data.lp1819181-example-dob.sql deleted file mode 100644 index b35f9c7a2d..0000000000 --- a/Open-ILS/src/sql/Pg/upgrade/XXXX.data.lp1819181-example-dob.sql +++ /dev/null @@ -1,12 +0,0 @@ -BEGIN; - -SELECT evergreen.upgrade_deps_block_check('XXXX', :eg_version); - -INSERT INTO config.org_unit_setting_type (name,label,grp,description,datatype) -VALUES ('ui.patron.edit.au.dob.example',oils_i18n_gettext('ui.patron.edit.au.dob.example', - 'Example dob field on patron registration', 'coust', 'label'),'gui', - oils_i18n_gettext('ui.patron.edit.au.dob.example', - 'The Example for validation on the dob field in patron registration.', 'coust', 'description'), - 'string'); - -COMMIT; -- 2.43.2