So, you want Cake to use MyISAM "syntax" for an InnoDB driven sql server? I think this is possible doing some configurations inside of the database related core files
On 14 Aug., 22:26, JamesF <[email protected]> wrote: > Whnn I first set up the current app I am using, I chose InnoDB tables > for almost any Model that i thought would be related. My thinking was > that Cake wouldn't understand the foreign key relationships and it > would lead to database integrity problems. > > I am assuming that Cake doesn't care which storage engine I use in the > case of simple model relationships. I am not using transactions or row > level locking currently, and more often then not, the CASCADE effect > of InnoDB tables has made some of my data go bye-bye. > > I appreciate that InnoDB prevents me from inserting data with > incorrect id's and fk id's but it also deletes child data when i don't > want it to (unless i use RESTRICT or SET NULL on that fk). > > So the crux of my question is this, can I maintain my current app > functionality while converting back to MyISAM tables, considering I do > not use any advanced InnoDB features? Will Cake still handle my table > relationships correctly when I am following proper naming conventions > for foreign keys and table names? --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "CakePHP" 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/cake-php?hl=en -~----------~----~----~----~------~----~------~--~---
