CREATE TABLE eventkalender (
    id INT AUTO_INCREMENT PRIMARY KEY,
    titel VARCHAR(255) NOT NULL,
    infotext TEXT,
    datum DATE NOT NULL,
    startzeit TIME NOT NULL,
    streamer VARCHAR(255) NOT NULL,
    plattform VARCHAR(100) NOT NULL,
    plattform_link VARCHAR(255),
    bild_url VARCHAR(255),
    thema VARCHAR(255)
);

CREATE TABLE eventkalender_matches (
    id INT AUTO_INCREMENT PRIMARY KEY,
    event_id INT NOT NULL,
    uhrzeit TIME NOT NULL,
    spieler1 VARCHAR(100) NOT NULL,
    spieler2 VARCHAR(100) NOT NULL,
    map VARCHAR(100),
    liga VARCHAR(100),
    FOREIGN KEY (event_id) REFERENCES eventkalender(id) ON DELETE CASCADE
);
