title: SQLite3::SQLException: duplicate column name: User_id: ALTER TABLE "comments" ADD "User_id" integer/
body: <p>I ran the command</p>
  
  <p><code>rails g migration AddUser_idToComments User_id:string</code></p>
  
  <p>and then I figured out that User_id should be an integer and so I ran</p>
  
  <p><code>rails g migration AddUser_idToComments User_id:integer --force</code> thinking that it would overwrite the initial command.</p>
  
  <p>But now, I'm getting this error:</p>
  
  <p>```
  louismorin$ rake db:migrate
  == 20140910155248 AddIndexToComments: migrating ===============================
  -- add_column(:comments, :Index, :string)
     -> 0.0069s
  == 20140910155248 AddIndexToComments: migrated (0.0070s) ======================</p>
  
  <p>== 20140910181022 AddUserIdToComments: migrating ==============================
  -- add_column(:comments, :User_id, :integer)
  rake aborted!
  StandardError: An error has occurred, this and all later migrations canceled:</p>
  
  <p>SQLite3::SQLException: duplicate column name: User_id: ALTER TABLE "comments" ADD "User_id" integer/Users/louismorin/code/CP299/db/migrate/20140910181022_add_user_id_to_comments.rb:3:in <code>change'
  ActiveRecord::StatementInvalid: SQLite3::SQLException: duplicate column name: User_id: ALTER TABLE "comments" ADD "User_id" integer
  /Users/louismorin/code/CP299/db/migrate/20140910181022_add_user_id_to_comments.rb:3:in</code>change'
  SQLite3::SQLException: duplicate column name: User_id
  /Users/louismorin/code/CP299/db/migrate/20140910181022_add_user_id_to_comments.rb:3:in `change'
  Tasks: TOP => db:migrate
  (See full trace by running task with --trace)
  ```</p>
  
  <p>Here's my schema.rb file</p>
  
  <p>```
      ActiveRecord::Schema.define(version: 20140910155210) do</p>
  
  <pre><code>create_table "comments", force: true do |t|
    t.text     "body"
    t.integer  "post_id"
    t.datetime "created_at"
    t.datetime "updated_at"
    t.string   "User_Id"
  end
  
  add_index "comments", ["post_id"], name: "index_comments_on_post_id"
  
  create_table "posts", force: true do |t|
    t.string   "title"
    t.text     "body"
    t.datetime "created_at"
    t.datetime "updated_at"
    t.integer  "user_id"
    t.integer  "topic_id"
  end
  
  add_index "posts", ["topic_id"], name: "index_posts_on_topic_id"
  add_index "posts", ["user_id"], name: "index_posts_on_user_id"
  
  create_table "topics", force: true do |t|
    t.string   "name"
    t.boolean  "public",      default: true
    t.text     "description"
    t.datetime "created_at"
    t.datetime "updated_at"
  end
  
  create_table "users", force: true do |t|
    t.string   "email",                  default: "", null: false
    t.string   "encrypted_password",     default: "", null: false
    t.string   "reset_password_token"
    t.datetime "reset_password_sent_at"
    t.datetime "remember_created_at"
    t.integer  "sign_in_count",          default: 0,  null: false
    t.datetime "current_sign_in_at"
    t.datetime "last_sign_in_at"
    t.string   "current_sign_in_ip"
    t.string   "last_sign_in_ip"
    t.string   "confirmation_token"
    t.datetime "confirmed_at"
    t.datetime "confirmation_sent_at"
    t.string   "unconfirmed_email"
    t.string   "name"
    t.datetime "created_at"
    t.datetime "updated_at"
    t.string   "role"
    t.string   "avatar"
    t.string   "Image"
  end
  
  add_index "users", ["email"], name: "index_users_on_email", unique: true
  add_index "users", ["reset_password_token"], name: "index_users_on_reset_password_token", unique:     true
  
  end
  </code></pre>
  
  <p>```</p>