From 3cbdf3a4ca85de36a22cb3517b24ae54f19eece6 Mon Sep 17 00:00:00 2001 From: dbs Date: Thu, 19 Nov 2009 16:18:43 +0000 Subject: [PATCH] Hmm. Missed this vestigial, dead file. Deleting. git-svn-id: svn://svn.open-ils.org/ILS/branches/rel_1_6_0@14973 dcc99617-32d9-48b4-a31d-7c20da2025e4 --- Open-ILS/src/sql/Pg/1.2.3-1.4-upgrade-db.sql | 22 ---------------------- 1 file changed, 22 deletions(-) delete mode 100644 Open-ILS/src/sql/Pg/1.2.3-1.4-upgrade-db.sql diff --git a/Open-ILS/src/sql/Pg/1.2.3-1.4-upgrade-db.sql b/Open-ILS/src/sql/Pg/1.2.3-1.4-upgrade-db.sql deleted file mode 100644 index fcf439619a..0000000000 --- a/Open-ILS/src/sql/Pg/1.2.3-1.4-upgrade-db.sql +++ /dev/null @@ -1,22 +0,0 @@ -/* Enable LIKE to use an index for database clusters with locales other than C or POSIX */ -CREATE INDEX authority_full_rec_value_tpo_index ON authority.full_rec (value text_pattern_ops); - -/* Upgrade to MODS32 for transforms */ -ALTER TABLE config.metabib_field - ALTER COLUMN format SET DEFAULT 'mods32'; -UPDATE config.metabib_field - SET format = 'mods32'; - -/* Update index definitions to MODS32-compliant XPaths */ -UPDATE config.metabib_field - SET xpath = $$//mods:mods/mods:name[@type='corporate']/mods:namePart[../mods:role/mods:roleTerm[text()='creator']]$$ - WHERE field_class = 'author' AND name = 'corporate'; -UPDATE config.metabib_field - SET xpath = $$//mods:mods/mods:name[@type='personal']/mods:namePart[../mods:role/mods:roleTerm[text()='creator']]$$ - WHERE field_class = 'author' AND name = 'personal'; -UPDATE config.metabib_field - SET xpath = $$//mods:mods/mods:name[@type='conference']/mods:namePart[../mods:role/mods:roleTerm[text()='creator']]$$ - WHERE field_class = 'author' AND name = 'conference'; -/* And they all want mods32: as their prefix */ -UPDATE config.metabib_field - SET xpath = regexp_replace(xpath, 'mods:', 'mods32:', 'g'); -- 2.11.0