Deleting User with mysql ...

Deleting User with mysql ...

ved Peter Sereinigg -
Antal besvarelser: 3

If I delete users using mysql, are then all informations from these users automaticly deleted in all tabels? (Database integrity rules ...)

Background: In the courses at university I will have to manage are 50 Students each course, 3 courses ...
you see al lot of deleting ...
The selection could be using the city information for the groups as a criterium...

Thanks Peter

Gennemsnitsbedømmelse: -
I svar til Peter Sereinigg

Re: Deleting User with mysql ...

ved Martin Dougiamas -
Billede af Core developers Billede af Documentation writers Billede af Moodle HQ Billede af Particularly helpful Moodlers Billede af Plugin developers Billede af Testers
No, they are not deleted everywhere and you will cause serious problems.  Don't delete things manually in the tables.

You can delete users on the admin user page ... it will mark accounts as deleted but retain the account for data integrity.


Gennemsnitsbedømmelse:Useful (1)
I svar til Martin Dougiamas

Re: Deleting User with mysql ...

ved Peter Sereinigg -

... a wish to santa clause (or better easter rabbit, this is sooner ...)... bachjob from a file to delete users ...

Thanks

Peter

Gennemsnitsbedømmelse: -
I svar til Martin Dougiamas

Re: Deleting User with mysql ...

ved Patrik Nilsson -
I been searching the forums and I think this is the closed to the question I get.
Martin you talk about deleting users in the admin page. I also noticed in the newest version there is a function that delete a user from a course if not seen for so many days. But is it possible to use the same script and modify so it deletes the user frommoodle after not seen for so many days.
Gennemsnitsbedømmelse: -