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

问题描述

以前，我问过如何在不使用SQL的情况下在Magento设置脚本中 ALTER TABLE .在那里， 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屋！