From 0f6b4a32ccf5d88debbfa4a7d7feaea8ca0969bc Mon Sep 17 00:00:00 2001 From: Matthias Beyer Date: Thu, 3 Dec 2020 09:55:29 +0100 Subject: An Artifact belongs to a job Signed-off-by: Matthias Beyer --- migrations/2020-12-03-085333_artifact_belongs_to_job/down.sql | 5 +++++ migrations/2020-12-03-085333_artifact_belongs_to_job/up.sql | 5 +++++ 2 files changed, 10 insertions(+) create mode 100644 migrations/2020-12-03-085333_artifact_belongs_to_job/down.sql create mode 100644 migrations/2020-12-03-085333_artifact_belongs_to_job/up.sql (limited to 'migrations/2020-12-03-085333_artifact_belongs_to_job') diff --git a/migrations/2020-12-03-085333_artifact_belongs_to_job/down.sql b/migrations/2020-12-03-085333_artifact_belongs_to_job/down.sql new file mode 100644 index 0000000..3a56084 --- /dev/null +++ b/migrations/2020-12-03-085333_artifact_belongs_to_job/down.sql @@ -0,0 +1,5 @@ +-- This file should undo anything in `up.sql` +ALTER TABLE + artifacts +DROP COLUMN + job_id 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 -- cgit v1.2.3