1,764
edits
Changes
Jump to navigation
Jump to search
Line 57:
Line 57: − + − To zap a user account, make sure you also remove+ − + − + + + + + + + + +
no edit summary
update users set email='OLDEMAIL' where login='USER';
update users set email='OLDEMAIL' where login='USER';
=== WARNING ===
=== Zapping a user account
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 ===
=== Restart gitorious after code/config changes ===
touch tmp/restart.txt
touch tmp/restart.txt