Dataset about soccerpredictor HOT 1 CLOSED

fixtures_table = """
CREATE TABLE fixtures
( id INT NOT NULL ,
date VARCHAR(200) NOT NULL ,
season VARCHAR(200) NOT NULL ,
league VARCHAR(200) NOT NULL ,
home_goals VARCHAR(200) NOT NULL ,
away_goals VARCHAR(200) NOT NULL ,
oddsDC_1X VARCHAR(200) NOT NULL ,
oddsDC_X2 VARCHAR(200) NOT NULL ,
homeTeamID VARCHAR(200) NOT NULL ,
awayTeamID VARCHAR(200) NOT NULL ,
homeStatsID VARCHAR(200) NOT NULL ,
awayStatsID VARCHAR(200) NOT NULL ,
winner VARCHAR(200) NOT NULL ,
PRIMARY KEY (id));
"""

teams = """CREATE TABLE teams
( id INT NOT NULL ,
name VARCHAR(200) NOT NULL ,
PRIMARY KEY (id)) """

team_stats = """CREATE TABLE teamstats
( id INT NOT NULL ,
rating VARCHAR(200) NOT NULL ,
goals VARCHAR(200) NOT NULL ,
errors VARCHAR(200) NOT NULL ,
red_cards VARCHAR(200) NOT NULL ,
shots VARCHAR(200) NOT NULL ,
fixtureID VARCHAR(200) NOT NULL ,
teamID VARCHAR(200) NOT NULL ,
PRIMARY KEY (id))"""

from soccerpredictor.