OpenSimulator 0.9.3.1 SQL tables
Detailed OpenSimulator 0.9.3.1 explanations based on INI templates and source code.
Migration families
MySQL 0.9.3.1 migrations are grouped by domain: UserAccount, AuthStore, InventoryStore, FriendsStore, GridStore, RegionStore, EstateStore, Presence and more. Migration group names do not dictate schema names.
User data
Accounts/authentication, inventory, avatar appearance, friendships and presence belong to different services. Copying one account row does not transfer assets or all user references.
Region data
RegionStore contains scene objects, parcels, terrain and region settings. GridStore is a region directory. Confusing the two may lead to backing up only region locations while losing actual scenes.
Estate data
EstateStore contains estate settings and access lists. estate_map maps RegionID to EstateID, and estate_settings stores the name and owner. Not every DefaultEstate* INI value appears there under an identical column name.
Additional data
Groups, profiles, economy, offline messages and other add-ons may use additional tables. These are optional configurations, not mandatory tables in every installation.
Read-only commands on an authorized instance; adapt names to actual schemas.
SHOW DATABASES; -- Sélectionner ensuite uniquement le schéma identifié : USE region_data; SHOW TABLES; -- Vérifier la structure d'une table présente : DESCRIBE regionsettings;
Other guides in this section
- Understanding OpenSimulator databases
- INI files and SQL connections
- Regions.ini and region tables
- OpenSim.ini, Estates.ini and estate storage
- Backing up and migrating OpenSimulator databases
- Administer MySQL / MariaDB
- Install a ROBUST grid
- Understanding FSAssets