[Feature Request] Create moves table

[brianerdelyi]

Currently, each game is stored as a record in the games table. Each record contains a field for each key in the PGN. All moves are stored in moves field. This schema is great for searching games and viewing all moves of a game.

This schema does not enable more advanced analytics of a game such as: position search, centipawn loss evaluation or other analysis based on piece movement. To enable deeper analysis of moves, a table containing all moves is required.

This request is to create a table containing moves for all games. Future feature requests will be created for specific data elements for move analysis.

Request:

1. Create a new table called moves.
2. Add each user's move (i.e. ply) to the moves table. Suggested fields include:
   GameID (Key for the game in the games table) *
   Ply (Ply number)
   Move (Move number)
   Player (Player name)
   Color (Colour)
   Piece (Piece moved by user)
   Notation (Move notation)
   Clock (Time left on the clock h:mm:ss)
   Move_Time (Time used for the move in seconds)
   FEN (FEN of the position after the user's move) **

Note *: I do not believe the games table includes a key for GameID. This will need to exist in the games table as well.
Note **: FEN be the basis for future feature requests that involve engine evaluations.