diff options
Diffstat (limited to 'src/main/resources/create.sql')
-rw-r--r-- | src/main/resources/create.sql | 29 |
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; |