X-Git-Url: https://git.openstreetmap.org/rails.git/blobdiff_plain/bdc6adddbfdcc57bd300688f48b28e027e561728..d1d4f8192da5a266cddb17bb8970b2b04387888c:/db/migrate/20150516073616_create_issues.rb

diff --git a/db/migrate/20150516073616_create_issues.rb b/db/migrate/20150516073616_create_issues.rb
index 3a59c9eb0..32e9976a2 100644
--- a/db/migrate/20150516073616_create_issues.rb
+++ b/db/migrate/20150516073616_create_issues.rb
@@ -1,9 +1,11 @@
+require "migrate"
+
 class CreateIssues < ActiveRecord::Migration
   def change
     create_table :issues do |t|
-      t.string :reportable_type
-      t.integer :reportable_id
-      t.integer :user_id
+      t.string :reportable_type, :null => false
+      t.integer :reportable_id, :null => false
+      t.integer :reported_user_id, :null => false
       t.integer :status
       t.datetime :resolved_at
       t.integer :resolved_by
@@ -12,5 +14,11 @@ class CreateIssues < ActiveRecord::Migration
 
       t.timestamps null: false
     end
+
+    add_foreign_key :issues, :users, :column => :reported_user_id,:name => "issues_reported_user_id_fkey"
+
+    add_index :issues, :reported_user_id,
+    add_index :issues, [:reportable_id, :reportable_type]
+    
   end
 end