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