Store all moderation change history in database.

Currently keeping the same front end functionality of only reverting to
the original.

3 files changed, 17 insertions, 1 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;
diff --git a/db/schema.sql b/db/schema.sql
index a448e05fa..d5d63f478 100644
--- a/db/schema.sql
+++ b/db/schema.sql
@@ -441,7 +441,7 @@ create table moderation_original_data (
 
     -- Problem details
     problem_id int references problem(id) ON DELETE CASCADE not null,
-    comment_id int references comment(id) ON DELETE CASCADE unique,
+    comment_id int references comment(id) ON DELETE CASCADE,
 
     title text null,
     detail text null, -- or text for comment
@@ -456,6 +456,7 @@ create table moderation_original_data (
     latitude double precision,
     longitude double precision
 );
+create index moderation_original_data_problem_id_comment_id_idx on moderation_original_data(problem_id, comment_id);
 
 create table user_body_permissions (
     id serial not null primary key,
diff --git a/db/schema_0064-allow-multiple-moderations.sql b/db/schema_0064-allow-multiple-moderations.sql
new file mode 100644
index 000000000..5fee96282
--- /dev/null
+++ b/db/schema_0064-allow-multiple-moderations.sql
@@ -0,0 +1,8 @@
+BEGIN;
+
+ALTER TABLE moderation_original_data
+    DROP CONSTRAINT moderation_original_data_comment_id_key;
+CREATE INDEX moderation_original_data_problem_id_comment_id_idx
+    ON moderation_original_data(problem_id, comment_id);
+
+COMMIT;