/*============================================================================*/
/* DDL SCRIPT                                                                 */
/*============================================================================*/
/* Title:      XTOSS                                                          */
/* Filename:   xtoss15.hf                                                     */
/* Platform:   MySQL 3                                                        */
/* Generated:  Friday, October 12, 2007                                       */
/*============================================================================*/

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

CREATE TABLE locations (
    id INTEGER NOT NULL AUTO_INCREMENT,
    timezone VARCHAR(100),
    latitude VARCHAR(100),
    longitude VARCHAR(100),
    country_code VARCHAR(100),
    PRIMARY KEY (id)
);

CREATE TABLE addresses (
    id INTEGER NOT NULL AUTO_INCREMENT AUTO_INCREMENT,
    location_id INTEGER NOT NULL,
    language VARCHAR(100),
    suite VARCHAR(100),
    floor VARCHAR(100),
    building VARCHAR(100),
    street_number VARCHAR(100),
    street_prefix VARCHAR(100),
    street VARCHAR(100),
    street_suffix VARCHAR(100),
    neighborhood VARCHAR(100),
    district VARCHAR(100),
    locality VARCHAR(100),
    county VARCHAR(100),
    region VARCHAR(100),
    postal_code VARCHAR(100),
    country VARCHAR(100),
    PRIMARY KEY (id)
);

CREATE TABLE publishers (
    id INTEGER NOT NULL AUTO_INCREMENT AUTO_INCREMENT,
    publisher_key VARCHAR(100) NOT NULL,
    publisher_name VARCHAR(100),
    PRIMARY KEY (id)
);

CREATE TABLE affiliations (
    id INTEGER NOT NULL AUTO_INCREMENT,
    affiliation_key VARCHAR(100) NOT NULL,
    affiliation_type VARCHAR(100),
    publisher_id INTEGER NOT NULL,
    PRIMARY KEY (id)
);

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

CREATE TABLE affiliation_phases (
    id INTEGER NOT NULL AUTO_INCREMENT,
    affiliation_id INTEGER NOT NULL,
    ancestor_affiliation_id INTEGER,
    start_season_id INTEGER,
    start_date_time DATETIME,
    end_season_id INTEGER,
    end_date_time DATETIME,
    PRIMARY KEY (id)
);

CREATE TABLE document_fixtures (
    id INTEGER NOT NULL AUTO_INCREMENT,
    fixture_key VARCHAR(100),
    publisher_id INTEGER NOT NULL,
    name VARCHAR(100),
    document_class_id INTEGER NOT NULL,
    PRIMARY KEY (id)
);

CREATE TABLE documents (
    id INTEGER NOT NULL AUTO_INCREMENT,
    doc_id VARCHAR(75) NOT NULL,
    publisher_id INTEGER NOT NULL,
    date_time DATETIME,
    title VARCHAR(255),
    language VARCHAR(100),
    priority VARCHAR(100),
    revision_id VARCHAR(75),
    stats_coverage VARCHAR(100),
    document_fixture_id INTEGER NOT NULL,
    source_id INTEGER,
    db_loading_date_time DATETIME,
    PRIMARY KEY (id)
);

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

CREATE TABLE sites (
    id INTEGER NOT NULL AUTO_INCREMENT,
    site_key INTEGER NOT NULL,
    publisher_id INTEGER NOT NULL,
    location_id INTEGER,
    PRIMARY KEY (id)
);

CREATE TABLE events (
    id INTEGER NOT NULL AUTO_INCREMENT,
    event_key VARCHAR(100) NOT NULL,
    publisher_id INTEGER NOT NULL,
    start_date_time DATETIME,
    site_id INTEGER,
    site_alignment VARCHAR(100),
    event_status VARCHAR(100),
    duration VARCHAR(100),
    attendance VARCHAR(100),
    last_update DATETIME,
    PRIMARY KEY (id)
);

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

CREATE TABLE persons (
    id INTEGER NOT NULL AUTO_INCREMENT,
    person_key VARCHAR(100) NOT NULL,
    publisher_id INTEGER NOT NULL,
    gender VARCHAR(20),
    birth_date VARCHAR(30),
    death_date VARCHAR(30),
    birth_location_id INTEGER,
    hometown_location_id INTEGER,
    residence_location_id INTEGER,
    death_location_id INTEGER,
    PRIMARY KEY (id)
);

CREATE TABLE media (
    id INTEGER NOT NULL AUTO_INCREMENT,
    object_id INTEGER,
    source_id INTEGER,
    revision_id INTEGER,
    media_type VARCHAR(100),
    publisher_id INTEGER NOT NULL,
    date_time VARCHAR(100),
    credit_id INTEGER NOT NULL,
    db_loading_date_time DATETIME,
    creation_location_id INTEGER NOT NULL,
    PRIMARY KEY (id)
);

CREATE TABLE affiliations_media (
    affiliation_id INTEGER NOT NULL,
    media_id INTEGER NOT NULL
);

CREATE TABLE teams (
    id INTEGER NOT NULL AUTO_INCREMENT,
    team_key VARCHAR(100) NOT NULL,
    publisher_id INTEGER NOT NULL,
    home_site_id INTEGER,
    PRIMARY KEY (id)
);

CREATE TABLE american_football_event_states (
    id INTEGER NOT NULL AUTO_INCREMENT,
    event_id INTEGER NOT NULL,
    current_state SMALLINT,
    sequence_number INTEGER,
    period_value INTEGER,
    period_time_elapsed VARCHAR(100),
    period_time_remaining VARCHAR(100),
    clock_state VARCHAR(100),
    down INTEGER,
    team_in_possession_id INTEGER,
    distance_for_1st_down INTEGER,
    field_side VARCHAR(100),
    field_line INTEGER,
    context VARCHAR(40),
    PRIMARY KEY (id)
);

CREATE TABLE american_football_action_plays (
    id INTEGER NOT NULL AUTO_INCREMENT,
    american_football_event_state_id INTEGER NOT NULL,
    play_type VARCHAR(100),
    score_attempt_type VARCHAR(100),
    drive_result VARCHAR(100),
    points INTEGER,
    comment VARCHAR(255),
    PRIMARY KEY (id)
);

CREATE TABLE american_football_action_participants (
    id INTEGER NOT NULL AUTO_INCREMENT,
    american_football_action_play_id INTEGER NOT NULL,
    person_id INTEGER NOT NULL,
    participant_role VARCHAR(100) NOT NULL,
    score_type VARCHAR(100),
    field_line INTEGER,
    yardage INTEGER,
    PRIMARY KEY (id)
);

CREATE TABLE american_football_defensive_stats (
    id INTEGER NOT NULL AUTO_INCREMENT,
    tackles_total VARCHAR(100),
    tackles_solo VARCHAR(100),
    tackles_assists VARCHAR(100),
    interceptions_total VARCHAR(100),
    interceptions_yards VARCHAR(100),
    interceptions_average VARCHAR(100),
    interceptions_longest VARCHAR(100),
    interceptions_touchdown VARCHAR(100),
    quarterback_hurries VARCHAR(100),
    sacks_total VARCHAR(100),
    sacks_yards VARCHAR(100),
    passes_defensed VARCHAR(100),
    PRIMARY KEY (id)
);

CREATE TABLE american_football_down_progress_stats (
    id INTEGER NOT NULL AUTO_INCREMENT,
    first_downs_total VARCHAR(100),
    first_downs_pass VARCHAR(100),
    first_downs_run VARCHAR(100),
    first_downs_penalty VARCHAR(100),
    conversions_third_down VARCHAR(100),
    conversions_third_down_attempts VARCHAR(100),
    conversions_third_down_percentage VARCHAR(100),
    conversions_fourth_down VARCHAR(100),
    conversions_fourth_down_attempts VARCHAR(100),
    conversions_fourth_down_percentage VARCHAR(100),
    PRIMARY KEY (id)
);

CREATE TABLE american_football_fumbles_stats (
    id INTEGER NOT NULL AUTO_INCREMENT,
    fumbles_committed VARCHAR(100),
    fumbles_forced VARCHAR(100),
    fumbles_recovered VARCHAR(100),
    fumbles_lost VARCHAR(100),
    fumbles_yards_gained VARCHAR(100),
    fumbles_own_committed VARCHAR(100),
    fumbles_own_recovered VARCHAR(100),
    fumbles_own_lost VARCHAR(100),
    fumbles_own_yards_gained VARCHAR(100),
    fumbles_opposing_committed VARCHAR(100),
    fumbles_opposing_recovered VARCHAR(100),
    fumbles_opposing_lost VARCHAR(100),
    fumbles_opposing_yards_gained VARCHAR(100),
    PRIMARY KEY (id)
);

CREATE TABLE american_football_offensive_stats (
    id INTEGER NOT NULL AUTO_INCREMENT,
    offensive_plays_yards VARCHAR(100),
    offensive_plays_number VARCHAR(100),
    offensive_plays_average_yards_per VARCHAR(100),
    possession_duration VARCHAR(100),
    turnovers_giveaway VARCHAR(100),
    PRIMARY KEY (id)
);

CREATE TABLE american_football_passing_stats (
    id INTEGER NOT NULL AUTO_INCREMENT,
    passes_attempts VARCHAR(100),
    passes_completions VARCHAR(100),
    passes_percentage VARCHAR(100),
    passes_yards_gross VARCHAR(100),
    passes_yards_net VARCHAR(100),
    passes_yards_lost VARCHAR(100),
    passes_touchdowns VARCHAR(100),
    passes_touchdowns_percentage VARCHAR(100),
    passes_interceptions VARCHAR(100),
    passes_interceptions_percentage VARCHAR(100),
    passes_longest VARCHAR(100),
    passes_average_yards_per VARCHAR(100),
    passer_rating VARCHAR(100),
    receptions_total VARCHAR(100),
    receptions_yards VARCHAR(100),
    receptions_touchdowns VARCHAR(100),
    receptions_first_down VARCHAR(100),
    receptions_longest VARCHAR(100),
    receptions_average_yards_per VARCHAR(100),
    PRIMARY KEY (id)
);

