ALTER TABLE `Link` ADD COLUMN `cable_dict_key` INTEGER UNSIGNED DEFAULT NULL AFTER `cable`,
 ADD CONSTRAINT `Link-FK-Cable-Dict` FOREIGN KEY `Link-FK-Cable-Dict` (`cable_dict_key`)
    REFERENCES `Dictionary` (`dict_key`)
    ON DELETE SET NULL
    ON UPDATE CASCADE;

ALTER TABLE `PortCompat` ADD COLUMN `cable_chapter_id` INTEGER UNSIGNED DEFAULT NULL AFTER `type2`,
 ADD CONSTRAINT `PortCompat-FK-Cable-Chapter` FOREIGN KEY `PortCompat-FK-Cable-Chapter` (`cable_chapter_id`)
    REFERENCES `Chapter` (`id`)
    ON DELETE SET NULL
    ON UPDATE CASCADE;