-- Tabelle für Liga-Anmeldungen (wenn noch nicht vorhanden)
CREATE TABLE IF NOT EXISTS liga_anmeldungen (
    id INT AUTO_INCREMENT PRIMARY KEY,
    name VARCHAR(100) NOT NULL,
    discord_tag VARCHAR(100) NOT NULL,
    liga_ids VARCHAR(255) NOT NULL,
    season_played ENUM('ja','nein') NOT NULL,
    season_names VARCHAR(255),
    other_name ENUM('ja','nein') NOT NULL,
    other_name_value VARCHAR(100),
    ip VARCHAR(45) NOT NULL,
    created_at DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP
);
