indexer
{
  mem_limit = 32M
}

searchd
{
  address = 127.0.0.1
  log = log/sphinx/searchd.development.log
  max_children = 30
  max_matches = 1000
  pid_file = sphinx/development/searchd.pid
  port = 3312
  query_log = log/sphinx/query.development.log
  read_timeout = 5
}

source lyrics
{
  index_html_attrs =
  sql_db = loflamenco_dev
  sql_group_column = sphincter_index_id
  sql_host = 127.0.0.1
  sql_pass =
  sql_query = SELECT (lyrics.`id` * 1 + 0) AS `id`, 0 AS sphincter_index_id, 'lyrics' AS klass, lyrics.`body` AS `body` FROM lyrics WHERE lyrics.`id` >= $start AND lyrics.`id` <= $end
  sql_query_info = SELECT * FROM lyrics WHERE lyrics.`id` = (($id - 0) / 1)
  sql_query_post =
  sql_query_pre = SET SESSION group_concat_max_len = 65535
  sql_query_pre = SET NAMES utf8
  sql_query_range = SELECT MIN(`id`), MAX(`id`) FROM lyrics
  sql_range_step = 20000
  sql_user = root
  strip_html = 0
  type = mysql
}

index lyrics
{
  charset_type = utf-8
  docinfo = extern
  min_word_len = 1
  morphology = stem_en
  path = /Users/joshua/work/projects/lof/trunk/sphinx/development/lyrics
  source = lyrics
  stopwords =
}


{Lyric(id: integer, body: text, created_at: datetime, updated_at: datetime, created_by: integer, updated_by: integer)=>[{:fields=>["body"], :index_id=>0}]}