<commit_before>CREATE TABLE IF NOT EXISTS game_info (
    id bigint not null,
    mode varchar(15) not null,
    type varchar(20) not null,
    subType varchar(25) not null,
    mapId int not null,
    date datetime not null,
    PRIMARY KEY (id)
);

CREATE TABLE IF NOT EXISTS league_games (
    gameid bigint not null,
    name varchar(60) null,
    confirmed bit(1) null,
    PRIMARY KEY (gameid),
    FOREIGN KEY (gameid) REFERENCES game_info(id)
);

CREATE TABLE IF NOT EXISTS neta_teams (
    id int(11) auto_increment not null,
    name varchar(60) not null,
    PRIMARY KEY (id)
);

CREATE TABLE IF NOT EXISTS summoner_games (
    id int(11) AUTO_INCREMENT not null,
    summonerId bigint not null,
    gameId bigint not null,
    championId int not null,
    spellOne int not null,
    spellTwo int not null,
    statId int(11) not null,
    PRIMARY KEY (id),
    FOREIGN KEY (statId) REFERENCES summoner_stats(id),
    FOREIGN KEY (summonerId) REFERENCES summoners(id),
    FOREIGN KEY (gameId) REFERENCES game_info(id)
);

CREATE TABLE IF NOT EXISTS summoner_stats (
    id int(11) AUTO_INCREMENT not null,
    assists int,
    barracksKilled int,
    championsKilled int,
    combatPlayerScore int,
    consumablesPurchased int,
    damageDealtPlayer int,
    doubleKills int,
    firstBlood int,
    gold int,
    goldEarned int,
    goldSpent int,
    item0 int,
    item1 int,
    item2 int,
    item3 int,
    item4 int,
    item5 int,
    item6 int,
    itemsPurchased int,
    killingSprees int,
    largestCriticalStrike int,
    largestKillingSpree int,
    largestMultiKill int,
    legendaryItemsCreated int,
    level int,
    magicDamageDealtPlayer int,
    magicDamageDealtToChampions int,
    magicDamageTaken int,
    minionsDenied int,
    minionsKilled int,
    neutralMinionsKilled int,
    neutralMinionsKilledEnemyJungle int,
    neutralMinionsKilledYourJungle int,
    nexusKilled bit(1),
    nodeCapture int,
    nodeCaptureAssist int,
    nodeNeutralize int,
    nodeNeutralizeAssist int,
    numDeaths int,
    numItemsBought int,
    objectivePlayerScore int,
    pentaKills int,
    physicalDamageDealtPlayer int,
    physicalDamageDealtToChampions int,
    physicalDamageTaken int,
    quadraKills int,
    sightWardsBought int,
    spellOneCast int,
    spellTwoCast int,
    spellThreeCast int,
    spellFourCast int,
    summonerSpellOneCast int,
    summonerSpellTwoCast int,
    superMonsterKilled int,
    team int,
    teamObjective int,
    timePlayed int,
    totalDamageDealt int,
    totalDamageDealtToChampions int,
    totalDamageTaken int,
    totalHeal int,
    totalPlayerScore int,
    totalScoreRank int,
    totalTimeCrowdControlDealt int,
    totalUnitsHealed int,
    tripleKills int,
    trueDamageDealtPlayer int,
    trueDamageDealtToChampions int,
    trueDamageTaken int,
    turretsKilled int,
    unrealKills int,
    victoryPointTotal int,
    visionWardsBought int,
    wardKilled int,
    wardPlaced int,
    win bit(1),
    PRIMARY KEY (id)
);<commit_msg>Resorted tables for install to work correctly<commit_after>CREATE TABLE IF NOT EXISTS game_info (
    id bigint not null,
    mode varchar(15) not null,
    type varchar(20) not null,
    subType varchar(25) not null,
    mapId int not null,
    date datetime not null,
    PRIMARY KEY (id)
);

CREATE TABLE IF NOT EXISTS league_games (
    gameid bigint not null,
    name varchar(60) null,
    confirmed bit(1) null,
    PRIMARY KEY (gameid),
    FOREIGN KEY (gameid) REFERENCES game_info(id)
);

