![[PukiWiki]](image/pukiwiki.png "[PukiWiki]")
#author("2024-09-02T05:16:21+00:00","default:iseki","iseki") ** UserProfile Module [#z55da6e4] *** DB [#k7dfac55] **** classifieds [#haaefa8a] 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) **** userdata [#t23838ca] 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) **** usernotes [#u4b91612] 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) **** userpicks [#q836110a] 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) **** userprofile [#f4a0f5a2] 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) **** usersettings [#z2e7fe39] 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)
