diff options
| author | Trygve Laugstøl <trygvis@inamo.no> | 2012-12-07 21:35:34 +0100 |
|---|---|---|
| committer | Trygve Laugstøl <trygvis@inamo.no> | 2012-12-07 21:35:34 +0100 |
| commit | fce88c72b4a549d60010b7b3ccab6a058a617ccc (patch) | |
| tree | 7676a4ad2e4689f5188aea4a3d393b4a5b9c8c90 /src/main/resources | |
| parent | 1ad9401c3f0c9ebc63546fb9e6905110a474a9dd (diff) | |
| download | esper-testing-fce88c72b4a549d60010b7b3ccab6a058a617ccc.tar.gz esper-testing-fce88c72b4a549d60010b7b3ccab6a058a617ccc.tar.bz2 esper-testing-fce88c72b4a549d60010b7b3ccab6a058a617ccc.tar.xz esper-testing-fce88c72b4a549d60010b7b3ccab6a058a617ccc.zip | |
o Better Jenkins importer.
Diffstat (limited to 'src/main/resources')
| -rwxr-xr-x | src/main/resources/ddl-jenkins.sql | 10 |
1 files changed, 8 insertions, 2 deletions
diff --git a/src/main/resources/ddl-jenkins.sql b/src/main/resources/ddl-jenkins.sql index 37e82c1..0c669e8 100755 --- a/src/main/resources/ddl-jenkins.sql +++ b/src/main/resources/ddl-jenkins.sql @@ -2,8 +2,14 @@ BEGIN; DROP TABLE IF EXISTS jenkins_server; -CREATE TABLE jenkins_server( - url VARCHAR(1000) NOT NULL PRIMARY KEY +CREATE TABLE jenkins_server ( + uuid CHAR(36) NOT NULL, + url VARCHAR(1000) NOT NULL, + CONSTRAINT pk_jenkins_server PRIMARY KEY (uuid), + CONSTRAINT uq_jenkins_server__url UNIQUE (url) ); +-- INSERT INTO jenkins_server (uuid, url) VALUES ('782a75f6-40a4-11e2-aca6-20cf30557fa0', 'https://builds.apache.org'); +INSERT INTO jenkins_server (uuid, url) VALUES ('4c473c86-40ad-11e2-ae61-20cf30557fa0', 'http://ci.jruby.org'); + COMMIT; |