Practical tools for OpenSimulator
Free web tools for generating UUIDs and converting dates used in OpenSimulator databases.
UUID generator
Generate UUID identifiers when an OpenSimulator application or development task needs a unique identifier. Before inserting a UUID into a database, verify schema constraints and relationships between tables.
https://bloodmoonpack.com/uuid/
Timestamp converter
Convert timestamp values to readable dates and back. This can help inspect or prepare date values in OpenSimulator databases, including fields used for avatar account creation dates, depending on the database schema in use.
https://bloodmoonpack.com/timestamp/
Precautions before making SQL changes
A viewer field described as an avatar’s “birthday” does not necessarily represent a person’s real birth date: in OpenSimulator it may refer to account creation. Use the value and time zone expected by your installation.