Open-ILS/src/sql/Pg/upgrade/0502.data.defacto_OCLC_local_cn_fields.sql

   1 BEGIN;
   2
   3 INSERT INTO config.upgrade_log (version) VALUES ('0502'); -- dbwells
   4
   5 -- Dewey fields
   6 UPDATE asset.call_number_class
   7     SET field = '080ab,082ab,092abef'
   8     WHERE id = 2
   9 ;
  10
  11 -- LC fields
  12 UPDATE asset.call_number_class
  13     SET field = '050ab,055ab,090abef'
  14     WHERE id = 3
  15 ;
  16
  17 COMMIT;