diff options
| author | Trygve Laugstøl <trygvis@inamo.no> | 2012-12-06 08:58:12 +0100 |
|---|---|---|
| committer | Trygve Laugstøl <trygvis@inamo.no> | 2012-12-07 20:06:57 +0100 |
| commit | 8ac0faa2b83dde165d45ab62c932ba0f26f42e54 (patch) | |
| tree | 6f5656e783c5bb9de425e718690732ce796b5603 /src/main/resources | |
| parent | 1c2c16858e95db9ae90726fa0da69b88457c1807 (diff) | |
| download | esper-testing-8ac0faa2b83dde165d45ab62c932ba0f26f42e54.tar.gz esper-testing-8ac0faa2b83dde165d45ab62c932ba0f26f42e54.tar.bz2 esper-testing-8ac0faa2b83dde165d45ab62c932ba0f26f42e54.tar.xz esper-testing-8ac0faa2b83dde165d45ab62c932ba0f26f42e54.zip | |
o Adding support for new release events.
Diffstat (limited to 'src/main/resources')
| -rwxr-xr-x | src/main/resources/ddl-nexus.sql | 9 |
1 files changed, 7 insertions, 2 deletions
diff --git a/src/main/resources/ddl-nexus.sql b/src/main/resources/ddl-nexus.sql index 1f7514f..7f84dac 100755 --- a/src/main/resources/ddl-nexus.sql +++ b/src/main/resources/ddl-nexus.sql @@ -38,17 +38,22 @@ CREATE TABLE nexus_event ( uuid CHAR(36) NOT NULL, artifact CHAR(36) NOT NULL, timestamp VARCHAR(100), + +-- From the RSS guid VARCHAR(1000), +-- Our type flag type VARCHAR(100) NOT NULL, -- new snapshot event - snapshot_timestamp VARCHAR(1000), + snapshot_timestamp TIMESTAMP, + build_number INT, file VARCHAR(1000), + who VARCHAR(1000), CONSTRAINT pk_nexus_event PRIMARY KEY (uuid), CONSTRAINT fk_nexus_artifact FOREIGN KEY (artifact) REFERENCES nexus_artifact (uuid), CONSTRAINT uq_guid UNIQUE (guid), - CONSTRAINT check_event_type CHECK (type IN ('new_snapshot')) + 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) ); |