X-Git-Url: https://plomlompom.com/repos/%7B%7Bprefix%7D%7D/copy_structured?a=blobdiff_plain;f=new_todo%2Finit.sql;h=a911fb02c8f21cb5383e42886fad3e71322674a5;hb=HEAD;hp=49b52d80d34f7ab6139e102d6df243fe3d8c24cc;hpb=9637ae6c570e9cf0cce500d85af03c74d6771362;p=misc

diff --git a/new_todo/init.sql b/new_todo/init.sql
index 49b52d8..a911fb0 100644
--- a/new_todo/init.sql
+++ b/new_todo/init.sql
@@ -3,23 +3,30 @@ CREATE TABLE days (
   comment TEXT NOT NULL
 );
 CREATE TABLE templates (
-  id INTEGER PRIMARY KEY
+  id INTEGER PRIMARY KEY,
+  forked_from INTEGER,
+  forked_at TEXT,
+  FOREIGN KEY (forked_from) REFERENCES templates(id)
 );
 CREATE TABLE versioned_default_efforts (
   template INTEGER NOT NULL,
   datetime TEXT NOT NULL,
   default_effort REAL NOT NULL,
-  PRIMARY KEY (template, datetime)
+  PRIMARY KEY (template, datetime),
+  FOREIGN KEY (template) REFERENCES templates(id)
 );
 CREATE TABLE versioned_descriptions (
   template INTEGER NOT NULL,
   datetime TEXT NOT NULL,
   description TEXT NOT NULL,
-  PRIMARY KEY (template, datetime)
+  PRIMARY KEY (template, datetime),
+  FOREIGN KEY (template) REFERENCES templates(id)
+
 );
 CREATE TABLE versioned_titles (
   template INTEGER NOT NULL,
   datetime TEXT NOT NULL,
   title TEXT NOT NULL,
-  PRIMARY KEY (template, datetime)
+  PRIMARY KEY (template, datetime),
+  FOREIGN KEY (template) REFERENCES templates(id)
 );