Marauroa Database Structure: Difference between revisions

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.