Untitled

mysql> insert into region_zip (region_id,zip_id) values (1, 294761);
ERROR 1452 (23000): Cannot add or update a child row: a foreign key constraint fails (`cf2_dev/region_zip`, CONSTRAINT `region_zip_FK_2` FOREIGN KEY (`zip_id`) REFERENCES `zip` (`id`))
mysql> select id from zip where id = 294761;
+--------+
| id     |
+--------+
| 294761 |
+--------+
1 row in set (0.00 sec)



CREATE TABLE `region_zip` (
  `id` int(11) NOT NULL auto_increment,
  `region_id` int(11) default NULL,
  `zip_id` int(11) default NULL,
  `distance_from_central_zip` float default '0',
  `transportation` float default '0',
  `surcharge` float default '0',
  `created_at` datetime default NULL,
  `updated_at` datetime default NULL,
  PRIMARY KEY  (`id`),
  KEY `region_zip_FI_1` (`region_id`),
  KEY `region_zip_FI_2` (`zip_id`),
  CONSTRAINT `region_zip_FK_1` FOREIGN KEY (`region_id`) REFERENCES `region` (`id`),
  CONSTRAINT `region_zip_FK_2` FOREIGN KEY (`zip_id`) REFERENCES `zip` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 


CREATE TABLE `zip` (
  `id` int(11) NOT NULL auto_increment,
  `zip` int(11) default NULL,
  `zip_type` text,
  `city` text,
  `city_type` text,
  `state` text,
  `state_code` text,
  `area_code` text,
  `latitude` float default NULL,
  `longitude` float default NULL,
  `tax_rate` float default NULL,
  `deleted` int(11) default NULL,
  `created_at` datetime default NULL,
  `updated_at` datetime default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=366928 DEFAULT CHARSET=latin1