Subversion Repositories Applications.papyrus

# 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

}