xonotic/xonstatdb.git
7 years agoFunction to merge two players.
Ant Zucaro [Wed, 29 Feb 2012 12:05:05 +0000 (07:05 -0500)]
Function to merge two players.

7 years agoSupport deactivating players.
Ant Zucaro [Mon, 20 Feb 2012 16:42:21 +0000 (11:42 -0500)]
Support deactivating players.

7 years agoChange game type codes to match new gametypes abbreviations.
Ant Zucaro [Mon, 20 Feb 2012 15:25:35 +0000 (10:25 -0500)]
Change game type codes to match new gametypes abbreviations.

7 years agoAdd rank history to the build.
Ant Zucaro [Sun, 22 Jan 2012 17:36:34 +0000 (12:36 -0500)]
Add rank history to the build.

7 years agoWhoops, add the 32 game req.
Ant Zucaro [Sun, 22 Jan 2012 17:36:21 +0000 (12:36 -0500)]
Whoops, add the 32 game req.

7 years agoSave rank history and also do not generate ranks if < 32 games played for the game...
Ant Zucaro [Sun, 22 Jan 2012 17:35:41 +0000 (12:35 -0500)]
Save rank history and also do not generate ranks if < 32 games played for the game type.

7 years agoAdd rank history table.
Ant Zucaro [Sun, 22 Jan 2012 17:31:50 +0000 (12:31 -0500)]
Add rank history table.

7 years agoAdd elos and ranks to the build file.
Ant Zucaro [Sun, 22 Jan 2012 04:08:33 +0000 (23:08 -0500)]
Add elos and ranks to the build file.

7 years agoFix player_ranks.
Ant Zucaro [Sun, 22 Jan 2012 04:07:24 +0000 (23:07 -0500)]
Fix player_ranks.

7 years agoSmall transaction to regenerate ranks.
Ant Zucaro [Sun, 22 Jan 2012 03:54:41 +0000 (22:54 -0500)]
Small transaction to regenerate ranks.

7 years agoAdd ranks table for batch purposes.
Ant Zucaro [Sun, 22 Jan 2012 03:49:43 +0000 (22:49 -0500)]
Add ranks table for batch purposes.

7 years agoAdd player Elo support.
Ant Zucaro [Sat, 31 Dec 2011 22:46:11 +0000 (17:46 -0500)]
Add player Elo support.

8 years agoFix unique key definition on games.
Ant Zucaro [Thu, 15 Dec 2011 02:55:25 +0000 (21:55 -0500)]
Fix unique key definition on games.

8 years agoAdd the duel game type.
Ant Zucaro [Thu, 15 Dec 2011 02:41:23 +0000 (21:41 -0500)]
Add the duel game type.

8 years agoThe match_id is now a varchar.
Ant Zucaro [Tue, 13 Dec 2011 00:45:20 +0000 (19:45 -0500)]
The match_id is now a varchar.

8 years agoAdd a unique constraint on server_id/match_id.
Ant Zucaro [Mon, 5 Dec 2011 17:15:31 +0000 (12:15 -0500)]
Add a unique constraint on server_id/match_id.

8 years agoAdd a match_id to each games row.
Ant Zucaro [Thu, 1 Dec 2011 17:00:34 +0000 (12:00 -0500)]
Add a match_id to each games row.

8 years agoRevert the functional index on players table. It won't be used with LIKE query anyway.
Ant Zucaro [Sun, 20 Nov 2011 21:59:06 +0000 (16:59 -0500)]
Revert the functional index on players table. It won't be used with LIKE query anyway.

8 years agoRevert the functional index on stripped_nick. Searches won't benefit from it anyway.
Ant Zucaro [Sun, 20 Nov 2011 21:58:16 +0000 (16:58 -0500)]
Revert the functional index on stripped_nick. Searches won't benefit from it anyway.

8 years agoAdd stripped_nick and indexes for it.
Ant Zucaro [Sun, 20 Nov 2011 02:54:54 +0000 (21:54 -0500)]
Add stripped_nick and indexes for it.

8 years agoAdd default to the create_dt of player game stats.
Ant Zucaro [Thu, 17 Nov 2011 15:15:40 +0000 (10:15 -0500)]
Add default to the create_dt of player game stats.

