aboutsummaryrefslogtreecommitdiffstats
path: root/db
diff options
context:
space:
mode:
Diffstat (limited to 'db')
-rw-r--r--db/downgrade_0069---0068.sql12
1 files changed, 12 insertions, 0 deletions
diff --git a/db/downgrade_0069---0068.sql b/db/downgrade_0069---0068.sql
new file mode 100644
index 000000000..668258524
--- /dev/null
+++ b/db/downgrade_0069---0068.sql
@@ -0,0 +1,12 @@
+BEGIN;
+
+ALTER TABLE admin_log DROP CONSTRAINT admin_log_object_type_check;
+
+ALTER TABLE admin_log ADD CONSTRAINT admin_log_object_type_check CHECK (
+ object_type = 'problem'
+ OR object_type = 'update'
+ OR object_type = 'user'
+ OR object_type = 'moderation'
+);
+
+COMMIT;