# Auto-generated at Tue Sep 16 14:35:14 -0400 2008.
# Hand modifications will be overwritten.
# /Users/jamie/code/alm/junto/config/ultrasphinx/default.base
indexer {
  mem_limit = 256M
}

searchd {
  read_timeout = 5
  max_children = 300
  log = /opt/local/var/db/sphinx/log/searchd.log
  port = 3313
  max_matches = 100000
  query_log = /opt/local/var/db/sphinx/log/query.log
  seamless_rotate = 1
  pid_file = /opt/local/var/db/sphinx/log/searchd.pid
  address = 0.0.0.0
}

# Source configuration

source profiles_main
{
  sql_range_step = 5000
  sql_query_post =
  sql_ranged_throttle = 0

      type = mysql
      sql_query_pre = SET SESSION group_concat_max_len = 65535
      sql_query_pre = SET NAMES utf8

sql_db = junto_dev
sql_host = localhost
sql_pass =
sql_user = root
sql_query_range = SELECT MIN(id) , MAX(id) FROM profiles
sql_query = SELECT (profiles.id * 1 + 0) AS id, profiles.about_me AS about_me, FLOOR(DATEDIFF(DATE(NOW()),birthdate)/365.25) AS age, UNIX_TIMESTAMP(profiles.birthdate) AS birthdate, profiles.body_type AS body_type, 'Profile' AS class, 0 AS class_id, UNIX_TIMESTAMP(profiles.created_at) AS created_at, profiles.ethnicity AS ethnicity, profiles.eye_colour AS eye_colour, profiles.gender AS gender, profiles.hair_colour AS hair_colour, profiles.height AS height, profiles.interest AS interest, UNIX_TIMESTAMP(profiles.last_login) AS last_login, RADIANS(profiles.lat) AS lat, RADIANS(profiles.lng) AS lng, profiles.login AS login, profiles.question_responses AS question_responses, profiles.tagline AS tagline FROM profiles WHERE profiles.id >= $start AND profiles.id <= $end GROUP BY profiles.id

sql_attr_uint = age
sql_attr_timestamp = birthdate
sql_attr_uint = class_id
sql_attr_timestamp = created_at
sql_attr_uint = height
sql_attr_timestamp = last_login
sql_attr_float = lat
sql_attr_float = lng
sql_query_info = SELECT * FROM profiles WHERE profiles.id = (($id - 0) / 1)
}


# Index configuration

index main
{
  source = profiles_main
  charset_type = utf-8
  html_index_attrs =
  charset_table = 0..9, A..Z->a..z, -, _, ., &, a..z, U+410..U+42F->U+430..U+44F, U+430..U+44F,U+C5->U+E5, U+E5, U+C4->U+E4, U+E4, U+D6->U+F6, U+F6, U+16B, U+0c1->a, U+0c4->a, U+0c9->e, U+0cd->i, U+0d3->o, U+0d4->o, U+0da->u, U+0dd->y, U+0e1->a, U+0e4->a, U+0e9->e, U+0ed->i, U+0f3->o, U+0f4->o, U+0fa->u, U+0fd->y, U+104->U+105, U+105, U+106->U+107, U+10c->c, U+10d->c, U+10e->d, U+10f->d, U+116->U+117, U+117, U+118->U+119, U+11a->e, U+11b->e, U+12E->U+12F, U+12F, U+139->l, U+13a->l, U+13d->l, U+13e->l, U+141->U+142, U+142, U+143->U+144, U+144,U+147->n, U+148->n, U+154->r, U+155->r, U+158->r, U+159->r, U+15A->U+15B, U+15B, U+160->s, U+160->U+161, U+161->s, U+164->t, U+165->t, U+16A->U+16B, U+16B, U+16e->u, U+16f->u, U+172->U+173, U+173, U+179->U+17A, U+17A, U+17B->U+17C, U+17C, U+17d->z, U+17e->z,
  min_word_len = 1
  stopwords =
  min_infix_len = 2
  enable_star = 1
  html_strip = 0
  path = /opt/local/var/db/sphinx//sphinx_index_main
  docinfo = extern
  morphology = stem_en
}


