summaryrefslogtreecommitdiffstats
path: root/migrations/2020-12-03-085333_artifact_belongs_to_job/up.sql
diff options
context:
space:
mode:
authorMatthias Beyer <mail@beyermatthias.de>2020-12-03 09:55:29 +0100
committerMatthias Beyer <mail@beyermatthias.de>2020-12-03 09:55:29 +0100
commit0f6b4a32ccf5d88debbfa4a7d7feaea8ca0969bc (patch)
treeab90f6f0314acfe2d95825567a186e770ce332f4 /migrations/2020-12-03-085333_artifact_belongs_to_job/up.sql
parentd7667a7aab2ffae5934292b16167f66a80bb9439 (diff)
An Artifact belongs to a job
Signed-off-by: Matthias Beyer <mail@beyermatthias.de>
Diffstat (limited to 'migrations/2020-12-03-085333_artifact_belongs_to_job/up.sql')
-rw-r--r--migrations/2020-12-03-085333_artifact_belongs_to_job/up.sql5
1 files changed, 5 insertions, 0 deletions
diff --git a/migrations/2020-12-03-085333_artifact_belongs_to_job/up.sql b/migrations/2020-12-03-085333_artifact_belongs_to_job/up.sql
new file mode 100644
index 0000000..c838962
--- /dev/null
+++ b/migrations/2020-12-03-085333_artifact_belongs_to_job/up.sql
@@ -0,0 +1,5 @@
+-- Your SQL goes here
+ALTER TABLE
+ artifacts
+ADD COLUMN
+ job_id INTEGER REFERENCES jobs(id) NOT NULL