When installing a Ryzom Core server, the mysql database is filled with various tricks, which must then be completed with the information contained in here.
This page tries to give meaning to the various values of the database.
This document is in progress!! It's a tiring job finding out(and filling out) all the information. Do not hesitate to help for faster completion!!
The layout respects the tree structure in the database.
The general table.
In this table the fields UId, DomainId and ShardId should be foreign keys, but they are not defined as well
It's 19 characters maximum, which corresponds to the value: “OPEN, DEV, RESTRICTED”. Value for a normal user: “OPEN”. This is a set of three values: `AccessPrivilege` set ('OPEN', 'DEV', 'RESTRICTED') NOT NULL DEFAULT 'OPEN'
Check that Online and NbPlayers are active.
Is it possible to turn over certain tables that we do not have and do not even ask for information, like the country?
In fact, we should keep only what really serves the game, and for the rest tie it to our table of users on khaganat, among other things for email and age.
except that visibly, right? Some users have joined on Lirria, but remain at -1 in value: it is the permission table that manages the rights, this field is certainly a remnant of an old version. Or the value -1 has a meaning, like: all shards, but we only have one shard, we do not realize it.
See note above: managed by table permissions
Web applications related to the game server.