|
1: 2010-01-13 (水) 19:46:05 iseki  |
| | + | *** users [#g7b4b1c5] |
| | + | - Avatar の情報 |
| | | | |
| | + | 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 | | |
| | + | +-------------------+---------------------+------+-----+--------------------------------------+-------+ |
