<WRAP alert round center>
Ce travail est repris et complété par l'outil [[gitlab>Tycho/WebNeL|WebNeL]].
</WRAP>

====== Modèles Django des bases de données ======

Les sources ci dessous son issues de fichiers créés par la commande

<code>
python manage.py inspectdb
</code>


Ils reprennent la structure des bases de données nel, pour être utilisées dans une application Django.

C'est assez brut comme info, mais directement utilisable par un dev.
===== Base nel =====

<WRAP prewrap 650px>
<code python>
from django.db import models

class Domain(models.Model):
    domain_id = models.AutoField(primary_key=True)
    domain_name = models.CharField(unique=True, max_length=32)
    status = models.CharField(max_length=13)
    patch_version = models.IntegerField()
    backup_patch_url = models.CharField(max_length=255, blank=True, null=True)
    patch_urls = models.TextField(blank=True, null=True)
    login_address = models.CharField(max_length=255)
    session_manager_address = models.CharField(max_length=255)
    ring_db_name = models.CharField(max_length=255)
    web_host = models.CharField(max_length=255)
    web_host_php = models.CharField(max_length=255)
    description = models.CharField(max_length=200, blank=True, null=True)

    class Meta:
        db_table = 'domain'


class Permission(models.Model):
    permissionid = models.AutoField(db_column='PermissionId', primary_key=True)  # Field name made lowercase.
    uid = models.IntegerField(db_column='UId')  # Field name made lowercase.
    domainid = models.IntegerField(db_column='DomainId')  # Field name made lowercase.
    shardid = models.IntegerField(db_column='ShardId')  # Field name made lowercase.
    accessprivilege = models.CharField(db_column='AccessPrivilege', max_length=19)  # Field name made lowercase.

    class Meta:
        db_table = 'permission'


class Shard(models.Model):
    shardid = models.IntegerField(db_column='ShardId', primary_key=True)  # Field name made lowercase.
    domain_id = models.IntegerField()
    wsaddr = models.CharField(db_column='WsAddr', max_length=64, blank=True, null=True)  # Field name made lowercase.
    nbplayers = models.IntegerField(db_column='NbPlayers', blank=True, null=True)  # Field name made lowercase.
    name = models.CharField(db_column='Name', max_length=255, blank=True, null=True)  # Field name made lowercase.
    online = models.IntegerField(db_column='Online', blank=True, null=True)  # Field name made lowercase.
    version = models.CharField(db_column='Version', max_length=64)  # Field name made lowercase.
    fixedsessionid = models.IntegerField(db_column='FixedSessionId')  # Field name made lowercase.
    state = models.CharField(db_column='State', max_length=13)  # Field name made lowercase.
    motd = models.TextField(db_column='MOTD')  # Field name made lowercase.

    class Meta:
        db_table = 'shard'


