From 495257a54739b619c95477843746a597128a7b71 Mon Sep 17 00:00:00 2001 From: Mike Rylander Date: Wed, 17 Apr 2013 14:04:11 -0400 Subject: [PATCH] Reinstate required TEXT SEARCH CONFIGURATION data Signed-off-by: Mike Rylander Signed-off-by: Jason Stephenson --- Open-ILS/src/sql/Pg/000.english.pg91.fts-config.sql | 10 +++++----- .../sql/Pg/upgrade/XXXX.schema.reinstate-tsconfigs.sql | 8 ++++++++ 2 files changed, 13 insertions(+), 5 deletions(-) create mode 100644 Open-ILS/src/sql/Pg/upgrade/XXXX.schema.reinstate-tsconfigs.sql diff --git a/Open-ILS/src/sql/Pg/000.english.pg91.fts-config.sql b/Open-ILS/src/sql/Pg/000.english.pg91.fts-config.sql index 0419aa727f..8bae23e091 100644 --- a/Open-ILS/src/sql/Pg/000.english.pg91.fts-config.sql +++ b/Open-ILS/src/sql/Pg/000.english.pg91.fts-config.sql @@ -45,12 +45,12 @@ ALTER TEXT SEARCH CONFIGURATION ' || lang || '_nostop ALTER MAPPING FOR asciiwor END LOOP; END; $$; ---CREATE TEXT SEARCH CONFIGURATION title ( COPY = english_nostop ); ---CREATE TEXT SEARCH CONFIGURATION author ( COPY = english_nostop ); ---CREATE TEXT SEARCH CONFIGURATION subject ( COPY = english_nostop ); +CREATE TEXT SEARCH CONFIGURATION title ( COPY = english_nostop ); +CREATE TEXT SEARCH CONFIGURATION author ( COPY = english_nostop ); +CREATE TEXT SEARCH CONFIGURATION subject ( COPY = english_nostop ); CREATE TEXT SEARCH CONFIGURATION keyword ( COPY = english_nostop ); ---CREATE TEXT SEARCH CONFIGURATION identifier ( COPY = english_nostop ); ---CREATE TEXT SEARCH CONFIGURATION series ( COPY = english_nostop ); +CREATE TEXT SEARCH CONFIGURATION identifier ( COPY = english_nostop ); +CREATE TEXT SEARCH CONFIGURATION series ( COPY = english_nostop ); CREATE TEXT SEARCH CONFIGURATION "default" ( COPY = english_nostop ); diff --git a/Open-ILS/src/sql/Pg/upgrade/XXXX.schema.reinstate-tsconfigs.sql b/Open-ILS/src/sql/Pg/upgrade/XXXX.schema.reinstate-tsconfigs.sql new file mode 100644 index 0000000000..9dad01d4ef --- /dev/null +++ b/Open-ILS/src/sql/Pg/upgrade/XXXX.schema.reinstate-tsconfigs.sql @@ -0,0 +1,8 @@ +SELECT evergreen.upgrade_deps_block_check('XXXX', :eg_version); + +-- These can be run outside of a transaction +CREATE TEXT SEARCH CONFIGURATION title ( COPY = english_nostop ); +CREATE TEXT SEARCH CONFIGURATION author ( COPY = english_nostop ); +CREATE TEXT SEARCH CONFIGURATION subject ( COPY = english_nostop ); +CREATE TEXT SEARCH CONFIGURATION series ( COPY = english_nostop ); +CREATE TEXT SEARCH CONFIGURATION identifier ( COPY = english_nostop ); -- 2.43.2