aboutsummaryrefslogtreecommitdiff
path: root/src/main/resources
diff options
context:
space:
mode:
authorTrygve Laugstøl <trygvis@inamo.no>2013-05-26 10:42:01 +0200
committerTrygve Laugstøl <trygvis@inamo.no>2013-05-26 10:42:01 +0200
commitb65d39ab617d19ac48f44bc41f04a18803ca75e6 (patch)
treec93ed68851b56f64a33508108cdb432bf507fa11 /src/main/resources
parent74a3da1853eeb2e853d17d8d8527404248b209d3 (diff)
downloadquartz-based-queue-b65d39ab617d19ac48f44bc41f04a18803ca75e6.tar.gz
quartz-based-queue-b65d39ab617d19ac48f44bc41f04a18803ca75e6.tar.bz2
quartz-based-queue-b65d39ab617d19ac48f44bc41f04a18803ca75e6.tar.xz
quartz-based-queue-b65d39ab617d19ac48f44bc41f04a18803ca75e6.zip
o Adding a 'parent' reference so tasks can be put in a tree.
Diffstat (limited to 'src/main/resources')
-rw-r--r--src/main/resources/create.sql6
1 files changed, 4 insertions, 2 deletions
diff --git a/src/main/resources/create.sql b/src/main/resources/create.sql
index ed8913f..f7f2939 100644
--- a/src/main/resources/create.sql
+++ b/src/main/resources/create.sql
@@ -11,7 +11,8 @@ CREATE TABLE queue (
);
CREATE TABLE task (
- id INTEGER NOT NULL,
+ id BIGINT NOT NULL,
+ parent BIGINT NOT NULL,
queue VARCHAR(100) NOT NULL,
scheduled TIMESTAMP NOT NULL,
last_run TIMESTAMP,
@@ -19,7 +20,8 @@ CREATE TABLE task (
completed TIMESTAMP,
arguments VARCHAR(100),
CONSTRAINT pk_task PRIMARY KEY (id),
- CONSTRAINT fk_task__queue FOREIGN KEY (queue) REFERENCES queue (name)
+ CONSTRAINT fk_task__queue FOREIGN KEY (queue) REFERENCES queue (name),
+ CONSTRAINT fk_task__parent FOREIGN KEY (parent) REFERENCES task (id)
);
CREATE SEQUENCE task_id;