3 -- Generate the equivalent of compound subject entries from the existing rows
4 -- so that we don't have to laboriously reindex them
6 INSERT INTO config.upgrade_log (version) VALUES ('0030'); -- dbs
8 INSERT INTO config.metabib_field (field_class, name, format, xpath ) VALUES
9 ( 'subject', 'complete', 'mods32', $$//mods32:mods/mods32:subject//text()$$ );
11 CREATE INDEX metabib_subject_field_entry_source_idx ON metabib.subject_field_entry (source);
13 INSERT INTO metabib.subject_field_entry (source, field, value)
16 FROM config.metabib_field
17 WHERE field_class = 'subject' AND name = 'complete'
22 FROM metabib.subject_field_entry msfe
23 WHERE msfe.source = groupee.source
29 FROM metabib.subject_field_entry