OpenSimulator · EN

OpenSimulator 0.9.3.1 SQL tables

Detailed OpenSimulator 0.9.3.1 explanations based on INI templates and source code.

Your deployment may organize schemas and files differently. Always inspect actual loaded settings. Never edit SQL data directly without a backup.

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

OpenSimulator 0.9.3.1 source files