From a63ec924e5440b17434ecc91e84d1419ae39ef2a Mon Sep 17 00:00:00 2001 From: Trygve Laugstøl Date: Fri, 21 Dec 2012 22:24:41 +0100 Subject: o Adding a sequence number to jenkins_build. o Making the table poller poll based on a sequence number instead. --- src/main/resources/ddl-core.sql | 10 +++++----- src/main/resources/ddl-jenkins.sql | 7 ++++++- 2 files changed, 11 insertions(+), 6 deletions(-) (limited to 'src/main/resources') diff --git a/src/main/resources/ddl-core.sql b/src/main/resources/ddl-core.sql index 25f373b..9dcdd09 100644 --- a/src/main/resources/ddl-core.sql +++ b/src/main/resources/ddl-core.sql @@ -9,11 +9,11 @@ DROP TABLE IF EXISTS person; DROP TABLE IF EXISTS table_poller_status; CREATE TABLE table_poller_status ( - poller_name VARCHAR(100) NOT NULL, - last_created_date TIMESTAMP, - last_run TIMESTAMP, - duration INT, - status VARCHAR(1000), + poller_name VARCHAR(100) NOT NULL, + last_seq INT NOT NULL, + last_run TIMESTAMP, + duration INT, + status VARCHAR(1000), CONSTRAINT pk_job_status PRIMARY KEY (poller_name) ); diff --git a/src/main/resources/ddl-jenkins.sql b/src/main/resources/ddl-jenkins.sql index bdda74b..94bfc4e 100644 --- a/src/main/resources/ddl-jenkins.sql +++ b/src/main/resources/ddl-jenkins.sql @@ -7,8 +7,10 @@ DROP TABLE IF EXISTS jenkins_server; CREATE TABLE jenkins_server ( uuid CHAR(36) NOT NULL, created_date TIMESTAMP NOT NULL, + url VARCHAR(1000) NOT NULL, enabled BOOLEAN NOT NULL, + CONSTRAINT pk_jenkins_server PRIMARY KEY (uuid), CONSTRAINT uq_jenkins_server__url UNIQUE (url) ); @@ -31,6 +33,7 @@ CREATE TABLE jenkins_job ( CREATE TABLE jenkins_build ( uuid CHAR(36) NOT NULL, created_date TIMESTAMP NOT NULL, + seq INT NOT NULL DEFAULT nextval('jenkins_build_seq'), job CHAR(36) NOT NULL, @@ -44,7 +47,8 @@ CREATE TABLE jenkins_build ( CONSTRAINT pk_jenkins_build PRIMARY KEY (UUID), CONSTRAINT fk_jenkins_build__job FOREIGN KEY (job) REFERENCES jenkins_job (uuid), - CONSTRAINT uq_jenkins_build__id UNIQUE (entry_id) + CONSTRAINT uq_jenkins_build__id UNIQUE (entry_id), + CONSTRAINT uq_jenkins_build__seq UNIQUE (seq) ); CREATE INDEX ix_jenkins_build__created_date ON jenkins_build (created_date); @@ -52,6 +56,7 @@ CREATE INDEX ix_jenkins_build__created_date ON jenkins_build (created_date); CREATE TABLE jenkins_user ( uuid CHAR(36) NOT NULL, created_date TIMESTAMP NOT NULL, + server CHAR(36) NOT NULL, absolute_url VARCHAR(1000) NOT NULL, CONSTRAINT pk_jenkins_user PRIMARY KEY (uuid), -- cgit v1.2.3