class User(models.Model):
    uid = models.AutoField(db_column='UId', primary_key=True)  # Field name made lowercase.
    login = models.CharField(db_column='Login', unique=True, max_length=64)  # Field name made lowercase.
    password = models.CharField(db_column='Password', max_length=106, blank=True, null=True)  # Field name made lowercase.
    shardid = models.IntegerField(db_column='ShardId')  # Field name made lowercase.
    state = models.CharField(db_column='State', max_length=7)  # Field name made lowercase.
    privilege = models.CharField(db_column='Privilege', max_length=255)  # Field name made lowercase.
    groupname = models.CharField(db_column='GroupName', max_length=255)  # Field name made lowercase.
    firstname = models.CharField(db_column='FirstName', max_length=255)  # Field name made lowercase.
    lastname = models.CharField(db_column='LastName', max_length=255)  # Field name made lowercase.
    birthday = models.CharField(db_column='Birthday', max_length=32)  # Field name made lowercase.
    gender = models.IntegerField(db_column='Gender')  # Field name made lowercase.
    country = models.CharField(db_column='Country', max_length=2)  # Field name made lowercase.
    email = models.CharField(db_column='Email', unique=True, max_length=255)  # Field name made lowercase.
    address = models.CharField(db_column='Address', max_length=255)  # Field name made lowercase.
    city = models.CharField(db_column='City', max_length=100)  # Field name made lowercase.
    postalcode = models.CharField(db_column='PostalCode', max_length=10)  # Field name made lowercase.
    usstate = models.CharField(db_column='USState', max_length=2)  # Field name made lowercase.
    chat = models.CharField(db_column='Chat', max_length=2)  # Field name made lowercase.
    betakeyid = models.IntegerField(db_column='BetaKeyId')  # Field name made lowercase.
    cachedcoupons = models.CharField(db_column='CachedCoupons', max_length=255)  # Field name made lowercase.
    profileaccess = models.CharField(db_column='ProfileAccess', max_length=45, blank=True, null=True)  # Field name made lowercase.
    level = models.IntegerField(db_column='Level')  # Field name made lowercase.
    currentfunds = models.IntegerField(db_column='CurrentFunds')  # Field name made lowercase.
    idbilling = models.CharField(db_column='IdBilling', max_length=255)  # Field name made lowercase.
    community = models.CharField(db_column='Community', max_length=2)  # Field name made lowercase.
    newsletter = models.IntegerField(db_column='Newsletter')  # Field name made lowercase.
    account = models.CharField(db_column='Account', max_length=64)  # Field name made lowercase.
    choicesublength = models.IntegerField(db_column='ChoiceSubLength')  # Field name made lowercase.
    currentsublength = models.CharField(db_column='CurrentSubLength', max_length=255)  # Field name made lowercase.
    valididbilling = models.IntegerField(db_column='ValidIdBilling')  # Field name made lowercase.
    gmid = models.IntegerField(db_column='GMId')  # Field name made lowercase.
    extendedprivilege = models.CharField(db_column='ExtendedPrivilege', max_length=128)  # Field name made lowercase.
    toolsgroup = models.CharField(db_column='ToolsGroup', max_length=20)  # Field name made lowercase.
    unsubscribe = models.DateField(db_column='Unsubscribe')  # Field name made lowercase.
    subdate = models.DateTimeField(db_column='SubDate')  # Field name made lowercase.
    subip = models.CharField(db_column='SubIp', max_length=20)  # Field name made lowercase.
    securepassword = models.CharField(db_column='SecurePassword', max_length=32)  # Field name made lowercase.
    lastinvoiceemailcheck = models.DateField(db_column='LastInvoiceEmailCheck')  # Field name made lowercase.
    fromsource = models.CharField(db_column='FromSource', max_length=8)  # Field name made lowercase.
    validmerchantcode = models.CharField(db_column='ValidMerchantCode', max_length=13)  # Field name made lowercase.
    pbc = models.IntegerField(db_column='PBC')  # Field name made lowercase.
    apikeyseed = models.CharField(db_column='ApiKeySeed', max_length=8, blank=True, null=True)  # Field name made lowercase.

    class Meta:
        db_table = 'user'

</code>
</WRAP>

===== Base kring =====

<WRAP prewrap 650px>
<code python>
from django.db import models


class Characters(models.Model):
    char_id = models.IntegerField(primary_key=True)
    char_name = models.CharField(max_length=20)
    user_id = models.IntegerField()
    guild_id = models.IntegerField()
    best_combat_level = models.IntegerField()
    home_mainland_session_id = models.IntegerField()
    ring_access = models.CharField(max_length=63)
    race = models.CharField(max_length=8)
    civilisation = models.CharField(max_length=9)
    cult = models.CharField(max_length=9)
    current_session = models.IntegerField()
    rrp_am = models.IntegerField()
    rrp_masterless = models.IntegerField()
    rrp_author = models.IntegerField()
    newcomer = models.IntegerField()
    creation_date = models.DateTimeField()
    last_played_date = models.DateTimeField()

    class Meta:
        managed = False
        db_table = 'characters'
        unique_together = (('char_name', 'home_mainland_session_id'),)


class Folder(models.Model):
    id = models.AutoField(db_column='Id', primary_key=True)  # Field name made lowercase.
    owner = models.IntegerField()
    title = models.CharField(max_length=40)
    comments = models.TextField()

    class Meta:
        managed = False
        db_table = 'folder'


