By flush out, I mean deleting any reference to the user in the given tables. In the case of viewed_stories, the column is just "uid" - DELETE FROM viewed_stories WHERE uid=<uid>. For sessions, who's online, and the preferences it depends on your scoop version. Some are a column name proper. Others have a UID buried somewhere as a value. Chris Schults wrote: > 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 >> > > _______________________________________________ > Scoop-help mailing list > Scoop-help at lists.kuro5hin.org > http://lists.kuro5hin.org/mailman/listinfo/scoop-help >