We need a strategy when deleting an ejabberd user

cleartext / ximpp-server

Cleartext ESM - MIcroblogging

3 stars 0 forks source link

We need a strategy when deleting an ejabberd user #55

Closed cleartext closed 14 years ago

cleartext commented 14 years ago

We need to decide what we delete or clean up in the bot's database when we delete an ejabberd user.

We should keep the message archive, but the user will be in other tables as well so what are the relationships we should delete and keep?

cleartext commented 14 years ago

I can make some guesses but I'm not sure what would break if I start deleting rows in tables that the bot uses.

svetlyak40wt commented 14 years ago

Bot uses only these tables: users, subscribers, search_terms.

When user deleted from 'users' table, you should 'DELETE FROM subscribers WHERE user=username;' and 'DELETE FROM search_term WHERE username=username;

cleartext commented 14 years ago

great thanks