On 1/8/07, Praveen Ray <[EMAIL PROTECTED]> wrote: > Why didn't it detect Foreign Key definition as promised in the tutorial?
This message from an earlier thread provides the solution. Skip the parts that aren't relevant and start reading at this line: "You need to use the InnoDB storage engine in order to create "real" foreign keys in MySQL, and even then there are very specific (and annoying) rules surrounding the procedure. ..." http://www.mail-archive.com/rose-db-object@lists.sourceforge.net/msg00929.html The short answer is: use the InnoDB table type, create indexes on all columns involved in the foreign key, and declare the foreign keys in separate constraints rather than inline with each column definition. -John ------------------------------------------------------------------------- Take Surveys. Earn Cash. Influence the Future of IT Join SourceForge.net's Techsay panel and you'll get the chance to share your opinions on IT & business topics through brief surveys - and earn cash http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV _______________________________________________ Rose-db-object mailing list Rose-db-object@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/rose-db-object
