o Sucking in all new events. Stops as soon as it has fetched an entire page with only old events.

1 files changed, 13 insertions, 12 deletions

diff --git a/src/main/resources/ddl-nexus.sql b/src/main/resources/ddl-nexus.sql
index 7f84dac..8acf741 100755
--- a/src/main/resources/ddl-nexus.sql
+++ b/src/main/resources/ddl-nexus.sql
@@ -19,8 +19,8 @@ CREATE TABLE nexus_repository (
   id        VARCHAR(100),
   group_ids VARCHAR(100) [],
   CONSTRAINT pk_nexus_repository PRIMARY KEY (uuid),
-  CONSTRAINT fk_nexus_server FOREIGN KEY (server) REFERENCES nexus_server (uuid),
-  CONSTRAINT uq_nexus_repository_id UNIQUE (server, id)
+  CONSTRAINT fk_nexus_repository__nexus_server FOREIGN KEY (server) REFERENCES nexus_server (uuid),
+  CONSTRAINT uq_nexus_repository__id UNIQUE (server, id)
 );
 
 CREATE TABLE nexus_artifact (
@@ -30,29 +30,30 @@ CREATE TABLE nexus_artifact (
   artifact_id VARCHAR(100) NOT NULL,
   version     VARCHAR(100) NOT NULL,
   CONSTRAINT pk_nexus_artifact PRIMARY KEY (uuid),
-  CONSTRAINT uq_nexus_artifact_gid_aid_version UNIQUE (group_id, artifact_id, version),
-  CONSTRAINT fk_nexus_repository FOREIGN KEY (repository) REFERENCES nexus_repository (uuid)
+  CONSTRAINT uq_nexus_artifact__gid__aid__version UNIQUE (group_id, artifact_id, version),
+  CONSTRAINT fk_nexus_artifact__nexus_repository FOREIGN KEY (repository) REFERENCES nexus_repository (uuid)
 );
 
 CREATE TABLE nexus_event (
-  uuid               CHAR(36)     NOT NULL,
-  artifact           CHAR(36)     NOT NULL,
-  timestamp          VARCHAR(100),
+  uuid               CHAR(36)      NOT NULL,
+  artifact           CHAR(36)      NOT NULL,
+  created            TIMESTAMP     NOT NULL,
 
 -- From the RSS
-  guid               VARCHAR(1000),
+  guid               VARCHAR(1000) NOT NULL,
+  date               TIMESTAMP     NOT NULL,
 
 -- Our type flag
-  type               VARCHAR(100) NOT NULL,
+  type               VARCHAR(100)  NOT NULL,
 
 -- new snapshot event
-  snapshot_timestamp TIMESTAMP,
+  snapshot_timestamp VARCHAR(100),
   build_number       INT,
   file               VARCHAR(1000),
   who                VARCHAR(1000),
   CONSTRAINT pk_nexus_event PRIMARY KEY (uuid),
-  CONSTRAINT fk_nexus_artifact FOREIGN KEY (artifact) REFERENCES nexus_artifact (uuid),
-  CONSTRAINT uq_guid UNIQUE (guid),
+  CONSTRAINT fk_nexus_event__artifact FOREIGN KEY (artifact) REFERENCES nexus_artifact (uuid),
+  CONSTRAINT uq_nexus_event__guid UNIQUE (guid),
   CONSTRAINT check_event_type CHECK (type IN ('new_snapshot', 'new_release'))
 --   CONSTRAINT pk_nexus_event PRIMARY KEY (timestamp, server_url, repository_id, group_id, artifact_id, version)
 );