Add partitions through 2025.
Partition tables out to 2020, remove old ones. Since these scripts are used to create a new xonstatdb, references to partitions using past dates will just mean empty tables. I'll cut off this pruning at each prior year.
Partition player weapon stats through 2014.
Fix merge.
Add indexes to the game and weapon stats tables. Store captimes.
Index game_id and player_id for performance (and badges).
Use UTC timestamps instead of local timestamps.
Remove nick from weapon stats and replace it w/ pgstat id. Remove corresponding constraint and replace it with an FK to player_game_stats.
Add nick to player_weapon_stats to give anonymous players uniqueness (they always have player_id of 2).
Fix weapon_cd in child table.
Add hit and fired to player_weapon_stats.
Get rid of time zones. We do not need them.
Change player_*_stats to bigserial - there is going to be a lot of them.
Change foreign keys from serial to integer.
Initial commit - migration of xonstatdb from MySQL to PostgreSQL.