Is there any work being done to add support for defining foreign keys in ActiveRecord Migrations? If not is it something that people would find useful or do most people here believe in the "Application Database" style over the "Integration Database" style [1] as defined by Fowler? I''d love to see support for foreign keys in Migrations. For selfish reasons I''d be most interested in such support for SQL Server and Oracle. Cheers, Steve [1] http://martinfowler.com/bliki/DatabaseStyles.html -------------- next part -------------- An HTML attachment was scrubbed... URL: http://wrath.rubyonrails.org/pipermail/rails/attachments/20060118/6a1305bb/attachment.html
This plugin does it for mysql & postgre. http://wiki.rubyonrails.org/rails/pages/Foreign+Key+Schema+Dumper+Plugin On 1/18/06, Steve Eichert <steve.eichert@gmail.com> wrote:> > Is there any work being done to add support for defining foreign keys in > ActiveRecord Migrations? If not is it something that people would find > useful or do most people here believe in the "Application Database" style > over the "Integration Database" style [1] as defined by Fowler? > > I''d love to see support for foreign keys in Migrations. For selfish > reasons I''d be most interested in such support for SQL Server and Oracle. > > Cheers, > Steve > > [1] http://martinfowler.com/bliki/DatabaseStyles.html > > _______________________________________________ > Rails mailing list > Rails@lists.rubyonrails.org > http://lists.rubyonrails.org/mailman/listinfo/rails > > >-------------- next part -------------- An HTML attachment was scrubbed... URL: http://wrath.rubyonrails.org/pipermail/rails/attachments/20060118/12abe548/attachment.html
Joshua Bates wrote:> This plugin does it for mysql & postgre. > http://wiki.rubyonrails.org/rails/pages/Foreign+Key+Schema+Dumper+Pluginmaybe a little simpler - but so far servicing my needs, hadn''t looked at the other one until now. http://blog.alancfrancis.com/2005/11/add_foreign_key.html -- Posted via http://www.ruby-forum.com/.
Joshua/Darragh, Thanks for the pointers to the plugins! On 1/18/06, Steve Eichert <steve.eichert@gmail.com> wrote:> > Is there any work being done to add support for defining foreign keys in > ActiveRecord Migrations? If not is it something that people would find > useful or do most people here believe in the "Application Database" style > over the "Integration Database" style [1] as defined by Fowler? > > I''d love to see support for foreign keys in Migrations. For selfish > reasons I''d be most interested in such support for SQL Server and Oracle. > > Cheers, > Steve > > [1] http://martinfowler.com/bliki/DatabaseStyles.html >-------------- next part -------------- An HTML attachment was scrubbed... URL: http://wrath.rubyonrails.org/pipermail/rails/attachments/20060119/0d9febca/attachment-0001.html