-- Normalize existing addon transport URLs
UPDATE addons
SET transport_url = REGEXP_REPLACE(transport_url, '/manifest\.[a-z0-9]+$', '')
WHERE transport_url REGEXP '/manifest\.[a-z0-9]+$';
