OpenSim​/UserProfile

mysql> show columns from classifieds;
+-----------------+--------------+------+-----+---------+-------+
| Field           | Type         | Null | Key | Default | Extra |
+-----------------+--------------+------+-----+---------+-------+
| classifieduuid  | char(36)     | NO   | PRI | NULL    |       |
| creatoruuid     | char(36)     | NO   |     | NULL    |       |
| creationdate    | int(20)      | NO   |     | NULL    |       |
| expirationdate  | int(20)      | NO   |     | NULL    |       |
| category        | varchar(20)  | NO   |     | NULL    |       |
| name            | varchar(255) | NO   |     | NULL    |       |
| description     | text         | NO   |     | NULL    |       |
| parceluuid      | char(36)     | NO   |     | NULL    |       |
| parentestate    | int(11)      | NO   |     | NULL    |       |
| snapshotuuid    | char(36)     | NO   |     | NULL    |       |
| simname         | varchar(255) | NO   |     | NULL    |       |
| posglobal       | varchar(255) | NO   |     | NULL    |       |
| parcelname      | varchar(255) | NO   |     | NULL    |       |
| classifiedflags | int(8)       | NO   |     | NULL    |       |
| priceforlisting | int(5)       | NO   |     | NULL    |       |
+-----------------+--------------+------+-----+---------+-------+
15 rows in set (0.00 sec)

mysql> show columns from userdata;
+---------+--------------+------+-----+---------+-------+
| Field   | Type         | Null | Key | Default | Extra |
+---------+--------------+------+-----+---------+-------+
| UserId  | char(36)     | NO   | PRI | NULL    |       |
| TagId   | varchar(64)  | NO   | PRI | NULL    |       |
| DataKey | varchar(255) | YES  |     | NULL    |       |
| DataVal | varchar(255) | YES  |     | NULL    |       |
+---------+--------------+------+-----+---------+-------+
4 rows in set (0.00 sec)

mysql> show columns from usernotes ;
+------------+-------------+------+-----+---------+-------+
| Field      | Type        | Null | Key | Default | Extra |
+------------+-------------+------+-----+---------+-------+
| useruuid   | varchar(36) | NO   | PRI | NULL    |       |
| targetuuid | varchar(36) | NO   | PRI | NULL    |       |
| notes      | text        | NO   |     | NULL    |       |
+------------+-------------+------+-----+---------+-------+
3 rows in set (0.00 sec)

mysql> show columns from userpicks;
+--------------+----------------------+------+-----+---------+-------+
| Field        | Type                 | Null | Key | Default | Extra |
+--------------+----------------------+------+-----+---------+-------+
| pickuuid     | varchar(36)          | NO   | PRI | NULL    |       |
| creatoruuid  | varchar(36)          | NO   |     | NULL    |       |
| toppick      | enum('true','false') | NO   |     | NULL    |       |
| parceluuid   | varchar(36)          | NO   |     | NULL    |       |
| name         | varchar(255)         | NO   |     | NULL    |       |
| description  | text                 | NO   |     | NULL    |       |
| snapshotuuid | varchar(36)          | NO   |     | NULL    |       |
| user         | varchar(255)         | NO   |     | NULL    |       |
| originalname | varchar(255)         | NO   |     | NULL    |       |
| simname      | varchar(255)         | NO   |     | NULL    |       |
| posglobal    | varchar(255)         | NO   |     | NULL    |       |
| sortorder    | int(2)               | NO   |     | NULL    |       |
| enabled      | enum('true','false') | NO   |     | NULL    |       |
| gatekeeper   | varchar(255)         | YES  |     | NULL    |       |
+--------------+----------------------+------+-----+---------+-------+
14 rows in set (0.00 sec)

mysql> show columns from userprofile ;
+----------------------+--------------+------+-----+---------+-------+
| Field                | Type         | Null | Key | Default | Extra |
+----------------------+--------------+------+-----+---------+-------+
| useruuid             | varchar(36)  | NO   | PRI | NULL    |       |
| profilePartner       | varchar(36)  | NO   |     | NULL    |       |
| profileAllowPublish  | binary(1)    | NO   |     | NULL    |       |
| profileMaturePublish | binary(1)    | NO   |     | NULL    |       |
| profileURL           | varchar(255) | NO   |     | NULL    |       |
| profileWantToMask    | int(3)       | NO   |     | NULL    |       |
| profileWantToText    | text         | NO   |     | NULL    |       |
| profileSkillsMask    | int(3)       | NO   |     | NULL    |       |
| profileSkillsText    | text         | NO   |     | NULL    |       |
| profileLanguages     | text         | NO   |     | NULL    |       |
| profileImage         | varchar(36)  | NO   |     | NULL    |       |
| profileAboutText     | text         | NO   |     | NULL    |       |
| profileFirstImage    | varchar(36)  | NO   |     | NULL    |       |
| profileFirstText     | text         | NO   |     | NULL    |       |
+----------------------+--------------+------+-----+---------+-------+
14 rows in set (0.00 sec)

mysql> show columns from usersettings;
+------------+----------------------+------+-----+---------+-------+
| Field      | Type                 | Null | Key | Default | Extra |
+------------+----------------------+------+-----+---------+-------+
| useruuid   | varchar(36)          | NO   | PRI | NULL    |       |
| imviaemail | enum('true','false') | NO   |     | NULL    |       |
| visible    | enum('true','false') | NO   |     | NULL    |       |
| email      | varchar(254)         | NO   |     | NULL    |       |
+------------+----------------------+------+-----+---------+-------+
4 rows in set (0.00 sec)