/*================================================================================*/
/* SQL CREATE SCRIPT                                                              */
/*================================================================================*/
/* Title:      XTOSS                                                              */
/* Filename:   xtoss3.hf                                                          */
/* Platform:   MySQL 3                                                            */
/* Generated:  Tuesday, April 26, 2005                                            */
/*================================================================================*/

/*================================================================================*/
/* Tables                                                                         */
/*================================================================================*/

CREATE TABLE affiliation_phases (
    id INTEGER AUTO_INCREMENT NOT NULL,
    team_id INTEGER AUTO_INCREMENT NOT NULL,
    start_season_id INTEGER AUTO_INCREMENT NOT NULL,
    end_season_id INTEGER AUTO_INCREMENT NOT NULL,
    affiliation_id INTEGER AUTO_INCREMENT NOT NULL,
    PRIMARY KEY (id)
);

CREATE TABLE affiliations (
    id INTEGER AUTO_INCREMENT NOT NULL,
    affiliation_key VARCHAR(40) NOT NULL,
    name VARCHAR(40),
    alias VARCHAR(40),
    abbreviation VARCHAR(40),
    type VARCHAR(40),
    parent_id INTEGER,
    PRIMARY KEY (id)
);

CREATE TABLE doc_classes (
    id INTEGER AUTO_INCREMENT NOT NULL,
    name VARCHAR(40),
    PRIMARY KEY (id)
);

CREATE TABLE documents (
    id INTEGER AUTO_INCREMENT NOT NULL,
    publisher_id INTEGER NOT NULL,
    date_time VARCHAR(40),
    title VARCHAR(40),
    language VARCHAR(40),
    priority VARCHAR(40),
    revision_id VARCHAR(40),
    stats_coverage VARCHAR(40),
    fixture_id INTEGER AUTO_INCREMENT NOT NULL,
    sportsml_path VARCHAR(40),
    abstract VARCHAR(40),
    PRIMARY KEY (id)
);

CREATE TABLE documents_affiliations (
    document_id INTEGER AUTO_INCREMENT NOT NULL,
    affiliation_id INTEGER AUTO_INCREMENT NOT NULL,
    PRIMARY KEY (document_id, affiliation_id)
);

CREATE TABLE documents_leagues (
    document_id INTEGER AUTO_INCREMENT NOT NULL,
    league_id INTEGER AUTO_INCREMENT NOT NULL,
    PRIMARY KEY (document_id, league_id)
);

CREATE TABLE documents_teams (
    document_id INTEGER AUTO_INCREMENT NOT NULL,
    team_id INTEGER AUTO_INCREMENT NOT NULL,
    PRIMARY KEY (document_id, team_id)
);

CREATE TABLE events (
    id INTEGER AUTO_INCREMENT NOT NULL,
    event_key VARCHAR(20),
    publisher_id INTEGER NOT NULL,
    site_key INTEGER NOT NULL,
    start_date_time VARCHAR(20),
    site_alignment VARCHAR(20),
    event_status VARCHAR(20),
    duration VARCHAR(20),
    attendance VARCHAR(20),
    PRIMARY KEY (id)
);

CREATE TABLE events_affiliations (
    event_id INTEGER AUTO_INCREMENT NOT NULL,
    affiliation_id INTEGER AUTO_INCREMENT NOT NULL,
    PRIMARY KEY (event_id, affiliation_id)
);

CREATE TABLE events_fixtures (
    event_id INTEGER AUTO_INCREMENT NOT NULL,
    fixture_id INTEGER AUTO_INCREMENT NOT NULL,
    document_id INTEGER AUTO_INCREMENT NOT NULL,
    PRIMARY KEY (event_id, fixture_id)
);

CREATE TABLE events_leagues (
    event_id INTEGER AUTO_INCREMENT NOT NULL,
    league_id INTEGER AUTO_INCREMENT NOT NULL,
    sub_season_id INTEGER AUTO_INCREMENT NOT NULL,
    PRIMARY KEY (event_id, league_id)
);

CREATE TABLE events_players (
    event_id INTEGER AUTO_INCREMENT NOT NULL,
    player_id INTEGER AUTO_INCREMENT NOT NULL,
    score VARCHAR(40),
    PRIMARY KEY (event_id, player_id)
);

CREATE TABLE events_players_subscores (
    id VARCHAR(40) BINARY NOT NULL,
    event_id VARCHAR(40),
    player_id INTEGER AUTO_INCREMENT NOT NULL,
    period VARCHAR(40),
    score VARCHAR(40),
    PRIMARY KEY (id)
);

