indexer
{
}

searchd
{
  listen = 127.0.0.1:9306:mysql41
  log = /home/ruy/Documentos/APP/APP_R2T/app_elementar/log/development.searchd.log
  query_log = /home/ruy/Documentos/APP/APP_R2T/app_elementar/log/development.searchd.query.log
  pid_file = /home/ruy/Documentos/APP/APP_R2T/app_elementar/log/development.sphinx.pid
  workers = threads
  binlog_path = /home/ruy/Documentos/APP/APP_R2T/app_elementar/tmp/binlog/development
}

source collaborator_core_0
{
  type = mysql
  sql_host = 127.0.0.1
  sql_user = root
  sql_pass = teste123
  sql_db = app_teste
  sql_port = 3306
  sql_query_pre = SET TIME_ZONE = '+0:00'
  sql_query_pre = SET NAMES utf8
  sql_query = SELECT SQL_NO_CACHE `collaborators`.`id` * 2 + 0 AS `id`, `collaborators`.`nome` AS `nome`, `collaborators`.`id` AS `sphinx_internal_id`, 'Collaborator' AS `sphinx_internal_class`, 0 AS `sphinx_deleted` FROM `collaborators` WHERE (`collaborators`.`id` BETWEEN $start AND $end) GROUP BY `collaborators`.`id`, `collaborators`.`nome`, `collaborators`.`id` ORDER BY NULL
  sql_query_range = SELECT IFNULL(MIN(`collaborators`.`id`), 1), IFNULL(MAX(`collaborators`.`id`), 1) FROM `collaborators`
  sql_attr_uint = sphinx_internal_id
  sql_attr_uint = sphinx_deleted
  sql_attr_string = sphinx_internal_class
  sql_field_string = nome
}

index collaborator_core
{
  type = plain
  path = /home/ruy/Documentos/APP/APP_R2T/app_elementar/db/sphinx/development/collaborator_core
  docinfo = extern
  source = collaborator_core_0
}

index collaborator
{
  type = distributed
  local = collaborator_core
}