diff options
Diffstat (limited to 'TaskApp.wiki')
-rw-r--r-- | TaskApp.wiki | 15 |
1 files changed, 15 insertions, 0 deletions
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) +) +}}} |