Hey If you want to use constraints / foreingkeys ( FK ) under the MySQL database server, you need to use the table type innodb instead of MyISAM ( default for mysql )
http://dev.mysql.com/doc/refman/4.1/en/innodb-overview.html ( == 5.1 ) http://dev.mysql.com/doc/refman/5.0/en/innodb-overview.html ( == 5.0 ) http://dev.mysql.com/doc/refman/5.1/en/innodb-overview.html ( < 5.0 ) also read on these links for how to use these foreign keys :) http://dev.mysql.com/doc/refman/5.1/en/example-foreign-keys.html http://dev.mysql.com/doc/refman/5.0/en/example-foreign-keys.html http://dev.mysql.com/doc/refman/4.1/en/example-foreign-keys.html Id recommend using EMS SQL Manager 2005 or other visual database editor when playing with them, since it can rather quick be hard to keep track of all your keys :) When I use cake constraints - I always back it up with triggers and foreign keys in mysql innodb aswell, better safe than sorry yes ? :) /Christian Winther --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
