title: CakePHP 1.3.4 $belongsTo problem incase of Relationship table
body: <p>I have a table called user_relationship. which has two foreign keys refering back to the User table to map that they are friends. </p>
  
  <pre><code>CREATE TABLE `user_relationships` (
    `id` int(11) unsigned NOT NULL auto_increment,
    `status` varchar(255) default 'pending',
    `time` datetime default NULL,
    `user_id` int(11) unsigned NOT NULL,
    `friend_id` int(11) unsigned NOT NULL,
    PRIMARY KEY  (`id`),
    KEY `fk_user_relationships_users1` (`user_id`),
    KEY `fk_user_relationships_users2` (`friend_id`)
  ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
  </code></pre>
  
  <p>when i try to bake it naturally doesnt understand that the friend_id has to refer to User module. i wanna manual edit the code but o have some problem understanding what parts to edit in the following</p>
  
  <pre><code>var $belongsTo = array(
      'User' =&gt; array(
          'className' =&gt; 'User',
          'foreignKey' =&gt; 'user_id',
          'conditions' =&gt; '',
          'fields' =&gt; '',
          'order' =&gt; ''
      ),
      'Friend' =&gt; array(
          'className' =&gt; 'Friend',
          'foreignKey' =&gt; 'friend_id',
          'conditions' =&gt; '',
          'fields' =&gt; '',
          'order' =&gt; ''
      )
  );
  </code></pre>
  
  <p>In this part of the code i wanna refer the friend_id to the User Table</p>
  
  <pre><code>    'Friend' =&gt; array(
          'className' =&gt; 'Friend',
          'foreignKey' =&gt; 'friend_id',
          'conditions' =&gt; '',
          'fields' =&gt; '',
          'order' =&gt; ''
      )
  </code></pre>
  
  <p>i tried doing this.. do i need to change anything else ?</p>
  
  <pre><code>    'Friend' =&gt; array(
          'className' =&gt; 'Friend',
          'foreignKey' =&gt; 'user_id',
          'conditions' =&gt; '',
          'fields' =&gt; '',
          'order' =&gt; ''
      )
  </code></pre>