diff options
Diffstat (limited to 'migrations/2021-02-15-094104_rm-job-output-artefacts/down.sql')
-rw-r--r-- | migrations/2021-02-15-094104_rm-job-output-artefacts/down.sql | 1 |
1 files changed, 1 insertions, 0 deletions
diff --git a/migrations/2021-02-15-094104_rm-job-output-artefacts/down.sql b/migrations/2021-02-15-094104_rm-job-output-artefacts/down.sql new file mode 100644 index 0000000..21c47b8 --- /dev/null +++ b/migrations/2021-02-15-094104_rm-job-output-artefacts/down.sql @@ -0,0 +1 @@ +-- This file should undo anything in `up.sql`
CREATE TABLE job_output_artifacts (
id SERIAL PRIMARY KEY NOT NULL,
job_id INTEGER REFERENCES jobs(id) NOT NULL,
artifact_id INTEGER REFERENCES artifacts(id) NOT NULL,
CONSTRAINT UC_jobid_output_artifactid UNIQUE (job_id, artifact_id)
)
\ No newline at end of file |