indexer
{
}

searchd
{
  address = 127.0.0.1
  port = 3312
  log = /www/send_peace/log/searchd.log
  query_log = /www/send_peace/log/searchd.query.log
  pid_file = /www/send_peace/log/searchd.development.pid
}

source event_core_0
{
  type = mysql
  sql_host = localhost
  sql_user = root
  sql_pass = M0nster
  sql_db = lovdbyless_development
  sql_query_pre = SET NAMES utf8
  sql_query = SELECT `events`.`id` * 2 + 0 AS `id` , CAST(`events`.`location` AS CHAR) AS `location`, CAST(`events`.`title` AS CHAR) AS `title`, CAST(`events`.`description` AS CHAR) AS `description`, CAST(`events`.`host` AS CHAR) AS `host`, `events`.`id` AS `sphinx_internal_id`, 4201588131 AS `class_crc`, '4201588131' AS `subclass_crcs`, 0 AS `sphinx_deleted` FROM events    WHERE `events`.`id` >= $start   AND `events`.`id` <= $end    GROUP BY `events`.`id`  ORDER BY NULL
  sql_query_range = SELECT IFNULL(MIN(`id`), 1), IFNULL(MAX(`id`), 1) FROM `events`
  sql_attr_uint = sphinx_internal_id
  sql_attr_uint = class_crc
  sql_attr_uint = sphinx_deleted
  sql_attr_multi = uint subclass_crcs from field
  sql_query_info = SELECT * FROM `events` WHERE  `id` = (($id - 0) / 2)
}

index event_core
{
  source = event_core_0
  path = /www/send_peace/db/sphinx/development/event_core
  charset_type = utf-8
  min_prefix_len = 3
}

index event
{
  type = distributed
  local = event_core
}

source profile_core_0
{
  type = mysql
  sql_host = localhost
  sql_user = root
  sql_pass = M0nster
  sql_db = lovdbyless_development
  sql_query_pre = SET NAMES utf8
  sql_query = SELECT `profiles`.`id` * 2 + 1 AS `id` , CAST(`profiles`.`location` AS CHAR) AS `location`, CAST(`profiles`.`about_me` AS CHAR) AS `about_me`, CAST(`profiles`.`first_name` AS CHAR) AS `first_name`, CAST(`profiles`.`last_name` AS CHAR) AS `last_name`, CAST(`users`.`login` AS CHAR) AS `login`, `profiles`.`id` AS `sphinx_internal_id`, 1323996051 AS `class_crc`, '1323996051' AS `subclass_crcs`, 0 AS `sphinx_deleted` FROM profiles    LEFT OUTER JOIN `users` ON `users`.id = `profiles`.user_id  WHERE `profiles`.`id` >= $start   AND `profiles`.`id` <= $end    GROUP BY `profiles`.`id`  ORDER BY NULL
  sql_query_range = SELECT IFNULL(MIN(`id`), 1), IFNULL(MAX(`id`), 1) FROM `profiles`
  sql_attr_uint = sphinx_internal_id
  sql_attr_uint = class_crc
  sql_attr_uint = sphinx_deleted
  sql_attr_multi = uint subclass_crcs from field
  sql_query_info = SELECT * FROM `profiles` WHERE  `id` = (($id - 1) / 2)
}

index profile_core
{
  source = profile_core_0
  path = /www/send_peace/db/sphinx/development/profile_core
  charset_type = utf-8
  min_prefix_len = 3
}

index profile
{
  type = distributed
  local = profile_core
}