1: 2016-07-20 (水) 16:08:06 iseki  |
現: 2016-07-20 (水) 16:12:19 iseki |
| | +------------+-------------+------+-----+---------+-------+ | | +------------+-------------+------+-----+---------+-------+ |
| | 3 rows in set (0.00 sec) | | 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) |
