OpenSim​/OpenProfile

MariaDB [opensim_op]> show columns from profile_classifieds;
+-----------------+--------------+------+-----+---------+-------+
| Field           | Type         | Null | Key | Default | Extra |
+-----------------+--------------+------+-----+---------+-------+
| classifieduuid  | varchar(36)  | NO   | PRI |         |       |
| creatoruuid     | varchar(36)  | NO   |     |         |       |
| creationdate    | bigint(20)   | NO   |     | NULL    |       |
| expirationdate  | bigint(20)   | NO   |     | NULL    |       |
| category        | varchar(20)  | NO   |     |         |       |
| name            | varchar(255) | NO   |     |         |       |
| description     | longtext     | NO   |     | NULL    |       |
| parceluuid      | varchar(36)  | NO   |     |         |       |
| parentestate    | bigint(11)   | NO   |     | NULL    |       |
| snapshotuuid    | varchar(36)  | NO   |     |         |       |
| simname         | varchar(255) | NO   |     |         |       |
| posglobal       | varchar(255) | NO   |     |         |       |
| parcelname      | varchar(255) | NO   |     |         |       |
| classifiedflags | int(8)       | NO   |     | NULL    |       |
| priceforlisting | mediumint(5) | NO   |     | NULL    |       |
+-----------------+--------------+------+-----+---------+-------+
15 rows in set (0.01 sec)

MariaDB [opensim_op]> show columns from profile_usernotes;
+------------+-------------+------+-----+---------+-------+
| Field      | Type        | Null | Key | Default | Extra |
+------------+-------------+------+-----+---------+-------+
| useruuid   | varchar(36) | NO   | PRI |         |       |
| targetuuid | varchar(36) | NO   | PRI |         |       |
| notes      | longtext    | NO   |     | NULL    |       |
+------------+-------------+------+-----+---------+-------+
3 rows in set (0.00 sec)

MariaDB [opensim_op]> show columns from  profile_userpicks;
+--------------+--------------+------+-----+---------+-------+
| Field        | Type         | Null | Key | Default | Extra |
+--------------+--------------+------+-----+---------+-------+
| pickuuid     | varchar(36)  | NO   | PRI |         |       |
| creatoruuid  | varchar(36)  | NO   |     |         |       |
| toppick      | varchar(6)   | NO   |     | false   |       |
| parceluuid   | varchar(36)  | NO   |     |         |       |
| name         | varchar(255) | NO   |     |         |       |
| description  | longtext     | NO   |     | NULL    |       |
| snapshotuuid | varchar(36)  | NO   |     |         |       |
| user         | varchar(255) | NO   |     |         |       |
| originalname | varchar(255) | NO   |     |         |       |
| simname      | varchar(255) | NO   |     |         |       |
| posglobal    | varchar(255) | NO   |     |         |       |
| sortorder    | tinyint(2)   | NO   |     | NULL    |       |
| enabled      | varchar(6)   | NO   |     | false   |       |
+--------------+--------------+------+-----+---------+-------+
13 rows in set (0.00 sec)

MariaDB [opensim_op]> show columns from profile_userprofile;
+----------------------+--------------+------+-----+---------+-------+
| Field                | Type         | Null | Key | Default | Extra |
+----------------------+--------------+------+-----+---------+-------+
| useruuid             | varchar(36)  | NO   | PRI |         |       |
| profilepartner       | varchar(36)  | NO   |     |         |       |
| profileimage         | varchar(36)  | NO   |     |         |       |
| profileabouttext     | longtext     | NO   |     | NULL    |       |
| profileallowpublish  | binary(1)    | NO   |     | NULL    |       |
| profilematurepublish | binary(1)    | NO   |     | NULL    |       |
| profileurl           | varchar(255) | NO   |     |         |       |
| profilewanttomask    | smallint(3)  | NO   |     | NULL    |       |
| profilewanttotext    | longtext     | NO   |     | NULL    |       |
| profileskillsmask    | smallint(3)  | NO   |     | NULL    |       |
| profileskillstext    | longtext     | NO   |     | NULL    |       |
| profilelanguagestext | longtext     | NO   |     | NULL    |       |
| profilefirstimage    | varchar(36)  | NO   |     |         |       |
| profilefirsttext     | longtext     | NO   |     | NULL    |       |
+----------------------+--------------+------+-----+---------+-------+
14 rows in set (0.00 sec)

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