ALTER TABLE deliveries ADD COLUMN IF NOT EXISTS scheduled_date DATE NULL AFTER address_id; UPDATE deliveries SET scheduled_date = DATE(LEFT(created_at, 10)) WHERE scheduled_date IS NULL;