search

shaoner / ziti

MySQL ORM for Node.js
http://ziti.ewdl.org/
MIT License
3 stars 0 forks source link

Auto migrate delColumns option does not work with foreign keys #10

Open shaoner opened 9 years ago

shaoner commented 9 years ago

When deleting a foreign key column, an exception is thrown: Unhandled rejection Error: ER_FK_COLUMN_CANNOT_DROP: Cannot drop column 'user_id': needed in a foreign key constraint 'relationship_ibfk_1'

Need to use for foreign keys:

ALTER TABLE table_name DROP FOREIGN KEY constraint_name