X-Git-Url: https://ruin.nu/git/?p=ndwebbie.git;a=blobdiff_plain;f=database%2Fclean-webbie.sql;h=b68cda86e62fb2513814ede42be607694ff1a7a6;hp=b8041c44352366260121e84c465e64aaccf9f1e6;hb=b14e0fb561f9c6cfdf06e76ff45c36c99c133545;hpb=833b02ec09d59a4968de6c3117e29654e5edca4b 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';