-- =====================================================================
-- Kapitano Logistic integration - Step 7 (payment)
--
--   logistic_order_links   one column added (our own table, step 1):
--                          payment_sent = the payment status Logistic was last
--                          told for the order (paid | unpaid).
--
-- No shop table is touched.
-- Same statement as migration 2026_10_06_000020_add_payment_sent_to_logistic_links.
-- Requires the Step 1 file (kapitano_logistic_integration_2026-10-05.sql) to have run first.
--
-- Run ONCE (MySQL < 8.0.29 has no ADD COLUMN IF NOT EXISTS), or use
-- `php artisan migrate`, which checks the column first.
-- =====================================================================

ALTER TABLE `logistic_order_links`
    ADD COLUMN `payment_sent` VARCHAR(10) NULL;