From 637dddf11f5d60b35c9696914e1e2658b2ddc611 Mon Sep 17 00:00:00 2001
From: Trygve Laugstøl <trygvis@inamo.no>
Date: Sat, 20 Apr 2013 15:43:01 +0200
Subject: wip

---
 src/main/resources/create.sql  | 27 +++++++++++++++++++++++++++
 src/main/resources/logback.xml |  3 ++-
 2 files changed, 29 insertions(+), 1 deletion(-)
 create mode 100644 src/main/resources/create.sql

(limited to 'src/main/resources')

diff --git a/src/main/resources/create.sql b/src/main/resources/create.sql
new file mode 100644
index 0000000..ed8913f
--- /dev/null
+++ b/src/main/resources/create.sql
@@ -0,0 +1,27 @@
+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        INTEGER      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)
+);
+
+CREATE SEQUENCE task_id;
+
+COMMIT;
diff --git a/src/main/resources/logback.xml b/src/main/resources/logback.xml
index 39e3dbd..a25644b 100755
--- a/src/main/resources/logback.xml
+++ b/src/main/resources/logback.xml
@@ -5,6 +5,7 @@
   <logger name="org.springframework" level="INFO"/>
   <logger name="org.springframework.jdbc" level="INFO"/>
   <logger name="org.springframework.orm" level="INFO"/>
+  <logger name="org.springframework.transaction" level="DEBUG"/>
 
   <logger name="org.hibernate" level="INFO"/>
   <logger name="org.hibernate.SQL" level="INFO"/>
@@ -13,7 +14,7 @@
 
   <appender name="STDOUT" class="ch.qos.logback.core.ConsoleAppender">
     <encoder>
-      <pattern>%d{HH:mm:ss.SSS} [%thread] %-5level %logger{36} - %msg%n</pattern>
+      <pattern>%d{HH:mm:ss.SSS} [%-15thread] %-5level %-50logger{36} - %msg%n</pattern>
     </encoder>
   </appender>
 
-- 
cgit v1.2.3