mysql - Symfony Doctrine 无法创建外键

Question

表中的字段Ordertaxi:

@ORM\Column(name="custom_id", type="integer", options={"unsigned"=true})
private $customId;

// new "column", which i want to add
@ORM\OneToOne(targetEntity="CustomOrder")
private $custom;

表中的字段CustomOrder:

@ORM\Column(name="id", type="integer")
@ORM\Id
@ORM\GeneratedValue(strategy="AUTO")
private $id;

<小时/>

执行:

php app/console doctrine:schema:update --dump-sql

获取:

ALTER TABLE Ordertaxi ADD CONSTRAINT FK_D345B7FB614A603A FOREIGN KEY (custom_id) REFERENCES CustomOrder (id);
CREATE UNIQUE INDEX UNIQ_D345B7FB614A603A ON Ordertaxi (custom_id)

执行:

php app/console doctrine:schema:update --force

获取:

[Doctrine\DBAL\DBALException]                                                                                                                       
  An exception occurred while executing 'ALTER TABLE Ordertaxi ADD CONSTRAINT FK_D345B7FB614A603A FOREIGN KEY (custom_id) REFERENCES CustomOrder (id  
  )':                                                                                                                                                 
  SQLSTATE[HY000]: General error: 1005 Can't create table 'aerotaxi.#sql-3b8a_4c' (errno: 150) 

为什么这个查询会导致错误？

Answer 1

将此代码添加到 Ordertaxi

@JoinColumn(name="customOrder_id", referencedColumnName="id")