-- Fehlende Spalten zur matches Tabelle hinzufügen
ALTER TABLE matches 
ADD COLUMN api_source VARCHAR(50) DEFAULT 'cnc_community' AFTER replay_url,
ADD COLUMN raw_data JSON NULL AFTER api_source,
ADD COLUMN updated_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP AFTER created_at;

-- Index für api_source hinzufügen
ALTER TABLE matches 
ADD INDEX idx_matches_source (api_source);
