From 4c81b886fbd6f50b0945d2a35b0559209fa7be9c Mon Sep 17 00:00:00 2001 From: Michael Andreen Date: Sun, 17 Aug 2008 02:50:43 +0200 Subject: [PATCH] Updated the script for cleaning webbie between rounds --- database/clean-webbie.sql | 9 +++++++-- 1 file changed, 7 insertions(+), 2 deletions(-) diff --git a/database/clean-webbie.sql b/database/clean-webbie.sql index 87441ad..2ba1118 100644 --- a/database/clean-webbie.sql +++ b/database/clean-webbie.sql @@ -6,9 +6,12 @@ TRUNCATE graphs; TRUNCATE fleet_ships; TRUNCATE incomings; TRUNCATE raid_claims; -TRUNCATE dumps; +/*TRUNCATE dumps;*/ TRUNCATE fleet_scans; -TRUNCATE planet_data; +TRUNCATE planet_scans; +TRUNCATE structure_scans; +TRUNCATE tech_scans; +TRUNCATE irc_requests; UPDATE users SET scan_points = 0, defense_points = 0, attack_points = 0, humor_points = 0, rank = NULL, planet = NULL; DELETE FROM scans; DELETE FROM raids; @@ -20,6 +23,7 @@ DELETE FROM alliances WHERE id > 1; SELECT * FROM alliances; DELETE FROM forum_threads WHERE fbid = -2; DELETE FROM forum_threads WHERE fbid = -3; +DELETE FROM forum_threads WHERE fbid = -5; DELETE FROM forum_threads WHERE fbid = 12; DELETE FROM forum_posts WHERE ftid IN (SELECT ftid FROM forum_threads WHERE fbid = -1); ALTER SEQUENCE alliances_id_seq RESTART 2; @@ -31,3 +35,4 @@ ALTER SEQUENCE planets_id_seq RESTART 1; ALTER SEQUENCE raid_targets_id_seq RESTART 1; ALTER SEQUENCE raids_id_seq RESTART 1; ALTER SEQUENCE scans_id_seq RESTART 1; +ALTER SEQUENCE irc_requests_id_seq RESTART 1; -- 2.39.2