users 
- Avatar の情報
- 0.7 で廃止
mysql> show columns from users; +-------------------+---------------------+------+-----+--------------------------------------+-------+ | Field | Type | Null | Key | Default | Extra | +-------------------+---------------------+------+-----+--------------------------------------+-------+ | UUID | varchar(36) | NO | PRI | | | | username | varchar(32) | NO | MUL | NULL | | | lastname | varchar(32) | NO | | NULL | | | passwordHash | varchar(32) | NO | | NULL | | | passwordSalt | varchar(32) | NO | | NULL | | | homeRegion | bigint(20) unsigned | YES | | NULL | | | homeLocationX | float | YES | | NULL | | | homeLocationY | float | YES | | NULL | | | homeLocationZ | float | YES | | NULL | | | homeLookAtX | float | YES | | NULL | | | homeLookAtY | float | YES | | NULL | | | homeLookAtZ | float | YES | | NULL | | | created | int(11) | NO | | NULL | | | lastLogin | int(11) | NO | | NULL | | | userInventoryURI | varchar(255) | YES | | NULL | | | userAssetURI | varchar(255) | YES | | NULL | | | profileCanDoMask | int(10) unsigned | YES | | NULL | | | profileWantDoMask | int(10) unsigned | YES | | NULL | | | profileAboutText | text | YES | | NULL | | | profileFirstText | text | YES | | NULL | | | profileImage | varchar(36) | YES | | NULL | | | profileFirstImage | varchar(36) | YES | | NULL | | | webLoginKey | varchar(36) | YES | | NULL | | | homeRegionID | char(36) | NO | | 00000000-0000-0000-0000-000000000000 | | | userFlags | int(11) | NO | | 0 | | | godLevel | int(11) | NO | | 0 | | | customType | varchar(32) | NO | | | | | partner | char(36) | NO | | 00000000-0000-0000-0000-000000000000 | | | email | varchar(250) | YES | | NULL | | | scopeID | char(36) | NO | | 00000000-0000-0000-0000-000000000000 | | +-------------------+---------------------+------+-----+--------------------------------------+-------+
Counter: 1705,
today: 1,
yesterday: 1
最終更新: 2010-05-21 (金) 18:37:38 (JST) (5417d) by admin