# Source configuration

source profiles_delta
{
  sql_range_step = 5000
  sql_query_post =
  sql_ranged_throttle = 0

      type = mysql
      sql_query_pre = SET SESSION group_concat_max_len = 65535
      sql_query_pre = SET NAMES utf8

sql_db = junto_dev
sql_host = localhost
sql_pass =
sql_user = root
sql_query_range = SELECT MIN(id) , MAX(id) FROM profiles WHERE profiles.updated_at > DATE_SUB(NOW(), INTERVAL 88200 SECOND)
sql_query = SELECT (profiles.id * 1 + 0) AS id, profiles.about_me AS about_me, FLOOR(DATEDIFF(DATE(NOW()),birthdate)/365.25) AS age, UNIX_TIMESTAMP(profiles.birthdate) AS birthdate, profiles.body_type AS body_type, 'Profile' AS class, 0 AS class_id, UNIX_TIMESTAMP(profiles.created_at) AS created_at, profiles.ethnicity AS ethnicity, profiles.eye_colour AS eye_colour, profiles.gender AS gender, profiles.hair_colour AS hair_colour, profiles.height AS height, profiles.interest AS interest, UNIX_TIMESTAMP(profiles.last_login) AS last_login, RADIANS(profiles.lat) AS lat, RADIANS(profiles.lng) AS lng, profiles.login AS login, profiles.question_responses AS question_responses, profiles.tagline AS tagline FROM profiles WHERE profiles.id >= $start AND profiles.id <= $end AND profiles.updated_at > DATE_SUB(NOW(), INTERVAL 88200 SECOND) GROUP BY profiles.id

sql_attr_uint = age
sql_attr_timestamp = birthdate
sql_attr_uint = class_id
sql_attr_timestamp = created_at
sql_attr_uint = height
sql_attr_timestamp = last_login
sql_attr_float = lat
sql_attr_float = lng
sql_query_info = SELECT * FROM profiles WHERE profiles.id = (($id - 0) / 1)
}


# Index configuration

index delta
{
  source = profiles_delta
  charset_type = utf-8
  html_index_attrs =
  charset_table = 0..9, A..Z->a..z, -, _, ., &, a..z, U+410..U+42F->U+430..U+44F, U+430..U+44F,U+C5->U+E5, U+E5, U+C4->U+E4, U+E4, U+D6->U+F6, U+F6, U+16B, U+0c1->a, U+0c4->a, U+0c9->e, U+0cd->i, U+0d3->o, U+0d4->o, U+0da->u, U+0dd->y, U+0e1->a, U+0e4->a, U+0e9->e, U+0ed->i, U+0f3->o, U+0f4->o, U+0fa->u, U+0fd->y, U+104->U+105, U+105, U+106->U+107, U+10c->c, U+10d->c, U+10e->d, U+10f->d, U+116->U+117, U+117, U+118->U+119, U+11a->e, U+11b->e, U+12E->U+12F, U+12F, U+139->l, U+13a->l, U+13d->l, U+13e->l, U+141->U+142, U+142, U+143->U+144, U+144,U+147->n, U+148->n, U+154->r, U+155->r, U+158->r, U+159->r, U+15A->U+15B, U+15B, U+160->s, U+160->U+161, U+161->s, U+164->t, U+165->t, U+16A->U+16B, U+16B, U+16e->u, U+16f->u, U+172->U+173, U+173, U+179->U+17A, U+17A, U+17B->U+17C, U+17C, U+17d->z, U+17e->z,
  min_word_len = 1
  stopwords =
  min_infix_len = 2
  enable_star = 1
  html_strip = 0
  path = /opt/local/var/db/sphinx//sphinx_index_delta
  docinfo = extern
  morphology = stem_en
}