-TRUNCATE defense_requests;
-DELETE FROM alliances WHERE id > 1;
-SELECT * FROM alliances;
+TRUNCATE fleet_ships;
+TRUNCATE incomings;
+TRUNCATE raid_claims;
+/*TRUNCATE dumps;*/
+TRUNCATE scan_requests;
+TRUNCATE fleet_scans;
+TRUNCATE launch_confirmations;
+TRUNCATE full_fleets;
+TRUNCATE intel_scans;
+TRUNCATE planet_scans;
+TRUNCATE development_scans;
+TRUNCATE irc_requests;
+TRUNCATE available_planet_tags, planet_tags;
+UPDATE users SET scan_points = 0, defense_points = 0, attack_points = 0, humor_points = 0, rank = NULL, pid = NULL;
+DELETE FROM scans;
+DELETE FROM raids;
+DELETE FROM calls;
+DELETE FROM fleets;
+DELETE FROM intel;
+DELETE FROM covop_attacks;