CREATE TABLE events_teams (
    event_id INTEGER AUTO_INCREMENT NOT NULL,
    team_id INTEGER AUTO_INCREMENT NOT NULL,
    alignment VARCHAR(40),
    score VARCHAR(40),
    PRIMARY KEY (event_id, team_id)
);

CREATE TABLE events_teams_subscores (
    id VARCHAR(40) BINARY NOT NULL,
    event_id INTEGER AUTO_INCREMENT NOT NULL,
    team_id INTEGER AUTO_INCREMENT NOT NULL,
    period VARCHAR(40),
    score VARCHAR(40),
    PRIMARY KEY (id)
);

CREATE TABLE fixtures (
    id INTEGER AUTO_INCREMENT NOT NULL,
    fixture_key VARCHAR(40),
    publisher_id INTEGER NOT NULL,
    name VARCHAR(40),
    doc_class_id INTEGER AUTO_INCREMENT NOT NULL,
    PRIMARY KEY (id)
);

CREATE TABLE injury_phases (
    id INTEGER AUTO_INCREMENT NOT NULL,
    player_id INTEGER AUTO_INCREMENT NOT NULL,
    injury_status VARCHAR(20),
    injury_type VARCHAR(20),
    injury_comment VARCHAR(20),
    disabled_list VARCHAR(20),
    start_date_time VARCHAR(20),
    end_date_time VARCHAR(20),
    season_id INTEGER AUTO_INCREMENT NOT NULL,
    PRIMARY KEY (id)
);

CREATE TABLE league_phases (
    id INTEGER AUTO_INCREMENT NOT NULL,
    player_id INTEGER AUTO_INCREMENT NOT NULL,
    league_key INTEGER NOT NULL,
    start_date_time VARCHAR(20),
    start_season_id INTEGER AUTO_INCREMENT NOT NULL,
    end_date_time VARCHAR(20),
    end_season_id INTEGER AUTO_INCREMENT NOT NULL,
    PRIMARY KEY (id)
);

CREATE TABLE leagues (
    id INTEGER AUTO_INCREMENT NOT NULL,
    league_key INTEGER NOT NULL,
    publisher_id INTEGER NOT NULL,
    name VARCHAR(40),
    alias VARCHAR(40),
    abbreviation VARCHAR(40),
    PRIMARY KEY (id)
);

CREATE TABLE leagues_affiliations (
    league_id INTEGER AUTO_INCREMENT NOT NULL,
    affiliation_id INTEGER AUTO_INCREMENT NOT NULL,
    PRIMARY KEY (league_id, affiliation_id)
);

CREATE TABLE players (
    id INTEGER AUTO_INCREMENT NOT NULL,
    player_key VARCHAR(20) NOT NULL,
    publisher_id INTEGER NOT NULL,
    given_name VARCHAR(20),
    middle_name VARCHAR(20),
    family_name VARCHAR(20),
    nickname VARCHAR(20),
    full_name VARCHAR(20),
    birth_date VARCHAR(20),
    gender VARCHAR(20),
    birth_city VARCHAR(20),
    birth_state VARCHAR(20),
    birth_country VARCHAR(20),
    death_date VARCHAR(20),
    current_injury_phase_id INTEGER AUTO_INCREMENT,
    current_team_phase_id INTEGER AUTO_INCREMENT,
    current_league_phase_id INTEGER AUTO_INCREMENT,
    PRIMARY KEY (id)
);

CREATE TABLE publishers (
    id INTEGER NOT NULL,
    publisher_name VARCHAR(40),
    PRIMARY KEY (id)
);

CREATE TABLE revisions (
    revision_id INTEGER AUTO_INCREMENT NOT NULL,
    most_recent_document_id INTEGER AUTO_INCREMENT NOT NULL,
    PRIMARY KEY (revision_id)
);

CREATE TABLE seasons (
    id INTEGER AUTO_INCREMENT NOT NULL,
    season_key INTEGER NOT NULL,
    publisher_id INTEGER NOT NULL,
    league_id INTEGER AUTO_INCREMENT NOT NULL,
    start_date_time VARCHAR(40),
    end_date_time VARCHAR(40),
    PRIMARY KEY (id)
);

CREATE TABLE sites (
    id INTEGER AUTO_INCREMENT NOT NULL,
    site_key INTEGER NOT NULL,
    publisher_id INTEGER NOT NULL,
    name VARCHAR(40),
    country INTEGER NOT NULL,
    state_province INTEGER NOT NULL,
    city VARCHAR(40),
    postal_code VARCHAR(40),
    postal_code_extension VARCHAR(40),
    timezone VARCHAR(40),
    address_1 VARCHAR(40),
    address_2 VARCHAR(40),
    PRIMARY KEY (id)
);

