Schema:user preferences
Jump to navigation
Jump to search
Schema Summary
+---------------------------------+-------------------------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+---------------------------------+-------------------------------+------+-----+---------+----------------+
| user_pref_id | int(11) | NO | PRI | NULL | auto_increment |
| user_id | int(11) | YES | MUL | NULL | |
| concise_disp | int(1) | YES | MUL | NULL | |
| display_all_languages | enum('All','None','Selected') | YES | | NULL | |
| default_language | int(11) | YES | | NULL | |
| covers_display | tinyint(1) | YES | | NULL | |
| suppress_translation_warnings | tinyint(1) | YES | | NULL | |
| suppress_bibliographic_warnings | tinyint(1) | YES | | NULL | |
| cover_links_display | tinyint(1) | YES | | NULL | |
| keep_spaces_in_searches | tinyint(1) | YES | | NULL | |
| suppress_help_bubbles | tinyint(1) | YES | | NULL | |
| suppress_awards | tinyint(1) | YES | | NULL | |
| suppress_reviews | tinyint(1) | YES | | NULL | |
| display_post_submission | tinyint(1) | YES | | NULL | |
+---------------------------------+-------------------------------+------+-----+---------+----------------+
Description
The user_preferences table is used to store user preferences. Each entry is associated with a registered user ID. This table is maintained via the "User Preferences" Web page.
- user_pref_id - Unique key ID.
- user_id - User ID of the registered user.
- concise_disp - 0/ 1 flag to indicate whether user prefers a concise display.
- display_all_languages - Value indicating how to display translations on Summary and Series pages for this user. The currently supported values are "All" for "Display all translations", "None" for "Do not display any translations" and "Selected" for "Display only translations listed in the table "user_languages" for this user.
- default_language - Numeric code of the language which will be used as this user's default in the drop-down list of languages. The list is displayed when editing authors and titles.
- covers_display - 0/1 flag indicating whether to display cover images on title pages.
- suppress_translation_warnings - 0/1 flag indicating whether to display translation warnings on Author and Series pages.
- suppress_bibliographic_warnings - 0/1 flag indicating whether to display bibliographic warnings about missing information on title pages.
- cover_links_display - 0/1 flag indicating whether to display cover scan indicators on Title pages.
- keep_spaces_in_searches - 0/1 flag indicating whether to keep or strip leading and trailing spaces in submitted search strings.
- suppress_help_bubbles - 0/1 flag indicating whether to display mouseover help on Edit pages.
- suppress_awards - 0/1 flag indicating whether to display awards on title pages.
- suppress_reviews - 0/1 flag indicating whether to display reviews on title pages.
- display_post_submission - 0/1 flag indicating whether to display post-submission review pages.