Partition player game stats through 2014.

[xonotic/xonstatdb.git] / build / build_full.sql

diff --git a/build/build_full.sql b/build/build_full.sql
index 9a0fabb571f5b7c96251c2a4d56eb6e641f05169..708e2cf1ed457b3055d04d79f296947c820794ff 100755 (executable)
--- a/build/build_full.sql
+++ b/build/build_full.sql
@@ -1,5 +1,12 @@
 -- drop tables first in reverse order
-drop table if exists server_hashkeys cascade;
+drop table if exists team_game_stats;
+drop table if exists summary_stats cascade;
+drop table if exists player_map_captimes;
+drop table if exists player_ladder_ranks;
+drop table if exists cd_ladder cascade;
+drop table if exists player_ranks_history cascade;
+drop table if exists player_ranks cascade;
+drop table if exists player_elos cascade;
 drop table if exists player_nicks cascade;
 drop table if exists db_version cascade;
 drop table if exists hashkeys cascade;
@@ -34,7 +41,14 @@ drop table if exists players cascade;
 \i tables/hashkeys.tab
 \i tables/db_version.tab
 \i tables/player_nicks.tab
-\i tables/server_hashkeys.tab
+\i tables/player_elos.tab
+\i tables/player_ranks.tab
+\i tables/player_ranks_history.tab
+\i tables/cd_ladder.tab
+\i tables/player_ladder_ranks.tab
+\i tables/player_map_captimes.tab
+\i tables/summary_stats.tab
+\i tables/team_game_stats.tab
 
 begin;
 
@@ -52,7 +66,7 @@ values('dm', 'Deathmatch');
 insert into cd_game_type(game_type_cd, descr)
 values('dom', 'Domination');
 insert into cd_game_type(game_type_cd, descr)
-values('freezetag', 'Freezetag');
+values('ft', 'Freezetag');
 insert into cd_game_type(game_type_cd, descr)
 values('ka', 'Keepaway');
 insert into cd_game_type(game_type_cd, descr)
@@ -60,7 +74,7 @@ values('kh', 'Keyhunt');
 insert into cd_game_type(game_type_cd, descr)
 values('lms', 'Last Man Standing');
 insert into cd_game_type(game_type_cd, descr)
-values('nexball', 'Nexball');
+values('nb', 'Nexball');
 insert into cd_game_type(game_type_cd, descr)
 values('ons', 'Onslaught');
 insert into cd_game_type(game_type_cd, descr)
@@ -71,6 +85,8 @@ insert into cd_game_type(game_type_cd, descr)
 values('rune', 'Runematch');
 insert into cd_game_type(game_type_cd, descr)
 values('tdm', 'Team Deathmatch');
+insert into cd_game_type(game_type_cd, descr)
+values('duel', 'Duel');
 
 -- weapons
 insert into cd_weapon(weapon_cd, descr) values('laser', 'Laser');
@@ -174,6 +190,7 @@ insert into players (nick) values ('Untracked Player');
 \i triggers/games_ins_trg.sql
 \i triggers/player_game_stats_ins_trg.sql
 \i triggers/player_weapon_stats_ins_trg.sql
+\i triggers/team_game_stats_ins_trg.sql
 
 -- version tracking
 insert into db_version(version, descr) values('1.0.0', 'Initial build');