author | Tero Marttila <terom@fixme.fi> |
Wed, 03 Jun 2009 18:59:46 +0300 | |
branch | use-distutils |
changeset 40 | 373392025533 |
parent 32 | cc2d9db311c0 |
permissions | -rw-r--r-- |
32 | 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); |