CREATE TABLE american_football_penalties_stats (
    id INTEGER NOT NULL AUTO_INCREMENT,
    penalties_total VARCHAR(100),
    penalty_yards VARCHAR(100),
    penalty_first_downs VARCHAR(100),
    PRIMARY KEY (id)
);

CREATE TABLE american_football_rushing_stats (
    id INTEGER NOT NULL AUTO_INCREMENT,
    rushes_attempts VARCHAR(100),
    rushes_yards VARCHAR(100),
    rushes_touchdowns VARCHAR(100),
    rushing_average_yards_per VARCHAR(100),
    rushes_first_down VARCHAR(100),
    rushes_longest VARCHAR(100),
    PRIMARY KEY (id)
);

CREATE TABLE american_football_sacks_against_stats (
    id INTEGER NOT NULL AUTO_INCREMENT,
    sacks_against_yards VARCHAR(100),
    sacks_against_total VARCHAR(100),
    PRIMARY KEY (id)
);

CREATE TABLE american_football_scoring_stats (
    id INTEGER NOT NULL AUTO_INCREMENT,
    touchdowns_total VARCHAR(100),
    touchdowns_passing VARCHAR(100),
    touchdowns_rushing VARCHAR(100),
    touchdowns_special_teams VARCHAR(100),
    touchdowns_defensive VARCHAR(100),
    extra_points_attempts VARCHAR(100),
    extra_points_made VARCHAR(100),
    extra_points_missed VARCHAR(100),
    extra_points_blocked VARCHAR(100),
    field_goal_attempts VARCHAR(100),
    field_goals_made VARCHAR(100),
    field_goals_missed VARCHAR(100),
    field_goals_blocked VARCHAR(100),
    safeties_against VARCHAR(100),
    two_point_conversions_attempts VARCHAR(100),
    two_point_conversions_made VARCHAR(100),
    touchbacks_total VARCHAR(100),
    PRIMARY KEY (id)
);

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

CREATE TABLE baseball_defensive_group (
    id INTEGER NOT NULL AUTO_INCREMENT,
    PRIMARY KEY (id)
);

CREATE TABLE baseball_event_states (
    id INTEGER NOT NULL AUTO_INCREMENT,
    event_id INTEGER NOT NULL,
    current_state SMALLINT,
    sequence_number INTEGER,
    at_bat_number INTEGER,
    inning_value INTEGER,
    inning_half VARCHAR(100),
    outs INTEGER,
    balls INTEGER,
    strikes INTEGER,
    runner_on_first_id INTEGER,
    runner_on_second_id INTEGER,
    runner_on_third_id INTEGER,
    runner_on_first SMALLINT,
    runner_on_second SMALLINT,
    runner_on_third SMALLINT,
    runs_this_inning_half INTEGER,
    pitcher_id INTEGER,
    batter_id INTEGER,
    batter_side VARCHAR(100),
    context VARCHAR(40),
    PRIMARY KEY (id)
);

CREATE TABLE baseball_action_pitches (
    id INTEGER NOT NULL AUTO_INCREMENT,
    baseball_event_state_id INTEGER NOT NULL,
    baseball_defensive_group_id INTEGER,
    umpire_call VARCHAR(100),
    pitch_location VARCHAR(100),
    pitch_type VARCHAR(100),
    pitch_velocity INTEGER,
    comment TEXT,
    trajectory_coordinates VARCHAR(100),
    trajectory_formula VARCHAR(100),
    PRIMARY KEY (id)
);

CREATE TABLE baseball_action_contact_details (
    id INTEGER NOT NULL AUTO_INCREMENT,
    baseball_action_pitch_id INTEGER NOT NULL,
    location VARCHAR(100),
    strength VARCHAR(100),
    velocity INTEGER,
    comment TEXT,
    trajectory_coordinates VARCHAR(100),
    trajectory_formula VARCHAR(100),
    PRIMARY KEY (id)
);

CREATE TABLE baseball_action_plays (
    id INTEGER NOT NULL AUTO_INCREMENT,
    baseball_event_state_id INTEGER NOT NULL,
    play_type VARCHAR(100),
    notation VARCHAR(100),
    notation_yaml TEXT,
    baseball_defensive_group_id INTEGER,
    comment VARCHAR(255),
    runner_on_first_advance INTEGER,
    runner_on_second_advance INTEGER,
    runner_on_third_advance INTEGER,
    outs_recorded INTEGER,
    rbi INTEGER,
    runs_scored INTEGER,
    earned_runs_scored VARCHAR(100),
    PRIMARY KEY (id)
);

CREATE TABLE positions (
    id INTEGER NOT NULL AUTO_INCREMENT,
    affiliation_id INTEGER NOT NULL,
    abbreviation VARCHAR(20) NOT NULL,
    PRIMARY KEY (id)
);

CREATE TABLE baseball_action_substitutions (
    id INTEGER NOT NULL AUTO_INCREMENT,
    baseball_event_state_id INTEGER NOT NULL,
    sequence_number INTEGER,
    person_type VARCHAR(100),
    person_original_id INTEGER,
    person_original_position_id INTEGER,
    person_original_lineup_slot INTEGER,
    person_replacing_id INTEGER,
    person_replacing_position_id INTEGER,
    person_replacing_lineup_slot INTEGER,
    substitution_reason VARCHAR(100),
    comment VARCHAR(100),
    PRIMARY KEY (id)
);

CREATE TABLE baseball_defensive_players (
    id INTEGER NOT NULL AUTO_INCREMENT,
    baseball_defensive_group_id INTEGER NOT NULL,
    player_id INTEGER NOT NULL,
    position_id INTEGER NOT NULL,
    PRIMARY KEY (id)
);

CREATE TABLE baseball_defensive_stats (
    id INTEGER NOT NULL AUTO_INCREMENT,
    double_plays INTEGER,
    triple_plays INTEGER,
    putouts INTEGER,
    assists INTEGER,
    errors INTEGER,
    fielding_percentage FLOAT,
    defensive_average FLOAT,
    errors_passed_ball INTEGER,
    errors_catchers_interference INTEGER,
    PRIMARY KEY (id)
);

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

CREATE TABLE baseball_pitching_stats (
    id INTEGER NOT NULL AUTO_INCREMENT,
    runs_allowed INTEGER,
    singles_allowed INTEGER,
    doubles_allowed INTEGER,
    triples_allowed INTEGER,
    home_runs_allowed INTEGER,
    innings_pitched VARCHAR(20),
    hits INTEGER,
    earned_runs INTEGER,
    unearned_runs INTEGER,
    bases_on_balls INTEGER,
    bases_on_balls_intentional INTEGER,
    strikeouts INTEGER,
    strikeout_to_bb_ratio FLOAT,
    number_of_pitches INTEGER,
    era FLOAT,
    inherited_runners_scored INTEGER,
    pick_offs INTEGER,
    errors_hit_with_pitch INTEGER,
    errors_wild_pitch INTEGER,
    balks INTEGER,
    wins INTEGER,
    losses INTEGER,
    saves INTEGER,
    shutouts INTEGER,
    games_complete INTEGER,
    games_finished INTEGER,
    winning_percentage FLOAT,
    event_credit VARCHAR(40),
    save_credit VARCHAR(40),
    PRIMARY KEY (id)
);

CREATE TABLE basketball_defensive_stats (
    id INTEGER NOT NULL AUTO_INCREMENT,
    steals_total VARCHAR(100),
    steals_per_game VARCHAR(100),
    blocks_total VARCHAR(100),
    blocks_per_game VARCHAR(100),
    PRIMARY KEY (id)
);

CREATE TABLE basketball_event_states (
    id INTEGER NOT NULL AUTO_INCREMENT,
    event_id INTEGER NOT NULL,
    current_state TINYINT,
    sequence_number INTEGER,
    period_value VARCHAR(100),
    period_time_elapsed VARCHAR(100),
    period_time_remaining VARCHAR(100),
    context VARCHAR(40),
    PRIMARY KEY (id)
);

CREATE TABLE basketball_offensive_stats (
    id INTEGER NOT NULL AUTO_INCREMENT,
    field_goals_made INTEGER,
    field_goals_attempted INTEGER,
    field_goals_percentage VARCHAR(100),
    field_goals_per_game VARCHAR(100),
    field_goals_attempted_per_game VARCHAR(100),
    field_goals_percentage_adjusted VARCHAR(100),
    three_pointers_made INTEGER,
    three_pointers_attempted INTEGER,
    three_pointers_percentage VARCHAR(100),
    three_pointers_per_game VARCHAR(100),
    three_pointers_attempted_per_game VARCHAR(100),
    free_throws_made VARCHAR(100),
    free_throws_attempted VARCHAR(100),
    free_throws_percentage VARCHAR(100),
    free_throws_per_game VARCHAR(100),
    free_throws_attempted_per_game VARCHAR(100),
    points_scored_total VARCHAR(100),
    points_scored_per_game VARCHAR(100),
    assists_total VARCHAR(100),
    assists_per_game VARCHAR(100),
    turnovers_total VARCHAR(100),
    turnovers_per_game VARCHAR(100),
    points_scored_off_turnovers VARCHAR(100),
    points_scored_in_paint VARCHAR(100),
    points_scored_on_second_chance VARCHAR(100),
    points_scored_on_fast_break VARCHAR(100),
    PRIMARY KEY (id)
);

