o Adding a sequence number to jenkins_build.

o Making the table poller poll based on a sequence number instead.

2 files changed, 11 insertions, 6 deletions

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),