diff options
author | Trygve Laugstøl <trygvis@inamo.no> | 2013-01-05 17:24:07 +0100 |
---|---|---|
committer | Trygve Laugstøl <trygvis@inamo.no> | 2013-01-05 17:24:07 +0100 |
commit | 24036ef94687300e98c742cfc268a2b5e9e87a88 (patch) | |
tree | fb6be2434919717b18234c0820d39d174c02a969 /src/main/sql/base-schema/ddl-nexus.sql | |
parent | 7880fd60bb6ba5237d269a1b840a412c4438dd39 (diff) | |
download | esper-testing-24036ef94687300e98c742cfc268a2b5e9e87a88.tar.gz esper-testing-24036ef94687300e98c742cfc268a2b5e9e87a88.tar.bz2 esper-testing-24036ef94687300e98c742cfc268a2b5e9e87a88.tar.xz esper-testing-24036ef94687300e98c742cfc268a2b5e9e87a88.zip |
o Trying out dbdeploy.
Diffstat (limited to 'src/main/sql/base-schema/ddl-nexus.sql')
-rw-r--r-- | src/main/sql/base-schema/ddl-nexus.sql | 67 |
1 files changed, 67 insertions, 0 deletions
diff --git a/src/main/sql/base-schema/ddl-nexus.sql b/src/main/sql/base-schema/ddl-nexus.sql new file mode 100644 index 0000000..8acf741 --- /dev/null +++ b/src/main/sql/base-schema/ddl-nexus.sql @@ -0,0 +1,67 @@ +BEGIN; + +DROP TABLE IF EXISTS nexus_event; +DROP TABLE IF EXISTS nexus_artifact; +DROP TABLE IF EXISTS nexus_repository; +DROP TABLE IF EXISTS nexus_server; + +CREATE TABLE nexus_server ( + uuid CHAR(36) NOT NULL, + url VARCHAR(1000) NOT NULL, + name VARCHAR(1000) NOT NULL, + CONSTRAINT pk_nexus_server PRIMARY KEY (uuid), + CONSTRAINT uq_nexus_server_url UNIQUE (url) +); + +CREATE TABLE nexus_repository ( + uuid CHAR(36) NOT NULL, + server CHAR(36) NOT NULL, + id VARCHAR(100), + group_ids VARCHAR(100) [], + CONSTRAINT pk_nexus_repository PRIMARY KEY (uuid), + 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 ( + uuid CHAR(36) NOT NULL, + repository CHAR(36) NOT NULL, + group_id VARCHAR(100) NOT NULL, + 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_artifact__nexus_repository FOREIGN KEY (repository) REFERENCES nexus_repository (uuid) +); + +CREATE TABLE nexus_event ( + uuid CHAR(36) NOT NULL, + artifact CHAR(36) NOT NULL, + created TIMESTAMP NOT NULL, + +-- From the RSS + guid VARCHAR(1000) NOT NULL, + date TIMESTAMP NOT NULL, + +-- Our type flag + type VARCHAR(100) NOT NULL, + +-- new snapshot event + snapshot_timestamp VARCHAR(100), + build_number INT, + file VARCHAR(1000), + who VARCHAR(1000), + CONSTRAINT pk_nexus_event PRIMARY KEY (uuid), + 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) +); + +INSERT INTO nexus_server (uuid, url, name) VALUES ('4666dba4-3e2e-11e2-8a1b-0bd430e00b36', 'https://oss.sonatype.org', 'Central Repository'); +INSERT INTO nexus_repository (uuid, server, id, group_ids) VALUES ('4a2d7ab2-3e2f-11e2-af03-eb1ace2381bb', '4666dba4-3e2e-11e2-8a1b-0bd430e00b36', 'releases', ARRAY ['io.trygvis', 'no.arktekk', 'org.codehaus']); + +INSERT INTO nexus_server (uuid, url, name) VALUES ('91d942d8-3e2f-11e2-aaa0-a70628365abd', 'http://nexus.codehaus.org', 'Codehaus Snapshots'); +INSERT INTO nexus_repository (uuid, server, id, group_ids) VALUES ('a2415b88-3e2f-11e2-a2b8-2f066b90cf13', '91d942d8-3e2f-11e2-aaa0-a70628365abd', 'snapshots', ARRAY ['org.codehaus.mojo']); + +COMMIT; |