Hi Max, The snippet you were trying might work for SQLite but not for mysql. I doubt Rails directly supports the declaration of foreign key constraints through ruby code.
So you have take the db specific sql way of adding and executing the foreign key constraints. You can try adding the following to the migration script, to be executed on mysql db. execute "alter table line_items add constraint fk_line_item_products foreign key (product_id) references products(id)" Thanks. On Wed, May 5, 2010 at 5:31 PM, Marnen Laibow-Koser <li...@ruby-forum.com>wrote: > dev wrote: > > What is the "proper" way to add constraints using MySQL as the > > database? I have it set up like this: > > > > t.integer :product_id, :null => false, :options=> "CONSTRAINT > > fk_line_item_products REFERENCES products(id)" > > > > This does nothing even if I fill the options with obviously bad syntax > > or just garbage. > > > > Suggestions? > > Use a plugin such as matthuhiggins-foreigner or foreign_key_constraints. > > Best, > -- > Marnen Laibow-Koser > http://www.marnen.org > mar...@marnen.org > -- > Posted via http://www.ruby-forum.com/. > > -- > You received this message because you are subscribed to the Google Groups > "Ruby on Rails: Talk" group. > To post to this group, send email to rubyonrails-t...@googlegroups.com. > To unsubscribe from this group, send email to > rubyonrails-talk+unsubscr...@googlegroups.com<rubyonrails-talk%2bunsubscr...@googlegroups.com> > . > For more options, visit this group at > http://groups.google.com/group/rubyonrails-talk?hl=en. > > -- You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To post to this group, send email to rubyonrails-t...@googlegroups.com. To unsubscribe from this group, send email to rubyonrails-talk+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en.
