aboutsummaryrefslogtreecommitdiff
path: root/src/main/resources/create.sql
diff options
context:
space:
mode:
authorTrygve Laugstøl <trygvis@inamo.no>2013-06-02 12:32:29 +0200
committerTrygve Laugstøl <trygvis@inamo.no>2013-06-02 12:32:29 +0200
commit52084f7b4e6f50c90b3255cdf2eb9deab560c970 (patch)
treeeed9abd7fe9825aaacfd4fe24c8fd363cc41fed1 /src/main/resources/create.sql
parent7d704feb86c44fca57941d223e8605b55fcf68f0 (diff)
downloadquartz-based-queue-52084f7b4e6f50c90b3255cdf2eb9deab560c970.tar.gz
quartz-based-queue-52084f7b4e6f50c90b3255cdf2eb9deab560c970.tar.bz2
quartz-based-queue-52084f7b4e6f50c90b3255cdf2eb9deab560c970.tar.xz
quartz-based-queue-52084f7b4e6f50c90b3255cdf2eb9deab560c970.zip
o Making some test cases.
Diffstat (limited to 'src/main/resources/create.sql')
-rw-r--r--src/main/resources/create.sql29
1 files changed, 0 insertions, 29 deletions
diff --git a/src/main/resources/create.sql b/src/main/resources/create.sql
deleted file mode 100644
index f7f2939..0000000
--- a/src/main/resources/create.sql
+++ /dev/null
@@ -1,29 +0,0 @@
-BEGIN;
-
-DROP TABLE IF EXISTS task;
-DROP TABLE IF EXISTS queue;
-DROP SEQUENCE IF EXISTS task_id;
-
-CREATE TABLE queue (
- name VARCHAR(100) NOT NULL,
- interval INTEGER NOT NULL,
- CONSTRAINT pk_queue PRIMARY KEY (name)
-);
-
-CREATE TABLE task (
- id BIGINT NOT NULL,
- parent BIGINT NOT NULL,
- queue VARCHAR(100) NOT NULL,
- scheduled TIMESTAMP NOT NULL,
- last_run TIMESTAMP,
- run_count INT NOT NULL,
- completed TIMESTAMP,
- arguments VARCHAR(100),
- CONSTRAINT pk_task PRIMARY KEY (id),
- CONSTRAINT fk_task__queue FOREIGN KEY (queue) REFERENCES queue (name),
- CONSTRAINT fk_task__parent FOREIGN KEY (parent) REFERENCES task (id)
-);
-
-CREATE SEQUENCE task_id;
-
-COMMIT;