Editing OpenSimulator Internals/Useful Queries (section)

=== Estate ===

All estate tables are in the region database (osimdev_t1), not the grid database.

Show estate settings:

 SELECT EstateID, EstateName, EstateOwner,
        PublicAccess, AllowVoice, DenyMinors,
        AllowDirectTeleport, AllowSetHome, AllowLandmark,
        AllowParcelChanges, AllowEnviromentOverride,
        FixedSun, SunPosition, UseGlobalTime,
        DenyAnonymous, DenyIdentified, DenyTransacted
 FROM estate_settings;

Show which region belongs to which estate:

 SELECT r.regionName, m.EstateID, e.EstateName
 FROM estate_map m
 JOIN estate_settings e ON e.EstateID = m.EstateID
 JOIN osimdev_robust.regions r ON r.uuid = m.RegionID;

List estate managers by name:

 SELECT e.EstateName, em.uuid AS manager_uuid,
        ua.FirstName, ua.LastName
 FROM estate_managers em
 JOIN estate_settings e ON e.EstateID = em.EstateID
 LEFT JOIN osimdev_robust.UserAccounts ua ON ua.PrincipalID = em.uuid
 ORDER BY e.EstateName, ua.LastName;

List allowed groups:

 SELECT e.EstateName, eg.uuid AS group_uuid
 FROM estate_groups eg
 JOIN estate_settings e ON e.EstateID = eg.EstateID
 ORDER BY e.EstateName;

List allowed users:

 SELECT e.EstateName, eu.uuid AS user_uuid,
        ua.FirstName, ua.LastName
 FROM estate_users eu
 JOIN estate_settings e ON e.EstateID = eu.EstateID
 LEFT JOIN osimdev_robust.UserAccounts ua ON ua.PrincipalID = eu.uuid
 ORDER BY e.EstateName, ua.LastName;

List ban entries:

 SELECT e.EstateName,
        eb.bannedUUID, eb.bannedIp, eb.bannedIpHostMask,
        eb.banningUUID, FROM_UNIXTIME(eb.banTime) AS banned_at
 FROM estateban eb
 JOIN estate_settings e ON e.EstateID = eb.EstateID
 ORDER BY e.EstateName, eb.banTime DESC;