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 | | 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 | |
| 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 | varchar(100) | NO | | UTC | |
| sorting_comments | 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 | | |
+--------------------+------------+--------------------+--------------+----------------+-----------+-------------+----------+--------+------+------------+---------+---------------+