HomePhabricator
Diffusion Comm b6f1abd14fe2

[native](web) Add message_search fts5 table

Description

[native](web) Add message_search fts5 table

Summary:
issue: ENG-8640
By default all columns of fts5 table are indexed for fulltext search. We want to avoid doing this for original_message_id and message_id which represent message ids. That's why we mark them as UNINDEXED.
From docs:
"It is an error to add types, constraints or PRIMARY KEY declarations to a CREATE VIRTUAL TABLE statement used to create an FTS5 table. "

Test Plan: Tested that the migration and new db setup don't throw

Reviewers: tomek, kamil

Reviewed By: tomek, kamil

Subscribers: ashoat

Differential Revision: https://phab.comm.dev/D12694

Details

Provenance
inkaAuthored on Jul 8 2024, 7:12 AM
Reviewer
tomek
Differential Revision
D12694: [native](web) Add message_search fts5 table
Parents
rCOMM66b8401f6f21: [native][web] Add fts5 extension to SQLite
Branches
Unknown
Tags
Unknown