#
# Table structure for table 'tx_hfcmatches_domain_model_club'
#
CREATE TABLE tx_hfcmatches_domain_model_club
(
    footy_stats_id varchar(100) DEFAULT ''  NOT NULL,
    logo_uri       varchar(500) DEFAULT ''  NOT NULL,
    logo           int(11)      DEFAULT '0' NOT NULL,
    name           varchar(100) DEFAULT ''  NOT NULL
);

#
# Table structure for table 'tx_hfcmatches_domain_model_match'
#
# column 'date' is created automatically from TCA
CREATE TABLE tx_hfcmatches_domain_model_fixture
(
    away_team_footy_stats_id varchar(100) DEFAULT '' NOT NULL,
    away_team_score          tinyint(6)   DEFAULT NULL,
    footy_stats_id           varchar(25)  DEFAULT '' NOT NULL,
    home_team_footy_stats_id varchar(100) DEFAULT '' NOT NULL,
    home_team_score          tinyint(6)   DEFAULT NULL
);

#
# Table structure for table 'tx_hfcmatches_domain_model_leaguescore'
#
CREATE TABLE tx_hfcmatches_domain_model_leaguescore
(
    footy_stats_club_id varchar(100) DEFAULT ''  NOT NULL,
    games_played        tinyint(6)   DEFAULT '0' NOT NULL,
    goals_conceded      tinyint(6)   DEFAULT '0' NOT NULL,
    goals_shot          tinyint(6)   DEFAULT '0' NOT NULL,
    points              tinyint(6)   DEFAULT '0' NOT NULL,
    position            tinyint(6)   DEFAULT '0' NOT NULL
);
