salix/db/versions/11007-greenRose/00-firstScript.sql

CREATE OR REPLACE TABLE `vn`.`farmingDeliveryNote` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `farmingFk` int(10) unsigned NOT NULL,
  `deliveryNoteFk` int(11) NOT NULL,
  `amount` decimal(10,2) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `farmingDeliveryNoteFk_FK` (`deliveryNoteFk`),
  KEY `farmingDeliveryNoteFk_FK_1` (`farmingFk`),
  CONSTRAINT `farmingDeliveryNoteFk_FK` FOREIGN KEY (`deliveryNoteFk`) REFERENCES `deliveryNote` (`id`),
  CONSTRAINT `farmingDeliveryNoteFk_FK_1` FOREIGN KEY (`farmingFk`) REFERENCES `farming` (`id`)
);

INSERT IGNORE INTO `vn`.`farmingDeliveryNote` (farmingFk, deliveryNoteFk, amount)
	SELECT farmingFk, id, amount  
		FROM vn.deliveryNote dn 
		WHERE farmingFk;