CREATE TABLE stats (
    id INTEGER AUTO_INCREMENT NOT NULL,
    stat_table_name VARCHAR(40),
    stat_holder_type VARCHAR(40),
    stat_holder_id VARCHAR(40),
    stat_coverage_type VARCHAR(40),
    stat_coverage_id VARCHAR(40),
    PRIMARY KEY (id)
);

CREATE TABLE stats_american_football_defensive (
    stat_id INTEGER AUTO_INCREMENT NOT NULL,
    tackles_total VARCHAR(40),
    tackles_solo VARCHAR(40),
    tackles_assists VARCHAR(40),
    interceptions_total VARCHAR(40),
    interceptions_yards VARCHAR(40),
    interceptions_average VARCHAR(40),
    interceptions_longest VARCHAR(40),
    interceptions_touchdown VARCHAR(40),
    quarterback_hurries VARCHAR(40),
    sacks_total VARCHAR(40),
    sacks_yards VARCHAR(40),
    passes_defensed VARCHAR(40)
);

CREATE TABLE stats_american_football_down_progress (
    stat_id INTEGER AUTO_INCREMENT NOT NULL,
    first_downs_total VARCHAR(40),
    first_downs_pass VARCHAR(40),
    first_downs_run VARCHAR(40),
    first_downs_penalty VARCHAR(40),
    conversions_third_down VARCHAR(40),
    conversions_third_down_attempts VARCHAR(40),
    conversions_third_down_percentage VARCHAR(40),
    conversions_fourth_down VARCHAR(40),
    conversions_fourth_down_attempts VARCHAR(40),
    conversions_fourth_down_percentage VARCHAR(40)
);

CREATE TABLE stats_american_football_fumbles (
    stat_id INTEGER AUTO_INCREMENT NOT NULL,
    fumbles_committed VARCHAR(40),
    fumbles_forced VARCHAR(40),
    fumbles_recovered VARCHAR(40),
    fumbles_lost VARCHAR(40),
    fumbles_yards_gained VARCHAR(40),
    fumbles_own_committed VARCHAR(40),
    fumbles_own_recovered VARCHAR(40),
    fumbles_own_lost VARCHAR(40),
    fumbles_own_yards_gained VARCHAR(40),
    fumbles_opposing_committed VARCHAR(40),
    fumbles_opposing_recovered VARCHAR(40),
    fumbles_opposing_lost VARCHAR(40),
    fumbles_opposing_yards_gained VARCHAR(40)
);

CREATE TABLE stats_american_football_offensive (
    stat_id INTEGER AUTO_INCREMENT NOT NULL,
    offensive_plays_yards VARCHAR(40),
    offensive_plays_number VARCHAR(40),
    offensive_plays_average_yards_per VARCHAR(40),
    possession_duration VARCHAR(40),
    turnovers_giveaway VARCHAR(40)
);

CREATE TABLE stats_american_football_passing (
    stat_id INTEGER AUTO_INCREMENT NOT NULL,
    passes_attempts VARCHAR(40),
    passes_completions VARCHAR(40),
    passes_percentage VARCHAR(40),
    passes_yards_gross VARCHAR(40),
    passes_yards_net VARCHAR(40),
    passes_yards_lost VARCHAR(40),
    passes_touchdowns VARCHAR(40),
    passes_touchdowns_percentage VARCHAR(40),
    passes_interceptions VARCHAR(40),
    passes_interceptions_percentage VARCHAR(40),
    passes_longest VARCHAR(40),
    passes_average_yards_per VARCHAR(40),
    passer_rating VARCHAR(40),
    receptions_total VARCHAR(40),
    receptions_yards VARCHAR(40),
    receptions_touchdowns VARCHAR(40),
    receptions_first_down VARCHAR(40),
    receptions_longest VARCHAR(40),
    receptions_average_yards_per VARCHAR(40)
);

CREATE TABLE stats_american_football_penalties (
    stat_id INTEGER AUTO_INCREMENT NOT NULL,
    penalties_total VARCHAR(40),
    penalty_yards VARCHAR(40),
    penalty_first_downs VARCHAR(40)
);

CREATE TABLE stats_american_football_rushing (
    stat_id INTEGER AUTO_INCREMENT NOT NULL,
    rushes_attempts VARCHAR(40),
    rushes_yards VARCHAR(40),
    rushes_touchdowns VARCHAR(40),
    rushing_average_yards_per VARCHAR(40),
    rushes_first_down VARCHAR(40),
    rushes_longest VARCHAR(40)
);

