Fixed tests + Altered migration file + Added reporting strings + Added update method

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

diff --git a/db/migrate/20150516073616_create_issues.rb b/db/migrate/20150516073616_create_issues_and_reports.rb
similarity index 53%
rename from db/migrate/20150516073616_create_issues.rb
rename to db/migrate/20150516073616_create_issues_and_reports.rb
index e77ea989a3524bdc52f8b84c847995919616312e..153dbd6906cc299c18b00732a2e2558e8e1dde23 100644 (file)
--- a/db/migrate/20150516073616_create_issues.rb
+++ b/db/migrate/20150516073616_create_issues_and_reports.rb
@@ -1,6 +1,6 @@
 require "migrate"
 
-class CreateIssues < ActiveRecord::Migration
+class CreateIssuesAndReports < ActiveRecord::Migration
   def change
     create_table :issues do |t|
       t.string :reportable_type, :null => false
@@ -19,6 +19,22 @@ class CreateIssues < ActiveRecord::Migration
 
     add_index :issues, :reported_user_id
     add_index :issues, [:reportable_id, :reportable_type]
+
+    create_table :reports do |t|
+      t.integer :issue_id
+      t.integer :reporter_user_id
+      t.text :details
+      t.datetime :created_at
+      t.datetime :updated_at
+
+      t.timestamps null: false
+    end
+
+    add_foreign_key :reports, :issues, :name => "reports_issue_id_fkey"
+    add_foreign_key :reports, :users,:column => :reporter_user_id, :name => "reports_reporter_user_id_fkey"
+
+    add_index :reports, :reporter_user_id
+    add_index :reports, :issue_id
     
   end
 end