aboutsummaryrefslogtreecommitdiff
path: root/src/main/resources
diff options
context:
space:
mode:
authorTrygve Laugstøl <trygvis@inamo.no>2012-11-20 20:02:47 +0100
committerTrygve Laugstøl <trygvis@inamo.no>2012-11-20 20:02:47 +0100
commitcac8228f38136cfc41673458c58c25f168b1e1ff (patch)
tree34f482cfd506a3b217f9f62fc00719b7f36e4a9e /src/main/resources
parent8596b9b566745ca65b3a75fe8b6d4c091369fedc (diff)
downloadesper-testing-cac8228f38136cfc41673458c58c25f168b1e1ff.tar.gz
esper-testing-cac8228f38136cfc41673458c58c25f168b1e1ff.tar.bz2
esper-testing-cac8228f38136cfc41673458c58c25f168b1e1ff.tar.xz
esper-testing-cac8228f38136cfc41673458c58c25f168b1e1ff.zip
o Adding BoneCP init to Config.
o Starting on an actor-like structure for the running jobs. o Loading Nexus servers and group ids to look for from the database.
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;