Jisko

delete users

Asked by monk77

hi,

i want deleting a few users. do i must only delete a user in users-table and then all post of him disappears or must his posts be deleted manually?

Question information

Language:
English Edit question
Status:
Answered
For:
Jisko Edit question
Assignee:
No assignee Edit question
Last query:
Last reply:
Revision history for this message
Rubén Díaz (outime) said : 		#1

Use this three queries to do it:

DELETE FROM `notes` WHERE `notes`.`ID` = x;
DELETE FROM `favorites` WHERE `favorites`.`note_id` = x;
DELETE FROM `post2id` WHERE `post2id`.`note_id` = x;

Where 'x' is the ID of the user.

On Mon, Mar 2, 2009 at 12:15, monk77
<email address hidden> wrote:
> New question #62826 on Jisko:
> https://answers.launchpad.net/jisko/+question/62826
>
> hi,
>
> i want deleting a few users. do i must only delete a user in users-table and then all post of him disappears or must his posts be deleted manually?
>
> --
> You received this question notification because you are an answer
> contact for Jisko.
>

--
Rubén Díaz
GPG id 2354DA5F
http://diazr.com

Can you help with this problem?

Provide an answer of your own, or ask monk77 for more information if necessary.

To post a message you must log in.