CREATE TABLE basketball_rebounding_stats (
    id INTEGER NOT NULL AUTO_INCREMENT,
    rebounds_total VARCHAR(100),
    rebounds_per_game VARCHAR(100),
    rebounds_defensive VARCHAR(100),
    rebounds_offensive VARCHAR(100),
    team_rebounds_total VARCHAR(100),
    team_rebounds_per_game VARCHAR(100),
    team_rebounds_defensive VARCHAR(100),
    team_rebounds_offensive VARCHAR(100),
    PRIMARY KEY (id)
);

CREATE TABLE basketball_team_stats (
    id INTEGER NOT NULL AUTO_INCREMENT,
    timeouts_left VARCHAR(100),
    largest_lead VARCHAR(100),
    fouls_total VARCHAR(100),
    turnover_margin VARCHAR(100),
    PRIMARY KEY (id)
);

CREATE TABLE bookmakers (
    id INTEGER NOT NULL AUTO_INCREMENT,
    bookmaker_key VARCHAR(100),
    publisher_id INTEGER NOT NULL,
    location_id INTEGER,
    PRIMARY KEY (id)
);

CREATE TABLE core_person_stats (
    id INTEGER NOT NULL AUTO_INCREMENT,
    time_played_event VARCHAR(40),
    time_played_total VARCHAR(40),
    time_played_event_average VARCHAR(40),
    events_played INTEGER,
    events_started INTEGER,
    position_id INTEGER NOT NULL,
    PRIMARY KEY (id)
);

CREATE TABLE core_stats (
    id INTEGER NOT NULL AUTO_INCREMENT,
    score VARCHAR(100),
    score_opposing VARCHAR(100),
    score_attempts VARCHAR(100),
    score_attempts_opposing VARCHAR(100),
    score_percentage VARCHAR(100),
    score_percentage_opposing VARCHAR(100),
    PRIMARY KEY (id)
);

CREATE TABLE db_info (
    version VARCHAR(100) NOT NULL DEFAULT 12
);

CREATE TABLE display_names (
    id INTEGER NOT NULL AUTO_INCREMENT,
    language VARCHAR(100) NOT NULL,
    entity_type VARCHAR(100) NOT NULL,
    entity_id INTEGER NOT NULL,
    full_name VARCHAR(100),
    first_name VARCHAR(100),
    middle_name VARCHAR(100),
    last_name VARCHAR(100),
    alias VARCHAR(100),
    abbreviation VARCHAR(100),
    short_name VARCHAR(100),
    prefix VARCHAR(20),
    suffix VARCHAR(20),
    PRIMARY KEY (id)
);

CREATE TABLE document_classes (
    id INTEGER NOT NULL AUTO_INCREMENT,
    name VARCHAR(100),
    PRIMARY KEY (id)
);

CREATE TABLE document_contents (
    id INTEGER NOT NULL AUTO_INCREMENT,
    document_id INTEGER NOT NULL,
    sportsml VARCHAR(200),
    abstract TEXT,
    PRIMARY KEY (id)
);

CREATE TABLE document_fixtures_events (
    id INTEGER NOT NULL AUTO_INCREMENT,
    document_fixture_id INTEGER NOT NULL,
    event_id INTEGER NOT NULL,
    latest_document_id INTEGER NOT NULL,
    last_update DATETIME,
    PRIMARY KEY (id)
);

CREATE TABLE document_packages (
    id INTEGER NOT NULL AUTO_INCREMENT,
    package_key VARCHAR(100),
    package_name VARCHAR(100),
    date_time DATE,
    PRIMARY KEY (id)
);

CREATE TABLE document_package_entry (
    id INTEGER NOT NULL AUTO_INCREMENT,
    document_package_id INTEGER NOT NULL,
    rank VARCHAR(100),
    document_id INTEGER NOT NULL,
    headline VARCHAR(100),
    short_headline VARCHAR(100),
    PRIMARY KEY (id)
);

CREATE TABLE media_captions (
    id INTEGER NOT NULL AUTO_INCREMENT,
    media_id INTEGER NOT NULL,
    caption_type VARCHAR(100),
    caption VARCHAR(100),
    caption_author_id INTEGER NOT NULL,
    language VARCHAR(100),
    caption_size VARCHAR(100),
    PRIMARY KEY (id)
);

/*
identifies the relationship between a document and its zero-or-more Media Objects
*/
CREATE TABLE documents_media (
    id INTEGER NOT NULL AUTO_INCREMENT,
    document_id INTEGER NOT NULL,
    media_id INTEGER NOT NULL,
    media_caption_id INTEGER NOT NULL,
    PRIMARY KEY (id)
);

CREATE TABLE events_documents (
    event_id INTEGER NOT NULL,
    document_id INTEGER NOT NULL,
    PRIMARY KEY (event_id, document_id)
);

CREATE TABLE events_media (
    event_id INTEGER NOT NULL,
    media_id INTEGER NOT NULL
);

CREATE TABLE sub_seasons (
    id INTEGER NOT NULL AUTO_INCREMENT,
    sub_season_key VARCHAR(100) NOT NULL,
    season_id INTEGER NOT NULL,
    sub_season_type VARCHAR(100) NOT NULL,
    start_date_time DATETIME,
    end_date_time DATETIME,
    PRIMARY KEY (id)
);

CREATE TABLE events_sub_seasons (
    event_id INTEGER NOT NULL,
    sub_season_id INTEGER NOT NULL,
    PRIMARY KEY (event_id, sub_season_id)
);

CREATE TABLE ice_hockey_defensive_stats (
    id INTEGER NOT NULL AUTO_INCREMENT,
    shots_power_play_allowed VARCHAR(100),
    shots_penalty_shot_allowed VARCHAR(100),
    goals_power_play_allowed VARCHAR(100),
    goals_penalty_shot_allowed VARCHAR(100),
    goals_against_average VARCHAR(100),
    saves VARCHAR(100),
    save_percentage VARCHAR(100),
    penalty_killing_amount VARCHAR(100),
    penalty_killing_percentage VARCHAR(100),
    shots_blocked VARCHAR(100),
    takeaways VARCHAR(100),
    shutouts VARCHAR(100),
    minutes_penalty_killing VARCHAR(100),
    hits VARCHAR(100),
    goals_empty_net_allowed VARCHAR(100),
    goals_short_handed_allowed VARCHAR(100),
    goals_shootout_allowed VARCHAR(100),
    shots_shootout_allowed VARCHAR(100),
    PRIMARY KEY (id)
);

CREATE TABLE ice_hockey_event_states (
    id INTEGER NOT NULL AUTO_INCREMENT,
    event_id INTEGER NOT NULL,
    current_state TINYINT,
    sequence_number INTEGER,
    period_value VARCHAR(100),
    period_time_elapsed VARCHAR(100),
    period_time_remaining VARCHAR(100),
    context VARCHAR(40),
    PRIMARY KEY (id)
);

CREATE TABLE ice_hockey_offensive_stats (
    id INTEGER NOT NULL AUTO_INCREMENT,
    goals_game_winning VARCHAR(100),
    goals_game_tying VARCHAR(100),
    goals_power_play VARCHAR(100),
    goals_short_handed VARCHAR(100),
    goals_even_strength VARCHAR(100),
    goals_empty_net VARCHAR(100),
    goals_overtime VARCHAR(100),
    goals_shootout VARCHAR(100),
    goals_penalty_shot VARCHAR(100),
    assists VARCHAR(100),
    points VARCHAR(100),
    power_play_amount VARCHAR(100),
    power_play_percentage VARCHAR(100),
    shots_penalty_shot_taken VARCHAR(100),
    shots_penalty_shot_missed VARCHAR(100),
    shots_penalty_shot_percentage VARCHAR(100),
    giveaways VARCHAR(100),
    minutes_power_play VARCHAR(100),
    faceoff_wins VARCHAR(100),
    faceoff_losses VARCHAR(100),
    faceoff_win_percentage VARCHAR(100),
    scoring_chances VARCHAR(100),
    PRIMARY KEY (id)
);

CREATE TABLE ice_hockey_player_stats (
    id INTEGER NOT NULL AUTO_INCREMENT,
    plus_minus VARCHAR(100),
    PRIMARY KEY (id)
);

CREATE TABLE injury_phases (
    id INTEGER NOT NULL AUTO_INCREMENT,
    person_id INTEGER NOT NULL,
    injury_status VARCHAR(100),
    injury_type VARCHAR(100),
    injury_comment VARCHAR(100),
    disabled_list VARCHAR(100),
    start_date_time DATETIME,
    end_date_time DATETIME,
    season_id INTEGER,
    phase_type VARCHAR(100),
    injury_side VARCHAR(100),
    PRIMARY KEY (id)
);

CREATE TABLE key_aliases (
    id INTEGER NOT NULL AUTO_INCREMENT,
    publisher_id INTEGER NOT NULL,
    alias_type VARCHAR(100),
    alias_id INTEGER,
    common_key VARCHAR(100),
    PRIMARY KEY (id)
);

CREATE TABLE latest_revisions (
    id INTEGER NOT NULL AUTO_INCREMENT,
    revision_id VARCHAR(75) NOT NULL,
    latest_document_id INTEGER NOT NULL,
    PRIMARY KEY (id)
);

CREATE TABLE media_contents (
    id INTEGER NOT NULL AUTO_INCREMENT,
    media_id INTEGER NOT NULL,
    object VARCHAR(100),
    format VARCHAR(100),
    mime_type VARCHAR(100),
    height VARCHAR(100),
    width VARCHAR(100),
    duration VARCHAR(100),
    file_size VARCHAR(100),
    resolution VARCHAR(100),
    PRIMARY KEY (id)
);

CREATE TABLE media_keywords (
    id INTEGER NOT NULL AUTO_INCREMENT,
    keyword VARCHAR(100),
    media_id INTEGER NOT NULL,
    PRIMARY KEY (id)
);

