indexer
{
}

searchd
{
  address = 0.0.0.0
  port = 3313
  log = /var/cache/sphinx/ujet.ru/log/searchd.log
  query_log = /var/cache/sphinx/ujet.ru/log/query.log
  pid_file = /var/cache/sphinx/ujet.ru/log/searchd.pid
}

source ad_core_0
{
  type = pgsql
  sql_host = um-sql-1
  sql_user = ujet
  sql_pass = ujetblya
  sql_db = ujet_production
  sql_query = SELECT "ads"."id" * 3 + 0 AS "id" , "ads"."content" AS "content", "ads"."contacts" AS "contacts", "ads"."id" AS "
  sql_query_range = SELECT COALESCE(MIN("id"), 1::bigint), COALESCE(MAX("id"), 1::bigint) FROM "ads"
  sql_attr_uint = sphinx_internal_id
  sql_attr_uint = class_crc
  sql_attr_uint = sphinx_deleted
  sql_attr_uint = ad_section_id
  sql_attr_multi = uint subclass_crcs from field
  sql_query_info = SELECT * FROM "ads" WHERE "id" = (($id - 0) / 3)
}

index ad_core
{
  source = ad_core_0
  path = /var/cache/sphinx/ujet.ru/sphinx_index/ad_core
  charset_type = utf-8
  min_infix_len = 3
  enable_star = 1
}

index ad
{
  type = distributed
  local = ad_core
}

