Subversion Repositories Applications.papyrus

        CONCAT(bret.nom_sci, ' ', bret.auteur) AS nom_ret \

        CONCAT(aret.nom_sci, ' ', aret.auteur) AS nom_ret \

        CONCAT(iret.nom_sci, ' ', iret.auteur) AS nom_ret \

	sql_attr_string		= main_id

	enable_star		= 0

    min_word_len    = 1

    min_prefix_len  = 0

    min_infix_len   = 3

}

# noms scientifiques / noms d'auteur BDTFX2

source bdtfx2 : common {

	sql_db			= tb_eflore

	sql_query		= \

        SELECT b.num_nom, b.nom_sci AS nom_sci, b.auteur AS auteur, \

        "bdtfx2" AS group_id, CONCAT("bdtfx2-", b.num_nom) as main_id, b.num_nom, \

        CONCAT(bret.nom_sci, ' ', bret.auteur) AS nom_ret \

        FROM bdtfx_v2_00 b LEFT JOIN bdtfx_v2_00 bret ON b.num_nom_retenu = bret.num_nom \

        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,	\

        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 \

        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, \

        CONCAT(iret.nom_sci, ' ', iret.auteur) AS nom_ret \

        FROM isfan_v2013 i LEFT JOIN isfan_v2013 iret ON i.num_nom_retenu = iret.num_nom

	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_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

}

index i_bdtfx2 : i_common {

	source			= bdtfx2

	path			= /var/lib/sphinx/bdtfx2

	stopwords		=

	morphology		=

    infix_fields    = b.nom_sci, b.auteur