X-Git-Url: https://ruin.nu/git/?a=blobdiff_plain;f=database%2Fclean-webbie.sql;h=9376126d9f4e2251f30482319f8fee40c2a8fb8c;hb=eb3bda37d084c0e6b13c97f88f06d5563c40d2fb;hp=2ba111864429121ddbd5d8274997c0d3026a6e14;hpb=4c81b886fbd6f50b0945d2a35b0559209fa7be9c;p=ndwebbie.git diff --git a/database/clean-webbie.sql b/database/clean-webbie.sql index 2ba1118..9376126 100644 --- a/database/clean-webbie.sql +++ b/database/clean-webbie.sql @@ -7,10 +7,10 @@ TRUNCATE fleet_ships; TRUNCATE incomings; TRUNCATE raid_claims; /*TRUNCATE dumps;*/ +TRUNCATE scan_requests; TRUNCATE fleet_scans; TRUNCATE planet_scans; -TRUNCATE structure_scans; -TRUNCATE tech_scans; +TRUNCATE development_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; @@ -36,3 +36,4 @@ 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; +ALTER SEQUENCE scan_requests_id_seq RESTART 1;