-- Add optional player and league relations to prueferboard
ALTER TABLE `prueferboard`
  ADD COLUMN IF NOT EXISTS `spieler_id` INT NULL AFTER `admin_id`,
  ADD COLUMN IF NOT EXISTS `liga_id` INT NULL AFTER `spieler_id`;

-- Optional indexes for faster joins/filters
CREATE INDEX IF NOT EXISTS `idx_pb_spieler_id` ON `prueferboard` (`spieler_id`);
CREATE INDEX IF NOT EXISTS `idx_pb_liga_id` ON `prueferboard` (`liga_id`);
