# Auto-generated at Thu Sep 13 13:34:29 -0500 2007.
# Hand modifications will be overwritten.

# /private/var/www/rails/napr/trunk/config/ultrasphinx/default.base

# to put in RAILS_ROOT/config/ultrasphinx
# can be namespaced individually (development.base)

indexer
{
  mem_limit = 256M
}

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




# Source configuration

source sellers
{

strip_html = 0
index_html_attrs =
sql_query_post =
sql_range_step = 20000


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

sql_pass =
sql_user = root
sql_host = localhost
sql_db = nap_development

sql_query_range = SELECT MIN(id), MAX(id) FROM sellers
sql_query = SELECT (sellers.id * 1 + 0) AS id, sellers.activation_code AS activation_code, 'Seller' AS class, 0 AS class_id, sellers.company_name AS company_name, UNIX_TIMESTAMP(sellers.created_at) AS created_at, '__empty_searchable__' AS empty_searchable FROM sellers WHERE sellers.id >= $start AND sellers.id <= $end GROUP BY id

sql_group_column = class_id
sql_date_column = created_at

sql_query_info = SELECT * FROM sellers WHERE sellers.id = (($id - 0) / 1)
}


# Index configuration

index complete
{
source = sellers
morphology = stem_en
stopwords =
min_word_len = 1
charset_type = utf-8
docinfo = extern
path = /opt/local/var/db/sphinx//sphinx_index_complete
}