From b6d0ee7f0eeed0c65270a13aba0627f2e7c83cdd Mon Sep 17 00:00:00 2001 From: Jason Etheridge Date: Fri, 12 Jul 2013 12:21:47 -0400 Subject: [PATCH] upgrde scrpt/release note for Usr Setting Defaults Signed-off-by: Jason Etheridge --- Open-ILS/src/sql/Pg/002.schema.config.sql | 2 +- Open-ILS/src/sql/Pg/upgrade/0807.usr_setting_default.sql | 9 +++++++++ Open-ILS/src/sql/Pg/upgrade/XXXX.usr_setting_default.sql | 2 -- docs/RELEASE_NOTES_NEXT/Client/user-setting-defaults.txt | 4 ++++ 4 files changed, 14 insertions(+), 3 deletions(-) create mode 100644 Open-ILS/src/sql/Pg/upgrade/0807.usr_setting_default.sql delete mode 100644 Open-ILS/src/sql/Pg/upgrade/XXXX.usr_setting_default.sql create mode 100644 docs/RELEASE_NOTES_NEXT/Client/user-setting-defaults.txt diff --git a/Open-ILS/src/sql/Pg/002.schema.config.sql b/Open-ILS/src/sql/Pg/002.schema.config.sql index 2d44af9159..8eae7a7402 100644 --- a/Open-ILS/src/sql/Pg/002.schema.config.sql +++ b/Open-ILS/src/sql/Pg/002.schema.config.sql @@ -91,7 +91,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 ('0806', :eg_version); -- berick/miker +INSERT INTO config.upgrade_log (version, applied_to) VALUES ('0807', :eg_version); -- tsbere/phasefx CREATE TABLE config.bib_source ( id SERIAL PRIMARY KEY, diff --git a/Open-ILS/src/sql/Pg/upgrade/0807.usr_setting_default.sql b/Open-ILS/src/sql/Pg/upgrade/0807.usr_setting_default.sql new file mode 100644 index 0000000000..c67fd0ed15 --- /dev/null +++ b/Open-ILS/src/sql/Pg/upgrade/0807.usr_setting_default.sql @@ -0,0 +1,9 @@ +BEGIN; + +-- check whether patch can be applied +SELECT evergreen.upgrade_deps_block_check('0807', :eg_version); + +ALTER TABLE config.usr_setting_type + ADD COLUMN reg_default TEXT; + +COMMIT; diff --git a/Open-ILS/src/sql/Pg/upgrade/XXXX.usr_setting_default.sql b/Open-ILS/src/sql/Pg/upgrade/XXXX.usr_setting_default.sql deleted file mode 100644 index e55e1e2f2b..0000000000 --- a/Open-ILS/src/sql/Pg/upgrade/XXXX.usr_setting_default.sql +++ /dev/null @@ -1,2 +0,0 @@ -ALTER TABLE config.usr_setting_type - ADD COLUMN reg_default TEXT; diff --git a/docs/RELEASE_NOTES_NEXT/Client/user-setting-defaults.txt b/docs/RELEASE_NOTES_NEXT/Client/user-setting-defaults.txt new file mode 100644 index 0000000000..333018cd0f --- /dev/null +++ b/docs/RELEASE_NOTES_NEXT/Client/user-setting-defaults.txt @@ -0,0 +1,4 @@ +User Setting Defaults +^^^^^^^^^^^^^^^^^^^^^^^^ + +For use during Patron Registration, we can now have supply default values for User Settings, under Admin -> Server Administration -> User Setting Types. -- 2.43.2