Hello, I bumped into a slight issue when trying to use associable with MySQL. An association table creation was failing with a referential integrity error. I figured out that Elixir was trying to create association tables using the default MyISAM storage engine whereas my other tables use InnoDB. I was able solve the problem by setting the default storage engine to be InnoDB in my.cnf. Maybe it'd be worth mentioning this pitfall somewhere in the docs?
Also, I wonder if changing the server configuration is an ideal solution, as it makes the app relying on specific settings to be deployed. Would it make sense to provide a way to specify the type of table generated by associable? Maybe within an extra table options parameter? If so, I'd be happy to try and make a little patch. All the best, Alex --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "SQLElixir" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/sqlelixir?hl=en -~----------~----~----~----~------~----~------~--~---
