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             |      |     |         |                | +-+--+--+-+-++

Fields

 * up_user : Foreign key to the  field of the user table.
 * up_property : The user preference.
 * up_value : The preference setting itself