OpenSim/DB/0.9.0 の変更点

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

#author("2024-09-02T04:40:58+00:00","default:iseki","iseki")
#author("2024-09-02T04:44:58+00:00","default:iseki","iseki")
** 0.9.0 [#s87aa068]
- MySQL のテーブル定義は OpenSim/Data/MySQL/Resources/*.migrations


*** [[Tables of Japan Open Grid>./tables]] [#iab64b62]


*** Tables [#bc8712eb]
**** Grid Mode [#r14c5224]
- [[AgentPrefs>./AgentPrefs]]
- [[Avatars>./Avatars]]
- [[Friends>./Friends]]
- [[GridUser>./GridUser]]
- [[Presence>./Presence]]  (Stand Alone X)
- [[UserAccounts>./UserAccounts]]
- [[assets>./assets]]
- [[auth>./auth]]
- [[estate_groups>./estate_groups]]
- [[estate_managers>./estate_managers]]
- [[estate_map>./estate_map]]
- [[estate_settings>./estate_settings]]
- [[estate_users>./estate_users]]
- [[estateban>./estateban]]
- [[hg_traveling_data>./hg_traveling_data]]  (HG Mode)
- [[im_offline>./im_offline]]
- [[inventoryfolders>./inventoryfolders]]
- [[inventoryitems>./inventoryitems]]
- [[land>./land]]
- [[landaccesslist>./landaccesslist]]
- [[migrations>./migrations]]
- [[primitems>./primitems]]
- [[prims>./prims]]
- [[primshapes>./primshapes]]
- [[regionban>./regionban]]
- [[regionenvironment>./regionenvironment]]
- [[regionextra>./regionextra]]
- [[regions>./regions]] 
- [[regionsettings>./regionsettings]]
- [[regionwindlight>./regionwindlight]]
- [[spawn_points>./spawn_points]]
- [[terrain>./terrain]]
- [[tokens>./tokens]]


**** [[Stand Alone>./Standalone]] [#b6958d74]


**** Group v2 [#te05cc5c]
- [[os_groups_invites>./os_groups_invites]]
- [[os_groups_membership>./os_groups_membership]]
- [[os_groups_notices>./os_groups_notices]]
- [[os_groups_principals>./os_groups_principals]]
- [[os_groups_rolemembership>./os_groups_rolemembership]]
- [[os_groups_roles>./os_groups_roles]]


**** DTL/NSL Money Server [#mca4b018]
- [[balances>./balances]]  
- [[transactions>./transactions]]
- [[totalsales>./totalsales]]
- [[userinfo>./userinfo]] 


*** Memo [#ucab8b0f]
- ログイン時間が更新しないバグ

 MariaDB [jogrid_db]> select * from GridUser where UserID LIKE '0fa2fdd3-e4b7-456f-aa79-75aade09ade%';
 +-----------------------------------------------------------------------------+--------+------------+------------+
 | UserID                                                                      | Online | Login      | Logout     |
 +-----------------------------------------------------------------------------+--------+------------+------------+
 | 0fa2fdd3-e4b7-456f-aa79-75aade09aded                                        | True   | 1427920227 | 1427920181 |
 | 0fa2fdd3-e4b7-456f-aa79-75aade09aded;http://jogrid.net:8002/;Kote2 Resident | True   | 1463473577 | 1463467496 |
 +-----------------------------------------------------------------------------+--------+------------+------------+
 2 rows in set (0.00 sec)

#br