In doctrine2 is it possible to have an autoincrement column that is not the primary key?
auto-increment, doctrine-orm, primary-key, symfony, zend-framework
Solution
The auto-increment limitation is related to the database you are using. in Mysql ,Mysql_autoincrement, it also depends on the engine you are using. exemple:
For MyISAM and BDB tables you can specify AUTO_INCREMENT on a secondary column in a multiple-column index. In this case, the generated value for the AUTO_INCREMENT column is calculated as
You can have a general documentation on auto_increment here
In general the auto_increment is reserved to a numerical field that is part of the identifier index (one or more column involved).
So this can work for mysql.
However the auto_incriment in doctrine seems to only be alllowed for THe @Id (Primary Key)
21.2.9. @GeneratedValue
Specifies which strategy is used for identifier generation for an instance variable which is annotated by @Id. This annotation is optional and only has meaning when used in conjunction with @Id.
If this annotation is not specified with @Id the NONE strategy is used as default.
Required attributes:
strategy: Set the name of the identifier generation strategy. Valid values are AUTO, SEQUENCE, TABLE, IDENTITY, UUID, CUSTOM and NONE. Example:
?php
/**
* @Id
* @Column(type="integer")
* @GeneratedValue(strategy="AUTO")
*/
protected $id = null;
Doctrine_auto_increment
You may want to find a work arround and post a ticket about it
Problem
In doctrine2 I have an entity that has a primary key that's feeded from a webservice, and also has an index that should be an auto increment. I can set manually in mysql but can't make this work in doctrine2.