在不使用 SQL 的情况下在 Magento 安装脚本中添加 auto_increment 列 [英] Add an auto_increment column in Magento setup script without using SQL

问题描述

以前我问过如何在不使用 SQL 的情况下在 Magento 安装脚本中更改表.在那里，Ivan 给出了一个很好的答案，我现在仍然参考.

Previously I asked how to ALTER TABLE in Magento setup script without using SQL. There, Ivan gave an excellent answer which I still refer to even now.

但是我还没有发现如何使用 Varien_Db_Ddl_Table::addColumn() 来指定一个 auto_increment 列.我认为这与一个名为 identity 的选项有关，但到目前为止还没有运气.

However I have yet to discover how to use Varien_Db_Ddl_Table::addColumn() to specify an auto_increment column. I think it has something to do with an option called identity but so far have had no luck.

这是可能的还是功能不完整?

Is this even possible or is that functionality incomplete?

推荐答案

可以像这样创建自动增量列(至少从 Magento 1.6 开始，甚至可能更早):

One can create an autoincrement column like that (at least since Magento 1.6, maybe even earlier):

/** @var $table Varien_Db_Ddl_Table */
$table->addColumn( 'id', Varien_Db_Ddl_Table::TYPE_INTEGER, null, array(
    'auto_increment' => true,
    'unsigned' => true,
    'nullable' => false,
    'primary' => true,
), 'ID' );

除了auto_increment"，还可以使用关键字identity".

Instead of "auto_increment", one may also use the keyword "identity".

这篇关于在不使用 SQL 的情况下在 Magento 安装脚本中添加 auto_increment 列的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！