sql
...
PRIMARY KEY (id),
FOREIGN KEY (logId) REFERENCES table_a(id)
...

...
PRIMARY KEY (id),
FOREIGN KEY (orderId) REFERENCES table_a(id)
...

#---------- UP ----------
ALTER TABLE xxx DROP CONSTRAINT ; ALTER TABLE `xxx` ADD CONSTRAINT `xxx_ibfk_1` FOREIGN KEY (`logId`) REFERENCES `xxx1` (`id`); ALTER TABLE `yyy` DROP CONSTRAINT ;
ALTER TABLE xxx ADD CONSTRAINT yyy_ibfk_1 FOREIGN KEY (orderId) REFERENCES yyy1 (id`);
#---------- DOWN ----------
ERROR 1064 (42000) at line 7: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'CONSTRAINT ``' at line 1