From 18726624965b6d00faf816e5acb9fa7f5a124f04 Mon Sep 17 00:00:00 2001 From: Trygve Laugstøl 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