db/db.sql
changeset 50 724121253d34
parent 49 03ae1dbbb14a
parent 48 20355dd2e61a
child 51 0f39cb5e4b11
--- a/db/db.sql	Wed Jun 03 20:41:10 2009 +0300
+++ /dev/null	Thu Jan 01 00:00:00 1970 +0000
@@ -1,5 +0,0 @@
-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);