CREATE TABLE league_teams(
    team_id INT NOT NULL AUTO_INCREMENT,
    team_name VARCHAR( 30 ) NOT NULL ,
    games_played INT (3) NOT NULL,
    wins INT (3) NOT NULL,
    draws INT (3) NOT NULL,
    loses INT (3) NOT NULL,
  goals_for INT (3) NOT NULL,
  goals_against INT (3) NOT NULL,
  goals_difference INT (3) NOT NULL,
    PRIMARY KEY ( team_id )
  ) ENGINE=INNODB;


CREATE TABLE Test.players(
    player_id INT NOT NULL AUTO_INCREMENT,
    team_id INT,
    player_name VARCHAR(30) NOT NULL,
    goals INT (3) NOT NULL,
    assists INT (3) NOT NULL,
    yellow_cards INT (3) NOT NULL,
    red_cards INT (3) NOT NULL,
    PRIMARY KEY ( player_id ),
    CONSTRAINT FK_PlayerToTeam FOREIGN KEY (team_id)
    REFERENCES league_teams(team_id) ON DELETE SET NULL ON UPDATE CASCADE
) ENGINE=INNODB;