This is not a bug, the ORM simply doesn't recognize `unsigned` and doesn't propagate it to other columns/join columns.
Just use an `int` unless there's a good reason for using an unsigned integer, or map all related fields to `unsigned` manually. Marco Pivetta http://twitter.com/Ocramius http://ocramius.github.com/ On 5 June 2014 01:14, Nima Sadjadi <[email protected]> wrote: > > As all know, FK on MySQL must be unsigned in order to be able to add > constraing fk index on it, otherwise when adding constraint key on it, it > gives errno 150. > when I set unsigned status of FK as true like this: > > $metadata->mapField(array( > 'fieldName' => 'productId', > 'columnName' => 'product_id', > 'type' => 'integer', > 'nullable' => false, > > * 'unsigned' => true,* 'comment' => '', > )); > > then run orm:update it revokes unsigned status as below: > ALTER TABLE .... CHANGE product_id product_id INT NOT NULL; > then on next line when it wants to add constraing key, it gives 150 error, > so I was forced to output the orm:update to a text file, remove CHANGE then > copy/paste it in MySQL console and this way it can adds constrainy key fine! > > So isn't it a bug on orm:update that it does not recognize > 'unsigned' => true, > and revokes unsigned status when orm:update is applied? > > > > -- > You received this message because you are subscribed to the Google Groups > "doctrine-user" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to [email protected]. > To post to this group, send email to [email protected]. > Visit this group at http://groups.google.com/group/doctrine-user. > For more options, visit https://groups.google.com/d/optout. > -- You received this message because you are subscribed to the Google Groups "doctrine-user" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at http://groups.google.com/group/doctrine-user. For more options, visit https://groups.google.com/d/optout.
