|
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 | | |
| + | +-------------------+---------------------+------+-----+--------------------------------------+-------+ |