From 9f6db569aba8118f1a654fce9165aa7f6c68a9eb Mon Sep 17 00:00:00 2001 From: Dan Wells Date: Tue, 22 Jan 2019 14:33:08 -0500 Subject: [PATCH] Forward-port 3.2.3 upgrade script Signed-off-by: Dan Wells --- .../version-upgrade/3.2.2-3.2.3-upgrade-db.sql | 17 +++++++++++++++++ 1 file changed, 17 insertions(+) create mode 100644 Open-ILS/src/sql/Pg/version-upgrade/3.2.2-3.2.3-upgrade-db.sql diff --git a/Open-ILS/src/sql/Pg/version-upgrade/3.2.2-3.2.3-upgrade-db.sql b/Open-ILS/src/sql/Pg/version-upgrade/3.2.2-3.2.3-upgrade-db.sql new file mode 100644 index 0000000000..865beffd13 --- /dev/null +++ b/Open-ILS/src/sql/Pg/version-upgrade/3.2.2-3.2.3-upgrade-db.sql @@ -0,0 +1,17 @@ +--Upgrade Script for 3.2.2 to 3.2.3 +\set eg_version '''3.2.3''' +BEGIN; +INSERT INTO config.upgrade_log (version, applied_to) VALUES ('3.2.3', :eg_version); + +SELECT evergreen.upgrade_deps_block_check('1141', :eg_version); + +ALTER TABLE vandelay.session_tracker + ALTER COLUMN record_type TYPE TEXT, + ALTER COLUMN record_type SET DEFAULT 'bib'::TEXT; + +ALTER TABLE vandelay.session_tracker + ADD CONSTRAINT vand_tracker_valid_record_type + CHECK (record_type IN ('bib', 'authority')); + + +COMMIT; -- 2.43.2