CREATE TABLE motor_racing_event_states (
    id INTEGER NOT NULL AUTO_INCREMENT,
    event_id INTEGER NOT NULL,
    current_state TINYINT,
    sequence_number INTEGER,
    lap VARCHAR(100),
    laps_remaining VARCHAR(100),
    time_elapsed VARCHAR(100),
    flag_state VARCHAR(100),
    context VARCHAR(40),
    PRIMARY KEY (id)
);

CREATE TABLE motor_racing_qualifying_stats (
    id INTEGER NOT NULL AUTO_INCREMENT,
    grid VARCHAR(100),
    pole_position VARCHAR(100),
    pole_wins VARCHAR(100),
    qualifying_speed VARCHAR(100),
    qualifying_speed_units VARCHAR(100),
    qualifying_time VARCHAR(100),
    qualifying_position VARCHAR(100),
    PRIMARY KEY (id)
);

CREATE TABLE motor_racing_race_stats (
    id INTEGER NOT NULL AUTO_INCREMENT,
    time_behind_leader VARCHAR(100),
    laps_behind_leader VARCHAR(100),
    time_ahead_follower VARCHAR(100),
    laps_ahead_follower VARCHAR(100),
    time VARCHAR(100),
    points VARCHAR(100),
    points_rookie VARCHAR(100),
    bonus VARCHAR(100),
    laps_completed VARCHAR(100),
    laps_leading_total VARCHAR(100),
    distance_leading VARCHAR(100),
    distance_completed VARCHAR(100),
    distance_units VARCHAR(40),
    speed_average VARCHAR(40),
    speed_units VARCHAR(40),
    status VARCHAR(40),
    finishes_top_5 VARCHAR(40),
    finishes_top_10 VARCHAR(40),
    starts VARCHAR(40),
    finishes VARCHAR(40),
    non_finishes VARCHAR(40),
    wins VARCHAR(40),
    races_leading VARCHAR(40),
    money VARCHAR(40),
    money_units VARCHAR(40),
    leads_total VARCHAR(40),
    PRIMARY KEY (id)
);

CREATE TABLE standings (
    id INTEGER NOT NULL AUTO_INCREMENT,
    affiliation_id INTEGER NOT NULL,
    standing_type VARCHAR(100),
    sub_season_id INTEGER NOT NULL,
    last_updated VARCHAR(100),
    duration_scope VARCHAR(100),
    competition_scope VARCHAR(100),
    competition_scope_id VARCHAR(100),
    alignment_scope VARCHAR(100),
    site_scope VARCHAR(100),
    scoping_label VARCHAR(100),
    publisher_id INTEGER NOT NULL,
    source VARCHAR(100),
    PRIMARY KEY (id)
);

CREATE TABLE standing_subgroups (
    id INTEGER NOT NULL AUTO_INCREMENT,
    standing_id INTEGER NOT NULL,
    affiliation_id INTEGER NOT NULL,
    PRIMARY KEY (id)
);

CREATE TABLE outcome_totals (
    id INTEGER NOT NULL AUTO_INCREMENT,
    standing_subgroup_id INTEGER NOT NULL,
    outcome_holder_type VARCHAR(100),
    outcome_holder_id INTEGER,
    rank VARCHAR(100),
    wins VARCHAR(100),
    losses VARCHAR(100),
    ties VARCHAR(100),
    undecideds VARCHAR(100),
    winning_percentage VARCHAR(100),
    points_scored_for VARCHAR(100),
    points_scored_against VARCHAR(100),
    points_difference VARCHAR(100),
    standing_points VARCHAR(100),
    streak_type VARCHAR(100),
    streak_duration VARCHAR(100),
    streak_total VARCHAR(100),
    streak_start DATE,
    streak_end DATE,
    PRIMARY KEY (id)
);

CREATE TABLE participants_events (
    id INTEGER NOT NULL AUTO_INCREMENT,
    participant_type VARCHAR(100) NOT NULL,
    participant_id INTEGER NOT NULL,
    event_id INTEGER NOT NULL,
    alignment VARCHAR(100),
    score VARCHAR(100),
    event_outcome VARCHAR(100),
    rank INTEGER,
    PRIMARY KEY (id)
);

CREATE TABLE periods (
    id INTEGER NOT NULL AUTO_INCREMENT,
    participant_event_id INTEGER NOT NULL,
    period_value VARCHAR(100),
    score VARCHAR(100),
    PRIMARY KEY (id)
);

CREATE TABLE roles (
    id INTEGER NOT NULL AUTO_INCREMENT,
    role_key VARCHAR(100) NOT NULL,
    role_name VARCHAR(100),
    comment VARCHAR(100),
    PRIMARY KEY (id)
);

CREATE TABLE person_event_metadata (
    id INTEGER NOT NULL AUTO_INCREMENT,
    person_id INTEGER NOT NULL,
    event_id INTEGER NOT NULL,
    status VARCHAR(100),
    health VARCHAR(100),
    weight VARCHAR(100),
    role_id INTEGER,
    position_id INTEGER,
    team_id INTEGER,
    lineup_slot INTEGER,
    lineup_slot_sequence INTEGER,
    PRIMARY KEY (id)
);

CREATE TABLE person_phases (
    id INTEGER NOT NULL AUTO_INCREMENT,
    person_id INTEGER NOT NULL,
    membership_type VARCHAR(40) NOT NULL,
    membership_id INTEGER NOT NULL,
    role_id INTEGER,
    role_status VARCHAR(40),
    phase_status VARCHAR(40),
    uniform_number VARCHAR(20),
    regular_position_id INTEGER,
    regular_position_depth INTEGER,
    height VARCHAR(100),
    weight VARCHAR(100),
    start_date_time DATETIME,
    start_season_id INTEGER,
    end_date_time DATETIME,
    end_season_id INTEGER,
    PRIMARY KEY (id)
);

CREATE TABLE persons_documents (
    person_id INTEGER NOT NULL,
    document_id INTEGER NOT NULL,
    PRIMARY KEY (person_id, document_id)
);

CREATE TABLE persons_media (
    person_id INTEGER NOT NULL,
    media_id INTEGER NOT NULL
);

CREATE TABLE soccer_defensive_stats (
    id INTEGER NOT NULL AUTO_INCREMENT,
    shots_penalty_shot_allowed VARCHAR(100),
    goals_penalty_shot_allowed VARCHAR(100),
    goals_against_average VARCHAR(100),
    goals_against_total VARCHAR(100),
    saves VARCHAR(100),
    save_percentage VARCHAR(100),
    catches_punches VARCHAR(100),
    shots_on_goal_total VARCHAR(100),
    shots_shootout_total VARCHAR(100),
    shots_shootout_allowed VARCHAR(100),
    shots_blocked VARCHAR(100),
    shutouts VARCHAR(100),
    PRIMARY KEY (id)
);

CREATE TABLE soccer_event_states (
    id INTEGER NOT NULL AUTO_INCREMENT,
    event_id INTEGER NOT NULL,
    current_state TINYINT,
    sequence_number INTEGER,
    period_value VARCHAR(100),
    period_time_elapsed VARCHAR(100),
    period_time_remaining VARCHAR(100),
    minutes_elapsed VARCHAR(100),
    period_minute_elapsed VARCHAR(100),
    context VARCHAR(40),
    PRIMARY KEY (id)
);

CREATE TABLE soccer_foul_stats (
    id INTEGER NOT NULL AUTO_INCREMENT,
    fouls_suffered VARCHAR(100),
    fouls_commited VARCHAR(100),
    cautions_total VARCHAR(100),
    cautions_pending VARCHAR(100),
    caution_points_total VARCHAR(100),
    caution_points_pending VARCHAR(100),
    ejections_total VARCHAR(100),
    PRIMARY KEY (id)
);

CREATE TABLE soccer_offensive_stats (
    id INTEGER NOT NULL AUTO_INCREMENT,
    goals_game_winning VARCHAR(100),
    goals_game_tying VARCHAR(100),
    goals_overtime VARCHAR(100),
    goals_shootout VARCHAR(100),
    goals_total VARCHAR(100),
    assists_game_winning VARCHAR(100),
    assists_game_tying VARCHAR(100),
    assists_overtime VARCHAR(100),
    assists_total VARCHAR(100),
    points VARCHAR(100),
    shots_total VARCHAR(100),
    shots_on_goal_total VARCHAR(100),
    shots_hit_frame VARCHAR(100),
    shots_penalty_shot_taken VARCHAR(100),
    shots_penalty_shot_scored VARCHAR(100),
    shots_penalty_shot_missed VARCHAR(40),
    shots_penalty_shot_percentage VARCHAR(40),
    shots_shootout_taken VARCHAR(40),
    shots_shootout_scored VARCHAR(40),
    shots_shootout_missed VARCHAR(40),
    shots_shootout_percentage VARCHAR(40),
    giveaways VARCHAR(40),
    offsides VARCHAR(40),
    corner_kicks VARCHAR(40),
    hat_tricks VARCHAR(40),
    PRIMARY KEY (id)
);

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

/*
Especially for Tennis. sub_period is for game, period is for set, score is for total number of sets won.
*/
CREATE TABLE sub_periods (
    id INTEGER NOT NULL AUTO_INCREMENT,
    period_id INTEGER NOT NULL,
    sub_period_value VARCHAR(100),
    score VARCHAR(100),
    PRIMARY KEY (id)
);

CREATE TABLE team_american_football_stats (
    id INTEGER NOT NULL AUTO_INCREMENT,
    yards_per_attempt VARCHAR(100),
    average_starting_position VARCHAR(100),
    timeouts VARCHAR(100),
    time_of_possession VARCHAR(100),
    turnover_ratio VARCHAR(100),
    PRIMARY KEY (id)
);

