3 INSERT INTO config.metabib_field (id, field_class, name, label, browse_field)
4 VALUES (45, 'keyword', 'blob', 'All searchable fields', FALSE);
6 INSERT INTO config.metabib_field_virtual_map (real, virtual)
9 FROM config.metabib_field
11 AND id NOT IN (15, 45)
12 AND id NOT IN (SELECT real FROM config.metabib_field_virtual_map);
14 UPDATE config.metabib_field SET xpath=$$//mods32:mods/mods32:subject[not(descendant::mods32:geographicCode)]$$ WHERE id = 16;
17 INSERT INTO config.metabib_field_ts_map (metabib_field, ts_config)
18 SELECT 33, 'english_nostop' WHERE NOT EXISTS (
19 SELECT 1 FROM config.metabib_field_ts_map WHERE metabib_field = 33 AND ts_config = 'english_nostop'
26 \qecho Reingesting all records. This may take a while.
27 \qecho This command can be stopped (control-c) and rerun later if needed:
31 \qecho same_marc BOOL;
33 \qecho SELECT INTO same_marc enabled FROM config.internal_flag WHERE name = 'ingest.reingest.force_on_same_marc';
34 \qecho UPDATE config.internal_flag SET enabled = true WHERE name = 'ingest.reingest.force_on_same_marc';
35 \qecho UPDATE biblio.record_entry SET id=id WHERE not deleted AND id > 0;
36 \qecho UPDATE config.internal_flag SET enabled = same_marc WHERE name = 'ingest.reingest.force_on_same_marc';
44 SELECT INTO same_marc enabled FROM config.internal_flag WHERE name = 'ingest.reingest.force_on_same_marc';
45 UPDATE config.internal_flag SET enabled = true WHERE name = 'ingest.reingest.force_on_same_marc';
46 UPDATE biblio.record_entry SET id=id WHERE not deleted AND id > 0;
47 UPDATE config.internal_flag SET enabled = same_marc WHERE name = 'ingest.reingest.force_on_same_marc';