From d27157016e9651f1bd3d76b86cd54f01cf80533d Mon Sep 17 00:00:00 2001
From: miker <miker@dcc99617-32d9-48b4-a31d-7c20da2025e4>
Date: Wed, 19 Sep 2007 16:07:39 +0000
Subject: [PATCH] removing stopword removal (uh...) from keyword indexes

git-svn-id: svn://svn.open-ils.org/ILS/trunk@7800 dcc99617-32d9-48b4-a31d-7c20da2025e4
---
 Open-ILS/src/sql/Pg/000.english.pg80.fts-config.sql | 6 +++---
 Open-ILS/src/sql/Pg/000.english.pg81.fts-config.sql | 6 +++---
 Open-ILS/src/sql/Pg/000.english.pg82.fts-config.sql | 6 +++---
 3 files changed, 9 insertions(+), 9 deletions(-)

diff --git a/Open-ILS/src/sql/Pg/000.english.pg80.fts-config.sql b/Open-ILS/src/sql/Pg/000.english.pg80.fts-config.sql
index e201c9c086..c15bcf1265 100644
--- a/Open-ILS/src/sql/Pg/000.english.pg80.fts-config.sql
+++ b/Open-ILS/src/sql/Pg/000.english.pg80.fts-config.sql
@@ -92,9 +92,9 @@ INSERT INTO pg_ts_cfgmap VALUES ('keyword', 'file', '{simple}');
 INSERT INTO pg_ts_cfgmap VALUES ('keyword', 'float', '{simple}');
 INSERT INTO pg_ts_cfgmap VALUES ('keyword', 'int', '{simple}');
 INSERT INTO pg_ts_cfgmap VALUES ('keyword', 'uint', '{simple}');
-INSERT INTO pg_ts_cfgmap VALUES ('keyword', 'lword', '{en_stem}');
-INSERT INTO pg_ts_cfgmap VALUES ('keyword', 'lpart_hword', '{en_stem}');
-INSERT INTO pg_ts_cfgmap VALUES ('keyword', 'lhword', '{en_stem}');
+INSERT INTO pg_ts_cfgmap VALUES ('keyword', 'lword', '{en_stem_nostop}');
+INSERT INTO pg_ts_cfgmap VALUES ('keyword', 'lpart_hword', '{en_stem_nostop}');
+INSERT INTO pg_ts_cfgmap VALUES ('keyword', 'lhword', '{en_stem_nostop}');
 
 INSERT INTO pg_ts_cfgmap VALUES ('series', 'nlword', '{simple}');
 INSERT INTO pg_ts_cfgmap VALUES ('series', 'word', '{simple}');
diff --git a/Open-ILS/src/sql/Pg/000.english.pg81.fts-config.sql b/Open-ILS/src/sql/Pg/000.english.pg81.fts-config.sql
index e201c9c086..c15bcf1265 100644
--- a/Open-ILS/src/sql/Pg/000.english.pg81.fts-config.sql
+++ b/Open-ILS/src/sql/Pg/000.english.pg81.fts-config.sql
@@ -92,9 +92,9 @@ INSERT INTO pg_ts_cfgmap VALUES ('keyword', 'file', '{simple}');
 INSERT INTO pg_ts_cfgmap VALUES ('keyword', 'float', '{simple}');
 INSERT INTO pg_ts_cfgmap VALUES ('keyword', 'int', '{simple}');
 INSERT INTO pg_ts_cfgmap VALUES ('keyword', 'uint', '{simple}');
-INSERT INTO pg_ts_cfgmap VALUES ('keyword', 'lword', '{en_stem}');
-INSERT INTO pg_ts_cfgmap VALUES ('keyword', 'lpart_hword', '{en_stem}');
-INSERT INTO pg_ts_cfgmap VALUES ('keyword', 'lhword', '{en_stem}');
+INSERT INTO pg_ts_cfgmap VALUES ('keyword', 'lword', '{en_stem_nostop}');
+INSERT INTO pg_ts_cfgmap VALUES ('keyword', 'lpart_hword', '{en_stem_nostop}');
+INSERT INTO pg_ts_cfgmap VALUES ('keyword', 'lhword', '{en_stem_nostop}');
 
 INSERT INTO pg_ts_cfgmap VALUES ('series', 'nlword', '{simple}');
 INSERT INTO pg_ts_cfgmap VALUES ('series', 'word', '{simple}');
diff --git a/Open-ILS/src/sql/Pg/000.english.pg82.fts-config.sql b/Open-ILS/src/sql/Pg/000.english.pg82.fts-config.sql
index e201c9c086..c15bcf1265 100644
--- a/Open-ILS/src/sql/Pg/000.english.pg82.fts-config.sql
+++ b/Open-ILS/src/sql/Pg/000.english.pg82.fts-config.sql
@@ -92,9 +92,9 @@ INSERT INTO pg_ts_cfgmap VALUES ('keyword', 'file', '{simple}');
 INSERT INTO pg_ts_cfgmap VALUES ('keyword', 'float', '{simple}');
 INSERT INTO pg_ts_cfgmap VALUES ('keyword', 'int', '{simple}');
 INSERT INTO pg_ts_cfgmap VALUES ('keyword', 'uint', '{simple}');
-INSERT INTO pg_ts_cfgmap VALUES ('keyword', 'lword', '{en_stem}');
-INSERT INTO pg_ts_cfgmap VALUES ('keyword', 'lpart_hword', '{en_stem}');
-INSERT INTO pg_ts_cfgmap VALUES ('keyword', 'lhword', '{en_stem}');
+INSERT INTO pg_ts_cfgmap VALUES ('keyword', 'lword', '{en_stem_nostop}');
+INSERT INTO pg_ts_cfgmap VALUES ('keyword', 'lpart_hword', '{en_stem_nostop}');
+INSERT INTO pg_ts_cfgmap VALUES ('keyword', 'lhword', '{en_stem_nostop}');
 
 INSERT INTO pg_ts_cfgmap VALUES ('series', 'nlword', '{simple}');
 INSERT INTO pg_ts_cfgmap VALUES ('series', 'word', '{simple}');
-- 
2.11.0