Remove player_skills when cleaning up the DB.

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

diff --git a/build/build_full.sql b/build/build_full.sql
index 5af9c6f5419e75da9f6e2b2496043e8f2e3d1676..d74adfccc4a62a797598e225025be0dec6c8b8cf 100755 (executable)
--- a/build/build_full.sql
+++ b/build/build_full.sql
@@ -1,4 +1,13 @@
 -- drop tables first in reverse order
+drop table if exists player_skills;
+drop table if exists player_game_nonparticipants;
+drop table if exists player_game_frag_matrix;
+drop table if exists player_agg_stats_mv;
+drop table if exists merged_servers;
+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;
@@ -55,6 +64,15 @@ drop table if exists players cascade;
 \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
+\i tables/merged_servers.tab
+\i tables/player_agg_stats_mv.tab
+\i tables/player_game_frag_matrix.tab
+\i tables/player_game_nonparticipants.tab
+\i tables/player_skills.tab
 
 begin;
 
@@ -120,6 +138,11 @@ 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');
+insert into cd_weapon(weapon_cd, descr) values('okhmg', 'Overkill Heavy Machine Gun');
+insert into cd_weapon(weapon_cd, descr) values('oknex', 'Overkill Nex');
+insert into cd_weapon(weapon_cd, descr) values('okshotgun', 'Overkill Shotgun');
+insert into cd_weapon(weapon_cd, descr) values('okmachinegun', 'Overkill Machine Gun');
+insert into cd_weapon(weapon_cd, descr) values('okrpc', 'Overkill Rocket-Propelled Chainsaw');
 
 -- achievements
 insert into cd_achievement(achievement_cd, descr, active_ind)
@@ -204,6 +227,8 @@ insert into players (nick) values ('Untracked Player');
 \i triggers/player_game_stats_ins_trg.sql
 \i triggers/player_weapon_stats_ins_trg.sql
 \i triggers/team_game_stats_ins_trg.sql
+\i triggers/player_game_frag_matrix_ins_trg.sql
+\i triggers/player_game_nonparticipants_ins_trg.sql
 
 -- version tracking
 insert into db_version(version, descr) values('1.0.0', 'Initial build');