htu_trigram.sql

htu_trigram.sql

begin;
create virtual table if not exists search_urls using fts5
(
    url,
    title,
    tokenize = 'trigram'
);
alter table search_urls rename to search_urls_bak;
create virtual table search_urls using fts5
(
    url,
    title,
    tokenize = 'trigram'
);
insert into search_urls select url,title from search_urls_bak;
drop table search_urls_bak;
commit;
vacuum;