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