From 52084f7b4e6f50c90b3255cdf2eb9deab560c970 Mon Sep 17 00:00:00 2001
From: Trygve Laugstøl <trygvis@inamo.no>
Date: Sun, 2 Jun 2013 12:32:29 +0200
Subject: o Making some test cases.

---
 src/main/resources/create.sql | 29 -----------------------------
 1 file changed, 29 deletions(-)
 delete mode 100644 src/main/resources/create.sql

(limited to 'src/main/resources/create.sql')

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;
-- 
cgit v1.2.3

