Page MenuHomePhorge
Files F33542076

D12694.1769083129.diff
No OneTemporary
Actions

Size
1 KB
Referenced Files
None
Subscribers
None

D12694.1769083129.diff
View Options

diff --git a/native/cpp/CommonCpp/DatabaseManagers/SQLiteQueryExecutor.cpp b/native/cpp/CommonCpp/DatabaseManagers/SQLiteQueryExecutor.cpp
--- a/native/cpp/CommonCpp/DatabaseManagers/SQLiteQueryExecutor.cpp
+++ b/native/cpp/CommonCpp/DatabaseManagers/SQLiteQueryExecutor.cpp
@@ -681,6 +681,16 @@
return create_table(db, query, "message_store_local");
}
+bool create_message_search_table(sqlite3 *db) {
+ std::string query =
+ "CREATE VIRTUAL TABLE IF NOT EXISTS message_search USING fts5("
+ " original_message_id UNINDEXED,"
+ " message_id UNINDEXED,"
+ " processed_content"
+ ");";
+ return create_table(db, query, "message_search");
+}
+
bool create_schema(sqlite3 *db) {
char *error;
sqlite3_exec(
@@ -836,7 +846,13 @@
" ON messages (thread, time);"
"CREATE INDEX IF NOT EXISTS outbound_p2p_messages_idx_id_timestamp"
- " ON outbound_p2p_messages (device_id, timestamp);",
+ " ON outbound_p2p_messages (device_id, timestamp);"
+
+ "CREATE VIRTUAL TABLE IF NOT EXISTS message_search USING fts5("
+ " original_message_id UNINDEXED,"
+ " message_id UNINDEXED,"
+ " processed_content"
+ ");",
nullptr,
nullptr,
@@ -1085,7 +1101,8 @@
{44, {create_received_messages_to_device, true}},
{45, {recreate_outbound_p2p_messages_table, true}},
{46, {create_entries_table, true}},
- {47, {create_message_store_local_table, true}}}};
+ {47, {create_message_store_local_table, true}},
+ {48, {create_message_search_table, true}}}};
enum class MigrationResult { SUCCESS, FAILURE, NOT_APPLIED };

File Metadata

Mime Type
text/plain
Expires
Thu, Jan 22, 11:58 AM (8 h, 52 m)
Storage Engine
blob
Storage Format
Raw Data
Storage Handle
5976963
Default Alt Text
D12694.1769083129.diff (1 KB)

Event Timeline