--- /dev/null
+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)
+);