From 6207240f54272dff698037a21d114d920680f450 Mon Sep 17 00:00:00 2001
From: =?UTF-8?q?Hugo=20H=C3=B6rnquist?= <hugo@lysator.liu.se>
Date: Sat, 31 Dec 2022 01:16:21 +0100
Subject: =?UTF-8?q?l=C3=B6r=2031=20dec=202022=2001:16:21=20CET?=
MIME-Version: 1.0
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: 8bit

---
 TaskApp.wiki | 15 +++++++++++++++
 1 file changed, 15 insertions(+)

(limited to 'TaskApp.wiki')

diff --git a/TaskApp.wiki b/TaskApp.wiki
index 37e62c0..8322385 100644
--- a/TaskApp.wiki
+++ b/TaskApp.wiki
@@ -1,3 +1,5 @@
+[[wn.private:Taskmanagers]]
+
 = Part 1 =
 
 notation:
@@ -87,3 +89,16 @@ Tasks should be able to block each other
 
 but with high enough priority / deadline close enough they should show
 despite the block
+
+= Part 5 =
+{{{SQL
+CREATE TABLE IF NOT EXISTS task
+( id INTEGER PRIMARY KEY NOT NULL
+, description TEXT NOT NULL
+, priority INTEGER NOT NULL DEFAULT 0
+, blocked_by INTEGER
+, parent INTEGER
+, FOREIGN KEY (parent) REFERENCES task (id)
+, FOREIGN KEY (blocked_by) REFERENCES task (id)
+)
+}}}
-- 
cgit v1.2.3