Mantis Bug Tracker

View Issue Details Jump to Notes ] Issue History ] Print ]
IDProjectCategoryView StatusDate SubmittedLast Update
0008312opensim[GRID] Other Servicepublic2018-04-10 23:042018-04-14 12:09
Assigned To 
PlatformtinkerboardOperating SystemdebianOperating System Version
Product Versionmaster (dev code) 
Target VersionFixed in Version 
Summary0008312: differences between sqlite and mysql tables
Descriptionthere are fields in tables, which exists in sqlite but not in mysql and vice versa. the order of fields and the naming might also mismatch. i attached a spreadsheet with some of the differences. i reordered some table fields to get a better overview of mismatches. i also attach a little perl script, which helped me to migrate from sqlite to mysql.
Steps To Reproducedump the database schemata and have a look on the differences.
Additional Informationmigrate from sqlite to mysql might disorder scripts in linked objects, because sqlite didn't keep the link number.
TagsNo tags attached.
Git Revision or version number96aecf80ef933273bc75e1d77d9b5137fb05505a
Run ModeStandalone (1 Region) , Standalone (Multiple Regions) , Grid (1 Region per Sim) , Grid (Multiple Regions per Sim)
Physics EngineBasicPhysics, ODE, BulletSim, ubODE, Other
Script Engine
EnvironmentUnknown, Mono / Linux32, Mono / Linux64, Mono / Windows, Mono / OSX, .NET / Windows32, .NET / Windows64
Mono VersionNone
Attached Files? file icon opensim sqlite vs mysql.ods [^] (26,541 bytes) 2018-04-10 23:04
? file icon [^] (3,414 bytes) 2018-04-10 23:09

- Relationships

-  Notes
aiaustin (developer)
2018-04-13 12:12

If this can get checked... it would be worth making this consistent also to PostgresSQL and MSSQL to.

- Issue History
Date Modified Username Field Change
2018-04-10 23:04 thomax New Issue
2018-04-10 23:04 thomax File Added: opensim sqlite vs mysql.ods
2018-04-10 23:09 thomax File Added:
2018-04-13 12:12 aiaustin Note Added: 0032639

Copyright © 2000 - 2012 MantisBT Group
Powered by Mantis Bugtracker