aboutsummaryrefslogtreecommitdiff
path: root/src/main/resources
diff options
context:
space:
mode:
Diffstat (limited to 'src/main/resources')
-rwxr-xr-xsrc/main/resources/ddl-nexus.sql15
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;