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;
Activity
Benjamin Eberlei
made changes -
| Field | Original Value | New Value |
|---|---|---|
| Status | Open [ 1 ] | Resolved [ 5 ] |
| Fix Version/s | 2.0-BETA1 [ 10030 ] | |
| Resolution | Fixed [ 1 ] |
Roman S. Borschel
made changes -
| Component/s | ORM [ 10012 ] | |
| Component/s | DBAL [ 10011 ] |
Benjamin Eberlei
made changes -
| Workflow | jira [ 11104 ] | jira-feedback [ 14347 ] |
Benjamin Eberlei
made changes -
| Workflow | jira-feedback [ 14347 ] | jira-feedback2 [ 16211 ] |
Benjamin Eberlei
made changes -
| Workflow | jira-feedback2 [ 16211 ] | jira-feedback3 [ 18464 ] |