3 INSERT INTO config.upgrade_log (version) VALUES ('0365'); -- dbs
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';
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.
15 UPDATE asset.call_number_class
16 SET field = '050ab,055ab,060ab,070ab,080ab,082ab,086ab,088ab,090,092,096,098,099'
21 UPDATE asset.call_number_class
22 SET field = '080ab,082ab'
27 UPDATE asset.call_number_class
28 SET field = '050ab,055ab'