ALTER TABLE kit
ADD COLUMN `installedIntoKitComponentId` int(10) NULL DEFAULT null AFTER `autocreated`;
CREATE INDEX `installedIntoKitComponentId` ON `kit`(`installedIntoKitComponentId`) USING BTREE;

ALTER TABLE kitcomponent
  ADD COLUMN `totalCost` float(14,4) NOT NULL DEFAULT 0 AFTER `unitCost`;
CREATE INDEX `totalCost` ON `kitcomponent`(`totalCost`) USING BTREE;

update kitcomponent
set totalCost = qty * unitCost, updated = updated
