-CREATE TYPE turnuesse AS ENUM ('Sommer', 'Winter');
+﻿CREATE TYPE turnuesse AS ENUM ('Sommer', 'Winter');
 
 CREATE TABLE Liga (
     id INTEGER NOT NULL,


    PRIMARY KEY(id)
);

CREATE TABLE Spiel (
    id INTEGER NOT NULL,


    PRIMARY KEY(team_id, spieler_id, trikotnr),
    FOREIGN KEY (team_id) REFERENCES Team(id),
    FOREIGN KEY (spieler_id) REFERENCES Spieler(id)
);

CREATE TABLE erzielt_tor (
