diff options
Diffstat (limited to 'src/main/resources/ddl-nexus.sql')
-rwxr-xr-x | src/main/resources/ddl-nexus.sql | 23 |
1 files changed, 23 insertions, 0 deletions
diff --git a/src/main/resources/ddl-nexus.sql b/src/main/resources/ddl-nexus.sql new file mode 100755 index 0000000..eaa0938 --- /dev/null +++ b/src/main/resources/ddl-nexus.sql @@ -0,0 +1,23 @@ +BEGIN; + +DROP TABLE IF EXISTS nexus_event; +DROP TABLE IF EXISTS nexus_repository; + +CREATE TABLE nexus_repository ( + id VARCHAR(1000) PRIMARY KEY, + discovered_date TIMESTAMP, + last_update TIMESTAMP, + last_successful_update TIMESTAMP +); + +CREATE TABLE nexus_event ( + repository_id VARCHAR(1000) NOT NULL, + + groupId VARCHAR(100), + artifactId VARCHAR(100), + version VARCHAR(100), + files VARCHAR(100), + CONSTRAINT nexus_repository_fk FOREIGN KEY (repository_id) REFERENCES nexus_repository (id) +); + +COMMIT; |