[Scoop-help] Delete user account

[Chris Schults]

Thanks Cory.

What do you mean exactly by "flush out"?

Chris

-----Original Message-----
From: Cory R. King [mailto:coryking at xlan.org] 
Sent: Wednesday, July 12, 2006 9:07 AM
To: Chris Schults
Cc: scoop-help at lists.kuro5hin.org
Subject: Re: [Scoop-help] Delete user account

Hello Chris,

DELETE FROM users WHERE nickname'<nickame>'
  or better:
DELETE FROM users WHERE uid=<uid>

Make sure to flush out the following tables as well:

sessions
whos_online
viewed_stories

There are probably a couple more tables that are filled in as well, but 
I forget which ones; something like a preferences table.

--
Cory R. King

Chris Schults wrote:
> I need to delete a user account, which hasn't posted a story or comment
yet.
> What is the best way?
> 
> Chris
> 
> --------------------------
> 
> Chris Schults
> Web Production Manager
> Grist Magazine
> 710 Second Avenue, Suite 860
> Seattle, WA  98104
> Phone: 206-876-2020, ext. 204
> Fax: 253-423-6487
> <http://www.grist.org>
> 
> To sign up for Grist by email, the world's top environmental news served
up
> with a sense of humor, click here <http://www.grist.org/signup/> or send a
> blank email message to <daily-grist-subscribe at lists.grist.org> 
> 
> _______________________________________________
> Scoop-help mailing list
> Scoop-help at lists.kuro5hin.org
> http://lists.kuro5hin.org/mailman/listinfo/scoop-help
>