From 5d56a80555ebe5a419dae3b1b849ffa78449b410 Mon Sep 17 00:00:00 2001 From: Trygve Laugstøl Date: Sat, 8 Dec 2012 00:52:19 +0100 Subject: o Storing Jenkins builds discovered from the feed. --- src/main/resources/ddl-jenkins.sql | 23 ++++++++++++++++++++--- 1 file changed, 20 insertions(+), 3 deletions(-) (limited to 'src/main/resources') diff --git a/src/main/resources/ddl-jenkins.sql b/src/main/resources/ddl-jenkins.sql index 0c669e8..00af6ee 100755 --- a/src/main/resources/ddl-jenkins.sql +++ b/src/main/resources/ddl-jenkins.sql @@ -1,15 +1,32 @@ BEGIN; +DROP TABLE IF EXISTS jenkins_build; DROP TABLE IF EXISTS jenkins_server; CREATE TABLE jenkins_server ( - uuid CHAR(36) NOT NULL, - url VARCHAR(1000) NOT NULL, + uuid CHAR(36) NOT NULL, + created_date TIMESTAMP NOT NULL, + url VARCHAR(1000) NOT NULL, CONSTRAINT pk_jenkins_server PRIMARY KEY (uuid), CONSTRAINT uq_jenkins_server__url UNIQUE (url) ); +CREATE TABLE jenkins_build ( + uuid CHAR(36) NOT NULL, + created_date TIMESTAMP 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, + + CONSTRAINT pk_jenkins_build PRIMARY KEY (UUID), + CONSTRAINT uq_jenkins_build__id UNIQUE (entry_id) +); + -- 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'); +INSERT INTO jenkins_server (uuid, created_date, url) VALUES ('4c473c86-40ad-11e2-ae61-20cf30557fa0', current_timestamp, 'http://ci.jruby.org'); COMMIT; -- cgit v1.2.3