Add nick history table.

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

diff --git a/build/build_full.sql b/build/build_full.sql
old mode 100644 (file)
new mode 100755 (executable)
index 14662b5..5ee1362
--- a/build/build_full.sql
+++ b/build/build_full.sql
@@ -1,4 +1,5 @@
 -- drop tables first in reverse order
+drop table if exists player_nicks cascade;
 drop table if exists db_version cascade;
 drop table if exists hashkeys cascade;
 drop table if exists player_weapon_stats cascade;
@@ -31,6 +32,7 @@ drop table if exists players cascade;
 \i tables/player_weapon_stats.tab
 \i tables/hashkeys.tab
 \i tables/db_version.tab
+\i tables/player_nicks.tab
 
 begin;
 
@@ -166,6 +168,11 @@ values(15, 'g_jetpack');
 insert into players (nick) values ('Bot');
 insert into players (nick) values ('Untracked Player');
 
+-- triggers 
+\i triggers/games_ins_trg.sql
+\i triggers/player_game_stats_ins_trg.sql
+\i triggers/player_weapon_stats_ins_trg.sql
+
 -- version tracking
 insert into db_version(version, descr) values('1.0.0', 'Initial build');