search

dbsrgits / sql-translator

SQL::Translator (SQLFairy)
http://sqlfairy.sourceforge.net/
82 stars 91 forks source link

Turned off foreign key checking in MySQL. #135

Open uehara-delta opened 3 years ago

uehara-delta commented 3 years ago

This turns off foreign key constraint checking in MySQL not only for CREATE TABLE but also for ALTER TABLE and DROP TABLE.

This is because ALTER TABLE and DROP TABLE may also result in errors due to foreign key constraint checking.

Changed the process of changing the foreign_key_checks variable from before and after CREATE TABLE to before and after the entire diff.