aboutsummaryrefslogtreecommitdiffstats
path: root/db
diff options
context:
space:
mode:
authorHakim Cassimally <hakim@mysociety.org>2014-08-14 09:43:06 +0000
committerHakim Cassimally <hakim@mysociety.org>2014-08-14 09:44:36 +0000
commit8758cafc007eba14f2d04e20273ed1fc4336d167 (patch)
treeeea36e6b1d59eb016002f0d4d7d2f1a59f9ced61 /db
parentf16060fa322a4230a5b16a1e8c5b122307f29bee (diff)
Moderation - update-schema fixed and improved
bin/update-schema --commit should now work A downgrade is also provided. Run bin/update-schema --help for details
Diffstat (limited to 'db')
-rw-r--r--db/downgrade_0032---0031.sql7
1 files changed, 7 insertions, 0 deletions
diff --git a/db/downgrade_0032---0031.sql b/db/downgrade_0032---0031.sql
new file mode 100644
index 000000000..520494406
--- /dev/null
+++ b/db/downgrade_0032---0031.sql
@@ -0,0 +1,7 @@
+alter table admin_log drop column user_id;
+
+alter table admin_log drop column reason;
+
+drop table moderation_original_data;
+
+drop table user_body_permissions;