1: 2016-07-20 (水) 15:59:20 iseki  |
2: 2016-07-20 (水) 16:03:40 iseki |
| | +-----------------+--------------+------+-----+---------+-------+ | | +-----------------+--------------+------+-----+---------+-------+ |
| | 15 rows in set (0.00 sec) | | 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) |
