]> de.git.xonotic.org Git - xonotic/xonstatdb.git/commitdiff
Fix merge.
authorAnt Zucaro <azucaro@gmail.com>
Mon, 29 Oct 2012 16:03:08 +0000 (12:03 -0400)
committerAnt Zucaro <azucaro@gmail.com>
Mon, 29 Oct 2012 16:03:08 +0000 (12:03 -0400)
1  2 
tables/player_game_stats.tab
tables/player_weapon_stats.tab

index 219e84a052363ec32e46806c62843c5bbd7c2e0e,e09f351da60d3a511eae2ee69a66247d0d439017..9a9f681a5d91f3bb7239a7db0c37dc9a87ebce8c
mode 100644,100755..100755
@@@ -42,8 -39,10 +42,9 @@@ WITH 
  
  CREATE INDEX player_game_stats_ix01 on player_game_stats(create_dt);
  CREATE INDEX player_game_stats_ix02 on player_game_stats(game_id);
+ CREATE INDEX player_game_stats_ix03 on player_game_stats(player_id);
  ALTER TABLE xonstat.player_game_stats OWNER TO xonstat;
  
 -
  CREATE TABLE xonstat.player_game_stats_2011Q2 (
      CHECK ( create_dt >= DATE '2011-04-01' AND create_dt < DATE '2011-07-01' ) 
  ) INHERITS (player_game_stats);
@@@ -122,5 -129,6 +131,5 @@@ CREATE TABLE xonstat.player_game_stats_
  
  CREATE INDEX player_game_stats_2013Q2_ix01 on player_game_stats_2013Q2(create_dt);
  CREATE INDEX player_game_stats_2013Q2_ix02 on player_game_stats_2013Q2(game_id);
+ CREATE INDEX player_game_stats_2013Q2_ix03 on player_game_stats_2013Q2(player_id);
  ALTER TABLE xonstat.player_game_stats_2013Q2 OWNER TO xonstat;
--
index 54e42343ab01daab5e01b6f00e80c8da510bf652,8bef1f5b811f60b87926685a1da375e4e65ba19d..86707536ebdbdddda9f591747ec2de79a092b7dc
mode 100644,100755..100755
@@@ -31,6 -31,7 +31,8 @@@ WITH 
  
  CREATE INDEX player_weap_stats_ix01 on player_weapon_stats(create_dt);
  CREATE INDEX player_weap_stats_ix02 on player_weapon_stats(game_id);
+ CREATE INDEX player_weap_stats_ix03 on player_weapon_stats(player_id);
++
  ALTER TABLE xonstat.player_weapon_stats OWNER TO xonstat;
  
  CREATE TABLE xonstat.player_weapon_stats_2011Q2 (