-- drop tables first in reverse order
+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;
\i tables/player_medals.tab
\i tables/merged_servers.tab
\i tables/player_agg_stats_mv.tab
+\i tables/player_game_frag_matrix.tab
begin;
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 RPC');
-- achievements
insert into cd_achievement(achievement_cd, descr, active_ind)
\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
-- version tracking
insert into db_version(version, descr) values('1.0.0', 'Initial build');