author | Tero Marttila <terom@fixme.fi> |
Thu, 11 Jun 2009 21:26:05 +0300 | |
branch | threaded-tasks |
changeset 89 | 4b254a90d6d0 |
parent 41 | 3b1579a7bffb |
permissions | -rw-r--r-- |
CREATE TABLE 'nodes' (id INTEGER NOT NULL PRIMARY KEY, dirpath TEXT NOT NULL, filename TEXT NOT NULL); CREATE TABLE tags (image INTEGER NOT NULL, type TEXT, tag TEXT NOT NULL); CREATE VIEW images AS SELECT id, dirpath, filename FROM nodes WHERE filename != ''; CREATE UNIQUE INDEX tags_unique_image_type ON tags (image, type); CREATE UNIQUE INDEX tags_unique_image_type_tag ON tags (image, type, tag);