CREATE TABLE team_phases (
    id INTEGER NOT NULL AUTO_INCREMENT,
    team_id INTEGER NOT NULL,
    start_season_id INTEGER,
    end_season_id INTEGER,
    affiliation_id INTEGER NOT NULL,
    start_date_time VARCHAR(100),
    end_date_time VARCHAR(100),
    phase_status VARCHAR(40),
    role_id INTEGER,
    PRIMARY KEY (id)
);

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

CREATE TABLE teams_media (
    team_id INTEGER NOT NULL,
    media_id INTEGER NOT NULL
);

CREATE TABLE tennis_action_points (
    id INTEGER NOT NULL AUTO_INCREMENT,
    sub_period_id VARCHAR(100),
    sequence_number VARCHAR(100),
    win_type VARCHAR(100),
    PRIMARY KEY (id)
);

/*
One row per time the ball makes contact with a racquet. Including the first serve and the second serve.
*/
CREATE TABLE tennis_action_volleys (
    id INTEGER NOT NULL AUTO_INCREMENT,
    sequence_number VARCHAR(100),
    tennis_action_points_id INTEGER,
    landing_location VARCHAR(100),
    swing_type VARCHAR(100),
    result VARCHAR(100),
    spin_type VARCHAR(100),
    trajectory_details VARCHAR(100),
    PRIMARY KEY (id)
);

CREATE TABLE tennis_event_states (
    id INTEGER NOT NULL AUTO_INCREMENT,
    event_id INTEGER NOT NULL,
    current_state TINYINT,
    sequence_number INTEGER,
    tennis_set VARCHAR(100),
    game VARCHAR(100),
    server_person_id INTEGER,
    server_score VARCHAR(100),
    receiver_person_id INTEGER,
    receiver_score VARCHAR(100),
    service_number VARCHAR(100),
    context VARCHAR(40),
    PRIMARY KEY (id)
);

CREATE TABLE tennis_return_stats (
    id INTEGER NOT NULL AUTO_INCREMENT,
    returns_played VARCHAR(100),
    matches_played VARCHAR(100),
    first_service_return_points_won VARCHAR(100),
    first_service_return_points_won_pct VARCHAR(100),
    second_service_return_points_won VARCHAR(100),
    second_service_return_points_won_pct VARCHAR(100),
    return_games_played VARCHAR(100),
    return_games_won VARCHAR(100),
    return_games_won_pct VARCHAR(100),
    break_points_played VARCHAR(100),
    break_points_converted VARCHAR(100),
    break_points_converted_pct VARCHAR(100),
    PRIMARY KEY (id)
);

CREATE TABLE tennis_service_stats (
    id INTEGER NOT NULL AUTO_INCREMENT,
    services_played VARCHAR(100),
    matches_played VARCHAR(100),
    aces VARCHAR(100),
    first_services_good VARCHAR(100),
    first_services_good_pct VARCHAR(100),
    first_service_points_won VARCHAR(100),
    first_service_points_won_pct VARCHAR(100),
    second_service_points_won VARCHAR(100),
    second_service_points_won_pct VARCHAR(100),
    service_games_played VARCHAR(100),
    service_games_won VARCHAR(100),
    service_games_won_pct VARCHAR(100),
    break_points_played VARCHAR(100),
    break_points_saved VARCHAR(100),
    break_points_saved_pct VARCHAR(100),
    PRIMARY KEY (id)
);

CREATE TABLE wagering_moneylines (
    id INTEGER NOT NULL AUTO_INCREMENT,
    bookmaker_id INTEGER NOT NULL,
    event_id INTEGER NOT NULL,
    date_time DATETIME,
    team_id INTEGER NOT NULL,
    person_id INTEGER,
    rotation_key VARCHAR(100),
    comment VARCHAR(100),
    vigorish VARCHAR(100),
    line VARCHAR(100),
    line_opening VARCHAR(100),
    prediction VARCHAR(100),
    PRIMARY KEY (id)
);

CREATE TABLE wagering_odds_lines (
    id INTEGER NOT NULL AUTO_INCREMENT,
    bookmaker_id INTEGER NOT NULL,
    event_id INTEGER NOT NULL,
    date_time DATETIME,
    team_id INTEGER NOT NULL,
    person_id INTEGER,
    rotation_key VARCHAR(100),
    comment VARCHAR(100),
    numerator VARCHAR(100),
    denominator VARCHAR(100),
    prediction VARCHAR(100),
    payout_calculation VARCHAR(100),
    payout_amount VARCHAR(100),
    PRIMARY KEY (id)
);

CREATE TABLE wagering_runlines (
    id INTEGER NOT NULL AUTO_INCREMENT,
    bookmaker_id INTEGER NOT NULL,
    event_id INTEGER NOT NULL,
    date_time DATETIME,
    team_id INTEGER NOT NULL,
    person_id INTEGER,
    rotation_key VARCHAR(100),
    comment VARCHAR(100),
    vigorish VARCHAR(100),
    line VARCHAR(100),
    line_opening VARCHAR(100),
    line_value VARCHAR(100),
    prediction VARCHAR(100),
    PRIMARY KEY (id)
);

CREATE TABLE wagering_straight_spread_lines (
    id INTEGER NOT NULL AUTO_INCREMENT,
    bookmaker_id INTEGER NOT NULL,
    event_id INTEGER NOT NULL,
    date_time DATETIME,
    team_id INTEGER NOT NULL,
    person_id INTEGER,
    rotation_key VARCHAR(100),
    comment VARCHAR(100),
    vigorish VARCHAR(100),
    line_value VARCHAR(100),
    line_value_opening VARCHAR(100),
    prediction VARCHAR(100),
    PRIMARY KEY (id)
);

CREATE TABLE wagering_total_score_lines (
    id INTEGER NOT NULL AUTO_INCREMENT,
    bookmaker_id INTEGER NOT NULL,
    event_id INTEGER NOT NULL,
    date_time DATETIME,
    team_id INTEGER NOT NULL,
    person_id INTEGER,
    rotation_key VARCHAR(100),
    comment VARCHAR(100),
    vigorish VARCHAR(100),
    line_over VARCHAR(100),
    line_under VARCHAR(100),
    total VARCHAR(100),
    total_opening VARCHAR(100),
    prediction VARCHAR(100),
    PRIMARY KEY (id)
);

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

/*============================================================================*/
/* Foreign keys                                                               */
/*============================================================================*/

ALTER TABLE addresses
    ADD CONSTRAINT FK_add_loc_id__loc_id
    FOREIGN KEY (location_id) REFERENCES locations (id);

ALTER TABLE sites
    ADD CONSTRAINT FK_sit_loc_id__loc_id
    FOREIGN KEY (location_id) REFERENCES locations (id);

ALTER TABLE persons
    ADD CONSTRAINT FK_per_bir_loc_id__loc_id
    FOREIGN KEY (birth_location_id) REFERENCES locations (id);

ALTER TABLE bookmakers
    ADD CONSTRAINT FK_boo_loc_id__loc_id
    FOREIGN KEY (location_id) REFERENCES locations (id);

ALTER TABLE media
    ADD CONSTRAINT FK_med_cre_loc_id__loc_id
    FOREIGN KEY (creation_location_id) REFERENCES locations (id);

ALTER TABLE persons
    ADD CONSTRAINT FK_per_dea_loc_id__loc_id
    FOREIGN KEY (death_location_id) REFERENCES locations (id);

ALTER TABLE persons
    ADD CONSTRAINT FK_per_res_loc_id__loc_id
    FOREIGN KEY (residence_location_id) REFERENCES locations (id);

ALTER TABLE persons
    ADD CONSTRAINT FK_per_hom_loc_id__loc_id
    FOREIGN KEY (hometown_location_id) REFERENCES locations (id);

ALTER TABLE bookmakers
    ADD CONSTRAINT FK_boo_pub_id__pub_id
    FOREIGN KEY (publisher_id) REFERENCES publishers (id);

ALTER TABLE affiliations
    ADD CONSTRAINT FK_aff_pub_id__pub_id
    FOREIGN KEY (publisher_id) REFERENCES publishers (id);

ALTER TABLE documents
    ADD CONSTRAINT FK_doc_sou_id__pub_id
    FOREIGN KEY (source_id) REFERENCES publishers (id);

ALTER TABLE key_aliases
    ADD CONSTRAINT FK_key_ali_pub_id__pub_id
    FOREIGN KEY (publisher_id) REFERENCES publishers (id);

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

ALTER TABLE document_fixtures
    ADD CONSTRAINT FK_doc_fix_pub_id__pub_id
    FOREIGN KEY (publisher_id) REFERENCES publishers (id);

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

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

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

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

ALTER TABLE persons
    ADD CONSTRAINT FK_per_pub_id__pub_id
    FOREIGN KEY (publisher_id) REFERENCES publishers (id);

ALTER TABLE media
    ADD CONSTRAINT FK_med_pub_id__pub_id
    FOREIGN KEY (publisher_id) REFERENCES publishers (id);

ALTER TABLE standings
    ADD CONSTRAINT FK_sta_pub_id__pub_id
    FOREIGN KEY (publisher_id) REFERENCES publishers (id);

ALTER TABLE affiliation_phases
    ADD CONSTRAINT FK_affiliations_affiliation_phases1
    FOREIGN KEY (ancestor_affiliation_id) REFERENCES affiliations (id);

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

ALTER TABLE positions
    ADD CONSTRAINT FK_pos_aff_id__aff_id
    FOREIGN KEY (affiliation_id) REFERENCES affiliations (id);

ALTER TABLE seasons
    ADD CONSTRAINT FK_sea_lea_id__aff_id
    FOREIGN KEY (league_id) REFERENCES affiliations (id);

ALTER TABLE affiliations_documents
    ADD CONSTRAINT FK_aff_doc_aff_id__aff_id
    FOREIGN KEY (affiliation_id) REFERENCES affiliations (id);

