Service/git: Difference between revisions

← Older edit Newer edit →

@@ Line 57: / Line 57: @@
   update users set email='OLDEMAIL' where login='USER';
-=== WARNING ===
+=== Zapping a user account
-To zap a user account, make sure you also remove
-its related records from all tables (committers,
+WARNING: to zap a user account, make sure you also remove its related records
-projects, repositories, events...)
+from all tables, or Gitorious will break in non-obvious ways.
+ SELECT id FROM users WHERE login='demian';
+ DELETE FROM committers WHERE user_id=666;
+ DELETE FROM events WHERE user_id=666;
+ DELETE FROM comments WHERE user_id=666;
+ DELETE FROM merge_requests WHERE user_id=666;
+ DELETE FROM repositories WHERE user_id=666;
+ DELETE FROM projects WHERE user_id=666;
 === Restart gitorious after code/config changes ===
   touch tmp/restart.txt