-- Migration: Ensure all required columns exist in addons table
-- Date: 2025-11-26
-- Description: Adds any missing columns to the addons table

-- Add transport_url if missing
ALTER TABLE addons 
ADD COLUMN IF NOT EXISTS transport_url VARCHAR(1024) NULL 
AFTER manifest_url;

-- Add manifest_url if missing
ALTER TABLE addons 
ADD COLUMN IF NOT EXISTS manifest_url VARCHAR(1024) NULL 
AFTER resource_identifier;

-- Add resource_identifier if missing
ALTER TABLE addons 
ADD COLUMN IF NOT EXISTS resource_identifier VARCHAR(255) NULL 
AFTER source;

