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
   6 ALTER TABLE vandelay.session_tracker
   7     ALTER COLUMN record_type TYPE 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 END;
  14 $$ LANGUAGE plpgsql;
  15
  16 COMMIT;