user_setting table
Fields
Schema summary
DESCRIBE user_setting;
6.1
+-------------------+---------------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +-------------------+---------------------+------+-----+---------+----------------+ | setting_id | int(10) unsigned | NO | PRI | NULL | auto_increment | | user_id | int(10) unsigned | NO | UNI | 0 | | | theme | varchar(20) | YES | | NULL | | | user_lang | varchar(5) | NO | | | | | list_count | int(10) unsigned | NO | | 50 | | | menu_items | int(2) unsigned | NO | | 5 | | | dont_redirect | tinyint(1) unsigned | YES | | NULL | | | send_watchmail | tinyint(1) unsigned | YES | MUL | NULL | | | show_files | tinyint(1) unsigned | YES | | NULL | | | show_comments | tinyint(1) unsigned | NO | | 1 | | | doubleclick_edit | tinyint(1) unsigned | NO | | 1 | | | show_spaces | tinyint(1) unsigned | NO | | 1 | | | autocomplete | tinyint(1) unsigned | NO | | 0 | | | numerate_links | tinyint(1) unsigned | NO | | 1 | | | diff_mode | tinyint(1) unsigned | NO | | 3 | | | notify_minor_edit | tinyint(1) unsigned | NO | | 1 | | | notify_page | tinyint(1) unsigned | NO | | 2 | | | notify_comment | tinyint(1) unsigned | NO | | 1 | | | allow_intercom | tinyint(1) unsigned | NO | | 0 | | | allow_massemail | tinyint(1) unsigned | NO | | 0 | | | hide_lastsession | tinyint(1) unsigned | YES | | NULL | | | validate_ip | tinyint(1) unsigned | YES | | NULL | | | noid_pubs | tinyint(1) unsigned | NO | | 0 | | | session_length | tinyint(3) unsigned | YES | | NULL | | | timezone | varchar(100) | NO | | UTC | | | date_preference | varchar(10) | YES | | default | | | sorting_comments | tinyint(1) unsigned | NO | | 0 | | | comments_offset | tinyint(1) unsigned | NO | | 0 | | +-------------------+---------------------+------+-----+---------+----------------+
6.0
+-------------------+---------------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +-------------------+---------------------+------+-----+---------+----------------+ | setting_id | int(10) unsigned | NO | PRI | NULL | auto_increment | | user_id | int(10) unsigned | NO | UNI | 0 | | | theme | varchar(20) | YES | | NULL | | | user_lang | varchar(5) | NO | | NULL | | | list_count | int(10) unsigned | NO | | 50 | | | menu_items | int(2) unsigned | NO | | 5 | | | dont_redirect | tinyint(1) unsigned | YES | | NULL | | | send_watchmail | tinyint(1) unsigned | YES | MUL | NULL | | | show_files | tinyint(1) unsigned | YES | | NULL | | | show_comments | tinyint(1) unsigned | NO | | 1 | | | doubleclick_edit | tinyint(1) unsigned | NO | | 1 | | | show_spaces | tinyint(1) unsigned | NO | | 1 | | | typografica | tinyint(1) unsigned | NO | | 1 | | | autocomplete | tinyint(1) unsigned | NO | | 0 | | | numerate_links | tinyint(1) unsigned | NO | | 1 | | | diff_mode | tinyint(1) unsigned | NO | | 2 | | | notify_minor_edit | tinyint(1) unsigned | NO | | 1 | | | notify_page | tinyint(1) unsigned | NO | | 2 | | | notify_comment | tinyint(1) unsigned | NO | | 1 | | | allow_intercom | tinyint(1) unsigned | NO | | 0 | | | allow_massemail | tinyint(1) unsigned | NO | | 0 | | | hide_lastsession | tinyint(1) unsigned | YES | | NULL | | | validate_ip | tinyint(1) unsigned | YES | | NULL | | | noid_pubs | tinyint(1) unsigned | NO | | 0 | | | session_length | tinyint(3) unsigned | YES | | NULL | | | timezone | decimal(5,2) | NO | | 0.00 | | | dst | tinyint(1) unsigned | NO | | 0 | | | sorting_comments | tinyint(1) unsigned | NO | | 0 | | +-------------------+---------------------+------+-----+---------+----------------+
Indices
SHOW INDEX IN user_setting;
+--------------------+------------+--------------------+--------------+----------------+-----------+-------------+----------+--------+------+------------+---------+---------------+ | Table | Non_unique | Key_name | Seq_in_index | Column_name | Collation | Cardinality | Sub_part | Packed | Null | Index_type | Comment | Index_comment | +--------------------+------------+--------------------+--------------+----------------+-----------+-------------+----------+--------+------+------------+---------+---------------+ | wacko_user_setting | 0 | PRIMARY | 1 | setting_id | A | 10 | NULL | NULL | | BTREE | | | | wacko_user_setting | 0 | idx_user_id | 1 | user_id | A | 10 | NULL | NULL | | BTREE | | | | wacko_user_setting | 1 | idx_send_watchmail | 1 | send_watchmail | A | 5 | NULL | NULL | YES | BTREE | | | +--------------------+------------+--------------------+--------------+----------------+-----------+-------------+----------+--------+------+------------+---------+---------------+