changeset 50 | 724121253d34 |
parent 49 | 03ae1dbbb14a |
parent 48 | 20355dd2e61a |
child 51 | 0f39cb5e4b11 |
49:03ae1dbbb14a | 50:724121253d34 |
---|---|
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); |