Skip to content

psi.sqlite (search database) changes from Photos 5 to Photos 6

Rhet Turnbull edited this page Dec 4, 2020 · 1 revision
> CREATE INDEX ga_groupid ON ga(groupid);
6c7,8
< CREATE INDEX group_pk ON groups(category, content_string, normalized_string, lookup_identifier);
---
> CREATE INDEX gc_groupid ON gc(groupid);
> CREATE INDEX groupid_by_contentstring_category_lookupid_owner ON groups(content_string, category, lookup_identifier, owning_groupid);
22a25
> CREATE TABLE tmp_used_groupids (groupid INTEGER PRIMARY KEY);
Clone this wiki locally