class FolderAccess(models.Model):
    id = models.AutoField(db_column='Id', primary_key=True)  # Field name made lowercase.
    folder_id = models.IntegerField()
    user_id = models.IntegerField()

    class Meta:
        managed = False
        db_table = 'folder_access'


class GuildInvites(models.Model):
    id = models.AutoField(db_column='Id', primary_key=True)  # Field name made lowercase.
    session_id = models.IntegerField()
    guild_id = models.IntegerField()

    class Meta:
        managed = False
        db_table = 'guild_invites'


class Guilds(models.Model):
    guild_id = models.IntegerField(primary_key=True)
    guild_name = models.CharField(max_length=50)
    shard_id = models.IntegerField()

    class Meta:
        managed = False
        db_table = 'guilds'


class JournalEntry(models.Model):
    id = models.AutoField(db_column='Id', primary_key=True)  # Field name made lowercase.
    session_id = models.IntegerField()
    author = models.IntegerField()
    type = models.CharField(max_length=11)
    text = models.TextField()
    time_stamp = models.DateTimeField()

    class Meta:
        managed = False
        db_table = 'journal_entry'


class KnownUsers(models.Model):
    id = models.AutoField(db_column='Id', primary_key=True)  # Field name made lowercase.
    owner = models.IntegerField()
    targer_user = models.IntegerField()
    targer_character = models.IntegerField()
    relation_type = models.CharField(max_length=12)
    comments = models.CharField(max_length=255)

    class Meta:
        managed = False
        db_table = 'known_users'


class MfsErasedMailSeries(models.Model):
    erased_char_id = models.IntegerField()
    erased_char_name = models.CharField(max_length=32)
    erased_series = models.AutoField(primary_key=True)
    erase_date = models.DateTimeField()

    class Meta:
        managed = False
        db_table = 'mfs_erased_mail_series'


class MfsGuildThread(models.Model):
    thread_id = models.AutoField(primary_key=True)
    guild_id = models.IntegerField()
    topic = models.CharField(max_length=255)
    author_name = models.CharField(max_length=32)
    last_post_date = models.DateTimeField()
    post_count = models.IntegerField()

    class Meta:
        managed = False
        db_table = 'mfs_guild_thread'


class MfsGuildThreadMessage(models.Model):
    thread_id = models.IntegerField()
    author_name = models.CharField(max_length=32)
    date = models.DateTimeField()
    content = models.TextField()

    class Meta:
        managed = False
        db_table = 'mfs_guild_thread_message'


class MfsMail(models.Model):
    sender_name = models.CharField(max_length=32)
    subject = models.CharField(max_length=250)
    date = models.DateTimeField()
    status = models.CharField(max_length=9)
    dest_char_id = models.IntegerField()
    erase_series = models.IntegerField()
    content = models.TextField()

    class Meta:
        managed = False
        db_table = 'mfs_mail'


class Outlands(models.Model):
    session_id = models.AutoField(primary_key=True)
    island_name = models.TextField()
    billing_instance_id = models.IntegerField()
    anim_session_id = models.IntegerField()

    class Meta:
        managed = False
        db_table = 'outlands'


class PlayerRating(models.Model):
    id = models.AutoField(db_column='Id', primary_key=True)  # Field name made lowercase.
    scenario_id = models.IntegerField()
    session_id = models.IntegerField()
    rate_fun = models.IntegerField()
    rate_difficulty = models.IntegerField()
    rate_accessibility = models.IntegerField()
    rate_originality = models.IntegerField()
    rate_direction = models.IntegerField()
    author = models.IntegerField()
    rating = models.IntegerField()
    comments = models.TextField()
    time_stamp = models.DateTimeField()

    class Meta:
        managed = False
        db_table = 'player_rating'


class RingUsers(models.Model):
    user_id = models.IntegerField(primary_key=True)
    user_name = models.CharField(unique=True, max_length=20)
    user_type = models.CharField(max_length=12)
    current_session = models.IntegerField()
    current_activity = models.CharField(max_length=7)
    current_status = models.CharField(max_length=10)
    public_level = models.CharField(max_length=9)
    account_type = models.CharField(max_length=9)
    content_access_level = models.CharField(max_length=20)
    description = models.TextField()
    lang = models.CharField(max_length=7)
    cookie = models.CharField(max_length=30)
    current_domain_id = models.IntegerField()
    pioneer_char_id = models.IntegerField()
    current_char = models.IntegerField()
    add_privileges = models.CharField(max_length=64)

    class Meta:
        managed = False
        db_table = 'ring_users'


