ALTER TABLE fleet_assets ADD COLUMN ownership_type TEXT NOT NULL DEFAULT 'Propre';
ALTER TABLE fleet_assets ADD COLUMN supplier_id TEXT NOT NULL DEFAULT '';
ALTER TABLE fleet_assets ADD COLUMN ownership_note TEXT NOT NULL DEFAULT '';

CREATE INDEX idx_fleet_assets_ownership ON fleet_assets(ownership_type, supplier_id);