From 68dd9911573c8eb630656f4cb6f66717451d8310 Mon Sep 17 00:00:00 2001 From: Bill Erickson Date: Thu, 6 Dec 2018 12:09:58 -0500 Subject: [PATCH] LP#1806968 Vand ses. tracker upgrade SQL additions Force the default value to show in the DB as 'bib'::text instead of 'bib'::vandelay.bib_queue_queue_type, which might be confusing. Removed some stray SQL from the script. Signed-off-by: Bill Erickson Signed-off-by: Jason Boyer --- .../upgrade/XXXX.schema.vandelay-record-type-fix.sql | 10 ++++------ 1 file changed, 4 insertions(+), 6 deletions(-) diff --git a/Open-ILS/src/sql/Pg/upgrade/XXXX.schema.vandelay-record-type-fix.sql b/Open-ILS/src/sql/Pg/upgrade/XXXX.schema.vandelay-record-type-fix.sql index 1187011783..0ba8a6ee1c 100644 --- a/Open-ILS/src/sql/Pg/upgrade/XXXX.schema.vandelay-record-type-fix.sql +++ b/Open-ILS/src/sql/Pg/upgrade/XXXX.schema.vandelay-record-type-fix.sql @@ -1,16 +1,14 @@ BEGIN; -SELECT evergreen.upgrade_deps_block_check('XXXX', :eg_version); - +--SELECT evergreen.upgrade_deps_block_check('XXXX', :eg_version); ALTER TABLE vandelay.session_tracker - ALTER COLUMN record_type TYPE TEXT; + 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')); -END; -$$ LANGUAGE plpgsql; +COMMIT; -COMMIT; \ No newline at end of file -- 2.43.2