Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- indexer
- {
- }
- searchd
- {
- address = 127.0.0.1
- port = 3312
- log = /home/jacobbasham/src/smart/log/searchd.log
- query_log = /home/jacobbasham/src/smart/log/searchd.query.log
- pid_file = /home/jacobbasham/src/smart/log/searchd.development.pid
- }
- source property_core_0
- {
- type = mysql
- sql_host = localhost
- sql_user = smartre
- sql_pass =
- sql_db = smartre_development
- sql_query_pre = SET NAMES utf8
- sql_query = SELECT `properties`.`id` * 2 + 0 AS `id` , CAST(CONCAT_WS(' ', `properties`.`address1`, `properties`.`address2`, `properties`.`city`, `properties`.`state`, `properties`.`postal_code`) AS CHAR) AS `address`, CAST(`properties`.`remarks` AS CHAR) AS `remarks`, CAST(`properties`.`listing_number` AS CHAR) AS `listing_number`, CAST(`properties`.`listing_status` AS CHAR) AS `listing_status`, CAST(`properties`.`listing_agent` AS CHAR) AS `listing_agent`, CAST(`properties`.`listing_office` AS CHAR) AS `listing_office`, CAST(`properties`.`code` AS CHAR) AS `code`, `properties`.`id` AS `sphinx_internal_id`, CAST(IFNULL(CRC32(NULLIF(`properties`.`type`,'')), 1921285768) AS UNSIGNED) AS `class_crc`, '1921285768' AS `subclass_crcs`, 0 AS `sphinx_deleted`, UNIX_TIMESTAMP(`properties`.`status_date`) AS `status_date`, `properties`.`list_price` AS `list_price`, `properties`.`baths` AS `baths`, `properties`.`bedrooms` AS `bedrooms`, `properties`.`north` AS `north`, `properties`.`south` AS `south`, `properties`.`east` AS `east`, `properties`.`west` AS `west`, `properties`.`postal_code` AS `postal_code`, `properties`.`active` AS `active`, `properties`.`searchable` AS `searchable`, `properties`.`neighborhood_id` AS `neighborhood_id`, (`properties`.`traits` & 512) > 0 AS `cats_allowed`, (`properties`.`traits` & 1) > 0 AS `central_air`, (`properties`.`traits` & 1024) > 0 AS `clubhouse`, (`properties`.`traits` & 2) > 0 AS `coming_soon`, (`properties`.`traits` & 2048) > 0 AS `dogs_allowed`, (`properties`.`traits` & 4096) > 0 AS `doorman`, (`properties`.`traits` & 4) > 0 AS `elevator`, (`properties`.`traits` & 8192) > 0 AS `exercise_area`, (`properties`.`traits` & 8) > 0 AS `foreclosure`, (`properties`.`traits` & 0) > 0 AS `green`, (`properties`.`traits` & 16384) > 0 AS `hardwood`, (`properties`.`traits` & 32768) > 0 AS `in_unit_laundry`, (`properties`.`traits` & 0) > 0 AS `investment`, (`properties`.`traits` & 0) > 0 AS `listed_on_mls`, (`properties`.`traits` & 65536) > 0 AS `loft`, (`properties`.`traits` & 64) > 0 AS `new_construction`, (`properties`.`traits` & 128) > 0 AS `new_listing`, (`properties`.`traits` & 131072) > 0 AS `outdoor_area`, (`properties`.`traits` & 0) > 0 AS `parking`, (`properties`.`traits` & 262144) > 0 AS `pool`, (`properties`.`traits` & 1048576) > 0 AS `sauna`, (`properties`.`traits` & 256) > 0 AS `security_features`, (`properties`.`traits` & 524288) > 0 AS `tennis_court`, (`properties`.`traits` & 2097152) > 0 AS `vacation` FROM `properties` WHERE `properties`.`id` >= $start AND `properties`.`id` <= $end GROUP BY `properties`.`id`, `properties`.`type` ORDER BY NULL
- sql_query_range = SELECT IFNULL(MIN(`id`), 1), IFNULL(MAX(`id`), 1) FROM `properties`
- sql_attr_uint = sphinx_internal_id
- sql_attr_uint = class_crc
- sql_attr_uint = sphinx_deleted
- sql_attr_uint = list_price
- sql_attr_uint = bedrooms
- sql_attr_uint = north
- sql_attr_uint = south
- sql_attr_uint = east
- sql_attr_uint = west
- sql_attr_uint = postal_code
- sql_attr_uint = neighborhood_id
- sql_attr_bool = active
- sql_attr_bool = searchable
- sql_attr_bool = cats_allowed
- sql_attr_bool = central_air
- sql_attr_bool = clubhouse
- sql_attr_bool = coming_soon
- sql_attr_bool = dogs_allowed
- sql_attr_bool = doorman
- sql_attr_bool = elevator
- sql_attr_bool = exercise_area
- sql_attr_bool = foreclosure
- sql_attr_bool = green
- sql_attr_bool = hardwood
- sql_attr_bool = in_unit_laundry
- sql_attr_bool = investment
- sql_attr_bool = listed_on_mls
- sql_attr_bool = loft
- sql_attr_bool = new_construction
- sql_attr_bool = new_listing
- sql_attr_bool = outdoor_area
- sql_attr_bool = parking
- sql_attr_bool = pool
- sql_attr_bool = sauna
- sql_attr_bool = security_features
- sql_attr_bool = tennis_court
- sql_attr_bool = vacation
- sql_attr_timestamp = status_date
- sql_attr_float = baths
- sql_attr_multi = uint subclass_crcs from field
- sql_query_info = SELECT * FROM `properties` WHERE `id` = (($id - 0) / 2)
- }
- index property_core
- {
- source = property_core_0
- path = /home/jacobbasham/src/smart/db/sphinx/development/property_core
- morphology = stem_en
- charset_type = utf-8
- }
- index property
- {
- type = distributed
- local = property_core
- }
- source user_core_0
- {
- type = mysql
- sql_host = localhost
- sql_user = smartre
- sql_pass =
- sql_db = smartre_development
- sql_query_pre = SET NAMES utf8
- sql_query = SELECT `users`.`id` * 2 + 1 AS `id` , CAST(`users`.`email` AS CHAR) AS `email`, `users`.`id` AS `sphinx_internal_id`, CAST(IFNULL(CRC32(NULLIF(`users`.`type`,'')), 765557111) AS UNSIGNED) AS `class_crc`, '765557111' AS `subclass_crcs`, 0 AS `sphinx_deleted` FROM `users` WHERE `users`.`id` >= $start AND `users`.`id` <= $end GROUP BY `users`.`id`, `users`.`type` ORDER BY NULL
- sql_query_range = SELECT IFNULL(MIN(`id`), 1), IFNULL(MAX(`id`), 1) FROM `users`
- sql_attr_uint = sphinx_internal_id
- sql_attr_uint = class_crc
- sql_attr_uint = sphinx_deleted
- sql_attr_multi = uint subclass_crcs from field
- sql_query_info = SELECT * FROM `users` WHERE `id` = (($id - 1) / 2)
- }
- index user_core
- {
- source = user_core_0
- path = /home/jacobbasham/src/smart/db/sphinx/development/user_core
- morphology = stem_en
- charset_type = utf-8
- }
- index user
- {
- type = distributed
- local = user_core
- }
Add Comment
Please, Sign In to add comment