1 /* Enable LIKE to use an index for database clusters with locales other than C or POSIX */
2 CREATE INDEX authority_full_rec_value_tpo_index ON authority.full_rec (value text_pattern_ops);
4 /* Upgrade to MODS32 for transforms */
5 ALTER TABLE config.metabib_field
6 ALTER COLUMN format SET DEFAULT 'mods32';
7 UPDATE config.metabib_field
10 /* Update index definitions to MODS32-compliant XPaths */
11 UPDATE config.metabib_field
12 SET xpath = $$//mods:mods/mods:name[@type='corporate']/mods:namePart[../mods:role/mods:roleTerm[text()='creator']]$$
13 WHERE field_class = 'author' AND name = 'corporate';
14 UPDATE config.metabib_field
15 SET xpath = $$//mods:mods/mods:name[@type='personal']/mods:namePart[../mods:role/mods:roleTerm[text()='creator']]$$
16 WHERE field_class = 'author' AND name = 'personal';
17 UPDATE config.metabib_field
18 SET xpath = $$//mods:mods/mods:name[@type='conference']/mods:namePart[../mods:role/mods:roleTerm[text()='creator']]$$
19 WHERE field_class = 'author' AND name = 'conference';
20 /* And they all want mods32: as their prefix */
21 UPDATE config.metabib_field
22 SET xpath = regexp_replace(xpath, 'mods:', 'mods32:', 'g');