ALTER TABLE fleet_assets ADD COLUMN exit_date TEXT NOT NULL DEFAULT '';
ALTER TABLE fleet_assets ADD COLUMN exit_reason TEXT NOT NULL DEFAULT '';
CREATE INDEX IF NOT EXISTS idx_fleet_assets_exit ON fleet_assets(exit_date,status);
PRAGMA optimize;