Ensure that issue comments have associated issues and users.

[rails.git] / db / migrate / 20160822153115_create_issue_comments.rb

diff --git a/db/migrate/20160822153115_create_issue_comments.rb b/db/migrate/20160822153115_create_issue_comments.rb
index 98b2afd106c7e2c9fd3219317998e8070e5dc6b2..b41dde8a71a2d848dd13c79da14d7c445b2c8cfd 100644 (file)
--- a/db/migrate/20160822153115_create_issue_comments.rb
+++ b/db/migrate/20160822153115_create_issue_comments.rb
@@ -1,19 +1,17 @@
 class CreateIssueComments < ActiveRecord::Migration
   def change
     create_table :issue_comments do |t|
-      t.integer :issue_id
-      t.integer :commenter_user_id
-      t.text :body
-      t.datetime :created_at
+      t.integer :issue_id, :null => false
+      t.integer :commenter_user_id, :null => false
+      t.text :body, :null => false
       t.boolean :reassign
-      t.timestamps null: false
+      t.timestamps :null => false
     end
 
-       add_foreign_key :issue_comments, :issues, :name => "issue_comments_issue_id_fkey", on_delete: :cascade
-       add_foreign_key :issue_comments, :users,:column => :commenter_user_id, :name => "issue_comments_commenter_user_id", on_delete: :cascade
-
-       add_index :issue_comments, :commenter_user_id
-       add_index :issue_comments, :issue_id
+    add_foreign_key :issue_comments, :issues, :name => "issue_comments_issue_id_fkey", :on_delete => :cascade
+    add_foreign_key :issue_comments, :users, :column => :commenter_user_id, :name => "issue_comments_commenter_user_id", :on_delete => :cascade
 
+    add_index :issue_comments, :commenter_user_id
+    add_index :issue_comments, :issue_id
   end
 end