xonotic/xonstatdb.git
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.