DB changes + Related issues added

[rails.git] / db / migrate / 20150516073616_create_issues.rb

diff --git a/db/migrate/20150516073616_create_issues.rb b/db/migrate/20150516073616_create_issues.rb
index 3a59c9eb09b0c75e47187a36d6052334430d09b4..32e9976a21e47b68f9b2e242ded28d6acd2efc7f 100644 (file)
--- 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