Manual:User properties table/ja

user_properties テーブルは、利用者の個人設定を保持します. 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.

スキーマの要約
DESCRIBE user_properties; +-++--+-+-++ +-++--+-+-++ +-++--+-+-++
 * Field      | Type           | Null | Key | Default | Extra          |
 * up_user    | int(11)        | NO   | PRI | NULL    |                |
 * up_property | varbinary(255) | NO  | PRI | NULL    |                |
 * up_value   | blob           | YES  |     | NULL    |                |

DESCRIBE user_properties; +-+---+--+-+-++ +-+---+--+-+-++ +-+---+--+-+-++
 * Field      | Type          | Null | Key | Default | Extra          |
 * up_user    | int(11)       | NO   | PRI | NULL    |                |
 * up_property | varbinary(32) | NO  | PRI | NULL    |                |
 * up_value   | blob          | YES  |     | NULL    |                |

up_user
Foreign key to the  field of the  table.

up_property
利用者の個人設定. を参照してください. 例:,  ,

up_value
The preference value.