X-Git-Url: https://ruin.nu/git/?a=blobdiff_plain;f=database%2Fclean-webbie.sql;h=87441ad38cd541c1193b4f0feb530ff58bd0a652;hb=f9f06136c85f9634c409b71e18452c358530556e;hp=24e469c5c17f6f010c91fbda2f3be709ef4b4ff6;hpb=f2c438684b7835e8c2033999fcc020d9352afca8;p=ndwebbie.git diff --git a/database/clean-webbie.sql b/database/clean-webbie.sql index 24e469c..87441ad 100644 --- a/database/clean-webbie.sql +++ b/database/clean-webbie.sql @@ -14,10 +14,12 @@ DELETE FROM scans; DELETE FROM raids; DELETE FROM calls; DELETE FROM fleets; +DELETE FROM covop_attacks; DELETE FROM planets ; 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 = 12; DELETE FROM forum_posts WHERE ftid IN (SELECT ftid FROM forum_threads WHERE fbid = -1); ALTER SEQUENCE alliances_id_seq RESTART 2;