home
·
contact
·
privacy
projects
/
plomtask
/ blobdiff
commit
grep
author
committer
pickaxe
?
search:
re
summary
|
shortlog
|
log
|
commit
|
commitdiff
|
tree
raw
|
inline
| side by side
Refactor and extend tests.
[plomtask]
/
scripts
/
init.sql
diff --git
a/scripts/init.sql
b/scripts/init.sql
index 5fdd77905bb8c5fbc2557843be015ae54f3a289f..b2979a5e1dffeedf0445ef65e6a675ec50e9bfce 100644
(file)
--- a/
scripts/init.sql
+++ b/
scripts/init.sql
@@
-34,6
+34,13
@@
CREATE TABLE process_descriptions (
PRIMARY KEY (parent, timestamp),
FOREIGN KEY (parent) REFERENCES processes(id)
);
PRIMARY KEY (parent, timestamp),
FOREIGN KEY (parent) REFERENCES processes(id)
);
+CREATE TABLE process_disables (
+ process INTEGER NOT NULL,
+ condition INTEGER NOT NULL,
+ PRIMARY KEY(process, condition),
+ FOREIGN KEY (process) REFERENCES processes(id),
+ FOREIGN KEY (condition) REFERENCES conditions(id)
+);
CREATE TABLE process_efforts (
parent INTEGER NOT NULL,
timestamp TEXT NOT NULL,
CREATE TABLE process_efforts (
parent INTEGER NOT NULL,
timestamp TEXT NOT NULL,
@@
-41,7
+48,7
@@
CREATE TABLE process_efforts (
PRIMARY KEY (parent, timestamp),
FOREIGN KEY (parent) REFERENCES processes(id)
);
PRIMARY KEY (parent, timestamp),
FOREIGN KEY (parent) REFERENCES processes(id)
);
-CREATE TABLE process_
fulfill
s (
+CREATE TABLE process_
enable
s (
process INTEGER NOT NULL,
condition INTEGER NOT NULL,
PRIMARY KEY(process, condition),
process INTEGER NOT NULL,
condition INTEGER NOT NULL,
PRIMARY KEY(process, condition),
@@
-64,13
+71,6
@@
CREATE TABLE process_titles (
PRIMARY KEY (parent, timestamp),
FOREIGN KEY (parent) REFERENCES processes(id)
);
PRIMARY KEY (parent, timestamp),
FOREIGN KEY (parent) REFERENCES processes(id)
);
-CREATE TABLE process_undoes (
- process INTEGER NOT NULL,
- condition INTEGER NOT NULL,
- PRIMARY KEY(process, condition),
- FOREIGN KEY (process) REFERENCES processes(id),
- FOREIGN KEY (condition) REFERENCES conditions(id)
-);
CREATE TABLE processes (
id INTEGER PRIMARY KEY
);
CREATE TABLE processes (
id INTEGER PRIMARY KEY
);
@@
-88,14
+88,14
@@
CREATE TABLE todo_conditions (
FOREIGN KEY (todo) REFERENCES todos(id),
FOREIGN KEY (condition) REFERENCES conditions(id)
);
FOREIGN KEY (todo) REFERENCES todos(id),
FOREIGN KEY (condition) REFERENCES conditions(id)
);
-CREATE TABLE todo_
fulfill
s (
+CREATE TABLE todo_
disable
s (
todo INTEGER NOT NULL,
condition INTEGER NOT NULL,
PRIMARY KEY(todo, condition),
FOREIGN KEY (todo) REFERENCES todos(id),
FOREIGN KEY (condition) REFERENCES conditions(id)
);
todo INTEGER NOT NULL,
condition INTEGER NOT NULL,
PRIMARY KEY(todo, condition),
FOREIGN KEY (todo) REFERENCES todos(id),
FOREIGN KEY (condition) REFERENCES conditions(id)
);
-CREATE TABLE todo_
undo
es (
+CREATE TABLE todo_
enabl
es (
todo INTEGER NOT NULL,
condition INTEGER NOT NULL,
PRIMARY KEY(todo, condition),
todo INTEGER NOT NULL,
condition INTEGER NOT NULL,
PRIMARY KEY(todo, condition),