Improve accounting scripts, start todo.py rewrite.

[misc] / new_todo / init.sql

diff --git a/new_todo/init.sql b/new_todo/init.sql
new file mode 100644 (file)
index 0000000..49b52d8
--- /dev/null
+++ b/new_todo/init.sql
@@ -0,0 +1,25 @@
+CREATE TABLE days (
+  date TEXT NOT NULL PRIMARY KEY,
+  comment TEXT NOT NULL
+);
+CREATE TABLE templates (
+  id INTEGER PRIMARY KEY
+);
+CREATE TABLE versioned_default_efforts (
+  template INTEGER NOT NULL,
+  datetime TEXT NOT NULL,
+  default_effort REAL NOT NULL,
+  PRIMARY KEY (template, datetime)
+);
+CREATE TABLE versioned_descriptions (
+  template INTEGER NOT NULL,
+  datetime TEXT NOT NULL,
+  description TEXT NOT NULL,
+  PRIMARY KEY (template, datetime)
+);
+CREATE TABLE versioned_titles (
+  template INTEGER NOT NULL,
+  datetime TEXT NOT NULL,
+  title TEXT NOT NULL,
+  PRIMARY KEY (template, datetime)
+);