LP#1806968 Teach Vandelay to pass correct auth tracker type
[Evergreen.git] / Open-ILS / src / sql / Pg / upgrade / XXXX.schema.vandelay-record-type-fix.sql
1 BEGIN;
2
3 --SELECT evergreen.upgrade_deps_block_check('XXXX', :eg_version);
4
5 ALTER TABLE vandelay.session_tracker
6     ALTER COLUMN record_type TYPE TEXT,
7     ALTER COLUMN record_type SET DEFAULT 'bib'::TEXT;
8
9 ALTER TABLE vandelay.session_tracker
10     ADD CONSTRAINT vand_tracker_valid_record_type
11         CHECK (record_type IN ('bib', 'authority'));
12
13 COMMIT;
14