Open-ILS/src/sql/Pg/upgrade/0365.schema.asset_call_number_class_field.sql

   1 BEGIN;
   2
   3 INSERT INTO config.upgrade_log (version) VALUES ('0365'); -- dbs
   4
   5 ALTER TABLE asset.call_number_class ADD COLUMN field TEXT NOT NULL DEFAULT '050ab,055ab,060ab,070ab,080ab,082ab,086ab,088ab,090,092,096,098,099';
   6
   7 COMMENT ON TABLE asset.call_number_class IS $$
   8 Defines the call number normalization database functions in the "normalizer"
   9 column and the tag/subfield combinations to use to lookup the call number in
  10 the "field" column for a given classification scheme. Tag/subfield combinations
  11 are delimited by commas.
  12 $$;
  13
  14 -- Generic fields
  15 UPDATE asset.call_number_class
  16     SET field = '050ab,055ab,060ab,070ab,080ab,082ab,086ab,088ab,090,092,096,098,099'
  17     WHERE id = 1
  18 ;
  19
  20 -- Dewey fields
  21 UPDATE asset.call_number_class
  22     SET field = '080ab,082ab'
  23     WHERE id = 2
  24 ;
  25
  26 -- LC fields
  27 UPDATE asset.call_number_class
  28     SET field = '050ab,055ab'
  29     WHERE id = 3
  30 ;
  31
  32 COMMIT;