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

diff --git a/db/migrate/20150516075620_create_reports.rb b/db/migrate/20150516075620_create_reports.rb
index bcdc3104e..abae0f705 100644
--- a/db/migrate/20150516075620_create_reports.rb
+++ b/db/migrate/20150516075620_create_reports.rb
@@ -9,5 +9,12 @@ class CreateReports < ActiveRecord::Migration
 
       t.timestamps null: false
     end
+
+    add_foreign_key :reports, :issues, :name => "reports_issue_id_fkey"
+    add_foreign_key :reports, :users, :name => "reports_user_id_fkey"
+
+    add_index :reports, :issue_id
+    add_index :reports, :user_id
+        
   end
 end