source division_core_0
{
  type = pgsql
  sql_host = um-sql-1
  sql_user = ujet
  sql_pass = ujetblya
  sql_db = ujet_production
  sql_query_pre = UPDATE "divisions" SET "delta" = FALSE WHERE "delta" = TRUE
  sql_query = SELECT "divisions"."id" * 3 + 1 AS "id" , "divisions"."address" AS "address", GROUP_CONCAT(regexp_replace(phone,
  sql_query_range = SELECT COALESCE(MIN("id"), 1::bigint), COALESCE(MAX("id"), 1::bigint) FROM "divisions" WHERE "divisions"."d
  sql_attr_uint = sphinx_internal_id
  sql_attr_uint = class_crc
  sql_attr_uint = sphinx_deleted
  sql_attr_uint = district_name
  sql_attr_uint = city_name
  sql_attr_bool = supplier_is_paid
  sql_attr_str2ordinal = address_sort
  sql_attr_str2ordinal = phone_sort
  sql_attr_str2ordinal = fax_sort
  sql_attr_str2ordinal = supplier_name_sort
  sql_attr_multi = uint subclass_crcs from field
  sql_query_info = SELECT * FROM "divisions" WHERE "id" = (($id - 1) / 3)
}

index division_core
{
  source = division_core_0
  path = /var/cache/sphinx/ujet.ru/sphinx_index/division_core
  charset_type = utf-8
  min_infix_len = 3
  enable_star = 1
}

source division_delta_0 : division_core_0
{
  type = pgsql
  sql_host = um-sql-1
  sql_user = ujet
  sql_pass = ujetblya
  sql_db = ujet_production
  sql_query_pre =
  sql_query = SELECT "divisions"."id" * 3 + 1 AS "id" , "divisions"."address" AS "address", GROUP_CONCAT(regexp_replace(phone,
  sql_query_range = SELECT COALESCE(MIN("id"), 1::bigint), COALESCE(MAX("id"), 1::bigint) FROM "divisions" WHERE "divisions"."d
  sql_attr_uint = sphinx_internal_id
  sql_attr_uint = class_crc
  sql_attr_uint = sphinx_deleted
  sql_attr_uint = district_name
  sql_attr_uint = city_name
  sql_attr_bool = supplier_is_paid
  sql_attr_str2ordinal = address_sort
  sql_attr_str2ordinal = phone_sort
  sql_attr_str2ordinal = fax_sort
  sql_attr_str2ordinal = supplier_name_sort
  sql_attr_multi = uint subclass_crcs from field
  sql_query_info = SELECT * FROM "divisions" WHERE "id" = (($id - 1) / 3)
}

index division_delta : division_core
{
  source = division_delta_0
  path = /var/cache/sphinx/ujet.ru/sphinx_index/division_delta
}

index division
{
  type = distributed
  local = division_delta
  local = division_core
}

source part_core_0
{
  type = pgsql
  sql_host = um-sql-1
  sql_user = ujet
  sql_pass = ujetblya
  sql_db = ujet_production
  sql_query_pre = UPDATE "parts" SET "delta" = FALSE WHERE "delta" = TRUE
  sql_query = SELECT "parts"."id" * 3 + 2 AS "id" , "parts"."description" AS "description", "parts"."engine_model" AS "engine_m
  sql_query_range = SELECT COALESCE(MIN("id"), 1::bigint), COALESCE(MAX("id"), 1::bigint) FROM "parts" WHERE "parts"."delta" =
  sql_attr_uint = sphinx_internal_id
  sql_attr_uint = class_crc
  sql_attr_uint = sphinx_deleted
  sql_attr_uint = car_brand_id
  sql_attr_uint = car_model_id
  sql_attr_uint = year
  sql_attr_uint = section_id
  sql_attr_uint = section_parent_id
  sql_attr_bool = is_used
  sql_attr_bool = supplier_is_paid
  sql_attr_str2ordinal = engine_model_sort
  sql_attr_str2ordinal = body_model_sort
  sql_attr_str2ordinal = color_sort
  sql_attr_str2ordinal = orientation_sort
  sql_attr_str2ordinal = longwise_sort
  sql_attr_str2ordinal = car_brand_name_sort
  sql_attr_str2ordinal = car_model_name_sort
  sql_attr_str2ordinal = supplier_name_sort
  sql_attr_str2ordinal = section_name_sort
  sql_attr_float = cost
  sql_attr_multi = uint subclass_crcs from field
  sql_query_info = SELECT * FROM "parts" WHERE "id" = (($id - 2) / 3)
}

index part_core
{
  source = part_core_0
  path = /var/cache/sphinx/ujet.ru/sphinx_index/part_core
  charset_type = utf-8
  min_infix_len = 3
  enable_star = 1
}

source part_delta_0 : part_core_0
{
  type = pgsql
  sql_host = um-sql-1
  sql_user = ujet
  sql_pass = ujetblya
  sql_db = ujet_production
  sql_query_pre =
  sql_query = SELECT "parts"."id" * 3 + 2 AS "id" , "parts"."description" AS "description", "parts"."engine_model" AS "engine_m
  sql_query_range = SELECT COALESCE(MIN("id"), 1::bigint), COALESCE(MAX("id"), 1::bigint) FROM "parts" WHERE "parts"."delta" =
  sql_attr_uint = sphinx_internal_id
  sql_attr_uint = class_crc
  sql_attr_uint = sphinx_deleted
  sql_attr_uint = car_brand_id
  sql_attr_uint = car_model_id
  sql_attr_uint = year
  sql_attr_uint = section_id
  sql_attr_uint = section_parent_id
  sql_attr_bool = is_used
  sql_attr_bool = supplier_is_paid
  sql_attr_str2ordinal = engine_model_sort
  sql_attr_str2ordinal = body_model_sort
  sql_attr_str2ordinal = color_sort
  sql_attr_str2ordinal = orientation_sort
  sql_attr_str2ordinal = longwise_sort
  sql_attr_str2ordinal = car_brand_name_sort
  sql_attr_str2ordinal = car_model_name_sort
  sql_attr_str2ordinal = supplier_name_sort
  sql_attr_str2ordinal = section_name_sort
  sql_attr_float = cost
  sql_attr_multi = uint subclass_crcs from field
  sql_query_info = SELECT * FROM "parts" WHERE "id" = (($id - 2) / 3)
}

index part_delta : part_core
{
  source = part_delta_0
  path = /var/cache/sphinx/ujet.ru/sphinx_index/part_delta
}

index part
{
  type = distributed
  local = part_delta
  local = part_core
}