DDC-2161: Moving entity relationship doesn't move foreign key in mysql table #2852

Closed
doctrinebot opened this Issue Nov 22, 2012 · 5 comments

2 participants

@doctrinebot

Jira issue originally created by user alex88:

Edit: moved the bug to the dbal project, please delete this or set as invalid, new bug:

http://www.doctrine-project.org/jira/browse/[DBAL-392](http://www.doctrine-project.org/jira/browse/DBAL-392)


These are the steps I've tried to reproduce the problem:

  • composer create-project symfony/framework-standard-edition path/ 2.1.3
  • edited parameters for mysql db
  • created attached 'Post' entity (note the parent/children fields)
  • updated schema with doctrine:schema:create

I see that the foreign key in phpmyadmin is correctly set to Post.id which is correct.

Now:

  • created another entity 'Argument'
  • moving the children field from 'Post' to 'Argument' removing setters getters into 'Post' and changing target entity field accordingly
  • Updated DB schema (doctrine:schema:update --force)

The situation is now the one you can find in Post2 and Argument attachments.

The problem is that now, the foreign key in Post field it's still on Post.id and not on Argument.id and schema:update says the DB is in sync with the metadata.

Manually deleting the foreign key and running schema:update makes the key being correctly created into Argument.id

@doctrinebot

Comment created by @beberlei:

A related Github Pull-Request [GH-234] was opened
doctrine/dbal#234

@doctrinebot

Comment created by @beberlei:

On wrong project, see DBAL-392

@doctrinebot

Issue was closed with resolution "Invalid"

@doctrinebot

Comment created by @doctrinebot:

A related Github Pull-Request [GH-234] was closed:
doctrine/common#234

@beberlei beberlei was assigned by doctrinebot Dec 6, 2015
@doctrinebot doctrinebot closed this Dec 6, 2015
@doctrinebot doctrinebot added the Bug label Dec 7, 2015
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment