title: Symfony2 Doctrine schema update fails
body: <p>I created database on my local machine. After moving my project to server I imported backup from local (because I had some important data there). </p>
  
  <p>Now,when I'm trying to update schema on my server it gives my this output:</p>
  
  <pre><code>php app/console doctrine:schema:update --force
  Updating database schema...
  
  
  
  
  
    [Doctrine\DBAL\Exception\ForeignKeyConstraintViolationException]                                                                                                             
    An exception occurred while executing 'ALTER TABLE golf_course ADD CONSTRAINT FK_EC96E162F1503E2B FOREIGN KEY (golf_id) REFERENCES golf (id)':                               
    SQLSTATE[23000]: Integrity constraint violation: 1452 Cannot add or update a child row: a foreign key constraint fails (`GolfFairway`.`#sql-3fae_7ccf1`, CONSTRAINT `FK_EC9  
    6E162F1503E2B` FOREIGN KEY (`golf_id`) REFERENCES `golf` (`id`))                                                                                                             
  
  
  
  
  
  
    [Doctrine\DBAL\Driver\PDOException]                                                                                                                                          
    SQLSTATE[23000]: Integrity constraint violation: 1452 Cannot add or update a child row: a foreign key constraint fails (`GolfFairway`.`#sql-3fae_7ccf1`, CONSTRAINT `FK_EC9  
    6E162F1503E2B` FOREIGN KEY (`golf_id`) REFERENCES `golf` (`id`))                                                                                                             
  
  
  
  
  
  
    [PDOException]                                                                                                                                                               
    SQLSTATE[23000]: Integrity constraint violation: 1452 Cannot add or update a child row: a foreign key constraint fails (`GolfFairway`.`#sql-3fae_7ccf1`, CONSTRAINT `FK_EC9  
    6E162F1503E2B` FOREIGN KEY (`golf_id`) REFERENCES `golf` (`id`))                                                                                                             
  </code></pre>
  
  <p>Why this happens ? Is there a solution ?</p>