Manual talk:User table

user_name being binary (probably in an effort to support multi-language) treats names in case-sensitive format. Thus, if there exists a trusted user 'Admin', and if a new user maliciously attempts to register as 'AdmiN', the user is most likely allowed to register with that username. I'm not quite too sure what consequences this will be other then possibly fooling few admins when browsing through the "Recent Changes" section and mistake a trusted user changes from somebody else... Any suggestions?


 * See http://bugzilla.wikimedia.org/show_bug.cgi?id=2290 in general. --brion 23:51, 22 Jun 2005 (UTC)

I've created a user "Brion VIBBEr" thinking this homograph feature was already there, please delete that user.

user_touched column
Is user_touched a record of the last time a person logged in or the last they made a change? I don't think it's obvious - could someone fill it in? - Mpnolan 07:32, 26 March 2006 (UTC)
 * yes that will be nice... if anyone knows that...--84.58.212.214 18:45, 12 April 2006 (UTC)
 * in version 1.10, this is the date and time of the last change to any page on the wiki made by a particular user, i.e. the last time a user "touched" (modified) the content of the site, including user pages and user preferences. --74.167.38.9 15:46, 8 June 2007 (UTC)

Investigations have revealed

 * An example content of user_touched (in my wiki DB) is 20060806161207. This is a standard date format: YYYYMMDDHHMMSS and combining this with the title suggests the data is a "last visited" or "last edited" value. Going in and out of my wiki does not change this value, so I suggest that it's a "Last made an edit" value.--DeadMeatGF 17:03, 6 August 2006 (UTC)

Update

 * I've made an edit and checked again, but it's not changed - so it's not a "Last Edit" or a "Last Visit" value.--DeadMeatGF 17:04, 6 August 2006 (UTC)

There is some info in docs/user.txt and in maintenance/archives/patch-cache.sql Natmaka 17:15, 19 August 2006 (UTC)

Update

 * The value is updated whenever you change user preferences. Poupouille 14:45, 3 November 2006 (UTC)


 * http://mail.wikipedia.org/pipermail/mediawiki-l/2005-September/007216.html --217.230.179.4 20:51, 3 January 2007 (UTC)

deleting users
Can users be deleted without corrupting the database or whatever? -Eep 07:25, 31 May 2006 (UTC)

Answer: Seems like it, yes. If the user had made edits to the site, references to the user will be a red (missing) link.

user_real_name
The content page says use in mediawiki unknown; however, I'd like to point out that from an administrator standpoint, it's sure nice to be able to look up who users actually are (or say they are). Especially on smaller wikis where people are unlikely to lie and you're more likely to care who everyone is. -Semisomna 10:11, 6 November 2006 (UTC)
 * Added it today --74.167.38.9 15:31, 8 June 2007 (UTC)

Support for Custom User Attributes?
Does the user_options blob support custom attributes for users?

I am operating an industry association wiki (using MediaWiki of course), and it would be nice to be able to define other user attributes (such as the company the user is from) and display them on the Special:Userlist.

How would I go about doing this?