CREATE TABLE stats_american_football_sacks_against (
    stat_id INTEGER AUTO_INCREMENT NOT NULL,
    sacks_against_yards VARCHAR(40),
    sacks_against_total VARCHAR(40)
);

CREATE TABLE stats_american_football_scoring (
    stat_id INTEGER AUTO_INCREMENT NOT NULL,
    touchdowns_total VARCHAR(40),
    touchdowns_passing VARCHAR(40),
    touchdowns_rushing VARCHAR(40),
    touchdowns_special_teams VARCHAR(40),
    touchdowns_defensive VARCHAR(40),
    extra_points_attempts VARCHAR(40),
    extra_points_made VARCHAR(40),
    extra_points_missed VARCHAR(40),
    extra_points_blocked VARCHAR(40),
    field_goal_attempts VARCHAR(40),
    field_goals_made VARCHAR(40),
    field_goals_missed VARCHAR(40),
    field_goals_blocked VARCHAR(40),
    safeties_against VARCHAR(40),
    two_point_conversions_attempts VARCHAR(40),
    two_point_conversions_made VARCHAR(40),
    touchbacks_total VARCHAR(40)
);

CREATE TABLE stats_american_football_special_teams (
    stat_id INTEGER AUTO_INCREMENT NOT NULL,
    returns_punt_total VARCHAR(40),
    returns_punt_yards VARCHAR(40),
    returns_punt_average VARCHAR(40),
    returns_punt_longest VARCHAR(40),
    returns_punt_touchdown VARCHAR(40),
    returns_kickoff_total VARCHAR(40),
    returns_kickoff_yards VARCHAR(40),
    returns_kickoff_average VARCHAR(40),
    returns_kickoff_longest VARCHAR(40),
    returns_kickoff_touchdown VARCHAR(40),
    returns_total VARCHAR(40),
    returns_yards VARCHAR(40),
    punts_total VARCHAR(40),
    punts_yards_gross VARCHAR(40),
    punts_yards_net VARCHAR(40),
    punts_longest VARCHAR(40),
    punts_inside_20 VARCHAR(40),
    punts_inside_20_percentage VARCHAR(40),
    punts_average VARCHAR(40),
    punts_blocked VARCHAR(40),
    touchbacks_total VARCHAR(40),
    touchbacks_total_percentage VARCHAR(40),
    touchbacks_kickoffs VARCHAR(40),
    touchbacks_kickoffs_percentage VARCHAR(40),
    touchbacks_punts VARCHAR(40),
    touchbacks_punts_percentage VARCHAR(40),
    touchbacks_interceptions VARCHAR(40),
    touchbacks_interceptions_percentage VARCHAR(40),
    fair_catches VARCHAR(40)
);

CREATE TABLE stats_baseball_defensive (
    stat_id INTEGER AUTO_INCREMENT NOT NULL,
    double_plays VARCHAR(40),
    triple_plays VARCHAR(40),
    putouts VARCHAR(40),
    assists VARCHAR(40),
    errors VARCHAR(40),
    fielding_percentage VARCHAR(40),
    defensive_average VARCHAR(40),
    errors_passed_ball VARCHAR(40),
    errors_catchers_interference VARCHAR(40)
);

CREATE TABLE stats_baseball_offensive (
    stat_id INTEGER AUTO_INCREMENT NOT NULL,
    average VARCHAR(40),
    runs_scored VARCHAR(40),
    at_bats VARCHAR(40),
    hits VARCHAR(40),
    rbi VARCHAR(40),
    total_bases VARCHAR(40),
    slugging_percentage VARCHAR(40),
    bases_on_balls VARCHAR(40),
    strikeouts VARCHAR(40),
    left_on_base VARCHAR(40),
    left_in_scoring_position VARCHAR(40),
    singles VARCHAR(40),
    doubles VARCHAR(40),
    triples VARCHAR(40),
    home_runs VARCHAR(40),
    grand_slams VARCHAR(40),
    at_bats_per_rbi VARCHAR(40),
    plate_appearances_per_rbi VARCHAR(40),
    at_bats_per_home_run VARCHAR(40),
    plate_appearances_per_home_run VARCHAR(40),
    sac_flies VARCHAR(40),
    sac_bunts VARCHAR(40),
    grounded_into_double_play VARCHAR(40),
    moved_up VARCHAR(40),
    on_base_percentage VARCHAR(40),
    stolen_bases VARCHAR(40),
    stolen_bases_caught VARCHAR(40),
    stolen_bases_average VARCHAR(40),
    hit_by_pitch VARCHAR(40),
    defensive_interferance_reaches VARCHAR(40),
    on_base_plus_slugging VARCHAR(40),
    plate_appearances VARCHAR(40),
    hits_extra_base VARCHAR(40)
);