8 years agoUse UTC timestamps instead of local timestamps.
Ant Zucaro [Wed, 16 Nov 2011 20:22:49 +0000 (15:22 -0500)]
Use UTC timestamps instead of local timestamps.

8 years agoChange to unix encoding.
antzucaro [Wed, 16 Nov 2011 01:01:26 +0000 (20:01 -0500)]
Change to unix encoding.

8 years agoAdd stripped nick to the players table to support future search implementation.
antzucaro [Wed, 16 Nov 2011 01:00:05 +0000 (20:00 -0500)]
Add stripped nick to the players table to support future search implementation.

8 years agoFix the triggers for partitioning.
Ant Zucaro [Wed, 9 Nov 2011 23:15:55 +0000 (18:15 -0500)]
Fix the triggers for partitioning.

8 years agoGet rid of the hashkeys table. It is not needed.
Ant Zucaro [Mon, 31 Oct 2011 01:05:01 +0000 (21:05 -0400)]
Get rid of the hashkeys table. It is not needed.

8 years agoMake the server hashkey an attribute instead of its own table.
Ant Zucaro [Mon, 31 Oct 2011 00:44:34 +0000 (20:44 -0400)]
Make the server hashkey an attribute instead of its own table.

8 years agoEnsure that the hashkeys for player and server are unique, as they are used for lookup.
Ant Zucaro [Fri, 28 Oct 2011 00:33:43 +0000 (20:33 -0400)]
Ensure that the hashkeys for player and server are unique, as they are used for lookup.

8 years agoAdd server hashkey table
Ant Zucaro [Tue, 25 Oct 2011 10:40:54 +0000 (06:40 -0400)]
Add server hashkey table

8 years agoClean up cd_mutator stuff.
Ant Zucaro [Tue, 25 Oct 2011 10:40:36 +0000 (06:40 -0400)]
Clean up cd_mutator stuff.

8 years agoWe no longer need the mutator table or the game types each map supports. Commenting...
Ant Zucaro [Fri, 21 Oct 2011 02:57:24 +0000 (22:57 -0400)]
We no longer need the mutator table or the game types each map supports. Commenting out those definitions

8 years agoAllow up to 128 characters in the player nick
Ant Zucaro [Mon, 17 Oct 2011 15:25:04 +0000 (11:25 -0400)]
Allow up to 128 characters in the player nick

8 years agoAdd nick history table.
antzucaro [Mon, 10 Oct 2011 19:13:35 +0000 (15:13 -0400)]
Add nick history table.

8 years agoRemove unique constraint on pgstats that prevents multiple bot stats.
antzucaro [Mon, 10 Oct 2011 19:06:42 +0000 (15:06 -0400)]
Remove unique constraint on pgstats that prevents multiple bot stats.

8 years agoMake directory location more clear.
antzucaro [Mon, 10 Oct 2011 17:23:54 +0000 (13:23 -0400)]
Make directory location more clear.

8 years agoFix typo on language command.
antzucaro [Mon, 10 Oct 2011 17:22:10 +0000 (13:22 -0400)]
Fix typo on language command.

8 years agoMake schema creation clear. Create pgplsql language.
Ant Zucaro [Thu, 6 Oct 2011 17:06:14 +0000 (13:06 -0400)]
Make schema creation clear. Create pgplsql language.

8 years agoAdd triggers for partitioning functionality.
Ant Zucaro [Thu, 7 Jul 2011 20:04:29 +0000 (16:04 -0400)]
Add triggers for partitioning functionality.

8 years agoRemove stat type column, as we only care about scoreboard stats.
Ant Zucaro [Thu, 7 Jul 2011 19:44:36 +0000 (15:44 -0400)]
Remove stat type column, as we only care about scoreboard stats.

8 years agoFix camping rifle short name
Ant Zucaro [Thu, 30 Jun 2011 02:56:49 +0000 (22:56 -0400)]
Fix camping rifle short name

8 years agoOnce again use the correct weapon names.
Ant Zucaro [Sat, 21 May 2011 02:45:26 +0000 (22:45 -0400)]
Once again use the correct weapon names.

8 years agoMerge branch 'master' of github.com:antzucaro/xonstatdb
Ant Zucaro [Fri, 20 May 2011 02:03:12 +0000 (22:03 -0400)]
Merge branch 'master' of github.com:antzucaro/xonstatdb

