aboutsummaryrefslogtreecommitdiffstats
path: root/db/downgrade_0064---0063.sql
diff options
context:
space:
mode:
Diffstat (limited to 'db/downgrade_0064---0063.sql')
-rw-r--r--db/downgrade_0064---0063.sql7
1 files changed, 7 insertions, 0 deletions
diff --git a/db/downgrade_0064---0063.sql b/db/downgrade_0064---0063.sql
new file mode 100644
index 000000000..7cce67680
--- /dev/null
+++ b/db/downgrade_0064---0063.sql
@@ -0,0 +1,7 @@
+BEGIN;
+
+DROP INDEX moderation_original_data_problem_id_comment_id_idx;
+ALTER TABLE moderation_original_data
+ ADD CONSTRAINT moderation_original_data_comment_id_key UNIQUE (comment_id);
+
+COMMIT;