====== Shard database ======
**Information about what should be in the MYSQL database**

See [[en:nel_mysql]] to understand in detail what each table contains.

=====nel_nel=====
====Domain :====
<code>
domain_id=12
domaine_name=ryzom_open
status=ds_open
patch_version=
backup_patch_url=address.ip:23001
patch_urls=address.ip/patch
login_address=address.ip:49998
session_manager_address=address.ip:49999
ring_db_name=ring_mini01
web_host=address.ip:30000
web_host_php=address.ip:40916
description=


</code>

====Permission :==== 
<code>
Permissionid=1(+1 each additional new permission)  
Uid=1(Even Uld to use it) 
Domainid=12  Shardid=302 
AccessPrivilege=OPEN, DEV, RESTRICTED 
</code>
====Shard :====
<code>
Shardid= 302
domain_id=12
WsAddr=adress.ip:
NbPlayers=0
Name=
Online=0 
Version=
FixedSessionId=0
State=ds_open
MOTD=
</code>
====User :====
**Filled by ams**
<code>
Uld=(Id of the user)
Login=(account name)
Password=(Encrypt)
ShardId=302
State=Offline
Privilege=:DEV: (To have all rights) 
.....
</code>
=====nel_ams=====
nel_ams and nel_ams_lib are filled in by AMS
=====nel_tool=====
......\\

====neltool_domains :====
<code>
domain_id=12
domain_name=ryzom_open
domaine_as_host=adress.ip
domain_as_port=46700
domain_rrd_path=/home/YOUR-USER/khanat-code/code/ryzom/server/save_shard/rrd_graphs
domain_las_admin_path=
domain_las_local_path=
domain_application=ryzom_open
......
</code>
......\\
====netool_shards :====
<code>
shard_id=302
shard_name=Open
shard_as_id=open
shard_domain_id=12
shard_lang=en
shard_restart=0
</code>
......\\
====neltool_users :====
<code>
It is filled by AMS
</code>
......\\
====neltool_user_domains :====
<code>
user_domain_id=1
user_domain_user_id=1
user_domain_domain_id=12
</code>
====neltool_user_shards :====
<code>
user_shard_id=1
user_shard_user_id=1
user_shard_shard_id=302
user_shard_domain_id=12
</code>
=====ring_mini01=====
......\\
====ring_users====
Filled with Shard\\
......\\
====sessions====
<code>
session_id=302
session_type=st_mainland
title=
owner=0
plan_date=
start_date=
description=
orientation=so_other
level=sl_a
rule_type=st_strict
access_type=at_private
state=ss_planned
.....
</code>
......\\
====shard====
<code>
shard_id=302
WSOnline=1
MOTD=Shard up
OldState=ds_restricted
RequiredState=ds_open
</code>

With the help of Depyraken! thanks to him
{{tag>shard server Utilities mysql tutorial}}