CREATE TABLE IF NOT EXISTS neta_teams (
    id int(11) auto_increment not null,
    name varchar(60) not null,
    PRIMARY KEY (id)
);

CREATE TABLE IF NOT EXISTS summoners (
    id bigint(20) not null,
    name varchar(40) not null,
    real_name varchar(60) not null,
    neta_team int(11) null,
    `level` int(11) not null,
    PRIMARY KEY (id),
    FOREIGN KEY (neta_team) REFERENCES neta_teams(id)
);

CREATE TABLE IF NOT EXISTS summoner_stats (
    id int(11) AUTO_INCREMENT not null,
    assists int,
    barracksKilled int,
    championsKilled int,
    combatPlayerScore int,
    consumablesPurchased int,
    damageDealtPlayer int,
    doubleKills int,
    firstBlood int,
    gold int,
    goldEarned int,
    goldSpent int,
    item0 int,
    item1 int,
    item2 int,
    item3 int,
    item4 int,
    item5 int,
    item6 int,
    itemsPurchased int,
    killingSprees int,
    largestCriticalStrike int,
    largestKillingSpree int,
    largestMultiKill int,
    legendaryItemsCreated int,
    level int,
    magicDamageDealtPlayer int,
    magicDamageDealtToChampions int,
    magicDamageTaken int,
    minionsDenied int,
    minionsKilled int,
    neutralMinionsKilled int,
    neutralMinionsKilledEnemyJungle int,
    neutralMinionsKilledYourJungle int,
    nexusKilled bit(1),
    nodeCapture int,
    nodeCaptureAssist int,
    nodeNeutralize int,
    nodeNeutralizeAssist int,
    numDeaths int,
    numItemsBought int,
    objectivePlayerScore int,
    pentaKills int,
    physicalDamageDealtPlayer int,
    physicalDamageDealtToChampions int,
    physicalDamageTaken int,
    quadraKills int,
    sightWardsBought int,
    spellOneCast int,
    spellTwoCast int,
    spellThreeCast int,
    spellFourCast int,
    summonerSpellOneCast int,
    summonerSpellTwoCast int,
    superMonsterKilled int,
    team int,
    teamObjective int,
    timePlayed int,
    totalDamageDealt int,
    totalDamageDealtToChampions int,
    totalDamageTaken int,
    totalHeal int,
    totalPlayerScore int,
    totalScoreRank int,
    totalTimeCrowdControlDealt int,
    totalUnitsHealed int,
    tripleKills int,
    trueDamageDealtPlayer int,
    trueDamageDealtToChampions int,
    trueDamageTaken int,
    turretsKilled int,
    unrealKills int,
    victoryPointTotal int,
    visionWardsBought int,
    wardKilled int,
    wardPlaced int,
    win bit(1),
    PRIMARY KEY (id)
);

CREATE TABLE IF NOT EXISTS summoner_games (
    id int(11) AUTO_INCREMENT not null,
    summonerId bigint not null,
    gameId bigint not null,
    championId int not null,
    spellOne int not null,
    spellTwo int not null,
    statId int(11) not null,
    PRIMARY KEY (id),
    FOREIGN KEY (statId) REFERENCES summoner_stats(id),
    FOREIGN KEY (summonerId) REFERENCES summoners(id),
    FOREIGN KEY (gameId) REFERENCES game_info(id)
);
{'fraction_non_alphanumeric': 0.056796727501573316, 'fraction_numerical': 0.01038388923851479, 'mean_word_length': 3.190507580751483, 'pattern_counts': {'":': 0, '<': 3, '<?xml version=': 0, '>': 3, 'https://': 0, 'lorem ipsum': 0, 'www.': 0, 'xml': 0}, 'pii_count': 0, 'substrings_counts': 0, 'word_list_counts': {'cursed_substrings.json': 0, 'profanity_word_list.json': 0, 'sexual_word_list.json': 0, 'zh_pornsignals.json': 0}}
{'dir': 'git-commits-cleaned', 'id': '295286', 'n_tokens_mistral': 2195, 'n_tokens_neox': 2152, 'n_words': 627}