From 7d454a73da66260adc5ef86ec4d89a38ff4b8756 Mon Sep 17 00:00:00 2001
From: Ant Zucaro <azucaro@gmail.com>
Date: Sat, 22 Apr 2017 16:44:25 -0400
Subject: [PATCH] Add a SQL script to clean the DB.

---
 scripts/clean_database.sql | 22 ++++++++++++++++++++++
 1 file changed, 22 insertions(+)
 create mode 100644 scripts/clean_database.sql

diff --git a/scripts/clean_database.sql b/scripts/clean_database.sql
new file mode 100644
index 0000000..a836d9b
--- /dev/null
+++ b/scripts/clean_database.sql
@@ -0,0 +1,22 @@
+-- cleans the database for Elo testing and comparison
+truncate table games cascade;
+truncate table maps cascade;
+truncate table servers cascade;
+truncate table player_game_stats cascade;
+truncate table player_weapon_stats cascade;
+truncate table hashkeys cascade;
+truncate table player_elos cascade;
+truncate table player_nicks cascade;
+truncate table player_ranks cascade;
+truncate table achievements cascade;
+truncate table hashkeys cascade;
+truncate table player_elos cascade;
+truncate table player_game_anticheats cascade;
+truncate table player_game_stats cascade;
+truncate table player_groups cascade;
+truncate table player_map_captimes cascade;
+truncate table player_medals cascade;
+truncate table player_nicks cascade;
+truncate table player_ranks cascade;
+truncate table player_weapon_stats cascade;
+delete from players where player_id > 2;
-- 
2.39.2