CREATE TABLE stats_baseball_pitching (
    stat_id INTEGER AUTO_INCREMENT NOT NULL,
    runs_allowed VARCHAR(40),
    home_runs_allowed VARCHAR(40),
    innings_pitched VARCHAR(40),
    hits VARCHAR(40),
    earned_runs VARCHAR(40),
    unearned_runs VARCHAR(40),
    bases_on_balls VARCHAR(40),
    bases_on_balls_intentional VARCHAR(40),
    strikeouts VARCHAR(40),
    strikeout_to_bb_ratio VARCHAR(40),
    number_of_pitches VARCHAR(40),
    era VARCHAR(40),
    inherited_runners_scored VARCHAR(40),
    pick_offs VARCHAR(40),
    errors_hit_with_pitch VARCHAR(40),
    errors_wild_pitch VARCHAR(40),
    balks VARCHAR(40),
    wins VARCHAR(40),
    losses VARCHAR(40),
    saves VARCHAR(40),
    shutouts VARCHAR(40),
    games_complete VARCHAR(40),
    games_finished VARCHAR(40),
    winning_percentage VARCHAR(40),
    event_credit VARCHAR(40),
    save_credit VARCHAR(40)
);

CREATE TABLE stats_team (
    stat_id INTEGER AUTO_INCREMENT NOT NULL,
    score VARCHAR(40),
    score_opposing VARCHAR(40),
    score_attempts VARCHAR(40),
    score_attempts_opposing VARCHAR(40),
    score_percentage VARCHAR(40),
    score_percentage_opposing VARCHAR(40)
);

CREATE TABLE stats_team_american_football (
    stat_id INTEGER AUTO_INCREMENT NOT NULL,
    yards_per_attempt VARCHAR(40),
    average_starting_position VARCHAR(40),
    timeouts VARCHAR(40),
    time_of_possession VARCHAR(40),
    turnover_ratio VARCHAR(40)
);

CREATE TABLE sub_seasons (
    id INTEGER AUTO_INCREMENT NOT NULL,
    season_id INTEGER AUTO_INCREMENT NOT NULL,
    type VARCHAR(20) NOT NULL,
    start_date_time VARCHAR(20),
    end_date_time VARCHAR(20),
    PRIMARY KEY (id)
);

CREATE TABLE team_phases (
    id INTEGER AUTO_INCREMENT NOT NULL,
    player_id INTEGER AUTO_INCREMENT NOT NULL,
    team_id INTEGER AUTO_INCREMENT NOT NULL,
    uniform_number VARCHAR(20),
    regular_position VARCHAR(20),
    start_date_time VARCHAR(20),
    start_season_id INTEGER AUTO_INCREMENT NOT NULL,
    end_date_time VARCHAR(20),
    end_season_id INTEGER AUTO_INCREMENT NOT NULL,
    height VARCHAR(40),
    weight VARCHAR(40),
    PRIMARY KEY (id)
);

CREATE TABLE teams (
    id INTEGER AUTO_INCREMENT NOT NULL,
    team_key VARCHAR(20) NOT NULL,
    publisher_id INTEGER NOT NULL,
    first_name VARCHAR(20),
    last_name VARCHAR(20),
    abbreviation VARCHAR(20),
    short_name VARCHAR(20),
    home_site_id INTEGER AUTO_INCREMENT NOT NULL,
    league_id INTEGER AUTO_INCREMENT NOT NULL,
    PRIMARY KEY (id)
);

CREATE TABLE teams_affiliations (
    team_id INTEGER AUTO_INCREMENT NOT NULL,
    affiliation_id INTEGER AUTO_INCREMENT NOT NULL,
    PRIMARY KEY (team_id, affiliation_id)
);

CREATE TABLE wagering_moneylines (
    id INTEGER AUTO_INCREMENT NOT NULL,
    bookmaker_key VARCHAR(40),
    event_id INTEGER AUTO_INCREMENT NOT NULL,
    date_time VARCHAR(40),
    team_id INTEGER AUTO_INCREMENT NOT NULL,
    player_id INTEGER AUTO_INCREMENT NOT NULL,
    rotation_number VARCHAR(40),
    comment VARCHAR(40),
    vigorish VARCHAR(40),
    line VARCHAR(40),
    line_opening VARCHAR(40),
    prediction VARCHAR(40),
    PRIMARY KEY (id)
);

