diff options
| author | Hugo Hörnquist <hugo@lysator.liu.se> | 2022-12-31 01:16:21 +0100 |
|---|---|---|
| committer | Hugo Hörnquist <hugo@lysator.liu.se> | 2022-12-31 01:16:21 +0100 |
| commit | 6207240f54272dff698037a21d114d920680f450 (patch) | |
| tree | c8f9bd81a7da7fc14e1a2584e16da79acf3417e9 /TaskApp.wiki | |
| parent | mån 26 dec 2022 11:59:51 CET (diff) | |
| download | wiki-public-6207240f54272dff698037a21d114d920680f450.tar.gz wiki-public-6207240f54272dff698037a21d114d920680f450.tar.xz | |
lör 31 dec 2022 01:16:21 CET
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) +) +}}} |