Reposition the note and user report flags

[rails.git] / db / structure.sql

diff --git a/db/structure.sql b/db/structure.sql
index 742791df544f70baafa75f6aeb4fcfe3318a98da..eac2acaaf6a5fcca1c66e9132490f3ab0fe7cf0d 100644 (file)
--- a/db/structure.sql
+++ b/db/structure.sql
@@ -726,9 +726,9 @@ CREATE TABLE issues (
     id integer NOT NULL,
     reportable_type character varying NOT NULL,
     reportable_id integer NOT NULL,
-    reported_user_id integer NOT NULL,
+    reported_user_id integer,
     status integer,
-    issue_type character varying,
+    assigned_role user_role_enum NOT NULL,
     resolved_at timestamp without time zone,
     resolved_by integer,
     updated_by integer,
@@ -1067,6 +1067,7 @@ CREATE TABLE reports (
     issue_id integer,
     user_id integer,
     details text NOT NULL,
+    category character varying NOT NULL,
     created_at timestamp without time zone NOT NULL,
     updated_at timestamp without time zone NOT NULL
 );
@@ -2877,3 +2878,5 @@ INSERT INTO "schema_migrations" (version) VALUES
 ('7'),
 ('8'),
 ('9');
+
+