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   |     | 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      |         |               |
+--------------------+------------+--------------------+--------------+----------------+-----------+-------------+----------+--------+------+------------+---------+---------------+	

Comments