On Oct 23, 2006, at 4:03 PM, Robert wrote:
> > Cheers John for the quick reply. > > Haven't run into problems, it was just that from my Databases > lecture I > vaguely remember something about foreign keys;) and the manual didn't > mention it all, was just checking if it was something the author > 'assumed' the reader had already done. Defining your schema and having the database engine enforce key integrity has its advantages and disadvantages. You'll probably want to continue to learn about the issues regarding telling mySQL about foreign keys. > Any advise of indexes / unique? <twocents> Always, always have an auto-incremented ID field for every table. Its a simple, fool-proof way to steer clear of the collisions that can come from complex/compound primary keys. </twocents> Welcome to Cake! -- John --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Cake PHP" 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 -~----------~----~----~----~------~----~------~--~---
