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 ),
  	FOREIGN KEY (team_name) REFERENCES players(team_name)
  )


CREATE TABLE players(
    player_id INT NOT NULL AUTO_INCREMENT,
  	team_name INT (30) NOT NULL,
    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,
)