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