sphinx.conf

indexer
{
  mem_limit = 1524M
}

searchd
{
  listen = 127.0.0.1:9312
  log = /Users/raphaelwc/Ruby Projects/ngforms/log/searchd.log
  query_log = /Users/raphaelwc/Ruby Projects/ngforms/log/searchd.query.log
  pid_file = /Users/raphaelwc/Ruby Projects/ngforms/log/searchd.development.pid
  max_matches = 500
}

source entry_with_morph_core_0
{
  type = mysql
  sql_host = localhost
  sql_user = root
  sql_pass = 
  sql_db = ngforms_development
  sql_sock = /tmp/mysql.sock
  sql_query_pre = SET NAMES utf8
  sql_query_pre = SET TIME_ZONE = '+0:00'
  sql_query = SELECT     SQL_NO_CACHE `entries`.`id` * 1 + 0 AS `id` , GROUP_CONCAT(DISTINCT IFNULL(`entry_values`.`value_string`, '0') SEPARATOR ' ') AS `values_string`, `entries`.`id` AS `sphinx_internal_id`, 3940594292 AS `class_crc`, 0 AS `sphinx_deleted`, GROUP_CONCAT(DISTINCT IFNULL(`entry_values`.`value_decimal`, '0') SEPARATOR ' ') AS `values_decimal`, GROUP_CONCAT(DISTINCT IFNULL(`entry_values`.`value_integer`, '0') SEPARATOR ',') AS `values_integer`, GROUP_CONCAT(DISTINCT IFNULL(UNIX_TIMESTAMP(`entry_values`.`value_date`), '0') SEPARATOR ',') AS `values_date`, GROUP_CONCAT(DISTINCT IFNULL(`database_fields`.`id`, '0') SEPARATOR ',') AS `values_database_field_id`, `databases`.`id` AS `database_id`, `entries`.`has_error` AS `has_error`, `entries`.`entry_number` AS `entry_number`, `entries`.`merged` AS `merged`, `entries`.`merged_entry_id` AS `merged_entry_id` FROM       `entries`  LEFT OUTER JOIN `entry_values` ON `entry_values`.`entry_id` = `entries`.`id` LEFT OUTER JOIN `database_fields` ON `database_fields`.`id` = `entry_values`.`database_field_id` LEFT OUTER JOIN `databases` ON `databases`.`id` = `entries`.`database_id` WHERE     (`entries`.`id` >= $start AND `entries`.`id` <= $end AND (`merged` = '0' OR `merged` = 'false')) GROUP BY  `entries`.`id` ORDER BY  NULL
  sql_query_range = SELECT IFNULL(MIN(`id`), 1), IFNULL(MAX(`id`), 1) FROM `entries` 
  sql_attr_uint = sphinx_internal_id
  sql_attr_uint = class_crc
  sql_attr_uint = sphinx_deleted
  sql_attr_uint = database_id
  sql_attr_uint = entry_number
  sql_attr_uint = merged_entry_id
  sql_attr_bool = has_error
  sql_attr_bool = merged
  sql_attr_multi = uint values_decimal from field
  sql_attr_multi = uint values_integer from field
  sql_attr_multi = uint values_date from field
  sql_attr_multi = uint values_database_field_id from field
  sql_query_info = SELECT * FROM `entries` WHERE `id` = (($id - 0) / 1)
}

index entry_with_morph_core
{
  source = entry_with_morph_core_0
  path = /Users/raphaelwc/Ruby Projects/ngforms/db/sphinx/development/entry_with_morph_core
  morphology = metaphone
  charset_type = utf-8
  min_prefix_len = 3
  enable_star = 1
}

index entry_with_morph
{
  type = distributed
  local = entry_with_morph_core
}

source entry_without_morph_core_0
{
  type = mysql
  sql_host = localhost
  sql_user = root
  sql_pass = 
  sql_db = ngforms_development
  sql_sock = /tmp/mysql.sock
  sql_query_pre = SET NAMES utf8
  sql_query_pre = SET TIME_ZONE = '+0:00'
  sql_query = SELECT     SQL_NO_CACHE `entries`.`id` * 1 + 0 AS `id` , GROUP_CONCAT(DISTINCT IFNULL(`entry_values`.`value_string`, '0') SEPARATOR ' ') AS `values_string_normal`, `entries`.`id` AS `sphinx_internal_id`, 3940594292 AS `class_crc`, 0 AS `sphinx_deleted` FROM       `entries`  LEFT OUTER JOIN `entry_values` ON `entry_values`.`entry_id` = `entries`.`id` WHERE     (`entries`.`id` >= $start AND `entries`.`id` <= $end AND (`merged` = '0' OR `merged` = 'false')) GROUP BY  `entries`.`id` ORDER BY  NULL
  sql_query_range = SELECT IFNULL(MIN(`id`), 1), IFNULL(MAX(`id`), 1) FROM `entries` 
  sql_attr_uint = sphinx_internal_id
  sql_attr_uint = class_crc
  sql_attr_uint = sphinx_deleted
  sql_query_info = SELECT * FROM `entries` WHERE `id` = (($id - 0) / 1)
}

index entry_without_morph_core
{
  source = entry_without_morph_core_0
  path = /Users/raphaelwc/Ruby Projects/ngforms/db/sphinx/development/entry_without_morph_core
  charset_type = utf-8
  min_prefix_len = 3
  enable_star = 1
}

index entry_without_morph
{
  type = distributed
  local = entry_without_morph_core
}