Subversion Repositories Applications.papyrus

}

# NVJFL

source nvjfl : common {

	sql_db			= tb_eflore

    # note: 66 taxons nvjfl n'ont pas de numéro nomenclatural

	sql_query		= \

        SELECT b.num_nom, num_taxon, nom_sci, GROUP_CONCAT(nom_vernaculaire), \

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

        FROM nvjfl_v2007 n \

        LEFT JOIN bdtfx_v1_02 b ON n.num_taxon = b.num_taxonomique \

        WHERE b.num_nom IS NOT NULL \

        GROUP by num_taxon

	sql_field_string	= group_id

	sql_attr_string		= main_id

    sql_attr_uint       = num_taxon

	sql_query_info	= SELECT * FROM nvjfl_v2007 WHERE num_taxon=$id

}

index i_nvjfl : i_common {

	source			= nvjfl

	path			= /var/lib/sphinx/nvjfl

    infix_fields    = texte, titre

}

# COSTE / NVJFL

# source costenvjfl : common {

# 	sql_db			= tb_eflore

# 	sql_query		= \

#         SELECT c.flore_bdtfx_nn AS id, c.nom_sci AS titre, dsc.body AS texte, cle.body AS determination, \

#         GROUP_CONCAT(n.nom_vernaculaire) AS nvjfl, n.num_taxon AS num_taxonomique, \

#         "costenvjfl" AS group_id, CONCAT("costenvjfl-", c.flore_bdtfx_nn) as main_id	\

#         FROM tb_eflore.coste_v2_00 c \

#         LEFT JOIN tela_prod_wikini.florecoste_pages dsc ON c.page_wiki_dsc = dsc.tag AND dsc.latest = 'Y' \

#         LEFT JOIN tela_prod_wikini.florecoste_pages cle ON c.page_wiki_cle = cle.tag AND cle.latest = 'Y' \

#         LEFT JOIN bdtfx_v1_02 b ON c.flore_bdtfx_nn = b.num_nom \

#         LEFT JOIN nvjfl_v2007 n ON b.num_taxonomique = n.num_taxon \

#         WHERE c.flore_bdtfx_nn != ''

# 	sql_field_string	= group_id

# 	sql_attr_string		= main_id

#     sql_attr_uint       = num_taxonomique

# 	sql_query_info	= SELECT * FROM coste_v2_00  WHERE flore_bdtfx_nn=$id

# }

# index i_costenvjfl : i_common {

# 	source			= costenvjfl

# 	path			= /var/lib/sphinx/costenvjfl

#     infix_fields    = texte, titre