X-Git-Url: https://git.openstreetmap.org/rails.git/blobdiff_plain/33c43ab0affe7317d7d136bc6ed934d6f6951585..1d24228a3bd3ac2b233078475c6d44d9c547bbc7:/db/structure.sql

diff --git a/db/structure.sql b/db/structure.sql
index 7888d8a9c..a4a6ff6c7 100644
--- a/db/structure.sql
+++ b/db/structure.sql
@@ -694,7 +694,6 @@ CREATE TABLE issue_comments (
     issue_id integer NOT NULL,
     commenter_user_id integer NOT NULL,
     body text NOT NULL,
-    reassign boolean,
     created_at timestamp without time zone NOT NULL,
     updated_at timestamp without time zone NOT NULL
 );
@@ -733,9 +732,9 @@ CREATE TABLE issues (
     resolved_at timestamp without time zone,
     resolved_by integer,
     updated_by integer,
+    reports_count integer DEFAULT 0,
     created_at timestamp without time zone NOT NULL,
-    updated_at timestamp without time zone NOT NULL,
-    reports_count integer DEFAULT 0
+    updated_at timestamp without time zone NOT NULL
 );
 
 
@@ -1067,7 +1066,7 @@ CREATE TABLE reports (
     id integer NOT NULL,
     issue_id integer,
     reporter_user_id integer,
-    details text,
+    details text NOT NULL,
     created_at timestamp without time zone NOT NULL,
     updated_at timestamp without time zone NOT NULL
 );
@@ -2831,8 +2830,6 @@ INSERT INTO "schema_migrations" (version) VALUES
 ('20150222101847'),
 ('20150818224516'),
 ('20160822153055'),
-('20160822153115'),
-('20160822153153'),
 ('20161002153425'),
 ('20161011010929'),
 ('20170222134109'),