OpenSim/DB/0.7.0/UserAccounts の変更点

• 追加された行はこの色です。
• 削除された行はこの色です。
• OpenSim/DB/0.7.0/UserAccounts へ行く。
• OpenSim/DB/0.7.0/UserAccounts の差分を削除

#author("2024-09-02T04:34:28+00:00","default:iseki","iseki")
*** UserAccounts [#k81079c2]
- アバターアカウントの状態
- 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 |           |
 +--------------------------------------+--------------------------------------+-----------+----------+--------------+-------------------------------------------------------------+---------+-----------+-----------+-----------+