ALTER TABLE affiliations_events
    ADD CONSTRAINT FK_aff_eve_aff_id__aff_id
    FOREIGN KEY (affiliation_id) REFERENCES affiliations (id);

ALTER TABLE team_phases
    ADD CONSTRAINT FK_tea_aff_pha_aff_id__aff_id
    FOREIGN KEY (affiliation_id) REFERENCES affiliations (id);

ALTER TABLE standings
    ADD CONSTRAINT FK_sta_aff_id__aff_id
    FOREIGN KEY (affiliation_id) REFERENCES affiliations (id);

ALTER TABLE standing_subgroups
    ADD CONSTRAINT FK_sta_sub_aff_id__aff_id
    FOREIGN KEY (affiliation_id) REFERENCES affiliations (id);

ALTER TABLE affiliations_media
    ADD CONSTRAINT FK_aff_med_aff_id__aff_id
    FOREIGN KEY (affiliation_id) REFERENCES affiliations (id);

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

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

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

ALTER TABLE person_phases
    ADD CONSTRAINT FK_per_pha_sta_sea_id__sea_id
    FOREIGN KEY (start_season_id) REFERENCES seasons (id);

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

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

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

ALTER TABLE person_phases
    ADD CONSTRAINT FK_per_pha_end_sea_id__sea_id
    FOREIGN KEY (end_season_id) REFERENCES seasons (id);

ALTER TABLE document_fixtures_events
    ADD CONSTRAINT FK_doc_fix_eve_doc_fix_id__doc_fix_id
    FOREIGN KEY (document_fixture_id) REFERENCES document_fixtures (id);

ALTER TABLE documents
    ADD CONSTRAINT FK_doc_doc_fix_id__doc_fix_id
    FOREIGN KEY (document_fixture_id) REFERENCES document_fixtures (id);

ALTER TABLE document_contents
    ADD CONSTRAINT FK_doc_con_doc_id__doc_id
    FOREIGN KEY (document_id) REFERENCES documents (id);

ALTER TABLE events_documents
    ADD CONSTRAINT FK_eve_doc_doc_id__doc_id
    FOREIGN KEY (document_id) REFERENCES documents (id);

ALTER TABLE persons_documents
    ADD CONSTRAINT FK_per_doc_doc_id__doc_id
    FOREIGN KEY (document_id) REFERENCES documents (id);

ALTER TABLE latest_revisions
    ADD CONSTRAINT FK_lat_rev_lat_doc_id__doc_id
    FOREIGN KEY (latest_document_id) REFERENCES documents (id);

ALTER TABLE document_fixtures_events
    ADD CONSTRAINT FK_doc_fix_eve_lat_doc_id__doc_id
    FOREIGN KEY (latest_document_id) REFERENCES documents (id);

ALTER TABLE affiliations_documents
    ADD CONSTRAINT FK_aff_doc_doc_id__doc_id
    FOREIGN KEY (document_id) REFERENCES documents (id);

ALTER TABLE teams_documents
    ADD CONSTRAINT FK_tea_doc_doc_id__doc_id
    FOREIGN KEY (document_id) REFERENCES documents (id);

ALTER TABLE document_package_entry
    ADD CONSTRAINT FK_doc_pac_ent_doc_id__doc_id
    FOREIGN KEY (document_id) REFERENCES documents (id);

ALTER TABLE documents_media
    ADD CONSTRAINT FK_doc_med_doc_id__doc_id
    FOREIGN KEY (document_id) REFERENCES documents (id);

ALTER TABLE events
    ADD CONSTRAINT FK_eve_sit_id__sit_id
    FOREIGN KEY (site_id) REFERENCES sites (id);

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

ALTER TABLE participants_events
    ADD CONSTRAINT FK_par_eve_eve_id__eve_id
    FOREIGN KEY (event_id) REFERENCES events (id);

ALTER TABLE person_event_metadata
    ADD CONSTRAINT FK_per_eve_met_eve_id__eve_id
    FOREIGN KEY (event_id) REFERENCES events (id);

ALTER TABLE events_documents
    ADD CONSTRAINT FK_eve_doc_eve_id__eve_id
    FOREIGN KEY (event_id) REFERENCES events (id);

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

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

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

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

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

ALTER TABLE document_fixtures_events
    ADD CONSTRAINT FK_doc_fix_eve_eve_id__eve_id
    FOREIGN KEY (event_id) REFERENCES events (id);

ALTER TABLE affiliations_events
    ADD CONSTRAINT FK_aff_eve_eve_id__eve_id
    FOREIGN KEY (event_id) REFERENCES events (id);

ALTER TABLE events_sub_seasons
    ADD CONSTRAINT FK_eve_sub_sea_eve_id__eve_id
    FOREIGN KEY (event_id) REFERENCES events (id);

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

ALTER TABLE events_media
    ADD CONSTRAINT FK_eve_med_eve_id__eve_id
    FOREIGN KEY (event_id) REFERENCES events (id);

ALTER TABLE baseball_event_states
    ADD CONSTRAINT FK_bas_eve_sta_eve_id__eve_id
    FOREIGN KEY (event_id) REFERENCES events (id);

ALTER TABLE american_football_event_states
    ADD CONSTRAINT FK_ame_foo_eve_sta_eve_id__eve_id
    FOREIGN KEY (event_id) REFERENCES events (id);

ALTER TABLE basketball_event_states
    ADD CONSTRAINT FK_bask_eve_sta_eve_id__eve_id
    FOREIGN KEY (event_id) REFERENCES events (id);

ALTER TABLE ice_hockey_event_states
    ADD CONSTRAINT FK_ice_hoc_eve_sta_eve_id__eve_id
    FOREIGN KEY (event_id) REFERENCES events (id);

ALTER TABLE tennis_event_states
    ADD CONSTRAINT FK_ten_eve_sta_eve_id__eve_id
    FOREIGN KEY (event_id) REFERENCES events (id);

ALTER TABLE soccer_event_states
    ADD CONSTRAINT FK_soc_eve_sta_eve_id__eve_id
    FOREIGN KEY (event_id) REFERENCES events (id);

ALTER TABLE motor_racing_event_states
    ADD CONSTRAINT FK_mot_rac_eve_sta_eve_id__eve_id
    FOREIGN KEY (event_id) REFERENCES events (id);

ALTER TABLE person_event_metadata
    ADD CONSTRAINT FK_per_eve_met_per_id__per_id
    FOREIGN KEY (person_id) REFERENCES persons (id);

ALTER TABLE american_football_action_participants
    ADD CONSTRAINT FK_ame_foo_act_par_per_id__per_id
    FOREIGN KEY (person_id) REFERENCES persons (id);

ALTER TABLE persons_documents
    ADD CONSTRAINT FK_per_doc_per_id__per_id
    FOREIGN KEY (person_id) REFERENCES persons (id);

ALTER TABLE injury_phases
    ADD CONSTRAINT FK_inj_pha_per_id__per_id
    FOREIGN KEY (person_id) REFERENCES persons (id);

ALTER TABLE person_phases
    ADD CONSTRAINT FK_per_pha_per_id__per_id
    FOREIGN KEY (person_id) REFERENCES persons (id);

ALTER TABLE media
    ADD CONSTRAINT FK_med_cre_id__per_id
    FOREIGN KEY (credit_id) REFERENCES persons (id);

ALTER TABLE persons_media
    ADD CONSTRAINT FK_per_med_per_id__per_id
    FOREIGN KEY (person_id) REFERENCES persons (id);

ALTER TABLE media_captions
    ADD CONSTRAINT FK_med_cap_cap_aut_id__per_id
    FOREIGN KEY (caption_author_id) REFERENCES persons (id);

ALTER TABLE baseball_event_states
    ADD CONSTRAINT FK_bas_eve_sta_run_on_sec_id__per_id
    FOREIGN KEY (runner_on_second_id) REFERENCES persons (id);

ALTER TABLE baseball_event_states
    ADD CONSTRAINT FK_bas_eve_sta_run_on_thi_id__per_id
    FOREIGN KEY (runner_on_third_id) REFERENCES persons (id);

ALTER TABLE baseball_event_states
    ADD CONSTRAINT FK_bas_eve_sta_run_on_fir_id__per_id
    FOREIGN KEY (runner_on_first_id) REFERENCES persons (id);

ALTER TABLE baseball_event_states
    ADD CONSTRAINT FK_bas_eve_sta_bat_id__per_id
    FOREIGN KEY (batter_id) REFERENCES persons (id);

ALTER TABLE baseball_event_states
    ADD CONSTRAINT FK_bas_eve_sta_pit_id__per_id
    FOREIGN KEY (pitcher_id) REFERENCES persons (id);

ALTER TABLE baseball_action_substitutions
    ADD CONSTRAINT FK_bas_act_sub_per_rep_id__per_id
    FOREIGN KEY (person_replacing_id) REFERENCES persons (id);

ALTER TABLE baseball_action_substitutions
    ADD CONSTRAINT FK_bas_act_sub_per_ori_id__per_id
    FOREIGN KEY (person_original_id) REFERENCES persons (id);

ALTER TABLE baseball_defensive_players
    ADD CONSTRAINT FK_bas_def_pla_pla_id__per_id
    FOREIGN KEY (player_id) REFERENCES persons (id);

ALTER TABLE affiliations_media
    ADD CONSTRAINT FK_aff_med_med_id__med_id
    FOREIGN KEY (media_id) REFERENCES media (id);

ALTER TABLE media_captions
    ADD CONSTRAINT FK_med_cap_med_id__med_id
    FOREIGN KEY (media_id) REFERENCES media (id);

ALTER TABLE documents_media
    ADD CONSTRAINT FK_doc_med_med_id__med_id
    FOREIGN KEY (media_id) REFERENCES media (id);

