![[PukiWiki]](image/pukiwiki.png "[PukiWiki]")
#author("2024-09-02T04:23:47+00:00","default:iseki","iseki") *** users [#g7b4b1c5] - 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 | | +-------------------+---------------------+------+-----+--------------------------------------+-------+
