From 6edccd3319fe217482497b1c781095d346391eb3 Mon Sep 17 00:00:00 2001
From: Bill Erickson <berickxx@gmail.com>
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 <berickxx@gmail.com>
Signed-off-by: Jason Boyer <jboyer@library.in.gov>
---
.../sql/Pg/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.11.0