CREATE TABLE wagering_odds_lines (
    id INTEGER AUTO_INCREMENT NOT NULL,
    bookmaker_key VARCHAR(40),
    event_id INTEGER AUTO_INCREMENT NOT NULL,
    date_time VARCHAR(40),
    team_id INTEGER AUTO_INCREMENT NOT NULL,
    player_id INTEGER AUTO_INCREMENT NOT NULL,
    rotation_number VARCHAR(40),
    comment VARCHAR(40),
    numerator VARCHAR(40),
    denominator VARCHAR(40),
    prediction VARCHAR(40),
    payout_calculation VARCHAR(40),
    payout_amount VARCHAR(40),
    PRIMARY KEY (id)
);

CREATE TABLE wagering_runlines (
    id INTEGER AUTO_INCREMENT NOT NULL,
    bookmaker_key VARCHAR(40),
    event_id INTEGER AUTO_INCREMENT NOT NULL,
    date_time VARCHAR(40),
    team_id INTEGER AUTO_INCREMENT NOT NULL,
    player_id INTEGER AUTO_INCREMENT NOT NULL,
    rotation_number VARCHAR(40),
    comment VARCHAR(40),
    vigorish VARCHAR(40),
    line VARCHAR(40),
    line_opening VARCHAR(40),
    value VARCHAR(40),
    prediction VARCHAR(40),
    PRIMARY KEY (id)
);

CREATE TABLE wagering_straight_spread_lines (
    id INTEGER AUTO_INCREMENT NOT NULL,
    bookmaker_key VARCHAR(40),
    event_id INTEGER AUTO_INCREMENT NOT NULL,
    date_time VARCHAR(40),
    team_id INTEGER AUTO_INCREMENT NOT NULL,
    player_id INTEGER AUTO_INCREMENT NOT NULL,
    rotation_number VARCHAR(40),
    comment VARCHAR(40),
    vigorish VARCHAR(40),
    value VARCHAR(40),
    value_opening VARCHAR(40),
    prediction VARCHAR(40),
    PRIMARY KEY (id)
);

CREATE TABLE wagering_total_score_lines (
    id INTEGER AUTO_INCREMENT NOT NULL,
    bookmaker_key VARCHAR(40),
    event_id INTEGER AUTO_INCREMENT NOT NULL,
    date_time VARCHAR(40),
    team_id INTEGER AUTO_INCREMENT NOT NULL,
    player_id INTEGER AUTO_INCREMENT NOT NULL,
    rotation_number VARCHAR(40),
    comment VARCHAR(40),
    vigorish VARCHAR(40),
    line_over VARCHAR(40),
    line_under VARCHAR(40),
    total VARCHAR(40),
    total_opening VARCHAR(40),
    prediction VARCHAR(40),
    PRIMARY KEY (id)
);

CREATE TABLE weather_conditions (
    id INTEGER AUTO_INCREMENT NOT NULL,
    event_id VARCHAR(20),
    temperature VARCHAR(20),
    humidity VARCHAR(20),
    clouds VARCHAR(20),
    wind_direction VARCHAR(20),
    wind_velocity VARCHAR(20),
    PRIMARY KEY (id)
);

/*================================================================================*/
/* Foreignkeys                                                                    */
/*================================================================================*/

ALTER TABLE affiliation_phases
    ADD FOREIGN KEY (affiliation_id) REFERENCES affiliations (id);

ALTER TABLE teams_affiliations
    ADD FOREIGN KEY (affiliation_id) REFERENCES affiliations (id);

ALTER TABLE events_affiliations
    ADD FOREIGN KEY (affiliation_id) REFERENCES affiliations (id);

ALTER TABLE leagues_affiliations
    ADD FOREIGN KEY (affiliation_id) REFERENCES affiliations (id);

ALTER TABLE documents_affiliations
    ADD FOREIGN KEY (affiliation_id) REFERENCES affiliations (id);

ALTER TABLE fixtures
    ADD FOREIGN KEY (doc_class_id) REFERENCES doc_classes (id);

ALTER TABLE revisions
    ADD FOREIGN KEY (most_recent_document_id) REFERENCES documents (id);

ALTER TABLE revisions
    ADD FOREIGN KEY (revision_id) REFERENCES documents (id);

ALTER TABLE documents_leagues
    ADD FOREIGN KEY (document_id) REFERENCES documents (id);

ALTER TABLE documents_teams
    ADD FOREIGN KEY (document_id) REFERENCES documents (id);

ALTER TABLE documents_affiliations
    ADD FOREIGN KEY (document_id) REFERENCES documents (id);

ALTER TABLE events_fixtures
    ADD FOREIGN KEY (document_id) REFERENCES documents (id);

ALTER TABLE weather_conditions
    ADD FOREIGN KEY (event_id) REFERENCES events (id);

