DELETE FROM "action" WHERE act_user_id = 1646;
DELETE FROM "issue" WHERE poster_id = 1646;
DELETE FROM "notification" WHERE updated_by = 1646;
DELETE FROM "team" WHERE org_id IN (SELECT org_id FROM "org_user" WHERE uid = 1646);
DELETE FROM "user" WHERE id IN (SELECT org_id FROM "org_user" WHERE uid = 1646);
DELETE FROM "org_user" WHERE uid = 1646;
DELETE FROM "repo_unit" WHERE repo_id IN (SELECT id FROM "repository" WHERE owner_id = 1646);
DELETE FROM "repository" WHERE owner_id = 1646;
DELETE FROM "team_user" WHERE uid = 1646;
DELETE FROM "watch" WHERE user_id = 1646;
DELETE FROM "issue_user" WHERE repo_id IS NULL OR uid = 1646;
DELETE FROM "team" WHERE org_id NOT IN (SELECT id from "user");
UPDATE repository r SET num_issues = (SELECT count(*) FROM issue i WHERE i.repo_id = r.id GROUP BY r.id);