Store more original stuff on moderation.

3 files changed, 23 insertions, 1 deletions

diff --git a/db/downgrade_0063---0062.sql b/db/downgrade_0063---0062.sql
new file mode 100644
index 000000000..0f875e3e4
--- /dev/null
+++ b/db/downgrade_0063---0062.sql
@@ -0,0 +1,8 @@
+BEGIN;
+
+ALTER TABLE moderation_original_data DROP extra;
+ALTER TABLE moderation_original_data DROP latitude;
+ALTER TABLE moderation_original_data DROP longitude;
+ALTER TABLE moderation_original_data DROP category;
+
+COMMIT;
diff --git a/db/schema.sql b/db/schema.sql
index 30f5d3a30..a448e05fa 100644
--- a/db/schema.sql
+++ b/db/schema.sql
@@ -449,7 +449,12 @@ create table moderation_original_data (
     anonymous bool not null,
 
     -- Metadata
-    created timestamp not null default current_timestamp
+    created timestamp not null default current_timestamp,
+
+    extra text,
+    category text,
+    latitude double precision,
+    longitude double precision
 );
 
 create table user_body_permissions (
diff --git a/db/schema_0063-add-extra-to-moderation.sql b/db/schema_0063-add-extra-to-moderation.sql
new file mode 100644
index 000000000..9d003f895
--- /dev/null
+++ b/db/schema_0063-add-extra-to-moderation.sql
@@ -0,0 +1,9 @@
+BEGIN;
+
+ALTER TABLE moderation_original_data ADD extra text;
+ALTER TABLE moderation_original_data ADD category text;
+ALTER TABLE moderation_original_data ADD latitude double precision;
+ALTER TABLE moderation_original_data ADD longitude double precision;
+
+COMMIT;
+