home
·
contact
·
privacy
projects
/
plomtask
/ blobdiff
commit
grep
author
committer
pickaxe
?
search:
re
summary
|
shortlog
|
log
|
commit
|
commitdiff
|
tree
raw
|
inline
| side by side
Add most basic Todo family relations.
[plomtask]
/
scripts
/
init.sql
diff --git
a/scripts/init.sql
b/scripts/init.sql
index 6dca3729e8ef6f7408c32ecc1466d674fcaa0c41..9f39305d5896b605a8fc09b4f47de073d4a295cd 100644
(file)
--- a/
scripts/init.sql
+++ b/
scripts/init.sql
@@
-35,6
+35,13
@@
CREATE TABLE process_titles (
CREATE TABLE processes (
id INTEGER PRIMARY KEY
);
CREATE TABLE processes (
id INTEGER PRIMARY KEY
);
+CREATE TABLE todo_children (
+ parent INTEGER NOT NULL,
+ child INTEGER NOT NULL,
+ PRIMARY KEY (parent, child),
+ FOREIGN KEY (parent) REFERENCES todos(id),
+ FOREIGN KEY (child) REFERENCES todos(id)
+);
CREATE TABLE todos (
id INTEGER PRIMARY KEY,
process_id INTEGER NOT NULL,
CREATE TABLE todos (
id INTEGER PRIMARY KEY,
process_id INTEGER NOT NULL,