X-Git-Url: https://plomlompom.com/repos/%7B%7B%20web_path%20%7D%7D/decks/%7B%7Bdeck_id%7D%7D/cards/%7B%7Bcard_id%7D%7D/form?a=blobdiff_plain;f=new_todo%2Finit.sql;h=1a91146ae4285a51a9855fafd56e3a4778413392;hb=0cd0b92d9e261dbe75fa45001aeca74592c053f8;hp=49b52d80d34f7ab6139e102d6df243fe3d8c24cc;hpb=9637ae6c570e9cf0cce500d85af03c74d6771362;p=misc

diff --git a/new_todo/init.sql b/new_todo/init.sql
index 49b52d8..1a91146 100644
--- a/new_todo/init.sql
+++ b/new_todo/init.sql
@@ -3,23 +3,31 @@ 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)
+
 );