Marauroa Database Structure: Difference between revisions

Content deleted Content added
imported>Hendrik Brummermann
imported>Hendrik Brummermann
Line 27:
== RPObjects ==
[[Image:Database-rpobjects.png‎]]
 
There are two ways which cause RPObjects to be stored to the database: Characters owned by players are stored in the table rpobject. The table characters links them to the account.
 
Non player objects may be persistent as well: If they are flagged as storeable, the will be saved in the rpzone they belong to.
 
Note: Currently the rpobjects (including owned slots and rpojbects in those slots) are serialized in a Blob field. In the Marauroa Version 1.x it was a relational. Unfortunately that approach was failing performance requirements (MySQL is extremely slow on delete statements). There is a [[Meta object model for relational data storage|concept]] in development that proposes an improved relational structure.
 
== Game Logging ==