ALTER TABLE `orders`
  ADD COLUMN `offer_id` BIGINT UNSIGNED NULL AFTER `number`,
  ADD KEY `orders_offer_id_index` (`offer_id`),
  ADD CONSTRAINT `orders_offer_id_foreign` FOREIGN KEY (`offer_id`) REFERENCES `offers` (`id`) ON DELETE SET NULL;