X-Git-Url: http://git.xonotic.org/?a=blobdiff_plain;f=build%2Fbuild_full.sql;h=86f1c6f795e9c3e22785bb13c3351fb6ea36e7d2;hb=b7b7d3e24f9334f5af6770f50faf688f93d29e53;hp=d8ad15e5ea1c009bc9563a58cf64454ac0b49a44;hpb=8cda5dd3abfa3d468f61773f357ebd4fe743d0ad;p=xonotic%2Fxonstatdb.git

diff --git a/build/build_full.sql b/build/build_full.sql
index d8ad15e..86f1c6f 100755
--- a/build/build_full.sql
+++ b/build/build_full.sql
@@ -1,4 +1,16 @@
 -- drop tables first in reverse order
+drop table if exists player_medals;
+drop table if exists active_maps_mv;
+drop table if exists active_servers_mv;
+drop table if exists active_players_mv;
+drop table if exists summary_stats_mv;
+drop table if exists player_groups;
+drop table if exists player_game_anticheats;
+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;
@@ -39,6 +51,18 @@ drop table if exists players cascade;
 \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
+\i tables/player_game_anticheats.tab
+\i tables/player_groups.tab
+\i tables/summary_stats_mv.tab
+\i tables/active_players_mv.tab
+\i tables/active_servers_mv.tab
+\i tables/active_maps_mv.tab
+\i tables/player_medals.tab
 
 begin;
 
@@ -97,6 +121,13 @@ insert into cd_weapon(weapon_cd, descr) values('tuba', '@!#%''n Tuba');
 insert into cd_weapon(weapon_cd, descr) values('hlac', 'Heavy Laser Assault Cannon');
 insert into cd_weapon(weapon_cd, descr) values('hook', 'Grappling Hook');
 insert into cd_weapon(weapon_cd, descr) values('porto', 'Port-O-Launch');
+insert into cd_weapon(weapon_cd, descr) values('blaster', 'Blaster');
+insert into cd_weapon(weapon_cd, descr) values('devastator', 'Devastator');
+insert into cd_weapon(weapon_cd, descr) values('machinegun', 'Machine Gun');
+insert into cd_weapon(weapon_cd, descr) values('mortar', 'Mortar');
+insert into cd_weapon(weapon_cd, descr) values('vaporizer', 'Vaporizer');
+insert into cd_weapon(weapon_cd, descr) values('vortex', 'Vortex');
+insert into cd_weapon(weapon_cd, descr) values('arc', 'Arc');
 
 -- achievements
 insert into cd_achievement(achievement_cd, descr, active_ind)
@@ -180,6 +211,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');