summaryrefslogtreecommitdiffstats
path: root/migrations/2020-12-14-113756_artifact_not_unique_by_path/down.sql
diff options
context:
space:
mode:
Diffstat (limited to 'migrations/2020-12-14-113756_artifact_not_unique_by_path/down.sql')
-rw-r--r--migrations/2020-12-14-113756_artifact_not_unique_by_path/down.sql7
1 files changed, 7 insertions, 0 deletions
diff --git a/migrations/2020-12-14-113756_artifact_not_unique_by_path/down.sql b/migrations/2020-12-14-113756_artifact_not_unique_by_path/down.sql
new file mode 100644
index 0000000..c8bfe9d
--- /dev/null
+++ b/migrations/2020-12-14-113756_artifact_not_unique_by_path/down.sql
@@ -0,0 +1,7 @@
+-- This file should undo anything in `up.sql`
+ALTER TABLE
+ artifacts
+ADD CONSTRAINT
+ artifacts_path_key -- as generated by default for postgresql
+ UNIQUE (path)
+