Free text search: add french_archeo thesaurus config

1 files changed, 23 insertions, 0 deletions

diff --git a/postgres/french/create.sql b/postgres/french/create.sql
new file mode 100644
index 000000000..4f1b9ee0e
--- /dev/null
+++ b/postgres/french/create.sql
@@ -0,0 +1,23 @@
+DROP TEXT SEARCH CONFIGURATION IF EXISTS french_archeo;
+DROP TEXT SEARCH DICTIONARY IF EXISTS thesaurus_french_archeo;
+
+
+CREATE TEXT SEARCH CONFIGURATION french_archeo (
+   COPY = french
+);
+
+ALTER TEXT SEARCH CONFIGURATION french_archeo
+   DROP MAPPING FOR hword_asciipart;
+ALTER TEXT SEARCH CONFIGURATION french_archeo
+   DROP MAPPING FOR hword_part;
+
+
+CREATE TEXT SEARCH DICTIONARY thesaurus_french_archeo (
+    TEMPLATE = thesaurus,
+    DictFile = thesaurus_french_archeo,
+    Dictionary = pg_catalog.simple
+);
+
+ALTER TEXT SEARCH CONFIGURATION french_archeo
+   ALTER MAPPING FOR asciihword, asciiword, hword, word
+   WITH thesaurus_french_archeo, french_stem;