Cake Version: 1.1.8.3544 PHP Version: 4.3.2 Hi,
I am looking to have a join table in my database which is a join of the same table: CREATE TABLE `builds` ( `id` int(11) NOT NULL auto_increment, `name` varchar(255) NOT NULL, PRIMARY KEY (`id`) ) Per the documentation, the naming convention for this is: *many-to-many join tables should be named: alphabetically_first_table_plural_alphabetically_second_table_plural ie: tags_users *columns in many-to-many join tables should be named like other foreign keys ie: tag_id and user_id So I would end up with CREATE TABLE `builds_builds` ( `id` int(11) NOT NULL auto_increment, `build_id` int(11) NOT NULL auto_increment, `build_id` int(11) NOT NULL auto_increment, PRIMARY KEY (`id`) ) which obviously won't work. Is there a way for CakePHP to handle this? To anticipate the first question of 'what in the heck are you doing', basically I am building a project release website which tracks clearcase labels against projects and project-components. From the apps perspective project and project-components are the same thing (components are just small projects). So a project can be composed of other projects. After looking around the related sites, i've been unable to find anything. Any help would be great! David --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
