photoprism/internal/entity/migrate/sqlite/20220421-200000.sql

CREATE INDEX IF NOT EXISTS idx_files_missing_root ON files (file_missing, file_root);