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