Difference between revisions of "User:Woozle/UserNuke"
Jump to navigation
Jump to search
m (→Notes: table name) |
(key tables) |
||
| Line 13: | Line 13: | ||
* [[MediaWiki/schema/ipblocks_old|ipblocks_old]]: ipb_user | * [[MediaWiki/schema/ipblocks_old|ipblocks_old]]: ipb_user | ||
* [[MediaWiki/schema/logging|logging]]: log_user | * [[MediaWiki/schema/logging|logging]]: log_user | ||
| + | ** includes user creation, but no need to delete these events | ||
* [[MediaWiki/schema/oldimage|oldimage]]: oi_user, oi_user_text | * [[MediaWiki/schema/oldimage|oldimage]]: oi_user, oi_user_text | ||
* [[MediaWiki/schema/page_restrictions|page_restrictions]]: pr_user | * [[MediaWiki/schema/page_restrictions|page_restrictions]]: pr_user | ||
* [[MediaWiki/schema/protected_titles|protected_titles]]: pt_user | * [[MediaWiki/schema/protected_titles|protected_titles]]: pt_user | ||
| − | * [[MediaWiki/schema/ | + | * [[MediaWiki/schema/recentchanges|recentchanges]]: rc_user, rc_user_text |
* [[MediaWiki/schema/revision|revision]]: rev_user, rev_user_text | * [[MediaWiki/schema/revision|revision]]: rev_user, rev_user_text | ||
* [[MediaWiki/schema/uploadstash|uploadstash]]: us_user | * [[MediaWiki/schema/uploadstash|uploadstash]]: us_user | ||
* [[MediaWiki/schema/user|user]]: master user table | * [[MediaWiki/schema/user|user]]: master user table | ||
| − | * [[MediaWiki/schema/ | + | * [[MediaWiki/schema/user_former_groups|user_former_groups]]: ufg_user |
* [[MediaWiki/schema/user_groups|user_groups]]: ug_user | * [[MediaWiki/schema/user_groups|user_groups]]: ug_user | ||
* [[MediaWiki/schema/user_newtalk|user_newtalk]]: user_id | * [[MediaWiki/schema/user_newtalk|user_newtalk]]: user_id | ||
* [[MediaWiki/schema/user_properties|user_properties]]: up_user | * [[MediaWiki/schema/user_properties|user_properties]]: up_user | ||
* [[MediaWiki/schema/watchlist|watchlist]]: wl_user | * [[MediaWiki/schema/watchlist|watchlist]]: wl_user | ||
| + | |||
| + | Affected even if unblessed users are read-only: | ||
| + | * [[MediaWiki/schema/recentchanges|recentchanges]] | ||
| + | * [[MediaWiki/schema/revision|revision]] -- only for pages with more than one edit, maybe? | ||
| + | * [[MediaWiki/schema/user_groups|user_groups]] -- if user's group has changed | ||
| + | * [[MediaWiki/schema/user_properties|user_properties]] -- set of properties for every user | ||
Latest revision as of 18:07, 16 April 2012
About
"Spam users" are user accounts created solely for the purpose of spamming. They typically make one edit, or a very small number of edits (e.g. upload one file, create one page with spam text and the uploaded image), each -- with the end result of a lot of user accounts that really should just be deleted.
User accounts are referred to by more than one table. We need to know all the places that refer to user accounts so that (a) we can present everything affected by a given user account, and (b) we can delete everything that user has done.
Notes
Tables that refer to user accounts:
- archive: ar_user -> user.user_id, ar_user_text -> user.user_name
- external_user: eu_local_id -> user.user_id
- filearchive: fa_user -> user.user_id, fa_user_text -> user.user_name
- image: img_user -> user.user_id, img_user_text -> user.user_name
- ipblocks: ipb_user
- ipblocks_old: ipb_user
- logging: log_user
- includes user creation, but no need to delete these events
- oldimage: oi_user, oi_user_text
- page_restrictions: pr_user
- protected_titles: pt_user
- recentchanges: rc_user, rc_user_text
- revision: rev_user, rev_user_text
- uploadstash: us_user
- user: master user table
- user_former_groups: ufg_user
- user_groups: ug_user
- user_newtalk: user_id
- user_properties: up_user
- watchlist: wl_user
Affected even if unblessed users are read-only:
- recentchanges
- revision -- only for pages with more than one edit, maybe?
- user_groups -- if user's group has changed
- user_properties -- set of properties for every user