There are many foreign key constraints in my schema.
I can normally generate the migration files by "phalcon migration generate". But when I try to run the migration script at other machine, it show me error:
Phalcon DevTools (1.3.0 ALPHA 1)
There are many foreign key constraints in my schema.
I can normally generate the migration files by "phalcon migration generate". But when I try to run the migration script at other machine, it show me error:
Phalcon DevTools (1.3.0 ALPHA 1)
INFORMATION_SCHEMA
.TABLES
WHERE TABLE_NAME
= 'doc_frags' AND TABLE_SCHEMA
='apidoc' => 1376656691.8706 (0.00045108795166016)
1376656691.8709: CREATE TABLE apidoc
.doc_frags
( id
INT(10) NOT NULL AUTO_INCREMENT, title
VARCHAR(255) NOT NULL, content
TEXT NOT NULL, docid
INT(10) NOT NULL, permid
INT(10) NOT NULL, created_at
VARCHAR(1) NOT NULL, updated_at
VARCHAR(1) NOT NULL, deleted_at
VARCHAR(1), created_by
INT(10) NOT NULL, updated_by
INT(10) NOT NULL, deleted_by
INT(10) NOT NULL, PRIMARY KEY (id
), KEY doc_frags_docid_foreign
(docid
), KEY doc_frags_permid_foreign
(permid
), KEY doc_frags_created_by_foreign
(created_by
), KEY doc_frags_updated_by_foreign
(updated_by
), KEY doc_frags_deleted_by_foreign
(deleted_by
), CONSTRAINT doc_frags_deleted_by_foreign
FOREIGN KEY (id
) REFERENCES admins
(id
), CONSTRAINT doc_frags_created_by_foreign
FOREIGN KEY (id
) REFERENCES admins
(id
), CONSTRAINT doc_frags_docid_foreign
FOREIGN KEY (id
) REFERENCES docs
(id
), CONSTRAINT doc_frags_permid_foreign
FOREIGN KEY (id
) REFERENCES permissions
(id
), CONSTRAINT doc_frags_updated_by_foreign
FOREIGN KEY (id
) REFERENCES admins
(id
) ) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci