base.myodbc
Sent: Wednesday, December 03, 2003 6:41 AM
Subject: Drop foreign key replication problem
> Hi,
>
> I am running a master and a slave. When I created a foreign key in
> master, it looked like this:
> CONSTRAINT `0_373` FOREIGN KEY (`prefecture_id`) REFERENCES `prefecture`
>
Hi,
I am running a master and a slave. When I created a foreign key in
master, it looked like this:
CONSTRAINT `0_373` FOREIGN KEY (`prefecture_id`) REFERENCES `prefecture`
(`id`)
But on the slave it was like:
CONSTRAINT `0_451` FOREIGN KEY (`prefecture_id`) REFERENCES `prefecture`
(`id`)
The pr