# HG changeset patch
# User terom
# Date 1205798642 0
# Node ID cc2d9db311c07dbceef04c596a39c01b868af73f
# Parent  09776792a91c4c71357ece9a97d99d597f876f87
database dir and schema

diff -r 09776792a91c -r cc2d9db311c0 db/db.sql
--- /dev/null	Thu Jan 01 00:00:00 1970 +0000
+++ b/db/db.sql	Tue Mar 18 00:04:02 2008 +0000
@@ -0,0 +1,5 @@
+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);