Remove the reassign column from issue_comments

[rails.git] / db / structure.sql

diff --git a/db/structure.sql b/db/structure.sql
index be0603e6ea299927e23c3b2140ccdbb39fd1ee5f..83257318313d623d21540137cde83bf60ca64170 100644 (file)
--- 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,
 
 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,
     created_at timestamp without time zone NOT NULL,

-    reassign boolean,

     updated_at timestamp without time zone NOT NULL
 );
 
     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,
     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,
     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

 );
 
 
 );