o Adding a sequence number to jenkins_build.

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

1 files changed, 5 insertions, 5 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)
 );