From c65a219526f1038cb428b5b419979ce82b5dc7f9 Mon Sep 17 00:00:00 2001 From: Kyle Huckins Date: Tue, 27 Nov 2018 23:21:15 +0000 Subject: [PATCH] LP#1806968 Vandelay record_type sql fix - Change record_type to TEXT rather than an enum, constrained with the option of "authority" or "bib" Signed-off-by: Kyle Huckins Changes to be committed: modified: Open-ILS/src/sql/Pg/012.schema.vandelay.sql new file: Open-ILS/src/sql/Pg/upgrade/XXXX.schema.vandelay-record-type-fix.sql Signed-off-by: Bill Erickson Signed-off-by: Jason Boyer --- .../Pg/upgrade/XXXX.schema.vandelay-record-type-fix.sql | 16 ++++++++++++++++ 1 file changed, 16 insertions(+) create mode 100644 Open-ILS/src/sql/Pg/upgrade/XXXX.schema.vandelay-record-type-fix.sql 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 new file mode 100644 index 0000000000..1187011783 --- /dev/null +++ b/Open-ILS/src/sql/Pg/upgrade/XXXX.schema.vandelay-record-type-fix.sql @@ -0,0 +1,16 @@ +BEGIN; + +SELECT evergreen.upgrade_deps_block_check('XXXX', :eg_version); + + +ALTER TABLE vandelay.session_tracker + ALTER COLUMN record_type TYPE TEXT; + +ALTER TABLE vandelay.session_tracker + ADD CONSTRAINT vand_tracker_valid_record_type + CHECK (record_type IN ('bib', 'authority')); + +END; +$$ LANGUAGE plpgsql; + +COMMIT; \ No newline at end of file -- 2.11.0