--- /dev/null	Thu Jan 01 00:00:00 1970 +0000
+++ b/schema.sql	Mon Jul 28 22:33:36 2008 +0200
@@ -0,0 +1,16 @@
+CREATE TABLE projects (
+    id          INTEGER PRIMARY KEY AUTOINCREMENT,
+    key         VARCHAR(16),
+    description VARCHAR(256),
+    active      BOOLEAN DEFAULT 1
+);
+
+CREATE TABLE entries (
+    id          INTEGER PRIMARY KEY AUTOINCREMENT,
+    project_id  INTEGER REFERENCES projects(id),
+    start_time  TIMESTAMP NOT NULL,
+    stop_time   TIMESTAMP NOT NULL,
+    description VARCHAR(256),
+
+    CHECK (strftime('%s', start_time) <= strftime('%s', stop_time))
+);