[geary: 3/4] Rebuild MessageSearchTable. Database version 25. Bug 772522.

[Michael Gratton <mjog src gnome org>]

commit 3e721feedb3173751c71904d48e2ba9b614e920e
Author: Michael James Gratton <mike vee net>
Date:   Sat Oct 22 07:33:34 2016 +1100

    Rebuild MessageSearchTable. Database version 25. Bug 772522.
    
    * sql/version-025.sql: Rebuild MessageSearchTable, and while we're here
      optimise it as well.

 sql/CMakeLists.txt  |    1 +
 sql/version-025.sql |   15 +++++++++++++++
 2 files changed, 16 insertions(+), 0 deletions(-)
---
diff --git a/sql/CMakeLists.txt b/sql/CMakeLists.txt
index 11de86c..c89b8c9 100644
--- a/sql/CMakeLists.txt
+++ b/sql/CMakeLists.txt
@@ -24,3 +24,4 @@ install(FILES version-021.sql DESTINATION ${SQL_DEST})
 install(FILES version-022.sql DESTINATION ${SQL_DEST})
 install(FILES version-023.sql DESTINATION ${SQL_DEST})
 install(FILES version-024.sql DESTINATION ${SQL_DEST})
+install(FILES version-025.sql DESTINATION ${SQL_DEST})
diff --git a/sql/version-025.sql b/sql/version-025.sql
new file mode 100644
index 0000000..7b7c287
--- /dev/null
+++ b/sql/version-025.sql
@@ -0,0 +1,15 @@
+--
+-- Rebuild corrupted MessageSearchTable indexes. Bug 772522.
+--
+
+-- According to the FTS3 docs <https://www.sqlite.org/fts3.html>, this
+-- needs to be done "whenever the implementation of a custom tokeniser
+-- changes", but Geary is also seeing the indexes being corrupted when
+-- doing UPDATEs on MessageSearchTable. Bug 772522 has replaced use of
+-- that with a SELECT/DELETE/INSERT which does not result in a
+-- corrupted index, so do a rebuild here to ensure everyone's is not
+-- back in order.
+INSERT INTO MessageSearchTable(MessageSearchTable) VALUES('rebuild');
+
+-- While we're here, optimise it as well.
+INSERT INTO MessageSearchTable(MessageSearchTable) VALUES('optimize');