CREATE TABLE distributor2manufacturer (
  id int( 10 ) unsigned NOT NULL auto_increment,
  distributor_id int( 10 ) unsigned NOT NULL default '0',
  manufacturer_id int( 10 ) unsigned NOT NULL default '0',
  timestamp timestamp( 14 ) NOT NULL,
  PRIMARY KEY  (id),
  KEY I_m2d_distributor_id (distributor_id),
  KEY I_m2d_manufacturer_id (manufacturer_id),
  CONSTRAINT `FK_d2m_distributor_id` FOREIGN KEY (`distributor_id`) REFERENCES `distributors` (`id`),
  CONSTRAINT `FK_d2m_manufacturer_id` FOREIGN KEY (`manufacturer_id`) REFERENCES `manufacturers` (`id`)
) TYPE=InnoDB;