From: Michael Andreen Date: Sat, 13 Jun 2020 12:01:32 +0000 (+0200) Subject: Cleaning database isn't done for shuffle anymore X-Git-Url: https://ruin.nu/git/?p=ndwebbie.git;a=commitdiff_plain;h=b14e0fb561f9c6cfdf06e76ff45c36c99c133545;hp=833b02ec09d59a4968de6c3117e29654e5edca4b Cleaning database isn't done for shuffle anymore --- diff --git a/database/clean-webbie.sql b/database/clean-webbie.sql index b8041c4..b68cda8 100644 --- a/database/clean-webbie.sql +++ b/database/clean-webbie.sql @@ -4,7 +4,7 @@ TRUNCATE alliance_stats ; TRUNCATE fleet_ships; TRUNCATE incomings; TRUNCATE raid_claims; -/*TRUNCATE dumps;*/ +TRUNCATE dumps; TRUNCATE scan_requests; TRUNCATE fleet_scans; TRUNCATE launch_confirmations; @@ -42,3 +42,4 @@ ALTER SEQUENCE scans_id_seq RESTART 1; ALTER SEQUENCE irc_requests_id_seq RESTART 1; ALTER SEQUENCE scan_requests_id_seq RESTART 1; ALTER SEQUENCE fleet_ships_num_seq RESTART 1; +UPDATE misc SET value = 0 WHERE id = 'TICK';