1 files changed, 13 insertions, 2 deletions
diff --git a/src/main/resources/ddl-nexus.sql b/src/main/resources/ddl-nexus.sql
index eaa0938..9ee35e0 100755
--- a/src/main/resources/ddl-nexus.sql
+++ b/src/main/resources/ddl-nexus.sql
@@ -2,12 +2,20 @@ BEGIN;
 
 DROP TABLE IF EXISTS nexus_event;
 DROP TABLE IF EXISTS nexus_repository;
+DROP TABLE IF EXISTS nexus_server;
+
+CREATE TABLE nexus_server (
+  url VARCHAR(1000) PRIMARY KEY
+);
 
 CREATE TABLE nexus_repository (
   id                     VARCHAR(1000) PRIMARY KEY,
-  discovered_date        TIMESTAMP,
+  nexus_server_url       VARCHAR(1000),
+  group_ids              VARCHAR(100) [],
+  created_date           TIMESTAMP,
   last_update            TIMESTAMP,
-  last_successful_update TIMESTAMP
+  last_successful_update TIMESTAMP,
+  CONSTRAINT nexus_server_fk FOREIGN KEY (nexus_server_url) REFERENCES nexus_server (url)
 );
 
 CREATE TABLE nexus_event (
@@ -20,4 +28,7 @@ CREATE TABLE nexus_event (
   CONSTRAINT nexus_repository_fk FOREIGN KEY (repository_id) REFERENCES nexus_repository (id)
 );
 
+INSERT INTO nexus_server(url) VALUES('https://oss.sonatype.org');
+INSERT INTO nexus_repository(id, nexus_server_url, group_ids) VALUES('codehaus', 'https://oss.sonatype.org', ARRAY['io.trygvis', 'org.codehaus.mojo']);
+
 COMMIT;