indexer
{
  mem_limit = 64M
}

searchd
{
  port          = 3313
  log           = <%= @path %>/fixtures/sphinx/searchd.log
  query_log     = <%= @path %>/fixtures/sphinx/searchd.query.log
  read_timeout  = 5
  max_children  = 30
  pid_file      = <%= @path %>/fixtures/sphinx/searchd.pid
}

source peoples
{
  type 	    = mysql
  sql_host  = <%= @host %>
  sql_user  = <%= @username %>
  sql_pass  = <%= @password %>
  sql_db    = riddle_sphinx_spec

  sql_query        = SELECT id, first_name, middle_initial, last_name, gender, street_address, city, state, postcode, email, UNIX_TIMESTAMP(birthday) AS birthday FROM people WHERE id >= $start AND id <= $end
  sql_query_range  = SELECT MIN(id), MAX(id) FROM people
  sql_query_info   = SELECT * FROM people WHERE id = $id
  sql_date_column  = birthday
}

index people
{
  source          = peoples
  morphology      = stem_en
  path            = <%= @path %>/fixtures/sphinx/people
  charset_type    = utf-8
  enable_star     = 1
  min_prefix_len  = 1
}