X-Git-Url: https://plomlompom.com/repos/?p=misc;a=blobdiff_plain;f=new_todo%2Finit.sql;fp=new_todo%2Finit.sql;h=49b52d80d34f7ab6139e102d6df243fe3d8c24cc;hp=0000000000000000000000000000000000000000;hb=9637ae6c570e9cf0cce500d85af03c74d6771362;hpb=ecee822bebf62049803b90fc8d8a0b484915a0fc

diff --git a/new_todo/init.sql b/new_todo/init.sql
new file mode 100644
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)
+);