1

CREATE TABLE 'nodes' (id INTEGER NOT NULL PRIMARY KEY, dirpath TEXT NOT NULL, filename TEXT NOT NULL);

     2

CREATE TABLE tags (image INTEGER NOT NULL, type TEXT, tag TEXT NOT NULL);

     3

CREATE VIEW images AS SELECT id, dirpath, filename FROM nodes WHERE filename != '';

     4

CREATE UNIQUE INDEX tags_unique_image_type ON tags (image, type);

     5

CREATE UNIQUE INDEX tags_unique_image_type_tag ON tags (image, type, tag);