Re: Drop foreign key replication problem

2003-12-03 Thread Heikki Tuuri
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` >

Drop foreign key replication problem

2003-12-02 Thread Batara Kesuma
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