From 18726624965b6d00faf816e5acb9fa7f5a124f04 Mon Sep 17 00:00:00 2001
From: Trygve Laugstøl <trygvis@inamo.no>
Date: Sun, 6 Jan 2013 00:21:29 +0100
Subject: o Moving data out of DDL files. o Making sure the dbdeltas work.

---
 src/main/sql/base-schema/ddl-jenkins.sql | 14 ++++----------
 1 file changed, 4 insertions(+), 10 deletions(-)

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

diff --git a/src/main/sql/base-schema/ddl-jenkins.sql b/src/main/sql/base-schema/ddl-jenkins.sql
index 3e420a2..6e28c85 100755
--- a/src/main/sql/base-schema/ddl-jenkins.sql
+++ b/src/main/sql/base-schema/ddl-jenkins.sql
@@ -44,10 +44,10 @@ CREATE TABLE jenkins_build (
   file         CHAR(36)      NOT NULL,
   entry_id     VARCHAR(1000) NOT NULL,
   url          VARCHAR(1000) NOT NULL,
---   result       VARCHAR(100)  NOT NULL,
---   number       INT           NOT NULL,
---   duration     INT           NOT NULL,
---   timestamp    TIMESTAMP     NOT NULL,
+  result       VARCHAR(100)  NOT NULL,
+  number       INT           NOT NULL,
+  duration     INT           NOT NULL,
+  timestamp    TIMESTAMP     NOT NULL,
   users        CHAR(36) [],
 
   CONSTRAINT pk_jenkins_build PRIMARY KEY (UUID),
@@ -70,10 +70,4 @@ CREATE TABLE jenkins_user (
   CONSTRAINT uq_jenkins_user__absolute_url UNIQUE (absolute_url)
 );
 
-INSERT INTO jenkins_server (uuid, created_date, url, enabled) VALUES
-('782a75f6-40a4-11e2-aca6-20cf30557fa0', CURRENT_TIMESTAMP, 'https://builds.apache.org', FALSE),
-('4c473c86-40ad-11e2-ae61-20cf30557fa0', CURRENT_TIMESTAMP, 'http://ci.jruby.org', FALSE),
-('518c6162-411b-11e2-b63c-20cf30557fa0', CURRENT_TIMESTAMP, 'http://www.simantics.org/jenkins', FALSE),
-('3c1a1448-422c-11e2-a7b3-20cf30557fa0', CURRENT_TIMESTAMP, 'https://jenkins.puppetlabs.com', FALSE);
-
 COMMIT;
-- 
cgit v1.2.3

