vendor/riddle/spec/fixtures/sphinx/configuration.erb in ultrasphinx-1.9 vs vendor/riddle/spec/fixtures/sphinx/configuration.erb in ultrasphinx-1.11
- old
+ new
@@ -19,13 +19,13 @@
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
+ 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_attr_timestamp = birthday
}
index people
{
source = peoples
\ No newline at end of file