OpenSim/DB/0.7.0/UserAccounts

UserAccounts†[edit]

• アバターアカウントの状態
• create userコマンドでアバター登録時に作成される．

mysql> show columns from UserAccounts;
+-------------+-------------+------+-----+---------+-------+
| Field       | Type        | Null | Key | Default | Extra |
+-------------+-------------+------+-----+---------+-------+
| PrincipalID | char(36)    | NO   | PRI | NULL    |       | 
| ScopeID     | char(36)    | NO   |     | NULL    |       | 
| FirstName   | varchar(64) | NO   | MUL | NULL    |       | 
| LastName    | varchar(64) | NO   | MUL | NULL    |       | 
| Email       | varchar(64) | YES  | MUL | NULL    |       | 
| ServiceURLs | text        | YES  |     | NULL    |       | 
| Created     | int(11)     | YES  |     | NULL    |       | 
| UserLevel   | int(11)     | NO   |     | 0       |       | 
| UserFlags   | int(11)     | NO   |     | 0       |       | 
| UserTitle   | varchar(64) | NO   |     |         |       | 
+-------------+-------------+------+-----+---------+-------+

mysql> select * from UserAccounts;
+--------------------------------------+--------------------------------------+-----------+----------+--------------+-------------------------------------------------------------+---------+-----------+-----------+-----------+
| PrincipalID                          | ScopeID                              | FirstName | LastName | Email        | ServiceURLs                                                 | Created | UserLevel | UserFlags | UserTitle |
+--------------------------------------+--------------------------------------+-----------+----------+--------------+-------------------------------------------------------------+---------+-----------+-----------+-----------+
| 4a1d4c70-ab8c-47be-a4d1-c914fd42413d | 00000000-0000-0000-0000-000000000000 | TEST      | TEST     |              | HomeURI= GatekeeperURI= InventoryServerURI= AssetServerURI= |       0 |         0 |         0 |           |
| 018fdfb4-3667-4d49-a5ad-10c21ad5c463 | 00000000-0000-0000-0000-000000000000 | AAAA      | AAAA     | eeeeeeeee@jp | HomeURI= GatekeeperURI= InventoryServerURI= AssetServerURI= |       0 |         0 |         0 |           |
+--------------------------------------+--------------------------------------+-----------+----------+--------------+-------------------------------------------------------------+---------+-----------+-----------+-----------+

最新の30件

[edit]