ALTER TABLE events_players_subscores
    ADD FOREIGN KEY (event_id) REFERENCES events (id);

ALTER TABLE events_players
    ADD FOREIGN KEY (event_id) REFERENCES events (id);

ALTER TABLE events_teams_subscores
    ADD FOREIGN KEY (event_id) REFERENCES events (id);

ALTER TABLE events_leagues
    ADD FOREIGN KEY (event_id) REFERENCES events (id);

ALTER TABLE events_affiliations
    ADD FOREIGN KEY (event_id) REFERENCES events (id);

ALTER TABLE events_teams
    ADD FOREIGN KEY (event_id) REFERENCES events (id);

ALTER TABLE events_fixtures
    ADD FOREIGN KEY (event_id) REFERENCES events (id);

ALTER TABLE wagering_moneylines
    ADD FOREIGN KEY (event_id) REFERENCES events (id);

ALTER TABLE wagering_straight_spread_lines
    ADD FOREIGN KEY (event_id) REFERENCES events (id);

ALTER TABLE wagering_odds_lines
    ADD FOREIGN KEY (event_id) REFERENCES events (id);

ALTER TABLE wagering_total_score_lines
    ADD FOREIGN KEY (event_id) REFERENCES events (id);

ALTER TABLE wagering_runlines
    ADD FOREIGN KEY (event_id) REFERENCES events (id);

ALTER TABLE documents
    ADD FOREIGN KEY (fixture_id) REFERENCES fixtures (id);

ALTER TABLE events_fixtures
    ADD FOREIGN KEY (fixture_id) REFERENCES fixtures (id);

ALTER TABLE players
    ADD FOREIGN KEY (current_injury_phase_id) REFERENCES injury_phases (id);

ALTER TABLE players
    ADD FOREIGN KEY (current_league_phase_id) REFERENCES league_phases (id);

ALTER TABLE league_phases
    ADD FOREIGN KEY (league_key) REFERENCES leagues (league_key);

ALTER TABLE teams
    ADD FOREIGN KEY (league_id) REFERENCES leagues (id);

ALTER TABLE seasons
    ADD FOREIGN KEY (league_id) REFERENCES leagues (id);

ALTER TABLE events_leagues
    ADD FOREIGN KEY (league_id) REFERENCES leagues (id);

ALTER TABLE leagues_affiliations
    ADD FOREIGN KEY (league_id) REFERENCES leagues (id);

ALTER TABLE documents_leagues
    ADD FOREIGN KEY (league_id) REFERENCES leagues (id);

ALTER TABLE team_phases
    ADD FOREIGN KEY (player_id) REFERENCES players (id);

ALTER TABLE league_phases
    ADD FOREIGN KEY (player_id) REFERENCES players (id);

ALTER TABLE injury_phases
    ADD FOREIGN KEY (player_id) REFERENCES players (id);

ALTER TABLE events_players
    ADD FOREIGN KEY (player_id) REFERENCES players (id);

ALTER TABLE events_players_subscores
    ADD FOREIGN KEY (player_id) REFERENCES players (id);

ALTER TABLE wagering_moneylines
    ADD FOREIGN KEY (player_id) REFERENCES players (id);

ALTER TABLE wagering_straight_spread_lines
    ADD FOREIGN KEY (player_id) REFERENCES players (id);

ALTER TABLE wagering_odds_lines
    ADD FOREIGN KEY (player_id) REFERENCES players (id);

ALTER TABLE wagering_total_score_lines
    ADD FOREIGN KEY (player_id) REFERENCES players (id);

ALTER TABLE wagering_runlines
    ADD FOREIGN KEY (player_id) REFERENCES players (id);

ALTER TABLE players
    ADD FOREIGN KEY (publisher_id) REFERENCES publishers (id);

ALTER TABLE events
    ADD FOREIGN KEY (publisher_id) REFERENCES publishers (id);

ALTER TABLE sites
    ADD FOREIGN KEY (publisher_id) REFERENCES publishers (id);

ALTER TABLE leagues
    ADD FOREIGN KEY (publisher_id) REFERENCES publishers (id);

ALTER TABLE teams
    ADD FOREIGN KEY (publisher_id) REFERENCES publishers (id);

ALTER TABLE seasons
    ADD FOREIGN KEY (publisher_id) REFERENCES publishers (id);

ALTER TABLE fixtures
    ADD FOREIGN KEY (publisher_id) REFERENCES publishers (id);

ALTER TABLE documents
    ADD FOREIGN KEY (publisher_id) REFERENCES publishers (id);

ALTER TABLE injury_phases
    ADD FOREIGN KEY (season_id) REFERENCES seasons (id);

