From 58e2f4c4ef4655c88270b2c3a6b53ef642f82c57 Mon Sep 17 00:00:00 2001
From: Trygve Laugstøl <trygvis@inamo.no>
Date: Sat, 8 Dec 2012 11:36:31 +0100
Subject: o Closing the HTTP streams so we don't run out of connections. o
 Attaching the build to a server.

---
 src/main/resources/ddl-jenkins.sql  | 3 +++
 src/main/resources/logback-test.xml | 2 +-
 2 files changed, 4 insertions(+), 1 deletion(-)

(limited to 'src/main/resources')

diff --git a/src/main/resources/ddl-jenkins.sql b/src/main/resources/ddl-jenkins.sql
index c34e8cb..df98185 100755
--- a/src/main/resources/ddl-jenkins.sql
+++ b/src/main/resources/ddl-jenkins.sql
@@ -16,6 +16,8 @@ CREATE TABLE jenkins_build (
   uuid         CHAR(36)      NOT NULL,
   created_date TIMESTAMP     NOT NULL,
 
+  server       CHAR(36)      NOT NULL,
+
   entry_id     VARCHAR(1000) NOT NULL,
   url          VARCHAR(1000) NOT NULL,
   result       VARCHAR(100)  NOT NULL,
@@ -24,6 +26,7 @@ CREATE TABLE jenkins_build (
   timestamp    TIMESTAMP     NOT NULL,
 
   CONSTRAINT pk_jenkins_build PRIMARY KEY (UUID),
+  CONSTRAINT fk_jenkins_build__server FOREIGN KEY (server) REFERENCES jenkins_server (uuid),
   CONSTRAINT uq_jenkins_build__id UNIQUE (entry_id)
 );
 
diff --git a/src/main/resources/logback-test.xml b/src/main/resources/logback-test.xml
index b972562..49aa8bc 100755
--- a/src/main/resources/logback-test.xml
+++ b/src/main/resources/logback-test.xml
@@ -12,7 +12,7 @@
   <!-- Gitorious spews out a few invalid cookies -->
   <logger name="org.apache.http.client.protocol.ResponseProcessCookies" level="ERROR"/>
 
-  <root level="DEBUG">
+  <root>
     <appender-ref ref="STDOUT"/>
   </root>
 </configuration>
-- 
cgit v1.2.3