classifieds 
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 
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 
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 
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 
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 
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)
Counter: 1074,
today: 1,
yesterday: 0
最終更新: 2016-08-08 (月) 10:46:51 (JST) (2679d) by iseki