diff options
| author | Matthias Beyer <matthias.beyer@atos.net> | 2021-02-15 10:41:50 +0100 |
|---|---|---|
| committer | Matthias Beyer <matthias.beyer@atos.net> | 2021-03-10 12:09:35 +0100 |
| commit | b95c3f21a2a9406d45a0e421a11f6425291f1182 (patch) | |
| tree | ab7619a94f4b320196b04653af87134aef7683eb /migrations | |
| parent | fd05d457f8c89a6da8ca241a972254c02a150fe7 (diff) | |
Remove job input/output artifacts tables
These tables were not used at all, but still existed.
Remove them.
Signed-off-by: Matthias Beyer <matthias.beyer@atos.net>
Diffstat (limited to 'migrations')
4 files changed, 4 insertions, 0 deletions
diff --git a/migrations/2021-02-15-093619_rm-job-input-artefacts/down.sql b/migrations/2021-02-15-093619_rm-job-input-artefacts/down.sql new file mode 100644 index 0000000..fbe4a24 --- /dev/null +++ b/migrations/2021-02-15-093619_rm-job-input-artefacts/down.sql @@ -0,0 +1 @@ +-- This file should undo anything in `up.sql`
CREATE TABLE job_input_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_artifactid UNIQUE (job_id, artifact_id)
)
\ No newline at end of file diff --git a/migrations/2021-02-15-093619_rm-job-input-artefacts/up.sql b/migrations/2021-02-15-093619_rm-job-input-artefacts/up.sql new file mode 100644 index 0000000..c5b00c0 --- /dev/null +++ b/migrations/2021-02-15-093619_rm-job-input-artefacts/up.sql @@ -0,0 +1 @@ +-- Your SQL goes here
DROP TABLE job_input_artifacts
\ No newline at end of file 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 diff --git a/migrations/2021-02-15-094104_rm-job-output-artefacts/up.sql b/migrations/2021-02-15-094104_rm-job-output-artefacts/up.sql new file mode 100644 index 0000000..15deeef --- /dev/null +++ b/migrations/2021-02-15-094104_rm-job-output-artefacts/up.sql @@ -0,0 +1 @@ +-- Your SQL goes here
DROP TABLE job_output_artifacts
\ No newline at end of file |