User:Woozle/UserNuke - Revision history

Woozle: key tables

2012-04-16T18:07:34Z

key tables

← Older revision		Revision as of 18:07, 16 April 2012
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/~~recent_changes~~\|~~recent_changes~~]]: rc_user, rc_user_text		* [[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/~~user_former_group~~\|~~user_former_group~~]]: ufg_user		* [[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

Woozle: /* Notes */ table name

2012-04-16T17:31:31Z

Notes: table name

← Older revision		Revision as of 17:31, 16 April 2012
Line 8:		Line 8:
	* [[MediaWiki/schema/archive\|archive]]: ar_user -> user.user_id, ar_user_text -> user.user_name		* [[MediaWiki/schema/archive\|archive]]: ar_user -> user.user_id, ar_user_text -> user.user_name
	* [[MediaWiki/schema/external_user\|external_user]]: eu_local_id -> user.user_id		* [[MediaWiki/schema/external_user\|external_user]]: eu_local_id -> user.user_id
	* [[MediaWiki/schema/~~file_archive~~\|~~file_archive~~]]: fa_user -> user.user_id, fa_user_text -> user.user_name		* [[MediaWiki/schema/filearchive\|filearchive]]: fa_user -> user.user_id, fa_user_text -> user.user_name
	* [[MediaWiki/schema/image\|image]]: img_user -> user.user_id, img_user_text -> user.user_name		* [[MediaWiki/schema/image\|image]]: img_user -> user.user_id, img_user_text -> user.user_name
	* [[MediaWiki/schema/ipblocks\|ipblocks]]: ipb_user		* [[MediaWiki/schema/ipblocks\|ipblocks]]: ipb_user

Woozle: brief description, list of tables

2012-04-16T16:19:27Z

brief description, list of tables

New page

==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:
* [[MediaWiki/schema/archive|archive]]: ar_user -> user.user_id, ar_user_text -> user.user_name
* [[MediaWiki/schema/external_user|external_user]]: eu_local_id -> user.user_id
* [[MediaWiki/schema/file_archive|file_archive]]: fa_user -> user.user_id, fa_user_text -> user.user_name
* [[MediaWiki/schema/image|image]]: img_user -> user.user_id, img_user_text -> user.user_name
* [[MediaWiki/schema/ipblocks|ipblocks]]: ipb_user
* [[MediaWiki/schema/ipblocks_old|ipblocks_old]]: ipb_user
* [[MediaWiki/schema/logging|logging]]: log_user
* [[MediaWiki/schema/oldimage|oldimage]]: oi_user, oi_user_text
* [[MediaWiki/schema/page_restrictions|page_restrictions]]: pr_user
* [[MediaWiki/schema/protected_titles|protected_titles]]: pt_user
* [[MediaWiki/schema/recent_changes|recent_changes]]: rc_user, rc_user_text
* [[MediaWiki/schema/revision|revision]]: rev_user, rev_user_text
* [[MediaWiki/schema/uploadstash|uploadstash]]: us_user
* [[MediaWiki/schema/user|user]]: master user table
* [[MediaWiki/schema/user_former_group|user_former_group]]: ufg_user
* [[MediaWiki/schema/user_groups|user_groups]]: ug_user
* [[MediaWiki/schema/user_newtalk|user_newtalk]]: user_id
* [[MediaWiki/schema/user_properties|user_properties]]: up_user
* [[MediaWiki/schema/watchlist|watchlist]]: wl_user