Best way to store learnsets in DB

[hmacphail]

Split learnsets into two tables. New pokemonLearnsets table has 1:M relation with both learnsets and pokemon tables.

gameId, genId, and pokemonId all moved to pokemonLearnsets.

[hmacphail]

when adding new learnset:

look for learnset in learnsets table... get id or make new one

if learnset not new, look for learnset/pokemon relationship in this table... change generation range if gameId = null else... create 1 entry in this table, for game, pokemon, generation

have to retrieve learnset every time new one is made to get id for this table (maybe on-the-fly within pokemon movesByLevel loop)

[hmacphail]

Promise loop for learnsets: https://stackoverflow.com/questions/24660096/correct-way-to-write-loops-for-promise https://stackoverflow.com/questions/40328932/javascript-es6-promise-for-loop https://caolan.github.io/async/