source foorum
{
    type                            = mysql
    
    sql_host                        = __HOST__
    sql_user                        = __USER__
    sql_pass                        = __PASS__
    sql_db                          = foorum
    sql_port                        = __PORT__

    sql_query_pre                   = \
            REPLACE INTO variables SELECT 'global', 'sphinx_tid', MAX(topic_id) FROM topic
    sql_query                       = \
            SELECT \
                    topic_id as id, topic_id, forum_id, title, author_id, status, post_on, last_update_date \
            FROM \
                    topic \
            WHERE \
                    status = 'healthy' \
                    AND topic_id <= (SELECT value FROM variables WHERE type = 'global' AND name = 'sphinx_tid');

    sql_attr_timestamp  = last_update_date
    sql_attr_timestamp  = post_on
    sql_attr_uint       = author_id
    sql_attr_uint       = forum_id

    # document info query
    sql_query_info          = SELECT topic_id, title, forum_id, author_id \
                              FROM topic WHERE topic_id=$id
}

source foorumdelta : foorum
{
    sql_query_pre                   = 
    sql_query                       = \
            SELECT \
                    topic_id as id, topic_id, forum_id, title, author_id, status, post_on, last_update_date \
            FROM \
                    topic \
            WHERE \
                    status = 'healthy' \
                    AND topic_id > (SELECT value FROM variables WHERE type = 'global' AND name = 'sphinx_tid');
}

index foorum
{
    source                  = foorum
    path                    = __HOME__/data/sphinx/foorum
    
    min_word_len = 1
    charset_type = utf-8
    charset_table = U+FF10..U+FF19->0..9, 0..9, U+FF41..U+FF5A->a..z, U+FF21..U+FF3A->a..z, \
        A..Z->a..z, a..z, U+0149, U+017F, U+0138, U+00DF, U+00FF, U+00C0..U+00D6->U+00E0..U+00F6, \
        U+00E0..U+00F6, U+00D8..U+00DE->U+00F8..U+00FE, U+00F8..U+00FE, U+0100->U+0101, U+0101, \
        U+0102->U+0103, U+0103, U+0104->U+0105, U+0105, U+0106->U+0107, U+0107, U+0108->U+0109, \
        U+0109, U+010A->U+010B, U+010B, U+010C->U+010D, U+010D, U+010E->U+010F, U+010F, \
        U+0110->U+0111, U+0111, U+0112->U+0113, U+0113, U+0114->U+0115, U+0115, U+0116->U+0117, \
        U+0117, U+0118->U+0119, U+0119, U+011A->U+011B, U+011B, U+011C->U+011D, U+011D, \
        U+011E->U+011F, U+011F, U+0130->U+0131, U+0131, U+0132->U+0133, U+0133, U+0134->U+0135, \
        U+0135, U+0136->U+0137, U+0137, U+0139->U+013A, U+013A, U+013B->U+013C, U+013C, \
        U+013D->U+013E, U+013E, U+013F->U+0140, U+0140, U+0141->U+0142, U+0142, U+0143->U+0144, \
        U+0144, U+0145->U+0146, U+0146, U+0147->U+0148, U+0148, U+014A->U+014B, U+014B, \
        U+014C->U+014D, U+014D, U+014E->U+014F, U+014F, U+0150->U+0151, U+0151, U+0152->U+0153, \
        U+0153, U+0154->U+0155, U+0155, U+0156->U+0157, U+0157, U+0158->U+0159, U+0159, \
        U+015A->U+015B, U+015B, U+015C->U+015D, U+015D, U+015E->U+015F, U+015F, U+0160->U+0161, \
        U+0161, U+0162->U+0163, U+0163, U+0164->U+0165, U+0165, U+0166->U+0167, U+0167, \
        U+0168->U+0169, U+0169, U+016A->U+016B, U+016B, U+016C->U+016D, U+016D, U+016E->U+016F, \
        U+016F, U+0170->U+0171, U+0171, U+0172->U+0173, U+0173, U+0174->U+0175, U+0175, \
        U+0176->U+0177, U+0177, U+0178->U+00FF, U+00FF, U+0179->U+017A, U+017A, U+017B->U+017C, \
        U+017C, U+017D->U+017E, U+017E, U+4E00..U+9FFF
    docinfo = extern
    morphology = none
    
    ngram_len = 1
    ngram_chars = U+4E00..U+9FBF, U+3400..U+4DBF, U+20000..U+2A6DF, U+F900..U+FAFF, \
        U+2F800..U+2FA1F, U+2E80..U+2EFF, U+2F00..U+2FDF, U+3100..U+312F, U+31A0..U+31BF, \
        U+3040..U+309F, U+30A0..U+30FF, U+31F0..U+31FF, U+AC00..U+D7AF, U+1100..U+11FF, \
        U+3130..U+318F, U+A000..U+A48F, U+A490..U+A4CF
}

index foorumdelta : foorum
{
    source                  = foorumdelta
    path                    = __HOME__/data/sphinx/foorumdelta
}

searchd
{
	port				= 3312
	log				    = __HOME__/log/searchd.log
	query_log			= __HOME__/log/query.log
	pid_file			= __HOME__/log/searchd.pid
}