Subversion Repositories Applications.papyrus

Rev

Rev 2132 | Rev 2137 | Go to most recent revision | Show entire file | Ignore whitespace | Details | Blame | Last modification | View Log | RSS feed

Rev 2132 Rev 2134
Line 373... Line 373...
373
source bdtfx : common {
373
source bdtfx : common {
374
	sql_db			= tb_eflore
374
	sql_db			= tb_eflore
Line 375... Line 375...
375
 
375
 
376
	sql_query		= \
376
	sql_query		= \
377
        SELECT b.num_nom, b.nom_sci AS nom_sci, b.auteur AS auteur, \
377
        SELECT b.num_nom, b.nom_sci AS nom_sci, b.auteur AS auteur, \
378
        "bdtfx" AS group_id, CONCAT("bdtfx-", b.num_nom) as main_id, b.num_nom	\
378
        "bdtfx" AS group_id, CONCAT("bdtfx-", b.num_nom) as main_id, b.num_nom, \
-
 
379
        CONCAT(bret.nom_sci, ' ', bret.auteur) AS nom_ret \
379
        FROM bdtfx_v1_01 b \
380
        FROM bdtfx_v1_01 b LEFT JOIN bdtfx_v1_01 bret ON b.num_nom_retenu = bret.num_nom \
380
        UNION ALL \
381
        UNION ALL \
381
        SELECT a.num_nom + 500000, a.nom_sci, a.auteur, \
382
        SELECT a.num_nom + 500000, a.nom_sci, a.auteur, \
382
        "bdtxa" AS group_id, CONCAT("bdtxa-", a.num_nom) AS main_id, a.num_nom	\
383
        "bdtxa" AS group_id, CONCAT("bdtxa-", a.num_nom) AS main_id, a.num_nom,	\
-
 
384
        CONCAT(aret.nom_sci, ' ', aret.auteur) AS nom_ret \
383
        FROM bdtxa_v1_00 a \
385
        FROM bdtxa_v1_00 a LEFT JOIN bdtxa_v1_00 aret ON a.num_nom_retenu = aret.num_nom \
384
        UNION ALL \
386
        UNION ALL \
385
        SELECT i.num_nom + 1000000, i.nom_sci, i.auteur, \
387
        SELECT i.num_nom + 1000000, i.nom_sci, i.auteur, \
386
        "isfan" AS group_id, CONCAT("isfan-", i.num_nom) AS main_id, i.num_nom \
388
        "isfan" AS group_id, CONCAT("isfan-", i.num_nom) AS main_id, i.num_nom, \
-
 
389
        CONCAT(iret.nom_sci, ' ', iret.auteur) AS nom_ret \
Line 387... Line 390...
387
        FROM isfan_v2013 i
390
        FROM isfan_v2013 i LEFT JOIN isfan_v2013 iret ON i.num_nom_retenu = iret.num_nom
388
 
391
 
389
	sql_field_string	= group_id
392
	sql_field_string	= group_id
390
	sql_field_string	= nom_sci
393
	sql_field_string	= nom_sci
391
	sql_field_string	= auteur
394
	sql_field_string	= auteur
-
 
395
	sql_attr_string		= main_id
Line 392... Line 396...
392
	sql_attr_string		= main_id
396
    sql_attr_uint       = num_nom
393
    sql_attr_uint       = num_nom
397
    sql_attr_string     = nom_ret
Line 394... Line 398...
394
 
398
 
Line 401... Line 405...
401
 
405
 
402
	stopwords		=
406
	stopwords		=
403
	morphology		=
407
	morphology		=
404
    infix_fields    = b.nom_sci, b.auteur
408
    infix_fields    = b.nom_sci, b.auteur
-
 
409
	enable_star		= 0
-
 
410
    min_word_len    = 1
-
 
411
    min_prefix_len  = 0
-
 
412
    min_infix_len   = 3
-
 
413
 
-
 
414
}
-
 
415
 
-
 
416
 
-
 
417
# noms scientifiques / noms d'auteur BDTFX2
-
 
418
source bdtfx2 : common {
-
 
419
	sql_db			= tb_eflore
-
 
420
 
-
 
421
	sql_query		= \
-
 
422
        SELECT b.num_nom, b.nom_sci AS nom_sci, b.auteur AS auteur, \
-
 
423
        "bdtfx2" AS group_id, CONCAT("bdtfx2-", b.num_nom) as main_id, b.num_nom, \
-
 
424
        CONCAT(bret.nom_sci, ' ', bret.auteur) AS nom_ret \
-
 
425
        FROM bdtfx_v2_00 b LEFT JOIN bdtfx_v2_00 bret ON b.num_nom_retenu = bret.num_nom \
-
 
426
        UNION ALL \
-
 
427
        SELECT a.num_nom + 500000, a.nom_sci, a.auteur, \
-
 
428
        "bdtxa" AS group_id, CONCAT("bdtxa-", a.num_nom) AS main_id, a.num_nom,	\
-
 
429
        CONCAT(aret.nom_sci, ' ', aret.auteur) AS nom_ret \
-
 
430
        FROM bdtxa_v1_00 a LEFT JOIN bdtxa_v1_00 aret ON a.num_nom_retenu = aret.num_nom \
-
 
431
        UNION ALL \
-
 
432
        SELECT i.num_nom + 1000000, i.nom_sci, i.auteur, \
-
 
433
        "isfan" AS group_id, CONCAT("isfan-", i.num_nom) AS main_id, i.num_nom, \
-
 
434
        CONCAT(iret.nom_sci, ' ', iret.auteur) AS nom_ret \
-
 
435
        FROM isfan_v2013 i LEFT JOIN isfan_v2013 iret ON i.num_nom_retenu = iret.num_nom
-
 
436
 
-
 
437
	sql_field_string	= group_id
-
 
438
	sql_field_string	= nom_sci
-
 
439
	sql_field_string	= auteur
-
 
440
	sql_attr_string		= main_id
-
 
441
    sql_attr_uint       = num_nom
-
 
442
    sql_attr_string     = nom_ret
-
 
443
 
-
 
444
	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
-
 
445
}
-
 
446
 
-
 
447
index i_bdtfx2 : i_common {
-
 
448
	source			= bdtfx2
-
 
449
	path			= /var/lib/sphinx/bdtfx2
-
 
450
 
-
 
451
	stopwords		=
-
 
452
	morphology		=
-
 
453
    infix_fields    = b.nom_sci, b.auteur
405
	enable_star		= 0
454
	enable_star		= 0
406
    min_word_len    = 1
455
    min_word_len    = 1
407
    min_prefix_len  = 0
456
    min_prefix_len  = 0
Line 408... Line 457...
408
    min_infix_len   = 3
457
    min_infix_len   = 3