Merge branch 'frag-matrix'
[xonotic/xonstatdb.git] / tables /
2017-10-17 Ant ZucaroMerge branch 'frag-matrix'
2017-10-17 Ant ZucaroUse the plain JSON type, not JSONB due to PG9.3.
2017-10-16 Ant ZucaroMerge pull request #3 from antzucaro/frag-matrix
2017-10-04 Ant ZucaroPartition the frag matrix table. frag-matrix
2017-09-30 Ant ZucaroInitial version of the player_game_frag_matrix table.
2017-05-13 Ant ZucaroRemove the trailing comma.
2017-05-12 Ant ZucaroAdd a new 'mv' table for player aggregate stats.
2017-04-30 Ant ZucaroAdd elo categories to several tables.
2017-04-03 Ant ZucaroAdd some additional IP address padding.
2016-11-25 Ant ZucaroAdd a log table for merged servers.
2016-11-11 Ant ZucaroAdd an Elo indicator for turning off processing at...
2016-03-29 Ant ZucaroAdd player_medals table.
2016-03-17 Ant ZucaroFix typos.
2016-02-04 Ant ZucaroGive the active MVs primary keys.
2016-02-02 Ant ZucaroAdd an MV for active maps.
2016-01-30 Ant ZucaroAdd an MV for active servers.
2016-01-30 Ant ZucaroUnify permissions on all the table scripts.
2016-01-30 Ant ZucaroAdd an MV for active players.
2016-01-29 Ant ZucaroAdd a create_dt to summary stats.
2016-01-29 Ant ZucaroAdd a summary stats "materialized view".
2015-06-13 Ant ZucaroUpdate the unique key on the player captimes table.
2015-06-13 Ant ZucaroThe mod is 64 characters, not 30.
2015-06-09 Ant ZucaroAdd the mod name to the captimes table to somewhat...
2015-06-09 Ant ZucaroAdd a field to track the absolute number of impure...
2014-12-16 Ant ZucaroStore a list of player_ids in the games table.
2014-12-02 Ant ZucaroPartition tables out to 2020, remove old ones.
2014-07-12 Ant ZucaroMerge branch 'master' of github.com:antzucaro/xonstatdb
2014-06-16 Ant ZucaroAdd groups table for admin functionality.
2014-06-13 Ant ZucaroAdd email address to the players table (for admins...
2014-05-28 Ant ZucaroMerge branch 'master' of github.com:antzucaro/xonstatdb
2014-05-28 Ant ZucaroAdd an anticheat log table.
2013-05-23 Ant ZucaroVarious typos on Q4.
2013-05-23 Ant ZucaroPartition player weapon stats through 2014.
2013-05-23 Ant ZucaroPartition player game stats through 2014.
2013-05-23 Ant ZucaroPartition games through 2014.
2013-05-23 Ant ZucaroYou know what? We don't need tables for the past!
2013-05-23 Ant ZucaroAdd rounds, caps fields.
2013-04-21 Ant ZucaroAdd team scores table. Partition till 2015.
2013-02-05 Ant ZucaroAdd port to servers table
2013-02-05 Ant ZucaroAdd mod string to games table
2013-01-25 Ant ZucaroModify column structure for better reuse.
2013-01-16 Ant ZucaroMerge branch 'master' of github.com:antzucaro/xonstatdb
2013-01-16 Ant ZucaroAdd teamrank and scoreboardpos fields.
2012-12-15 Ant ZucaroAdd primary key to summary stats. SQLAlchemy requires it.
2012-12-15 Ant ZucaroAdd support for summary statistics.
2012-12-02 Ant ZucaroAdd an update_dt to the player_elos table.
2012-10-29 Ant ZucaroFix merge.
2012-10-29 Ant ZucaroAdd indexes to the game and weapon stats tables. Store...
2012-08-24 Ant ZucaroMerge branch 'master' of ssh://push.git.xonotic.org...
2012-08-24 Ant ZucaroIndex game_id and player_id for performance (and badges).
2012-08-21 Ant ZucaroAdd players to ladder associative table, with ranks.
2012-08-21 Ant ZucaroChange title to name.
2012-08-21 Ant ZucaroAdd the ladder code table.
2012-06-11 Ant ZucaroMerge branch 'master' of github.com:antzucaro/xonstatdb
2012-06-11 Ant ZucaroAdd an active indicator to player_elo.
2012-02-20 Ant ZucaroSupport deactivating players.
2012-01-22 Ant ZucaroAdd rank history table.
2012-01-22 Ant ZucaroFix player_ranks.
2012-01-22 Ant ZucaroAdd ranks table for batch purposes.
2011-12-31 Ant ZucaroAdd player Elo support.
2011-12-15 Ant ZucaroFix unique key definition on games.
2011-12-13 Ant ZucaroThe match_id is now a varchar.
2011-12-05 Ant ZucaroAdd a unique constraint on server_id/match_id.
2011-12-01 Ant ZucaroAdd a match_id to each games row.
2011-11-20 Ant ZucaroRevert the functional index on players table. It won...
2011-11-20 Ant ZucaroRevert the functional index on stripped_nick. Searches...
2011-11-20 Ant ZucaroAdd stripped_nick and indexes for it.
2011-11-17 Ant ZucaroAdd default to the create_dt of player game stats.
2011-11-16 Ant ZucaroUse UTC timestamps instead of local timestamps.
2011-11-16 antzucaroAdd stripped nick to the players table to support futur...
2011-10-31 Ant ZucaroGet rid of the hashkeys table. It is not needed.
2011-10-31 Ant ZucaroMake the server hashkey an attribute instead of its...
2011-10-28 Ant ZucaroEnsure that the hashkeys for player and server are...
2011-10-25 Ant ZucaroAdd server hashkey table
2011-10-17 Ant ZucaroAllow up to 128 characters in the player nick
2011-10-10 antzucaroAdd nick history table.
2011-10-10 antzucaroRemove unique constraint on pgstats that prevents multi...
2011-07-07 Ant ZucaroRemove stat type column, as we only care about scoreboa...
2011-05-20 Ant ZucaroMerge branch 'master' of github.com:antzucaro/xonstatdb
2011-05-20 Ant ZucaroRemove nick from weapon stats and replace it w/ pgstat...
2011-05-16 Ant ZucaroAdd nick to player_weapon_stats to give anonymous playe...
2011-04-28 azucaroAdd alivetime and rank to player_game_stats table.
2011-04-28 Ant ZucaroMisc fixes.
2011-04-28 Ant ZucaroFix weapon_cd in child table.
2011-04-28 Ant ZucaroAdd public key to servers.
2011-04-27 Ant ZucaroAdd hit and fired to player_weapon_stats.
2011-04-27 Ant ZucaroAdd revision to servers table.
2011-04-27 Ant ZucaroAlign weapon codes with what is emitted in the stats...
2011-04-23 Ant ZucaroAdd plural to alter for map_game_types.
2011-03-09 Ant ZucaroAdd default to servers table.
2011-03-06 Ant ZucaroGet rid of time zones. We do not need them.
2011-03-06 Ant ZucaroChange from integer to serial where I forgot on servers.
2011-03-06 Ant ZucaroChange datatypes from integer to serial where I forgot.
2011-03-06 Ant ZucaroChange player_*_stats to bigserial - there is going...
2011-03-06 Ant ZucaroChange foreign keys from serial to integer.
2011-03-06 Ant ZucaroInitial commit - migration of xonstatdb from MySQL...