To get the data to load into mysql without invalid integer value errors I had to change the following fields to nullable. These columns have blank values in the CSVs and try to enter a blank string into the DB without these columns allowing null.
Line 1663: base_experience (Pokemon table)
Line 1665: order (Pokemon table)
Line 2038: shape_id (PokemonSpecies table)
Line 2046: base_happiness (PokemonSpecies table)
Line 2050: hatch_counter (PokemonSpecies table)
To get the data to load into mysql without invalid integer value errors I had to change the following fields to nullable. These columns have blank values in the CSVs and try to enter a blank string into the DB without these columns allowing null.
Line 1663: base_experience (Pokemon table) Line 1665: order (Pokemon table) Line 2038: shape_id (PokemonSpecies table) Line 2046: base_happiness (PokemonSpecies table) Line 2050: hatch_counter (PokemonSpecies table)