Manual:User properties table

The user_properties table stores user preferences.

It replaces the old  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(255)  |      | MUL |         |                | | up_value   | blob             |      |     |         |                | +-+--+--+-+-++

up_user
Foreign key to the  field of the  table.

up_property
The user preference, see .

Examples:,  ,

up_value
The preference value.