]> git.rm.cloudns.org Git - xonotic/xonstatdb.git/log
xonotic/xonstatdb.git
12 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.

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

13 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.

13 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.

13 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.

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

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

13 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

13 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

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

13 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.

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

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

13 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.

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

13 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.

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

13 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.

13 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

13 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.

13 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.

13 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).

13 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.

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

13 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.

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

13 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.

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

13 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.

13 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.

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

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

13 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.

13 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.

13 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.

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

13 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.

13 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.

13 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.