diff options
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 |