Details
Description
If you add several new tables and make a schema diff, these tables foreign key relations to each other are not sorted properly leading to possible errors:
benny@benny-pc:~/code/php/wsnetbeans/whitewashing$ doctrine orm:schema-tool --update --dump-sql Doctrine Command Line Interface CREATE TABLE blog_posts_tags (post_id INT NOT NULL, tag_id VARCHAR(255) NOT NULL, INDEX blog_posts_tags_tag_id_idx (tag_id), PRIMARY KEY(post_id, tag_id)) ENGINE = InnoDB; ALTER TABLE blog_posts_tags ADD FOREIGN KEY (post_id) REFERENCES blog_posts(id); ALTER TABLE blog_posts_tags ADD FOREIGN KEY (tag_id) REFERENCES blog_tags(id); CREATE TABLE blog_tags (tag_name VARCHAR(255) NOT NULL, id VARCHAR(255) NOT NULL, PRIMARY KEY(id)) ENGINE = InnoDB;