#1692: Versionable creating too many Foreign Key constraints
---------------------------------------+------------------------------------
Reporter: popthestack | Owner: guilhermeblanco
Type: defect | Status: new
Priority: blocker | Milestone: 1.1.0
Component: Versionable | Version: 1.1-DEV
Keywords: foreign keys, constraints | Has_test: 0
Mystatus: Pending Core Response | Has_patch: 0
---------------------------------------+------------------------------------
This is a MySQL CREATE TABLE query after creating tables with Doctrine
1.1:
http://paste2.org/p/106685
* You'll notice that the FK names are from
[http://trac.phpdoctrine.org/ticket/1691 the last ticket I created]. The
problem exists regardless of my patch, as you can see here
[http://paste2.org/p/106686] from the ALTER TABLE statements that Doctrine
creates before my patch. I just think it's easier to see the problem with
the FK names being the same length.
Anyway, there are 5 too many Foreign Keys, all on `id`, one of which is a
duplicate.
It's not just because that table is self-referencing. Here's two more:
http://paste2.org/p/106687
http://paste2.org/p/106688
--
Ticket URL: <http://trac.phpdoctrine.org/ticket/1692>
Doctrine <http://www.phpdoctrine.org>
PHP Doctrine Object Relational Mapper
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"doctrine-svn" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at
http://groups.google.co.uk/group/doctrine-svn?hl=en-GB
-~----------~----~----~----~------~----~------~--~---
