![[PukiWiki]](image/pukiwiki.png "[PukiWiki]")
#author("2024-01-07T01:33:50+00:00","default:iseki","iseki") ** OpenProfile for OpenSim [#ra0d1a6b] *** DB [#n8639779] **** profile_classifieds [#gaf6de43] 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) **** profile_usernotes [#saa08676] 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) **** profile_userpicks [#p2e538b3] 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) **** profile_userprofile [#rd8e5d33] 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) **** profile_usersettings [#xc1e6339] 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)
