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