-- Guest checkout: make customer_id nullable, add guest fields
ALTER TABLE orders
    MODIFY COLUMN customer_id INT UNSIGNED NULL,
    ADD COLUMN guest_name  VARCHAR(100)  NULL AFTER customer_id,
    ADD COLUMN guest_phone VARCHAR(20)   NULL AFTER guest_name,
    ADD COLUMN guest_email VARCHAR(150)  NULL AFTER guest_phone;