8 years agoRemove nick from weapon stats and replace it w/ pgstat id. Remove corresponding const...
Ant Zucaro [Fri, 20 May 2011 02:02:48 +0000 (22:02 -0400)]
Remove nick from weapon stats and replace it w/ pgstat id. Remove corresponding constraint and replace it with an FK to player_game_stats.

8 years agoMake weapon codes match w/ QCSRC weapon codes.
Ant Zucaro [Wed, 18 May 2011 16:24:00 +0000 (12:24 -0400)]
Make weapon codes match w/ QCSRC weapon codes.

8 years agoAdd nick to player_weapon_stats to give anonymous players uniqueness (they always...
Ant Zucaro [Mon, 16 May 2011 03:10:45 +0000 (23:10 -0400)]
Add nick to player_weapon_stats to give anonymous players uniqueness (they always have player_id of 2).

8 years agoAdd alivetime and rank to player_game_stats table.
azucaro [Thu, 28 Apr 2011 12:35:34 +0000 (08:35 -0400)]
Add alivetime and rank to player_game_stats table.

8 years agoMisc fixes.
Ant Zucaro [Thu, 28 Apr 2011 02:43:39 +0000 (22:43 -0400)]
Misc fixes.

8 years agoFix weapon_cd in child table.
Ant Zucaro [Thu, 28 Apr 2011 01:58:31 +0000 (21:58 -0400)]
Fix weapon_cd in child table.

8 years agoAdd public key to servers.
Ant Zucaro [Thu, 28 Apr 2011 00:18:20 +0000 (20:18 -0400)]
Add public key to servers.

8 years agoAdd hit and fired to player_weapon_stats.
Ant Zucaro [Wed, 27 Apr 2011 22:40:42 +0000 (18:40 -0400)]
Add hit and fired to player_weapon_stats.

8 years agoAdd revision to servers table.
Ant Zucaro [Wed, 27 Apr 2011 01:31:40 +0000 (21:31 -0400)]
Add revision to servers table.

8 years agoAlign weapon codes with what is emitted in the stats code.
Ant Zucaro [Wed, 27 Apr 2011 01:25:30 +0000 (21:25 -0400)]
Align weapon codes with what is emitted in the stats code.

8 years agoAdd plural to alter for map_game_types.
Ant Zucaro [Sat, 23 Apr 2011 16:01:10 +0000 (12:01 -0400)]
Add plural to alter for map_game_types.

8 years agoAdd default to servers table.
Ant Zucaro [Wed, 9 Mar 2011 22:25:58 +0000 (17:25 -0500)]
Add default to servers table.

8 years agoUpdate README
Ant Zucaro [Sun, 6 Mar 2011 21:21:01 +0000 (16:21 -0500)]
Update README

8 years agoGet rid of time zones. We do not need them.
Ant Zucaro [Sun, 6 Mar 2011 21:09:39 +0000 (16:09 -0500)]
Get rid of time zones. We do not need them.

8 years agoChange from integer to serial where I forgot on servers.
Ant Zucaro [Sun, 6 Mar 2011 21:05:35 +0000 (16:05 -0500)]
Change from integer to serial where I forgot on servers.

8 years agoChange datatypes from integer to serial where I forgot.
Ant Zucaro [Sun, 6 Mar 2011 21:04:32 +0000 (16:04 -0500)]
Change datatypes from integer to serial where I forgot.

8 years agoAdd ignore file.
Ant Zucaro [Sun, 6 Mar 2011 21:02:15 +0000 (16:02 -0500)]
Add ignore file.

8 years agoChange player_*_stats to bigserial - there is going to be a lot of them.
Ant Zucaro [Sun, 6 Mar 2011 21:01:03 +0000 (16:01 -0500)]
Change player_*_stats to bigserial - there is going to be a lot of them.

8 years agoChange foreign keys from serial to integer.
Ant Zucaro [Sun, 6 Mar 2011 21:00:14 +0000 (16:00 -0500)]
Change foreign keys from serial to integer.

8 years agoInitial commit - migration of xonstatdb from MySQL to PostgreSQL.
Ant Zucaro [Sun, 6 Mar 2011 20:58:09 +0000 (15:58 -0500)]
Initial commit - migration of xonstatdb from MySQL to PostgreSQL.