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 GET /todo and Todo retrieval by ID.
[plomtask]
/
scripts
/
init.sql
diff --git
a/scripts/init.sql
b/scripts/init.sql
index 12450302ab084356fb2cbede95106027445c329a..6dca3729e8ef6f7408c32ecc1466d674fcaa0c41 100644
(file)
--- a/
scripts/init.sql
+++ b/
scripts/init.sql
@@
-35,3
+35,11
@@
CREATE TABLE process_titles (
CREATE TABLE processes (
id INTEGER PRIMARY KEY
);
CREATE TABLE processes (
id INTEGER PRIMARY KEY
);
+CREATE TABLE todos (
+ id INTEGER PRIMARY KEY,
+ process_id INTEGER NOT NULL,
+ is_done BOOLEAN NOT NULL,
+ day TEXT NOT NULL,
+ FOREIGN KEY (process_id) REFERENCES processes(id),
+ FOREIGN KEY (day) REFERENCES days(date)
+);