source search_suggest
{
    type = mysql
    sql_host = 127.0.0.1
    sql_user = root
    sql_pass = 123456
    sql_db = ihello_release
    sql_port = 3306

    sql_query_pre = SET NAMES utf8
    sql_query = SELECT id, trigrams, freq, keyword, CHAR_LENGTH(keyword) AS len FROM search_suggests

    sql_attr_uint = freq
    sql_attr_uint = len
    sql_attr_string	= keyword
}

source data_units
{
    type = mysql
    sql_host = 127.0.0.1
    sql_user = root
    sql_pass = 123456
    sql_db = ihello_release
    sql_port = 3306

    sql_query_pre = SET NAMES utf8
    sql_query = \
        SELECT \
        du.unitid, du.unitid as _id, du.amount, "unit" as `type`, du.catid as catid, 1 as available, \
        null AS parent_unit_id, min_price as price, \
        CONCAT(IFNULL(du.`name`, ''), ' ', IFNULL(du.sematype, ''), ' ', IFNULL(c.name, '')) AS keywords \
        FROM data_units du \
        LEFT JOIN `categories` c ON c.id = du.catid

    sql_attr_uint = _id
    sql_attr_uint = amount
    sql_attr_uint = price
    sql_attr_uint = catid
    sql_attr_uint = parent_unit_id
    sql_attr_string	= type
    sql_attr_uint = available
}

source real_offers
{
    type = mysql
    sql_host = 127.0.0.1
    sql_user = root
    sql_pass = 123456
    sql_db = ihello_release
    sql_port = 3306

    sql_query_pre = SET NAMES utf8
    sql_query = \
        SELECT \
        ro.UID, ro.UID as _id, ro.amount, "offer" as `type`, ro.catid as catid, ro.available, \
        ro.unit_id AS parent_unit_id, cost as price, shop_id, shop_name, \
        CONCAT(IFNULL(ro.`unit_name`, ''), ' ', IFNULL(c.name, ''), ' ', IFNULL(ro.description, '')) AS keywords \
        FROM `real_offers` ro \
        LEFT JOIN `categories` c ON c.id = ro.catid

    sql_attr_uint = _id
    sql_attr_uint = amount
    sql_attr_uint = price
    sql_attr_uint = catid
    sql_attr_uint = parent_unit_id
    sql_attr_uint = shop_id
    sql_attr_string	= shop_name
    sql_attr_string	= type
    sql_attr_uint = available
}

source shops
{
    type = mysql
    sql_host = 127.0.0.1
    sql_user = root
    sql_pass = 123456
    sql_db = ihello_import
    sql_port = 3306

    sql_query_pre = SET NAMES utf8
    sql_query = \
        SELECT s.id, s.id as _id, "shop" as `type`, s.is_publicated, s.name AS name, \
        s.site_type, s.switched_off, s.local_city_id, s.reference_id, s.reference_source, s.logo, \
        s.delivery, s.phone, s.local_delivery_cost, s.email, s.has_cashback, \
        CONCAT(IFNULL(s.`name`, ''), ' ', IFNULL(s.http, '')) AS keywords \
        FROM `shops` as s

    sql_attr_uint = _id
    sql_attr_uint = site_type
    sql_attr_uint = switched_off
    sql_attr_uint = local_city_id
    sql_attr_uint = is_publicated
    sql_attr_string = reference_id
    sql_attr_string = reference_source
    sql_attr_string = logo
    sql_attr_string = delivery
    sql_attr_string = phone
    sql_attr_string = local_delivery_cost
    sql_attr_uint = has_cashback
    sql_attr_string	= type
    sql_attr_string = email
    sql_attr_string = name
}

index data_units
{
    source = data_units
    path = /var/sphinx/index/data_units
    morphology = stem_enru
    min_word_len = 2

    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
}

index search_suggest
{
    source = search_suggest
    path = /var/sphinx/index/search_suggest
    morphology = stem_enru
    docinfo = extern
}

index real_offers
{
    source = real_offers
    path = /var/sphinx/index/real_offers
    morphology = stem_enru
    min_word_len = 2

    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
}

index shops
{
    source = shops
    path = /var/sphinx/index/shops
    morphology = stem_enru
    min_word_len = 2

    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
}