ALTER TABLE media_contents
    ADD CONSTRAINT FK_med_con_med_id__med_id
    FOREIGN KEY (media_id) REFERENCES media (id);

ALTER TABLE events_media
    ADD CONSTRAINT FK_eve_med_med_id__med_id
    FOREIGN KEY (media_id) REFERENCES media (id);

ALTER TABLE teams_media
    ADD CONSTRAINT FK_tea_med_med_id__med_id
    FOREIGN KEY (media_id) REFERENCES media (id);

ALTER TABLE persons_media
    ADD CONSTRAINT FK_per_med_med_id__med_id
    FOREIGN KEY (media_id) REFERENCES media (id);

ALTER TABLE media_keywords
    ADD CONSTRAINT FK_med_key_med_id__med_id
    FOREIGN KEY (media_id) REFERENCES media (id);

ALTER TABLE person_event_metadata
    ADD CONSTRAINT FK_per_eve_met_tea_id__tea_id
    FOREIGN KEY (team_id) REFERENCES teams (id);

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

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

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

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

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

ALTER TABLE teams_documents
    ADD CONSTRAINT FK_tea_doc_tea_id__tea_id
    FOREIGN KEY (team_id) REFERENCES teams (id);

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

ALTER TABLE teams_media
    ADD CONSTRAINT FK_tea_med_tea_id__tea_id
    FOREIGN KEY (team_id) REFERENCES teams (id);

ALTER TABLE american_football_event_states
    ADD CONSTRAINT FK_ame_foo_eve_sta_tea_in_pos_id__tea_id
    FOREIGN KEY (team_in_possession_id) REFERENCES teams (id);

ALTER TABLE american_football_action_plays
    ADD CONSTRAINT FK_ame_foo_act_pla_ame_foo_eve_sta_id__ame_foo_eve_sta_id
    FOREIGN KEY (american_football_event_state_id) REFERENCES american_football_event_states (id);

ALTER TABLE american_football_action_participants
    ADD CONSTRAINT FK_ame_foo_act_par_ame_foo_act_pla_id__ame_foo_act_pla_id
    FOREIGN KEY (american_football_action_play_id) REFERENCES american_football_action_plays (id);

ALTER TABLE baseball_defensive_players
    ADD CONSTRAINT FK_bas_def_pla_bas_def_gro_id__bas_def_gro_id
    FOREIGN KEY (baseball_defensive_group_id) REFERENCES baseball_defensive_group (id);

ALTER TABLE baseball_action_pitches
    ADD CONSTRAINT FK_bas_act_pit_bas_def_gro_id__bas_def_gro_id
    FOREIGN KEY (baseball_defensive_group_id) REFERENCES baseball_defensive_group (id);

ALTER TABLE baseball_action_pitches
    ADD CONSTRAINT FK_bas_act_pit_bas_eve_sta_id__bas_eve_sta_id
    FOREIGN KEY (baseball_event_state_id) REFERENCES baseball_event_states (id);

ALTER TABLE baseball_action_plays
    ADD CONSTRAINT FK_bas_act_pla_bas_eve_sta_id__bas_eve_sta_id
    FOREIGN KEY (baseball_event_state_id) REFERENCES baseball_event_states (id);

ALTER TABLE baseball_action_substitutions
    ADD CONSTRAINT FK_bas_act_sub_bas_eve_sta_id__bas_eve_sta_id
    FOREIGN KEY (baseball_event_state_id) REFERENCES baseball_event_states (id);

ALTER TABLE baseball_action_contact_details
    ADD CONSTRAINT FK_bas_act_con_det_bas_act_pit_id__bas_act_pit_id
    FOREIGN KEY (baseball_action_pitch_id) REFERENCES baseball_action_pitches (id);

ALTER TABLE person_event_metadata
    ADD CONSTRAINT FK_per_eve_met_pos_id__pos_id
    FOREIGN KEY (position_id) REFERENCES positions (id);

ALTER TABLE person_phases
    ADD CONSTRAINT FK_per_pha_reg_pos_id__pos_id
    FOREIGN KEY (regular_position_id) REFERENCES positions (id);

ALTER TABLE baseball_action_substitutions
    ADD CONSTRAINT FK_bas_act_sub_per_rep_pos_id__pos_id
    FOREIGN KEY (person_replacing_position_id) REFERENCES positions (id);

ALTER TABLE baseball_action_substitutions
    ADD CONSTRAINT FK_bas_act_sub_per_ori_pos_id__pos_id
    FOREIGN KEY (person_original_position_id) REFERENCES positions (id);

ALTER TABLE core_person_stats
    ADD CONSTRAINT FK_cor_per_sta_pos_id__pos_id
    FOREIGN KEY (position_id) REFERENCES positions (id);

ALTER TABLE baseball_defensive_players
    ADD CONSTRAINT FK_bas_def_pla_pos_id__pos_id
    FOREIGN KEY (position_id) REFERENCES positions (id);

ALTER TABLE wagering_runlines
    ADD CONSTRAINT FK_wag_run_boo_id__boo_id
    FOREIGN KEY (bookmaker_id) REFERENCES bookmakers (id);

ALTER TABLE wagering_total_score_lines
    ADD CONSTRAINT FK_wag_tot_sco_lin_boo_id__boo_id
    FOREIGN KEY (bookmaker_id) REFERENCES bookmakers (id);

ALTER TABLE wagering_moneylines
    ADD CONSTRAINT FK_wag_mon_boo_id__boo_id
    FOREIGN KEY (bookmaker_id) REFERENCES bookmakers (id);

ALTER TABLE wagering_odds_lines
    ADD CONSTRAINT FK_wag_odd_lin_boo_id__boo_id
    FOREIGN KEY (bookmaker_id) REFERENCES bookmakers (id);

ALTER TABLE wagering_straight_spread_lines
    ADD CONSTRAINT FK_wag_str_spr_lin_boo_id__boo_id
    FOREIGN KEY (bookmaker_id) REFERENCES bookmakers (id);

ALTER TABLE document_fixtures
    ADD CONSTRAINT FK_doc_fix_doc_cla_id__doc_cla_id
    FOREIGN KEY (document_class_id) REFERENCES document_classes (id);

ALTER TABLE document_package_entry
    ADD CONSTRAINT FK_doc_pac_ent_doc_pac_id__doc_pac_id
    FOREIGN KEY (document_package_id) REFERENCES document_packages (id);

ALTER TABLE documents_media
    ADD CONSTRAINT FK_doc_med_med_cap_id__med_cap_id
    FOREIGN KEY (media_caption_id) REFERENCES media_captions (id);

ALTER TABLE events_sub_seasons
    ADD CONSTRAINT FK_eve_sub_sea_sub_sea_id__sub_sea_id
    FOREIGN KEY (sub_season_id) REFERENCES sub_seasons (id);

ALTER TABLE standings
    ADD CONSTRAINT FK_sta_sub_sea_id__sub_sea_id
    FOREIGN KEY (sub_season_id) REFERENCES sub_seasons (id);

ALTER TABLE standing_subgroups
    ADD CONSTRAINT FK_sta_sub_sta_id__sta_id
    FOREIGN KEY (standing_id) REFERENCES standings (id);

ALTER TABLE outcome_totals
    ADD CONSTRAINT FK_out_tot_sta_sub_id__sta_sub_id
    FOREIGN KEY (standing_subgroup_id) REFERENCES standing_subgroups (id);

ALTER TABLE periods
    ADD CONSTRAINT FK_per_par_eve_id__par_eve_id
    FOREIGN KEY (participant_event_id) REFERENCES participants_events (id);

ALTER TABLE sub_periods
    ADD CONSTRAINT FK_sub_per_per_id__per_id
    FOREIGN KEY (period_id) REFERENCES periods (id);

ALTER TABLE team_phases
    ADD CONSTRAINT FK_tea_aff_pha_rol_id__rol_id
    FOREIGN KEY (role_id) REFERENCES roles (id);

ALTER TABLE person_event_metadata
    ADD CONSTRAINT FK_per_eve_met_rol_id__rol_id
    FOREIGN KEY (role_id) REFERENCES roles (id);

ALTER TABLE person_phases
    ADD CONSTRAINT FK_per_pha_rol_id__rol_id
    FOREIGN KEY (role_id) REFERENCES roles (id);

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

ALTER TABLE locations
ADD INDEX IDX_locations_1 (country_code);

ALTER TABLE addresses
ADD INDEX IDX_addresses_1 (locality);

ALTER TABLE addresses
ADD INDEX IDX_addresses_2 (region);

ALTER TABLE addresses
ADD INDEX IDX_addresses_3 (postal_code);

ALTER TABLE addresses
ADD INDEX IDX_FK_add_loc_id__loc_id (location_id);

ALTER TABLE publishers
ADD INDEX IDX_publishers_1 (publisher_key);

ALTER TABLE affiliations
ADD INDEX IDX_affiliations_1 (affiliation_key);

ALTER TABLE affiliations
ADD INDEX IDX_affiliations_2 (affiliation_type);

ALTER TABLE affiliations
ADD INDEX IDX_FK_aff_pub_id__pub_id (publisher_id);

ALTER TABLE seasons
ADD INDEX IDX_FK_sea_lea_id__aff_id (league_id);

ALTER TABLE seasons
ADD INDEX IDX_FK_sea_pub_id__pub_id (publisher_id);

ALTER TABLE seasons
ADD INDEX IDX_seasons_1 (season_key);

ALTER TABLE document_fixtures
ADD INDEX IDX_document_fixtures_1 (fixture_key);

ALTER TABLE document_fixtures
ADD INDEX IDX_FK_doc_fix_doc_cla_id__doc_cla_id (document_class_id);

ALTER TABLE document_fixtures
ADD INDEX IDX_FK_doc_fix_pub_id__pub_id (publisher_id);

