-- 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;
\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;
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)