file://
INSERT OR IGNORE INTO 'photos' ('base_uri', 'filename') VALUES ('
','
')
INSERT OR IGNORE INTO 'tags' ('name') VALUES ('
')
INSERT OR IGNORE INTO 'photo_tags' ('photo_id', 'tag_id') SELECT 'photos'.'id', 'tags'.'id' FROM 'photos', 'tags' WHERE 'photos'.'filename' = '
' AND 'tags'.'name'='
'