Zend_Db_Table 外键约束失败

Question

我必须表，它们的 SQL 如下：

CREATE TABLE item (
itemID INTEGER UNSIGNED AUTO_INCREMENT PRIMARY KEY NOT NULL,
name VARCHAR(100) NOT NULL,
price FLOAT NOT NULL,
stock INTEGER NOT NULL
) ENGINE = InnoDB;


CREATE TABLE salesrecord (
recordID INTEGER UNSIGNED AUTO_INCREMENT PRIMARY KEY NOT NULL,
itemID INT UNSIGNED NOT NULL,
recordDate DATE NOT NULL,
FOREIGN KEY (itemID) REFERENCES item (itemID)
) ENGINE = InnoDB;

这是我的 Zend_Db_Table 具体类：

<?php
class Store_Model_Items extends Zend_Db_Table_Abstract
{
  protected $_name = 'item';
  protected $_rowClass = 'Store_Model_Item';
  protected $_dependTables = array('Store_Model_SalesRecords');
}


<?php
class Store_Model_SalesRecords extends Zend_Db_Table_Abstract
{
  protected $_name = 'salesrecord';
  protected $_referenceMap = array(
    'Item' => array(
        'columns' => array('itemID'),
        'refTableClass' => 'Store_Model_Items',
        'refColumns' => array('itemID'),
        'onDelete' => self::CASCADE
    )
  );
} 

当我尝试删除项目表中的一行时， 我收到此消息：

SQLSTATE[HY000]：一般错误：1451 无法删除或更新父行：外键约束失败（newstore/salesrecord，CONSTRAINT salesrecord_ibfk_1 FOREIGN KEY (itemID) 参考 item (itemID))

Answer 1

如果要删除父表中的记录，首先应删除子表中的相关记录。还可以添加ON DELETE CASCADE检查，这将有助于自动删除子表中的相关记录。尝试以这种方式重新创建您的 FK -

ALTER TABLE salesrecord
  DROP FOREIGN KEY salesrecord_ibfk_1; -- change FK name here!

ALTER TABLE salesrecord
  ADD CONSTRAINT salesrecord_ibfk_1 FOREIGN KEY (itemID)
    REFERENCES item(itemID) ON DELETE CASCADE;

将 'salesrecord_ibfk_1' 更改为实际的 FK 名称。