indexer
{
}

searchd
{
  address = 127.0.0.1
  port = 3312
  log = /home/jacobbasham/src/smart/log/searchd.log
  query_log = /home/jacobbasham/src/smart/log/searchd.query.log
  pid_file = /home/jacobbasham/src/smart/log/searchd.development.pid
}

source property_core_0
{
  type = mysql
  sql_host = localhost
  sql_user = smartre
  sql_pass =
  sql_db = smartre_development
  sql_query_pre = SET NAMES utf8
  sql_query = SELECT `properties`.`id` * 2 + 0 AS `id` , CAST(`properties`.`listing_number` AS CHAR) AS `listing_number`, `properties`.`id` AS `sphinx_internal_id`, CAST(IFNULL(CRC32(NULLIF(`properties`.`type`,'')), 1921285768) AS UNSIGNED) AS `class_crc`, '1921285768' AS `subclass_crcs`, 0 AS `sphinx_deleted` FROM `properties`    WHERE `properties`.`id` >= $start AND `properties`.`id` <= $end GROUP BY `properties`.`id`, `properties`.`type`  ORDER BY NULL
  sql_query_range = SELECT IFNULL(MIN(`id`), 1), IFNULL(MAX(`id`), 1) FROM `properties`
  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 `properties` WHERE `id` = (($id - 0) / 2)
}

index property_core
{
  source = property_core_0
  path = /home/jacobbasham/src/smart/db/sphinx/development/property_core
  morphology = stem_en
  charset_type = utf-8
}

index property
{
  type = distributed
  local = property_core
}

source user_core_0
{
  type = mysql
  sql_host = localhost
  sql_user = smartre
  sql_pass =
  sql_db = smartre_development
  sql_query_pre = SET NAMES utf8
  sql_query = SELECT `users`.`id` * 2 + 1 AS `id` , CAST(`users`.`email` AS CHAR) AS `email`, `users`.`id` AS `sphinx_internal_id`, CAST(IFNULL(CRC32(NULLIF(`users`.`type`,'')), 765557111) AS UNSIGNED) AS `class_crc`, '765557111' AS `subclass_crcs`, 0 AS `sphinx_deleted` FROM `users`    WHERE `users`.`id` >= $start AND `users`.`id` <= $end GROUP BY `users`.`id`, `users`.`type`  ORDER BY NULL
  sql_query_range = SELECT IFNULL(MIN(`id`), 1), IFNULL(MAX(`id`), 1) FROM `users`
  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 `users` WHERE `id` = (($id - 1) / 2)
}

index user_core
{
  source = user_core_0
  path = /home/jacobbasham/src/smart/db/sphinx/development/user_core
  morphology = stem_en
  charset_type = utf-8
}

index user
{
  type = distributed
  local = user_core
}