OpenSim/DB/0.9.0 のバックアップ(No.1)

• バックアップ一覧
• 差分 を表示
• 現在との差分 を表示
• ソース を表示
• OpenSim/DB/0.9.0 へ行く。
  • 1 (2024-09-02 (月) 13:40:58)

0.9.0 †[edit]

• MySQL のテーブル定義は OpenSim/Data/MySQL/Resources/*.migrations

Tables of Japan Open Grid †[edit]

Tables †[edit]

Grid Mode †[edit]

• AgentPrefs
• Avatars
• Friends
• GridUser
• Presence (Stand Alone X)
• UserAccounts
• assets
• auth
• estate_groups
• estate_managers
• estate_map
• estate_settings
• estate_users
• estateban
• hg_traveling_data (HG Mode)
• im_offline
• inventoryfolders
• inventoryitems
• land
• landaccesslist
• migrations
• primitems
• prims
• primshapes
• regionban
• regionenvironment
• regionextra
• regions
• regionsettings
• regionwindlight
• spawn_points
• terrain
• tokens

Stand Alone †[edit]

Group v2 †[edit]

• os_groups_invites
• os_groups_membership
• os_groups_notices
• os_groups_principals
• os_groups_rolemembership
• os_groups_roles

DTL/NSL Money Server †[edit]

• balances
• transactions
• totalsales
• userinfo

Memo †[edit]

• ログイン時間が更新しないバグ

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)