ALTER TABLE documents
ADD INDEX IDX_documents_1 (doc_id);

ALTER TABLE documents
ADD INDEX IDX_documents_3 (date_time);

ALTER TABLE documents
ADD INDEX IDX_documents_4 (priority);

ALTER TABLE documents
ADD INDEX IDX_documents_5 (revision_id);

ALTER TABLE documents
ADD INDEX IDX_FK_doc_doc_fix_id__doc_fix_id (document_fixture_id);

ALTER TABLE documents
ADD INDEX IDX_FK_doc_pub_id__pub_id (publisher_id);

ALTER TABLE documents
ADD INDEX IDX_FK_doc_sou_id__pub_id (source_id);

ALTER TABLE sites
ADD INDEX IDX_FK_sit_loc_id__loc_id (location_id);

ALTER TABLE sites
ADD INDEX IDX_FK_sit_pub_id__pub_id (publisher_id);

ALTER TABLE sites
ADD INDEX IDX_sites_1 (site_key);

ALTER TABLE events
ADD INDEX IDX_events_1 (event_key);

ALTER TABLE events
ADD INDEX IDX_FK_eve_pub_id__pub_id (publisher_id);

ALTER TABLE events
ADD INDEX IDX_FK_eve_sit_id__sit_id (site_id);

ALTER TABLE persons
ADD INDEX IDX_FK_per_pub_id__pub_id (publisher_id);

ALTER TABLE persons
ADD INDEX IDX_persons_1 (person_key);

ALTER TABLE american_football_event_states
ADD INDEX IDX_american_football_event_states_1 (current_state);

ALTER TABLE american_football_event_states
ADD INDEX IDX_FK_ame_foo_eve_sta_eve_id__eve_id (event_id);

ALTER TABLE american_football_action_plays
ADD INDEX IDX_american_football_action_plays_1 (play_type);

ALTER TABLE american_football_action_plays
ADD INDEX IDX_american_football_action_plays_2 (score_attempt_type);

ALTER TABLE american_football_action_plays
ADD INDEX IDX_american_football_action_plays_3 (drive_result);

ALTER TABLE american_football_action_plays
ADD INDEX IDX_FK_ame_foo_act_pla_ame_foo_eve_sta_id__ame_foo_eve_sta_id (american_football_event_state_id);

ALTER TABLE american_football_action_participants
ADD INDEX IDX_american_football_action_participants_1 (participant_role);

ALTER TABLE american_football_action_participants
ADD INDEX IDX_american_football_action_participants_2 (score_type);

ALTER TABLE american_football_action_participants
ADD INDEX IDX_FK_ame_foo_act_par_ame_foo_act_pla_id__ame_foo_act_pla_id (american_football_action_play_id);

ALTER TABLE american_football_action_participants
ADD INDEX IDX_FK_ame_foo_act_par_per_id__per_id (person_id);

ALTER TABLE baseball_event_states
ADD INDEX IDX_baseball_event_states_1 (current_state);

ALTER TABLE baseball_event_states
ADD INDEX IDX_FK_bas_eve_sta_eve_id__eve_id (event_id);

ALTER TABLE baseball_action_pitches
ADD INDEX IDX_baseball_action_pitches_1 (umpire_call);

ALTER TABLE baseball_action_pitches
ADD INDEX IDX_baseball_action_pitches_2 (pitch_type);

ALTER TABLE baseball_action_pitches
ADD INDEX IDX_FK_bas_act_pit_bas_def_gro_id__bas_def_gro_id (baseball_defensive_group_id);

ALTER TABLE baseball_action_pitches
ADD INDEX IDX_FK_bas_act_pit_bas_eve_sta_id__bas_eve_sta_id (baseball_event_state_id);

ALTER TABLE baseball_action_plays
ADD INDEX IDX_baseball_action_plays_1 (play_type);

ALTER TABLE baseball_action_plays
ADD INDEX IDX_FK_bas_act_pla_bas_eve_sta_id__bas_eve_sta_id (baseball_event_state_id);

ALTER TABLE positions
ADD INDEX IDX_FK_pos_aff_id__aff_id (affiliation_id);

ALTER TABLE positions
ADD INDEX IDX_positions_1 (abbreviation);

ALTER TABLE basketball_event_states
ADD INDEX IDX_FK_events_basketball_event_states (event_id);

ALTER TABLE db_info
ADD INDEX IDX_roles_1 (version);

ALTER TABLE document_classes
ADD INDEX IDX_document_classes_1 (name);

ALTER TABLE document_contents
ADD INDEX IDX_FK_doc_con_doc_id__doc_id (document_id);

ALTER TABLE document_fixtures_events
ADD INDEX IDX_FK_doc_fix_eve_doc_fix_id__doc_fix_id (document_fixture_id);

ALTER TABLE document_fixtures_events
ADD INDEX IDX_FK_doc_fix_eve_eve_id__eve_id (event_id);

ALTER TABLE document_fixtures_events
ADD INDEX IDX_FK_doc_fix_eve_lat_doc_id__doc_id (latest_document_id);

ALTER TABLE sub_seasons
ADD INDEX IDX_FK_sub_sea_sea_id__sea_id (season_id);

ALTER TABLE sub_seasons
ADD INDEX IDX_sub_seasons_1 (sub_season_key);

ALTER TABLE sub_seasons
ADD INDEX IDX_sub_seasons_2 (sub_season_type);

ALTER TABLE injury_phases
ADD INDEX IDX_FK_inj_pha_per_id__per_id (person_id);

ALTER TABLE injury_phases
ADD INDEX IDX_FK_inj_pha_sea_id__sea_id (season_id);

ALTER TABLE injury_phases
ADD INDEX IDX_injury_phases_2 (injury_status);

ALTER TABLE injury_phases
ADD INDEX IDX_injury_phases_3 (start_date_time);

ALTER TABLE injury_phases
ADD INDEX IDX_injury_phases_4 (end_date_time);

ALTER TABLE key_aliases
ADD INDEX IDX_FK_key_ali_pub_id__pub_id (publisher_id);

ALTER TABLE key_aliases
ADD INDEX IDX_key_aliases_1 (alias_type);

ALTER TABLE key_aliases
ADD INDEX IDX_key_aliases_2 (alias_id);

ALTER TABLE key_aliases
ADD INDEX IDX_key_aliases_4 (common_key);

ALTER TABLE latest_revisions
ADD INDEX IDX_FK_lat_rev_lat_doc_id__doc_id (latest_document_id);

ALTER TABLE latest_revisions
ADD INDEX IDX_latest_revisions_1 (revision_id);

ALTER TABLE motor_racing_event_states
ADD INDEX IDX_FK_events_motor_racing_event_states (event_id);

ALTER TABLE participants_events
ADD INDEX IDX_FK_par_eve_eve_id__eve_id (event_id);

ALTER TABLE participants_events
ADD INDEX IDX_participants_events_1 (participant_type);

ALTER TABLE participants_events
ADD INDEX IDX_participants_events_2 (participant_id);

ALTER TABLE participants_events
ADD INDEX IDX_participants_events_3 (alignment);

ALTER TABLE participants_events
ADD INDEX IDX_participants_events_4 (event_outcome);

ALTER TABLE periods
ADD INDEX IDX_FK_per_par_eve_id__par_eve_id (participant_event_id);

ALTER TABLE roles
ADD INDEX IDX_roles_1 (role_key);

ALTER TABLE person_event_metadata
ADD INDEX IDX_FK_per_eve_met_eve_id__eve_id (event_id);

ALTER TABLE person_event_metadata
ADD INDEX IDX_FK_per_eve_met_per_id__per_id (person_id);

ALTER TABLE person_event_metadata
ADD INDEX IDX_FK_per_eve_met_pos_id__pos_id (position_id);

ALTER TABLE person_event_metadata
ADD INDEX IDX_FK_per_eve_met_rol_id__rol_id (role_id);

ALTER TABLE person_event_metadata
ADD INDEX IDX_FK_teams_person_event_metadata (team_id);

ALTER TABLE person_event_metadata
ADD INDEX IDX_person_event_metadata_1 (status);

ALTER TABLE person_phases
ADD INDEX IDX_FK_per_pha_per_id__per_id (person_id);

ALTER TABLE person_phases
ADD INDEX IDX_FK_per_pha_reg_pos_id__pos_id (regular_position_id);

ALTER TABLE person_phases
ADD INDEX IDX_person_phases_1 (membership_type);

ALTER TABLE person_phases
ADD INDEX IDX_person_phases_2 (membership_id);

ALTER TABLE person_phases
ADD INDEX IDX_person_phases_3 (phase_status);

ALTER TABLE soccer_event_states
ADD INDEX IDX_FK_events_soccer_event_states (event_id);

ALTER TABLE stats
ADD INDEX IDX_stats_1 (stat_repository_type);

ALTER TABLE stats
ADD INDEX IDX_stats_2 (stat_repository_id);

ALTER TABLE stats
ADD INDEX IDX_stats_3 (stat_holder_type);

ALTER TABLE stats
ADD INDEX IDX_stats_4 (stat_holder_id);

ALTER TABLE stats
ADD INDEX IDX_stats_5 (stat_coverage_type);

ALTER TABLE stats
ADD INDEX IDX_stats_6 (stat_coverage_id);

ALTER TABLE stats
ADD INDEX IDX_stats_7 (context);

ALTER TABLE sub_periods
ADD INDEX IDX_FK_sub_per_per_id__per_id (period_id);

ALTER TABLE tennis_event_states
ADD INDEX IDX_FK_events_tennis_event_states (event_id);

ALTER TABLE weather_conditions
ADD INDEX IDX_FK_wea_con_eve_id__eve_id (event_id);


/* -- END OF SCRIPT -- */