X-Git-Url: https://git.openstreetmap.org./rails.git/blobdiff_plain/dbd88d893f3c3fce9cafd666b94396988646d81f..2dd8f09395f1a8e050330b360154e5b7ad1a8492:/db/structure.sql?ds=inline

diff --git a/db/structure.sql b/db/structure.sql
index be0603e6e..832573183 100644
--- a/db/structure.sql
+++ b/db/structure.sql
@@ -691,11 +691,10 @@ ALTER SEQUENCE gpx_files_id_seq OWNED BY gpx_files.id;
 
 CREATE TABLE issue_comments (
     id integer NOT NULL,
-    issue_id integer,
-    commenter_user_id integer,
-    body text,
+    issue_id integer NOT NULL,
+    commenter_user_id integer NOT NULL,
+    body text NOT NULL,
     created_at timestamp without time zone NOT NULL,
-    reassign boolean,
     updated_at timestamp without time zone NOT NULL
 );
 
@@ -732,10 +731,10 @@ CREATE TABLE issues (
     issue_type character varying,
     resolved_at timestamp without time zone,
     resolved_by integer,
+    updated_by integer,
     created_at timestamp without time zone NOT NULL,
     updated_at timestamp without time zone NOT NULL,
-    updated_by integer,
-    report_count integer DEFAULT 0
+    reports_count integer DEFAULT 0
 );