diff --git a/etc/sphinx.conf b/etc/sphinx.conf index f2d094c..77abadf 100644 --- a/etc/sphinx.conf +++ b/etc/sphinx.conf @@ -11,13 +11,14 @@ sql_pass = piler sql_query_pre = SET NAMES utf8 - sql_query = SELECT id, `from`, `to`, `fromdomain`, `todomain`, `subject`, `arrived`, `sent`, `body`, `size`, `direction`, `attachments`, `attachment_types` FROM sph_index \ + sql_query = SELECT id, `from`, `to`, `fromdomain`, `todomain`, `subject`, `arrived`, `sent`, `body`, `size`, `direction`, `folder`, `attachments`, `attachment_types` FROM sph_index \ WHERE id<=( SELECT max_doc_id FROM sph_counter WHERE counter_id=1 ) sql_attr_uint = size sql_attr_uint = arrived sql_attr_uint = sent sql_attr_uint = direction + sql_attr_uint = folder sql_attr_uint = attachments } @@ -34,13 +35,14 @@ sql_query_pre = SET NAMES utf8 sql_query_pre = REPLACE INTO sph_counter SELECT 1, MAX(id) FROM sph_index sql_query_post_index = DELETE FROM sph_index WHERE id<=(SELECT max_doc_id FROM sph_counter WHERE counter_id=1) - sql_query = SELECT id, `from`, `to`, `fromdomain`, `todomain`, `subject`, `arrived`, `sent`, `body`, `size`, `direction`, `attachments`, `attachment_types` FROM sph_index \ + sql_query = SELECT id, `from`, `to`, `fromdomain`, `todomain`, `subject`, `arrived`, `sent`, `body`, `size`, `direction`, `folder`, `attachments`, `attachment_types` FROM sph_index \ WHERE id <= (SELECT max_doc_id FROM sph_counter WHERE counter_id=1) sql_attr_uint = size sql_attr_uint = arrived sql_attr_uint = sent sql_attr_uint = direction + sql_attr_uint = folder sql_attr_uint = attachments sql_query_killlist = SELECT `id` FROM `metadata` WHERE `deleted`=1