OpenSim/DB/users

users†[edit]

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

最新の30件

[edit]