SOURCE application
{
    TYPE = pgsql
    sql_host = 192.168.1.2
    sql_user = www
    sql_pass = ghjcnjq
    sql_db = shop
    sql_port = 5432
    sql_query_pre = SET NAMES 'utf-8'
}

SOURCE legacySource : application
{
    sql_query = \
        SELECT i.id, 'i' AS prefix, i.title, i.photo, i.base_price, i.base_quantity, i.fixed_price, \
        i.in_store, i.model, g.title AS group_title, g.id AS group_id, m.title AS manufactor \
        FROM legacy.data_item i \
        LEFT JOIN legacy.data_manufactor m ON i.manufactor_id = m.id \
        LEFT JOIN legacy.data_group g ON g.id = i.parent_id \
        WHERE i.id BETWEEN $start AND $end AND g.STATUS = 1

    sql_query_range = SELECT MIN(id),MAX(id) FROM legacy.data_item
    sql_range_step = 10000

    sql_attr_string = prefix
    sql_field_str2wordcount = title
    sql_attr_string = photo
    sql_attr_uint = base_price:12
    sql_attr_uint = base_quantity:4
    sql_attr_uint = fixed_price:12
    sql_attr_uint = in_store:4
    sql_field_str2wordcount = model
    sql_attr_string = group_title
    sql_attr_uint = group_id:12
    sql_attr_string = manufactor
}

SOURCE publicSource : application
{
    sql_query = \
        SELECT p.id, 'p' AS prefix, p.title, p.photo, p.base_price, p.base_quantity, p.fixed_price, \
        p.in_store, p.model, g.title AS group_title, g.id AS group_id, l.VALUE AS manufactor \
        FROM public.data_item p \
        LEFT JOIN legacy.data_group_type gt ON gt.type_id = p.type_id \
        LEFT JOIN legacy.data_group g ON g.id = gt.group_id \
        LEFT JOIN public.data_item_feature f ON  f.item_id=p.id AND f.feature_id=2 \
        LEFT JOIN public.data_feature_list l ON f.VALUE::INT=l.id AND l.feature_id=f.feature_id \
        WHERE p.id BETWEEN $start AND $end AND g.STATUS = 1

    sql_query_range = SELECT MIN(id),MAX(id) FROM public.data_item
    sql_range_step = 10000

    sql_attr_string = prefix
    sql_field_str2wordcount = title
    sql_attr_string = photo
    sql_attr_uint = base_price:12
    sql_attr_uint = base_quantity:4
    sql_attr_uint = fixed_price:12
    sql_attr_uint = in_store:4
    sql_field_str2wordcount = model
    sql_attr_string = group_title
    sql_attr_uint = group_id:12
    sql_attr_string = manufactor
}

INDEX legacyIndex
{
    SOURCE = legacySource
    path = /var/run/sphinx/legacySource/legacyIndex
    docinfo = extern
    mlock = 0
    morphology = stem_ru
    charset_type = utf-8

    charset_table = 0..9, A..Z->a..z, a..z, U+410..U+42F->U+430..U+44F, U+430..U+44F
    #ignore_chars = U+AD,U+2D,U+27,U+22,U+2B,U+3D,U+3E,U+3F,U+3C,U+3B,U+3A,U+2F,U+2E,U+2C,U+2A,U+20..U+29, \
    #!,@,#,$,%,^,&,*,(,),_,+,|,\,/,=,-,`,~,',",},{,],[,;,:,<,>,?
    blend_chars = U+AD,U+2D,U+27,U+22,U+2B,U+3D,U+3E,U+3F,U+3C,U+3B,U+3A,U+2F,U+2E,U+2C,U+2A,U+20..U+29, \
    !,@,#,$,%,^,&,*,(,),_,+,|,\,/,=,`,~,',",},{,],[,;,:,<,>
    ignor_chars = -,.,?
    blend_mode = trim_tail, skip_pure
    min_prefix_len = 0
    min_infix_len = 3
    enable_star = 1
    wordforms = /home/www/wahu.ru/files/sphinx/wordforms.txt
}

index publicIndex
{
    source = publicSource
    path = /var/run/sphinx/publicSource/publicIndex
    docinfo = extern
    mlock = 0
    morphology = stem_ru
    charset_type = utf-8

    charset_table = 0..9, A..Z->a..z, a..z, U+410..U+42F->U+430..U+44F, U+430..U+44F
    #ignore_chars = U+AD,U+2D,U+27,U+22,U+2B,U+3D,U+3E,U+3F,U+3C,U+3B,U+3A,U+2F,U+2E,U+2C,U+2A,U+20..U+29, \
    #!,@,#,$,%,^,&,*,(,),_,+,|,\,/,=,-,`,~,',",},{,],[,;,:,<,>,?
    blend_chars = U+AD,U+2D,U+27,U+22,U+2B,U+3D,U+3E,U+3F,U+3C,U+3B,U+3A,U+2F,U+2E,U+2C,U+2A,U+20..U+29, \
    !,@,#,$,%,^,&,*,(,),_,+,|,\,/,=,`,~,',",},{,],[,;,:,<,>
    ignor_chars = -,.,?
    blend_mode = trim_tail, skip_pure
    min_prefix_len = 0
    min_infix_len = 3
    enable_star = 1
    wordforms = /home/www/wahu.ru/files/sphinx/wordforms.txt
}

indexer
{
    mem_limit = 128M
}

searchd
{
    listen = 127.0.0.1
    port = 5000
    log = /home/www/wahu.ru/files/sphinx/searchd.log
    query_log = /home/www/wahu.ru/files/sphinx/query.log
    read_timeout = 2
    max_children = 32
    pid_file = /home/www/wahu.ru/files/sphinx/searchd.pid
}