X-Git-Url: https://git.openstreetmap.org./rails.git/blobdiff_plain/dbd88d893f3c3fce9cafd666b94396988646d81f..3115fd41b178e76bd1932ffb2c051407a4020e8e:/db/structure.sql

diff --git a/db/structure.sql b/db/structure.sql
index be0603e6e..7888d8a9c 100644
--- a/db/structure.sql
+++ b/db/structure.sql
@@ -691,11 +691,11 @@ 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,
-    created_at timestamp without time zone NOT NULL,
+    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
 );
 
@@ -732,10 +732,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
 );