12,10 → 12,10 |
type = mysql |
|
sql_host = localhost |
sql_user = root |
sql_user = telabotap |
sql_pass = |
sql_db = raphdb |
sql_sock = /var/lib/mysql/mysql.sock |
sql_db = tela_prod_v4 |
sql_sock = /run/mysqld/mysqld.sock |
|
sql_query_pre = SET NAMES utf8 |
sql_query_pre = SET CHARACTER_SET_RESULTS=utf8 |
28,7 → 28,7 |
# ces deux directive permettent à la source abstraite d'être valide |
# lors de l'utilisation de sphinx-search sans précision d'index |
source = common |
path = /var/lib/sphinx/void |
path = /var/lib/sphinxsearch/void |
docinfo = extern |
stopwords = /etc/sphinx/stopwords.txt |
|
45,7 → 45,7 |
phrase_boundary = ., ?, !, U+2026 |
|
# http://sphinxsearch.com/wiki/doku.php?id=charset_tables |
# mysql raphdb<<<"SELECT p_description FROM projet WHERE p_id = 121"|xxd |
# mysql tela_prod_v4<<<"SELECT p_description FROM projet WHERE p_id = 121"|xxd |
# sphinx-search -q -c sphinx-min.conf -i i_projet "homoge*|homogé"|grep -w hits |
# SELECT * FROM i_projet WHERE MATCH('homoge*|homogé'); SHOW META; |
charset_type = utf-8 |
197,7 → 197,7 |
|
index i_spip : i_common { |
source = spip |
path = /var/lib/sphinx/spip |
path = /var/lib/sphinxsearch/spip |
|
# prefix_fields = titre, texte |
infix_fields = titre, texte |
245,7 → 245,7 |
|
index i_papyrus : i_common { |
source = papyrus |
path = /var/lib/sphinx/papyrus |
path = /var/lib/sphinxsearch/papyrus |
|
# prefix_fields = titre, texte |
infix_fields = titre, texte |
278,7 → 278,7 |
|
index i_projet : i_common { |
source = projet |
path = /var/lib/sphinx/projet |
path = /var/lib/sphinxsearch/projet |
|
# prefix_fields = titre, texte |
infix_fields = titre, texte |
302,7 → 302,7 |
|
index i_bazar : i_common { |
source = bazar |
path = /var/lib/sphinx/bazar |
path = /var/lib/sphinxsearch/bazar |
|
# prefix_fields = titre, texte |
infix_fields = titre, texte |
330,7 → 330,7 |
|
index i_coste : i_common { |
source = coste |
path = /var/lib/sphinx/coste |
path = /var/lib/sphinxsearch/coste |
|
infix_fields = texte, titre |
} |
362,7 → 362,7 |
|
index i_nvjfl : i_common { |
source = nvjfl |
path = /var/lib/sphinx/nvjfl |
path = /var/lib/sphinxsearch/nvjfl |
|
infix_fields = texte, titre |
} |
382,7 → 382,7 |
SELECT a.num_nom + 500000, a.nom_sci, a.auteur, \ |
"bdtxa" AS group_id, CONCAT("bdtxa-", a.num_nom) AS main_id, a.num_nom, \ |
CONCAT(aret.nom_sci, ' ', aret.auteur) AS nom_ret \ |
FROM bdtxa_v1_00 a LEFT JOIN bdtxa_v1_00 aret ON a.num_nom_retenu = aret.num_nom \ |
FROM bdtxa_v1_01 a LEFT JOIN bdtxa_v1_01 aret ON a.num_nom_retenu = aret.num_nom \ |
UNION ALL \ |
SELECT i.num_nom + 1000000, i.nom_sci, i.auteur, \ |
"isfan" AS group_id, CONCAT("isfan-", i.num_nom) AS main_id, i.num_nom, \ |
396,12 → 396,17 |
sql_attr_uint = num_nom |
sql_attr_string = nom_ret |
|
sql_query_info = SELECT * FROM bdtfx_v1_01 b, bdtxa_v1_00 a, isfan_v2013 is WHERE b.num_nom=$id OR a.num_nom=$id OR is.num_nom=$id |
sql_query_info = SELECT num_nom, num_nom_retenu, num_tax_sup, rang, nom_sci, genre, auteur, annee, homonyme, nom_francais, num_taxonomique, nom_complet, famille FROM bdtfx_v1_01 \ |
WHERE num_nom=$id UNION \ |
SELECT num_nom, num_nom_retenu, num_tax_sup, rang, nom_sci, genre, auteur, annee, homonyme, nom_francais, num_tax, nom_complet, famille FROM bdtxa_v1_01 \ |
WHERE num_nom=$id UNION \ |
SELECT num_nom, num_nom_retenu, num_tax_sup, rang, nom_sci, genre, auteur, annee, NULL, NULL, num_taxonomique, nom_complet, famille FROM isfan_v2013 \ |
WHERE num_nom=$id |
} |
|
index i_bdtfx : i_common { |
source = bdtfx |
path = /var/lib/sphinx/bdtfx |
path = /var/lib/sphinxsearch/bdtfx |
|
stopwords = |
morphology = |
427,7 → 432,7 |
SELECT a.num_nom + 500000, a.nom_sci, a.auteur, \ |
"bdtxa" AS group_id, CONCAT("bdtxa-", a.num_nom) AS main_id, a.num_nom, \ |
CONCAT(aret.nom_sci, ' ', aret.auteur) AS nom_ret \ |
FROM bdtxa_v1_00 a LEFT JOIN bdtxa_v1_00 aret ON a.num_nom_retenu = aret.num_nom \ |
FROM bdtxa_v1_01 a LEFT JOIN bdtxa_v1_01 aret ON a.num_nom_retenu = aret.num_nom \ |
UNION ALL \ |
SELECT i.num_nom + 1000000, i.nom_sci, i.auteur, \ |
"isfan" AS group_id, CONCAT("isfan-", i.num_nom) AS main_id, i.num_nom, \ |
441,12 → 446,17 |
sql_attr_uint = num_nom |
sql_attr_string = nom_ret |
|
sql_query_info = SELECT * FROM bdtfx_v2_00 b, bdtxa_v1_00 a, isfan_v2013 is WHERE b.num_nom=$id OR a.num_nom=$id OR is.num_nom=$id |
sql_query_info = SELECT num_nom, num_nom_retenu, num_tax_sup, rang, nom_sci, genre, auteur, annee, homonyme, nom_francais, num_taxonomique, nom_complet, famille FROM bdtfx_v2_00 \ |
WHERE num_nom=$id UNION \ |
SELECT num_nom, num_nom_retenu, num_tax_sup, rang, nom_sci, genre, auteur, annee, homonyme, nom_francais, num_tax, nom_complet, famille FROM bdtxa_v1_01 \ |
WHERE num_nom=$id UNION \ |
SELECT num_nom, num_nom_retenu, num_tax_sup, rang, nom_sci, genre, auteur, annee, NULL, NULL, num_taxonomique, nom_complet, famille FROM isfan_v2013 \ |
WHERE num_nom=$id |
} |
|
index i_bdtfx2 : i_common { |
source = bdtfx2 |
path = /var/lib/sphinx/bdtfx2 |
path = /var/lib/sphinxsearch/bdtfx2 |
|
stopwords = |
morphology = |
484,7 → 494,7 |
|
# index i_costenvjfl : i_common { |
# source = costenvjfl |
# path = /var/lib/sphinx/costenvjfl |
# path = /var/lib/sphinxsearch/costenvjfl |
|
# infix_fields = texte, titre |
# } |
502,7 → 512,7 |
# type = rt |
# rt_mem_limit = 32M |
|
# path = /var/lib/sphinx/testrt |
# path = /var/lib/sphinxsearch/testrt |
# charset_type = utf-8 |
|
# rt_field = title |