sogo_db

mysql> desc sogo_view;
+------------+-------------+------+-----+---------+-------+
| Field      | Type        | Null | Key | Default | Extra |
+------------+-------------+------+-----+---------+-------+
| c_uid      | varchar(60) | YES  |     | NULL    |       |
| c_name     | varchar(60) | YES  |     | NULL    |       |
| c_password | varchar(60) | YES  |     | NULL    |       |
| c_cn       | varchar(60) | YES  |     | NULL    |       |
| mail       | varchar(60) | YES  |     | NULL    |       |
+------------+-------------+------+-----+---------+-------+
5 rows in set (0.00 sec)

mysql> desc sogo_session_folder;
+------------+--------------+------+-----+---------+-------+
| Field      | Type         | Null | Key | Default | Extra |
+------------+--------------+------+-----+---------+-------+
| c_uid      | varchar(255) | NO   | PRI | NULL    |       |
| c_defaults | text         | YES  |     | NULL    |       |
| c_settings | text         | YES  |     | NULL    |       |
+------------+--------------+------+-----+---------+-------+
3 rows in set (0.00 sec)

mysql> desc sogo_user_profile;
+------------+--------------+------+-----+---------+-------+
| Field      | Type         | Null | Key | Default | Extra |
+------------+--------------+------+-----+---------+-------+
| c_uid      | varchar(255) | NO   | PRI | NULL    |       |
| c_defaults | text         | YES  |     | NULL    |       |
| c_settings | text         | YES  |     | NULL    |       |
+------------+--------------+------+-----+---------+-------+
3 rows in set (0.00 sec)

mysql>