Add table definitions.
[xonotic/xonstatdb.git] / tables /
2014-07-12 Ant ZucaroMerge branch 'master' of
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
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
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://
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
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
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...