From fce88c72b4a549d60010b7b3ccab6a058a617ccc Mon Sep 17 00:00:00 2001
From: Trygve Laugstøl <trygvis@inamo.no>
Date: Fri, 7 Dec 2012 21:35:34 +0100
Subject: o Better Jenkins importer.

---
 src/main/resources/ddl-jenkins.sql | 10 ++++++++--
 1 file changed, 8 insertions(+), 2 deletions(-)

(limited to 'src/main/resources/ddl-jenkins.sql')

diff --git a/src/main/resources/ddl-jenkins.sql b/src/main/resources/ddl-jenkins.sql
index 37e82c1..0c669e8 100755
--- a/src/main/resources/ddl-jenkins.sql
+++ b/src/main/resources/ddl-jenkins.sql
@@ -2,8 +2,14 @@ BEGIN;
 
 DROP TABLE IF EXISTS jenkins_server;
 
-CREATE TABLE jenkins_server(
-    url VARCHAR(1000) NOT NULL PRIMARY KEY
+CREATE TABLE jenkins_server (
+  uuid CHAR(36)      NOT NULL,
+  url  VARCHAR(1000) NOT NULL,
+  CONSTRAINT pk_jenkins_server PRIMARY KEY (uuid),
+  CONSTRAINT uq_jenkins_server__url UNIQUE (url)
 );
 
+-- INSERT INTO jenkins_server (uuid, url) VALUES ('782a75f6-40a4-11e2-aca6-20cf30557fa0', 'https://builds.apache.org');
+INSERT INTO jenkins_server (uuid, url) VALUES ('4c473c86-40ad-11e2-ae61-20cf30557fa0', 'http://ci.jruby.org');
+
 COMMIT;
-- 
cgit v1.2.3

