aboutsummaryrefslogtreecommitdiff
path: root/src/main/resources
diff options
context:
space:
mode:
authorTrygve Laugstøl <trygvis@inamo.no>2012-12-23 12:00:04 +0100
committerTrygve Laugstøl <trygvis@inamo.no>2012-12-23 12:00:04 +0100
commitafbfd905b8f5326d149ba7fdfd784af50d85e5ee (patch)
tree7ebdb883ce69d697af278780bdf67362ce164c2d /src/main/resources
parenta057cf0cb5b855d1fedd58d702bd06bb22e938f5 (diff)
downloadesper-testing-afbfd905b8f5326d149ba7fdfd784af50d85e5ee.tar.gz
esper-testing-afbfd905b8f5326d149ba7fdfd784af50d85e5ee.tar.bz2
esper-testing-afbfd905b8f5326d149ba7fdfd784af50d85e5ee.tar.xz
esper-testing-afbfd905b8f5326d149ba7fdfd784af50d85e5ee.zip
o Storing the file file reference on the jenkins build and job.
Diffstat (limited to 'src/main/resources')
-rw-r--r--src/main/resources/ddl-jenkins.sql4
1 files changed, 4 insertions, 0 deletions
diff --git a/src/main/resources/ddl-jenkins.sql b/src/main/resources/ddl-jenkins.sql
index 2a57ad6..c75f836 100644
--- a/src/main/resources/ddl-jenkins.sql
+++ b/src/main/resources/ddl-jenkins.sql
@@ -21,12 +21,14 @@ CREATE TABLE jenkins_job (
server CHAR(36) NOT NULL,
+ file CHAR(36) NOT NULL,
url VARCHAR(1000) NOT NULL,
job_type VARCHAR(100) NOT NULL,
display_name VARCHAR(100),
CONSTRAINT pk_jenkins_job PRIMARY KEY (UUID),
CONSTRAINT fk_jenkins_job__server FOREIGN KEY (server) REFERENCES jenkins_server (uuid),
+ CONSTRAINT fk_jenkins_job__file FOREIGN KEY (file) REFERENCES file (uuid),
CONSTRAINT uq_jenkins_job__url UNIQUE (url)
);
@@ -39,6 +41,7 @@ CREATE TABLE jenkins_build (
job CHAR(36) NOT NULL,
+ file CHAR(36) NOT NULL,
entry_id VARCHAR(1000) NOT NULL,
url VARCHAR(1000) NOT NULL,
result VARCHAR(100) NOT NULL,
@@ -49,6 +52,7 @@ CREATE TABLE jenkins_build (
CONSTRAINT pk_jenkins_build PRIMARY KEY (UUID),
CONSTRAINT fk_jenkins_build__job FOREIGN KEY (job) REFERENCES jenkins_job (uuid),
+ CONSTRAINT fk_jenkins_build__file FOREIGN KEY (file) REFERENCES file (uuid),
CONSTRAINT uq_jenkins_build__id UNIQUE (entry_id),
CONSTRAINT uq_jenkins_build__seq UNIQUE (seq)
);