Manual:User properties table

The user_properties table stores user preferences. It replaces the old user.user_options blob. Only non-default settings are stored, so changes to the defaults are now reflected for everybody that hasn't saved an alternative preference, not only new accounts.

+-+--+--+-+-++ | Field      | Type             | Null | Key | Default | Extra          | +-+--+--+-+-++ | up_user    | int(10) unsigned |      | UNI |         |                | | up_property | varbinary(32)   |      | MUL |         |                | | up_value   | blob             |      |     |         |                | +-+--+--+-+-++

up_user
Foreign key to the  field of the user table.

up_property
The user preference. Examples: 'gender', 'rememberpassword', 'watchcreations'.

up_value
The preference value.