====== The game server database ====== When installing a Ryzom Core server, the mysql database is filled with various tricks, which must then be completed with the information contained in [[shard_database|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. [[en:nel_mysql:django|Django version of the databases]] {{INLINETOC}} ===== nel ===== The general table. ==== nel ==== Concerns the shard itself. {{:en:nel-database.png?200|}} === domain === * Domain_id: number identifying the domain(and this is not the shard, but what will contain one or more shards) * Domain_name: domain name * status * patch_version * backup_patch_urls * patch_urls * login_adress * session_manager_address * ring_db_name * web_host * web_host_php * description === permission === In this table the fields UId, DomainId and ShardId should be foreign keys, but they are not defined as well * PermissionId: Permission ID number * UId: User(reference to //User/UId//) * DomainId: Domain on which it is valid(reference to //domain/domain_id//) * ShardId: Shard on which it is valid(reference to //shard/shard_id//). * AccessPrivilege: conditions of the shard, user must have right conditions to be able to access the shard. \\ 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' === shard === Check that //Online// and //NbPlayers// are active. * ShardId: number identifying the shard(is not an autoincrement) * Domain_id: number of the domain to which this shard is bound * WsAddr: web address(ip) where this shard is located * NbPlayers: number of players online * Name: shard name * Online: server status, is 0 or 1 * Version:? * FixedSessionId? * State: Server status. 4 Possible values: * Ds_close * Ds_dev which is the default * Ds_restricted * Ds_open which is the normal value of a running shard * MOTD: Word of the day that appears when you connect to the game server? === user === 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. * UId: number identifying the user * Login: login to login * Password: password, chopped. * ShardId: Shard ID where the user connects 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. * State: Online or Offline, online or offline. * Privilege: User privilege, see [[commands_shard#rights_right]]. If there is nothing, basic player? See note above: managed by table permissions * GroupName :? * FirstName: not useful here * LastName: id * Birthday: to manage if people are minors or not * Gender: unnecessary * Country: id * Email: useful for returning the password. * Address: unnecessary * City: unnecessary *PostalCode: useless * USState: unnecessary * Chat : to 0, why? what's this? * BetaKeyId: Key for those participating in the beta(opened up some bonuses later). Useless in khagnats case. * CachedCoupons: coupons linked to codes to play without subscription. Useless in khagnats case. * ProfileAccess ? * Level : it can not be the level of the character, there is just the user, which has 5 characters ... * CurrentFunds : credit in case of payment? * IdBilling ? * Community : remainder of old separation in shard by language? useful ? * Newsletter: subscription or name to a newsletter, not to be managed here ... * Account ? * ChoiceSubLength : * CurrentSubLength * ValidIdBilling * GMId * ExtendedPrivilege * ToolsGroup * Unsubscribe * SubDate * SubIp * SecurePassword * LastInvoiceEmailCheck * FromSource * ValidMerchantCode * PBC * ApiKeySeed ==== ams ==== About AMS === nel_ams === == ams_user == * UId * Login * Password * Email * Permission * FirstName * LastName * Gender * Country * ReceiveMail * Language === nel_ams_lib === == ams_api_keys == == ams_querycache == == assigned == == email == == forwarded == == in_group == == in_support_group == == plugins == == settings == == support_group == == tag == == tagged == == ticket == == ticket_attachments == == ticket_category == == ticket_content == == ticket_group == == ticket_info == == ticket_log == == ticket_reply == == ticket_user == == updates == ==== nel_tool ==== === neltool_annotations === === neltool_applications === === neltool_domains === === neltool_groups === === neltool_group_applications === === neltool_group_domains === === neltool_group_shards === === neltool_locks === === neltool_logs === === neltool_notes === === neltool_restart_groups === === neltool_restart_messages === === neltool_restart_sequences === === neltool_shards === === neltool_stats_hd_datas === === neltool_stats_hd_times === === neltool_users === === neltool_user_applications === === neltool_user_domains === === neltool_user_shards === ===== webig ===== Web applications related to the game server. ==== accounts ==== ==== players ==== {{Tag> Draft Nel Server Ryzom_Core}}