psi.sqlite (search database) changes from Photos 5 to Photos 6
Rhet Turnbull edited this page 2020-12-03 18:03:11 -08:00
> 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);