ALTER TABLE affiliation_phases
    ADD FOREIGN KEY (start_season_id) REFERENCES seasons (id);

ALTER TABLE affiliation_phases
    ADD FOREIGN KEY (end_season_id) REFERENCES seasons (id);

ALTER TABLE league_phases
    ADD FOREIGN KEY (start_season_id) REFERENCES seasons (id);

ALTER TABLE league_phases
    ADD FOREIGN KEY (end_season_id) REFERENCES seasons (id);

ALTER TABLE team_phases
    ADD FOREIGN KEY (start_season_id) REFERENCES seasons (id);

ALTER TABLE team_phases
    ADD FOREIGN KEY (end_season_id) REFERENCES seasons (id);

ALTER TABLE sub_seasons
    ADD FOREIGN KEY (season_id) REFERENCES seasons (id);

ALTER TABLE events
    ADD FOREIGN KEY (site_key) REFERENCES sites (site_key);

ALTER TABLE teams
    ADD FOREIGN KEY (home_site_id) REFERENCES sites (id);

ALTER TABLE stats_baseball_defensive
    ADD FOREIGN KEY (stat_id) REFERENCES stats (id);

ALTER TABLE stats_baseball_pitching
    ADD FOREIGN KEY (stat_id) REFERENCES stats (id);

ALTER TABLE stats_baseball_offensive
    ADD FOREIGN KEY (stat_id) REFERENCES stats (id);

ALTER TABLE stats_team
    ADD FOREIGN KEY (stat_id) REFERENCES stats (id);

ALTER TABLE stats_american_football_defensive
    ADD FOREIGN KEY (stat_id) REFERENCES stats (id);

ALTER TABLE stats_american_football_down_progress
    ADD FOREIGN KEY (stat_id) REFERENCES stats (id);

ALTER TABLE stats_american_football_sacks_against
    ADD FOREIGN KEY (stat_id) REFERENCES stats (id);

ALTER TABLE stats_american_football_fumbles
    ADD FOREIGN KEY (stat_id) REFERENCES stats (id);

ALTER TABLE stats_american_football_special_teams
    ADD FOREIGN KEY (stat_id) REFERENCES stats (id);

ALTER TABLE stats_team_american_football
    ADD FOREIGN KEY (stat_id) REFERENCES stats (id);

ALTER TABLE stats_american_football_penalties
    ADD FOREIGN KEY (stat_id) REFERENCES stats (id);

ALTER TABLE stats_american_football_rushing
    ADD FOREIGN KEY (stat_id) REFERENCES stats (id);

ALTER TABLE stats_american_football_offensive
    ADD FOREIGN KEY (stat_id) REFERENCES stats (id);

ALTER TABLE stats_american_football_passing
    ADD FOREIGN KEY (stat_id) REFERENCES stats (id);

ALTER TABLE stats_american_football_scoring
    ADD FOREIGN KEY (stat_id) REFERENCES stats (id);

ALTER TABLE events_leagues
    ADD FOREIGN KEY (sub_season_id) REFERENCES sub_seasons (id);

ALTER TABLE players
    ADD FOREIGN KEY (current_team_phase_id) REFERENCES team_phases (id);

ALTER TABLE events_teams_subscores
    ADD FOREIGN KEY (team_id) REFERENCES teams (id);

ALTER TABLE affiliation_phases
    ADD FOREIGN KEY (team_id) REFERENCES teams (id);

ALTER TABLE teams_affiliations
    ADD FOREIGN KEY (team_id) REFERENCES teams (id);

ALTER TABLE team_phases
    ADD FOREIGN KEY (team_id) REFERENCES teams (id);

ALTER TABLE events_teams
    ADD FOREIGN KEY (team_id) REFERENCES teams (id);

ALTER TABLE documents_teams
    ADD FOREIGN KEY (team_id) REFERENCES teams (id);

ALTER TABLE wagering_moneylines
    ADD FOREIGN KEY (team_id) REFERENCES teams (id);

ALTER TABLE wagering_straight_spread_lines
    ADD FOREIGN KEY (team_id) REFERENCES teams (id);

ALTER TABLE wagering_odds_lines
    ADD FOREIGN KEY (team_id) REFERENCES teams (id);

ALTER TABLE wagering_total_score_lines
    ADD FOREIGN KEY (team_id) REFERENCES teams (id);

ALTER TABLE wagering_runlines
    ADD FOREIGN KEY (team_id) REFERENCES teams (id);

/*================================================================================*/
/* Indexes                                                                        */
/*================================================================================*/



/* -- END OF SCRIPT -- */