From 26f6eec60921e320a37c6cb394366bb188ca012c Mon Sep 17 00:00:00 2001 From: Bill Erickson Date: Thu, 21 Mar 2019 16:20:34 -0400 Subject: [PATCH] JBAS-1832 3.2 point release updates SQL cross-port Signed-off-by: Bill Erickson --- KCLS/sql/schema/deploy/3.2-post-base-schema.sql | 20 ++++++-------------- 1 file changed, 6 insertions(+), 14 deletions(-) diff --git a/KCLS/sql/schema/deploy/3.2-post-base-schema.sql b/KCLS/sql/schema/deploy/3.2-post-base-schema.sql index 1569fd20e8..f3536d77ae 100644 --- a/KCLS/sql/schema/deploy/3.2-post-base-schema.sql +++ b/KCLS/sql/schema/deploy/3.2-post-base-schema.sql @@ -366,14 +366,6 @@ BEGIN END; $$ LANGUAGE plpgsql; -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')); - CREATE OR REPLACE VIEW reporter.simple_record AS SELECT r.id, s.metarecord, @@ -425,12 +417,12 @@ BEGIN ) ); - SELECT evergreen.upgrade_deps_block_check('1136', :eg_version); - SELECT evergreen.upgrade_deps_block_check('1137', :eg_version); - SELECT evergreen.upgrade_deps_block_check('1138', :eg_version); - SELECT evergreen.upgrade_deps_block_check('1141', :eg_version); - SELECT evergreen.upgrade_deps_block_check('1142', :eg_version); - SELECT evergreen.upgrade_deps_block_check('1149', :eg_version); -- Dyrcona/mmorgan/gmcharlt + PERFORM evergreen.upgrade_deps_block_check('1136', '3.2.1'); + PERFORM evergreen.upgrade_deps_block_check('1137', '3.2.1'); + PERFORM evergreen.upgrade_deps_block_check('1138', '3.2.1'); + PERFORM evergreen.upgrade_deps_block_check('1141', '3.2.1'); + PERFORM evergreen.upgrade_deps_block_check('1142', '3.2.1'); + PERFORM evergreen.upgrade_deps_block_check('1149', '3.2.1'); -- Dyrcona/mmorgan/gmcharlt END IF; END $INSERT$; -- 2.11.0