Rails 3 Add Foreign Key in Migration Problems

Question

Does anyone know of a way to create a foreign key in Rails 3 using migrations?

score 3 · Answer 1 · answered Aug 28 '13 at 17:48

the foreigner gem works well for me. it adds a few methods to Rails migrations that allow easy foreign key creation and deletion:

example:

create_table :site_credit_payments do |t|
  t.decimal  :amount, precision: 8, scale: 2, nil: false
  t.string   :note, nil: true

  t.integer  :credit_account_id

  t.timestamps
end
add_foreign_key :site_credit_payments, :credit_accounts

score 1 · Accepted Answer · answered Sep 10 '10 at 06:20

1

foreign_key_migrations,but I dont like that.

answered Sep 10 '10 at 06:20

Ford Guo

957
9
18

Archonic · Answer 3 · 2013-08-02T13:31:08.360

0

If you're app has ActiveRecord::Migration (rails 3 apps do), use add_foreign_key. Documentation here: http://araddconstraint.rubyforge.org/classes/ActiveRecord/ConnectionAdapters/SchemaStatements.html

Note that this is a plugin and not a part of Active Record.

edited Aug 02 '13 at 13:31

answered Dec 10 '12 at 17:24

Archonic

5,207
5
39
55

This isn't part of AR it's a separate plugin. – PhilT Aug 02 '13 at 09:14
I never said it was a part of AR. – Archonic Aug 02 '13 at 13:25

Rails 3 Add Foreign Key in Migration Problems

3 Answers3

Linked