From 0de57d3d0ef43eb9ed91056560df9e47eecfa43e Mon Sep 17 00:00:00 2001 From: Galen Charlton Date: Mon, 27 Mar 2023 11:48:52 -0400 Subject: [PATCH] forward-port 3.8.3 schema update script Signed-off-by: Galen Charlton --- .../Pg/version-upgrade/3.8.2-3.8.3-upgrade-db.sql | 38 ++++++++++++++++++++++ 1 file changed, 38 insertions(+) create mode 100644 Open-ILS/src/sql/Pg/version-upgrade/3.8.2-3.8.3-upgrade-db.sql diff --git a/Open-ILS/src/sql/Pg/version-upgrade/3.8.2-3.8.3-upgrade-db.sql b/Open-ILS/src/sql/Pg/version-upgrade/3.8.2-3.8.3-upgrade-db.sql new file mode 100644 index 0000000000..f1174dec41 --- /dev/null +++ b/Open-ILS/src/sql/Pg/version-upgrade/3.8.2-3.8.3-upgrade-db.sql @@ -0,0 +1,38 @@ +--Upgrade Script for 3.8.2 to 3.8.3 +\set eg_version '''3.8.3''' +BEGIN; +INSERT INTO config.upgrade_log (version, applied_to) VALUES ('3.8.3', :eg_version); + +-- check whether patch can be applied +SELECT evergreen.upgrade_deps_block_check('1361', :eg_version); + +INSERT INTO config.global_flag (name, value, enabled, label) +VALUES ( + 'opac.max_concurrent_search.query', + '20', + TRUE, + oils_i18n_gettext( + 'opac.max_concurrent_search.query', + 'Limit the number of global concurrent matching search queries', + 'cgf', 'label' + ) +); + +INSERT INTO config.global_flag (name, value, enabled, label) +VALUES ( + 'opac.max_concurrent_search.ip', + '0', + TRUE, + oils_i18n_gettext( + 'opac.max_concurrent_search.ip', + 'Limit the number of global concurrent searches per client IP address', + 'cgf', 'label' + ) +); + + +COMMIT; + +-- Update auditor tables to catch changes to source tables. +-- Can be removed/skipped if there were no schema changes. +SELECT auditor.update_auditors(); -- 2.11.0