1 TRUNCATE planet_stats ;
3 TRUNCATE alliance_stats ;
4 TRUNCATE defense_requests;
12 UPDATE users SET scan_points = 0, defense_points = 0, attack_points = 0, humor_points = 0, rank = NULL, planet = NULL;
18 DELETE FROM alliances WHERE id > 1;
19 SELECT * FROM alliances;
20 DELETE FROM forum_threads WHERE fbid = -2;
21 DELETE FROM forum_threads WHERE fbid = -3;
22 DELETE FROM forum_threads WHERE fbid = 12;
23 DELETE FROM forum_posts WHERE ftid IN (SELECT ftid FROM forum_threads WHERE fbid = -1);
24 ALTER SEQUENCE alliances_id_seq RESTART 2;
25 ALTER SEQUENCE calls_id_seq RESTART 1;
26 ALTER SEQUENCE defense_requests_id_seq RESTART 1;
27 ALTER SEQUENCE fleets_id_seq RESTART 1;
28 ALTER SEQUENCE incomings_id_seq RESTART 1;
29 ALTER SEQUENCE planets_id_seq RESTART 1;
30 ALTER SEQUENCE raid_targets_id_seq RESTART 1;
31 ALTER SEQUENCE raids_id_seq RESTART 1;
32 ALTER SEQUENCE scans_id_seq RESTART 1;