366,6 → 366,41 |
|
|
|
# noms scientifiques / noms d'auteur BDTFX |
source bdtfx : common { |
sql_db = tb_eflore |
|
sql_query = \ |
SELECT b.num_nom, b.nom_sci AS nom_sci, b.auteur AS auteur, \ |
"bdtfx" AS group_id, CONCAT("bdtfx-", b.num_nom) as main_id, b.num_nom \ |
FROM bdtfx_v1_01 b \ |
UNION ALL \ |
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 \ |
FROM bdtxa_v1_00 a \ |
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 \ |
FROM isfan_v2013 i |
|
sql_field_string = group_id |
sql_field_string = nom_sci |
sql_field_string = auteur |
sql_attr_string = main_id |
sql_attr_uint = num_nom |
|
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 |
} |
|
index i_bdtfx : i_common { |
source = bdtfx |
path = /var/lib/sphinx/bdtfx |
|
infix_fields = b.nom_sci, b.auteur |
} |
|
|
|
# COSTE / NVJFL |
# source costenvjfl : common { |
# sql_db = tb_eflore |