Changes

236 bytes added ,  12:33, 18 August 2010
no edit summary
Line 57: Line 57:  
  update users set email='OLDEMAIL' where login='USER';
 
  update users set email='OLDEMAIL' where login='USER';
   −
=== Zapping a user account
+
=== Zapping a user account ===
   −
WARNING: to zap a user account, make sure you also remove its related records
+
WARNING: to kill a user account, make sure you also remove *ALL* its associated records
 
from all tables, or Gitorious will break in non-obvious ways.
 
from all tables, or Gitorious will break in non-obvious ways.
   Line 69: Line 69:  
  DELETE FROM repositories WHERE user_id=666;
 
  DELETE FROM repositories WHERE user_id=666;
 
  DELETE FROM projects WHERE user_id=666;
 
  DELETE FROM projects WHERE user_id=666;
 +
 +
NOTE: tch pointed out that Rails applications often provide a higher-level method
 +
in class User which deletes the record and its associated entries. However, our
 +
deployed version of Gitorious does not seem to provide it.
    
=== Restart gitorious after code/config changes ===
 
=== Restart gitorious after code/config changes ===
 
  touch tmp/restart.txt
 
  touch tmp/restart.txt