On Wed, Jun 10, 2009 at 12:21 AM, Mathieu Rene
<mrene_lists@avgs.ca> wrote:
If we look at the message again,
(`fs_lcr/lcr`, CONSTRAINT `carrier_id` FOREIGN KEY (`carrier_id`)
REFERENCES `carriers` (`id`) ON DELETE CASCADE ON UPDATE CASCADE)
And put it into words:
The contrainst names fs_lcr/lcr affecting field carrier_id, and
referencing the id field of the carriers table, fails.
In other words, the value you have for carrier_id does not match any
value of id in the carriers table.
Math
On 10-Jun-09, at 12:13 AM, Diego Viola wrote:
> (`fs_lcr/lcr`, CONSTRAINT `carrier_id` FOREIGN KEY (`carrier_id`)
> REFERENCES `carriers` (`id`) ON DELETE CASCADE ON UPDATE CASCADE)