class Scenario(models.Model):
    md5 = models.CharField(max_length=64)
    title = models.CharField(max_length=32)
    description = models.TextField()
    author = models.CharField(max_length=32)
    rrp_total = models.IntegerField()
    anim_mode = models.CharField(max_length=13)
    language = models.CharField(max_length=11)
    orientation = models.CharField(max_length=18)
    level = models.CharField(max_length=4)
    allow_free_trial = models.IntegerField()

    class Meta:
        managed = False
        db_table = 'scenario'


class ScenarioDesc(models.Model):
    session_id = models.IntegerField(primary_key=True)
    parent_scenario = models.IntegerField()
    description = models.TextField()
    relation_to_parent = models.CharField(max_length=13)
    title = models.CharField(unique=True, max_length=40)
    num_player = models.IntegerField()
    content_access_level = models.CharField(max_length=20)

    class Meta:
        managed = False
        db_table = 'scenario_desc'


class SessionLog(models.Model):
    id = models.IntegerField(primary_key=True)
    scenario_id = models.IntegerField()
    rrp_scored = models.IntegerField()
    scenario_point_scored = models.IntegerField()
    time_taken = models.IntegerField()
    participants = models.TextField()
    launch_date = models.DateTimeField()
    owner = models.CharField(max_length=32)
    guild_name = models.CharField(max_length=50, blank=True, null=True)

    class Meta:
        managed = False
        db_table = 'session_log'


class SessionParticipant(models.Model):
    id = models.AutoField(db_column='Id', primary_key=True)  # Field name made lowercase.
    session_id = models.IntegerField()
    char_id = models.IntegerField()
    status = models.CharField(max_length=19)
    kicked = models.IntegerField()
    session_rated = models.IntegerField()

    class Meta:
        managed = False
        db_table = 'session_participant'


class Sessions(models.Model):
    session_id = models.AutoField(primary_key=True)
    session_type = models.CharField(max_length=11)
    title = models.CharField(max_length=40)
    owner = models.IntegerField()
    plan_date = models.DateTimeField()
    start_date = models.DateTimeField()
    description = models.TextField()
    orientation = models.CharField(max_length=18)
    level = models.CharField(max_length=4)
    rule_type = models.CharField(max_length=10)
    access_type = models.CharField(max_length=10)
    state = models.CharField(max_length=10)
    host_shard_id = models.IntegerField()
    subscription_slots = models.IntegerField()
    reserved_slots = models.IntegerField()
    free_slots = models.IntegerField()
    estimated_duration = models.CharField(max_length=9)
    final_duration = models.IntegerField()
    folder_id = models.IntegerField()
    lang = models.CharField(max_length=20)
    icone = models.CharField(max_length=70)
    anim_mode = models.CharField(max_length=13)
    race_filter = models.CharField(max_length=36)
    religion_filter = models.CharField(max_length=29)
    guild_filter = models.CharField(max_length=16, blank=True, null=True)
    shard_filter = models.CharField(max_length=351)
    level_filter = models.CharField(max_length=29)
    subscription_closed = models.IntegerField()
    newcomer = models.IntegerField()

    class Meta:
        managed = False
        db_table = 'sessions'


class Shard(models.Model):
    shard_id = models.IntegerField(primary_key=True)
    wsonline = models.IntegerField(db_column='WSOnline')  # Field name made lowercase.
    motd = models.TextField(db_column='MOTD')  # Field name made lowercase.
    oldstate = models.CharField(db_column='OldState', max_length=13)  # Field name made lowercase.
    requiredstate = models.CharField(db_column='RequiredState', max_length=13)  # Field name made lowercase.

    class Meta:
        managed = False
        db_table = 'shard'

</code>
</WRAP>

{{tag>sysadmin developpement}}