rendered paste body>>> dir(__builtins__)['__class__', '__cmp__', '__contains__', '__delattr__', '__delitem__', '__doc__', '__eq__', '__ge__', '__getattribute__', '__getitem__', '__gt__', '__hash__', '__init__', '__iter__', '__le__', '__len__', '__lt__', '__ne__', '__new__', '__reduce__', '__reduce_ex__', '__repr__', '__setattr__', '__setitem__', '__str__', 'clear', 'copy', 'fromkeys', 'get', 'has_key', 'items', 'iteritems', 'iterkeys', 'itervalues', 'keys', 'pop', 'popitem', 'setdefault', 'update', 'values']from django.db import modelsfrom django.contrib.auth.models import Userfrom django.contrib.contenttypes.models import ContentTypefrom django.utils.translation import gettext_lazy as _REACTIONS = ( ('1', _('Neutral')), ('2', _('Friendly')), ('3', _('Hostile')),)class Version(models.Model): version = models.IntegerField(primary_key=True) patch = models.CharField(maxlength=135) test_server = models.BooleanField(); class Admin: list_display = ('version', 'patch', 'test_server',) list_filter = ('test_server',) search_fields = ['version', 'patch',]class SoundType(models.Model): name = models.CharField(maxlength=255, blank=True, null=True) class Admin: list_display = ('name',) search_fields = ['name',]#### These models are not handled by staff and are automatically kept updated. They may, however, include some administration to delete rows.###class DurabilityQuality(models.Model): unknown1 = models.FloatField(blank=True, null=True) text = models.CharField(maxlength=255) lang = models.CharField(maxlength=2, primary_key=True)class String(models.Model): name = models.CharField(primary_key=True, maxlength=255) text = models.CharField(maxlength=255) lang = models.CharField(maxlength=2, primary_key=True)class CreatureData(models.Model): creature = models.ForeignKey("Creature", primary_key=True) level_min = models.PositiveSmallIntegerField(null=True, blank=True) level_max = models.PositiveSmallIntegerField(null=True, blank=True) horde_react = models.PositiveSmallIntegerField(null=True, blank=True, choices=REACTIONS) alliance_react = models.PositiveSmallIntegerField(null=True, blank=True, choices=REACTIONS) def __str__(self): return creature.nameclass SpawnLocation(models.Model): spawn_type = models.ForeignKey(ContentType, db_index=True, primary_key=True) key = models.IntegerField(db_index=True, primary_key=True) area = models.ForeignKey("AreaTable", db_index=True, primary_key=True) pos_x = models.PositiveSmallIntegerField(primary_key=True, blank=True, null=True) pos_y = models.PositiveSmallIntegerField(primary_key=True, blank=True, null=True) recorded = models.PositiveIntegerField()class SpawnLoot(models.Model): spawn_type = models.ForeignKey(ContentType, db_index=True, primary_key=True) key = models.IntegerField(db_index=True, primary_key=True)class SpawnItem(models.Model): loot = models.ForeignKey("SpawnLoot", primary_key=True) item = models.ForeignKey("Item", db_index=True, primary_key=True) date = models.DateTimeField(primary_key=True)class NameGen(models.Model): name = models.TextField(blank=True, null=True) race = models.ForeignKey("ChrRace", db_index=True, blank=True, null=True) gender = models.PositiveSmallIntegerField(db_index=True, blank=True, null=True) version = models.ForeignKey("Version", db_index=True) hash = models.IntegerField(blank=True, null=True)class Creature(models.Model): name = models.CharField(maxlength=255)class NPC(models.Model): name = models.CharField(maxlength=255)class ItemText(models.Model): text = models.TextField()class PageText(models.Model): text_en = models.TextField(blank=True, null=True) text_kr = models.TextField(blank=True, null=True) text_fr = models.TextField(blank=True, null=True) text_de = models.TextField(blank=True, null=True) text_cn = models.TextField(blank=True, null=True) text_tw = models.TextField(blank=True, null=True) text_07 = models.TextField(blank=True, null=True) text_08 = models.TextField(blank=True, null=True) text_flags = models.IntegerField(blank=True, null=True) next_page = models.ForeignKey("self", db_index=True, blank=True, null=True) version = models.ForeignKey("Version", db_index=True) hash = models.IntegerField(blank=True, null=True) user = models.ForeignKey("User", db_index=True, blank=True, null=True)class Material(models.Model): unknown1 = models.IntegerField(blank=True, null=True) unknown2 = models.IntegerField(blank=True, null=True) unknown3 = models.IntegerField(blank=True, null=True) version = models.ForeignKey("Version", db_index=True) hash = models.IntegerField(blank=True, null=True)class SpellIcon(models.Model): path = models.CharField(maxlength=255, blank=True, null=True) version = models.ForeignKey("Version", db_index=True) hash = models.IntegerField(blank=True, null=True)class SoundEntry(models.Model): sound_type = models.ForeignKey(SoundType, db_index=True, blank=True, null=True) name = models.CharField(maxlength=255, blank=True, null=True) sound_file_1 = models.CharField(maxlength=255, blank=True, null=True) sound_file_2 = models.CharField(maxlength=255, blank=True, null=True) sound_file_3 = models.CharField(maxlength=255, blank=True, null=True) sound_file_4 = models.CharField(maxlength=255, blank=True, null=True) sound_file_5 = models.CharField(maxlength=255, blank=True, null=True) sound_file_6 = models.CharField(maxlength=255, blank=True, null=True) sound_file_7 = models.CharField(maxlength=255, blank=True, null=True) sound_file_8 = models.CharField(maxlength=255, blank=True, null=True) sound_file_9 = models.CharField(maxlength=255, blank=True, null=True) sound_file_10 = models.CharField(maxlength=255, blank=True, null=True) unknown1 = models.IntegerField(blank=True, null=True) unknown2 = models.IntegerField(blank=True, null=True) unknown3 = models.IntegerField(blank=True, null=True) unknown4 = models.IntegerField(blank=True, null=True) unknown5 = models.IntegerField(blank=True, null=True) unknown6 = models.IntegerField(blank=True, null=True) unknown7 = models.IntegerField(blank=True, null=True) unknown8 = models.IntegerField(blank=True, null=True) unknown9 = models.IntegerField(blank=True, null=True) unknown10 = models.IntegerField(blank=True, null=True) sound_folder = models.CharField(maxlength=255, blank=True, null=True) unknown11 = models.IntegerField(blank=True, null=True) unknown12 = models.IntegerField(blank=True, null=True) unknown13 = models.IntegerField(blank=True, null=True) unknown14 = models.IntegerField(blank=True, null=True) unknown15 = models.IntegerField(blank=True, null=True) version = models.ForeignKey("Version", db_index=True) hash = models.IntegerField(blank=True, null=True)class ZoneIntroMusicTable(models.Model): name = models.CharField(maxlength=255, blank=True, null=True) sound = models.ForeignKey(SoundEntry, db_index=True, blank=True, null=True) pos_begin = models.IntegerField(blank=True, null=True) pos_end = models.IntegerField(blank=True, null=True) version = models.ForeignKey("Version", db_index=True) hash = models.CharField(maxlength=69)class SoundAmbience(models.Model): sound_day = models.ForeignKey(SoundEntry, db_index=True, blank=True, null=True) sound_night = models.ForeignKey(SoundEntry, db_index=True, blank=True, null=True) version = models.ForeignKey("Version", db_index=True) hash = models.CharField(maxlength=69)class CreatureSoundData(models.Model): attack_sound = models.ForeignKey(SoundEntry, db_index=True, blank=True, null=True) unknown1 = models.IntegerField(blank=True, null=True) wound_sound = models.ForeignKey(SoundEntry, db_index=True, blank=True, null=True) wound_crit_sound = models.ForeignKey(SoundEntry, db_index=True, blank=True, null=True) unknown2 = models.IntegerField(blank=True, null=True) death_sound = models.ForeignKey(SoundEntry, db_index=True, blank=True, null=True) unknown3 = models.IntegerField(blank=True, null=True) unknown4 = models.IntegerField(blank=True, null=True) unknown5 = models.IntegerField(blank=True, null=True) aggro_sound = models.ForeignKey(SoundEntry, db_index=True, blank=True, null=True) unknown6 = models.IntegerField(blank=True, null=True) unknown7 = models.IntegerField(blank=True, null=True) unknown8 = models.IntegerField(blank=True, null=True) unknown9 = models.IntegerField(blank=True, null=True) unknown10 = models.IntegerField(blank=True, null=True) stand_1_sound = models.ForeignKey(SoundEntry, db_index=True, blank=True, null=True) stand_2_sound = models.ForeignKey(SoundEntry, db_index=True, blank=True, null=True) unknown11 = models.IntegerField(blank=True, null=True) bite_1_sound = models.ForeignKey(SoundEntry, db_index=True, blank=True, null=True) unknown12 = models.IntegerField(blank=True, null=True) unknown13 = models.IntegerField(blank=True, null=True) unknown14 = models.IntegerField(blank=True, null=True) unknown15 = models.IntegerField(blank=True, null=True) unknown16 = models.IntegerField(blank=True, null=True) unknown17 = models.IntegerField(blank=True, null=True) unknown18 = models.IntegerField(blank=True, null=True) unknown19 = models.IntegerField(blank=True, null=True) unknown20 = models.IntegerField(blank=True, null=True) unknown21 = models.IntegerField(blank=True, null=True) version = models.ForeignKey("Version", db_index=True) hash = models.CharField(maxlength=32)class NPCSound(models.Model): sound_1 = models.ForeignKey(SoundEntry, db_index=True, blank=True, null=True) sound_2 = models.ForeignKey(SoundEntry, db_index=True, blank=True, null=True) sound_3 = models.ForeignKey(SoundEntry, db_index=True, blank=True, null=True) sound_4 = models.ForeignKey(SoundEntry, db_index=True, blank=True, null=True) version = models.ForeignKey("Version", db_index=True) hash = models.IntegerField(blank=True, null=True)class ZoneIntroMusicTable(models.Model): name = models.CharField(maxlength=255, blank=True, null=True) sound = models.ForeignKey(SoundEntry, db_index=True, blank=True, null=True) pos_begin = models.IntegerField(blank=True, null=True) pos_end = models.IntegerField(blank=True, null=True) version = models.ForeignKey("Version", db_index=True) hash = models.CharField(maxlength=69)class ItemGroupSound(models.Model): sound_pickup = models.ForeignKey(SoundEntry, db_index=True, blank=True, null=True) sound_drop = models.ForeignKey(SoundEntry, db_index=True, blank=True, null=True) sound_3 = models.ForeignKey(SoundEntry, db_index=True, blank=True, null=True) sound_4 = models.ForeignKey(SoundEntry, db_index=True, blank=True, null=True) version = models.ForeignKey("Version", db_index=True) hash = models.CharField(maxlength=32)class SkillLineCategory(models.Model): name_en = models.CharField(maxlength=255, blank=True, null=True) name_kr = models.CharField(maxlength=255, blank=True, null=True) name_fr = models.CharField(maxlength=255, blank=True, null=True) name_de = models.CharField(maxlength=255, blank=True, null=True) name_cn = models.CharField(maxlength=255, blank=True, null=True) name_tw = models.CharField(maxlength=255, blank=True, null=True) name_07 = models.CharField(maxlength=255, blank=True, null=True) name_08 = models.CharField(maxlength=255, blank=True, null=True) name_flags = models.IntegerField(blank=True, null=True) unknown1 = models.IntegerField(blank=True, null=True) version = models.ForeignKey("Version", db_index=True) hash = models.IntegerField(blank=True, null=True)class SkillLine(models.Model): category = models.ForeignKey(SkillLineCategory, db_index=True, blank=True, null=True) unknown1 = models.IntegerField(blank=True, null=True) name_en = models.CharField(maxlength=255, blank=True, null=True) name_kr = models.CharField(maxlength=255, blank=True, null=True) name_fr = models.CharField(maxlength=255, blank=True, null=True) name_de = models.CharField(maxlength=255, blank=True, null=True) name_cn = models.CharField(maxlength=255, blank=True, null=True) name_tw = models.CharField(maxlength=255, blank=True, null=True) name_07 = models.CharField(maxlength=255, blank=True, null=True) name_08 = models.CharField(maxlength=255, blank=True, null=True) name_flags = models.IntegerField(blank=True, null=True) description_en = models.TextField(blank=True, null=True) description_kr = models.TextField(blank=True, null=True) description_fr = models.TextField(blank=True, null=True) description_de = models.TextField(blank=True, null=True) description_cn = models.TextField(blank=True, null=True) description_tw = models.TextField(blank=True, null=True) description_07 = models.TextField(blank=True, null=True) description_08 = models.TextField(blank=True, null=True) description_flags = models.IntegerField(blank=True, null=True) icon = models.ForeignKey(SpellIcon, db_index=True, blank=True, null=True) version = models.ForeignKey("Version", db_index=True) hash = models.IntegerField(blank=True, null=True)class SpellEffectName(models.Model): name_en = models.CharField(maxlength=255, blank=True, null=True) name_kr = models.CharField(maxlength=255, blank=True, null=True) name_fr = models.CharField(maxlength=255, blank=True, null=True) name_de = models.CharField(maxlength=255, blank=True, null=True) name_cn = models.CharField(maxlength=255, blank=True, null=True) name_tw = models.CharField(maxlength=255, blank=True, null=True) name_07 = models.CharField(maxlength=255, blank=True, null=True) name_08 = models.CharField(maxlength=255, blank=True, null=True) name_flags = models.IntegerField(blank=True, null=True) version = models.ForeignKey("Version", db_index=True) hash = models.IntegerField(blank=True, null=True)class SpellMechanic(models.Model): name_en = models.CharField(maxlength=255, blank=True, null=True) name_kr = models.CharField(maxlength=255, blank=True, null=True) name_fr = models.CharField(maxlength=255, blank=True, null=True) name_de = models.CharField(maxlength=255, blank=True, null=True) name_cn = models.CharField(maxlength=255, blank=True, null=True) name_tw = models.CharField(maxlength=255, blank=True, null=True) name_07 = models.CharField(maxlength=255, blank=True, null=True) name_08 = models.CharField(maxlength=255, blank=True, null=True) name_flags = models.IntegerField(blank=True, null=True) version = models.ForeignKey("Version", db_index=True) hash = models.IntegerField(blank=True, null=True)class SpellAuraName(models.Model): unknown1 = models.IntegerField(blank=True, null=True) constant_name = models.CharField(maxlength=255, blank=True, null=True) name_en = models.CharField(maxlength=255, blank=True, null=True) name_kr = models.CharField(maxlength=255, blank=True, null=True) name_fr = models.CharField(maxlength=255, blank=True, null=True) name_de = models.CharField(maxlength=255, blank=True, null=True) name_cn = models.CharField(maxlength=255, blank=True, null=True) name_tw = models.CharField(maxlength=255, blank=True, null=True) name_07 = models.CharField(maxlength=255, blank=True, null=True) name_08 = models.CharField(maxlength=255, blank=True, null=True) name_flags = models.IntegerField(blank=True, null=True) version = models.ForeignKey("Version", db_index=True) hash = models.IntegerField(blank=True, null=True)class SpellCastTime(models.Model): base = models.IntegerField(blank=True, null=True) per_level = models.IntegerField(blank=True, null=True) min = models.IntegerField(blank=True, null=True) version = models.ForeignKey("Version", db_index=True) hash = models.IntegerField(blank=True, null=True)class SpellDispelType(models.Model): name_en = models.CharField(maxlength=255, blank=True, null=True) name_kr = models.CharField(maxlength=255, blank=True, null=True) name_fr = models.CharField(maxlength=255, blank=True, null=True) name_de = models.CharField(maxlength=255, blank=True, null=True) name_cn = models.CharField(maxlength=255, blank=True, null=True) name_tw = models.CharField(maxlength=255, blank=True, null=True) name_07 = models.CharField(maxlength=255, blank=True, null=True) name_08 = models.CharField(maxlength=255, blank=True, null=True) name_flags = models.IntegerField(blank=True, null=True) tooltip = models.PositiveSmallIntegerField(blank=True, null=True) constant_name = models.CharField(maxlength=255, blank=True, null=True) version = models.ForeignKey("Version", db_index=True) hash = models.IntegerField(blank=True, null=True)class SpellDuration(models.Model): base = models.IntegerField(blank=True, null=True) per_level = models.IntegerField(blank=True, null=True) max = models.IntegerField(blank=True, null=True) version = models.ForeignKey("Version", db_index=True) hash = models.IntegerField(blank=True, null=True)class SpellFocusObject(models.Model): name_en = models.CharField(maxlength=255, blank=True, null=True) name_kr = models.CharField(maxlength=255, blank=True, null=True) name_fr = models.CharField(maxlength=255, blank=True, null=True) name_de = models.CharField(maxlength=255, blank=True, null=True) name_cn = models.CharField(maxlength=255, blank=True, null=True) name_tw = models.CharField(maxlength=255, blank=True, null=True) name_07 = models.CharField(maxlength=255, blank=True, null=True) name_08 = models.CharField(maxlength=255, blank=True, null=True) name_flags = models.IntegerField(blank=True, null=True) version = models.ForeignKey("Version", db_index=True) hash = models.IntegerField(blank=True, null=True)class SpellRadius(models.Model): base = models.IntegerField(blank=True, null=True) per_level = models.IntegerField(blank=True, null=True) max = models.IntegerField(blank=True, null=True) version = models.ForeignKey("Version", db_index=True) hash = models.IntegerField(blank=True, null=True)class SpellRange(models.Model): min = models.IntegerField(blank=True, null=True) max = models.IntegerField(blank=True, null=True) flags = models.IntegerField(blank=True, null=True) description_en = models.CharField(maxlength=255, blank=True, null=True) description_kr = models.CharField(maxlength=255, blank=True, null=True) description_fr = models.CharField(maxlength=255, blank=True, null=True) description_de = models.CharField(maxlength=255, blank=True, null=True) description_cn = models.CharField(maxlength=255, blank=True, null=True) description_tw = models.CharField(maxlength=255, blank=True, null=True) description_07 = models.CharField(maxlength=255, blank=True, null=True) description_08 = models.CharField(maxlength=255, blank=True, null=True) description_flags = models.IntegerField(blank=True, null=True) name_en = models.CharField(maxlength=255, blank=True, null=True) name_kr = models.CharField(maxlength=255, blank=True, null=True) name_fr = models.CharField(maxlength=255, blank=True, null=True) name_de = models.CharField(maxlength=255, blank=True, null=True) name_cn = models.CharField(maxlength=255, blank=True, null=True) name_tw = models.CharField(maxlength=255, blank=True, null=True) name_07 = models.CharField(maxlength=255, blank=True, null=True) name_08 = models.CharField(maxlength=255, blank=True, null=True) name_flags = models.IntegerField(blank=True, null=True) version = models.ForeignKey("Version", db_index=True) hash = models.IntegerField(blank=True, null=True)class SpellShapeshiftForm(models.Model): unknown1 = models.IntegerField(blank=True, null=True) name_en = models.CharField(maxlength=255, blank=True, null=True) name_kr = models.CharField(maxlength=255, blank=True, null=True) name_fr = models.CharField(maxlength=255, blank=True, null=True) name_de = models.CharField(maxlength=255, blank=True, null=True) name_cn = models.CharField(maxlength=255, blank=True, null=True) name_tw = models.CharField(maxlength=255, blank=True, null=True) name_07 = models.CharField(maxlength=255, blank=True, null=True) name_08 = models.CharField(maxlength=255, blank=True, null=True) name_flags = models.IntegerField(blank=True, null=True) unknown2 = models.IntegerField(blank=True, null=True) unknown3 = models.IntegerField(blank=True, null=True) unknown4 = models.IntegerField(blank=True, null=True) version = models.ForeignKey("Version", db_index=True) hash = models.CharField(maxlength=69)class SpellChainEffect(models.Model): unknown1 = models.FloatField(blank=True, null=True) unknown2 = models.FloatField(blank=True, null=True) unknown3 = models.FloatField(blank=True, null=True) unknown4 = models.FloatField(blank=True, null=True) unknown5 = models.IntegerField(blank=True, null=True) unknown6 = models.IntegerField(blank=True, null=True) name_en = models.CharField(maxlength=255, blank=True, null=True) name_kr = models.CharField(maxlength=255, blank=True, null=True) name_fr = models.CharField(maxlength=255, blank=True, null=True) name_de = models.CharField(maxlength=255, blank=True, null=True) name_cn = models.CharField(maxlength=255, blank=True, null=True) name_tw = models.CharField(maxlength=255, blank=True, null=True) name_07 = models.CharField(maxlength=255, blank=True, null=True) name_08 = models.CharField(maxlength=255, blank=True, null=True) name_flags = models.IntegerField(blank=True, null=True) version = models.ForeignKey("Version", db_index=True) hash = models.CharField(maxlength=69)class SpellVisualEffectName(models.Model): constant_name = models.CharField(maxlength=255, blank=True, null=True) path = models.CharField(maxlength=255, blank=True, null=True) flags = models.IntegerField(blank=True, null=True) unknown1 = models.FloatField(blank=True, null=True) version = models.ForeignKey("Version", db_index=True) hash = models.CharField(maxlength=69)class SpellVisualKit(models.Model): unknown1 = models.IntegerField(blank=True, null=True) unknown2 = models.IntegerField(blank=True, null=True) unknown3 = models.IntegerField(blank=True, null=True) unknown4 = models.IntegerField(blank=True, null=True) unknown5 = models.IntegerField(blank=True, null=True) unknown6 = models.IntegerField(blank=True, null=True) unknown7 = models.IntegerField(blank=True, null=True) unknown8 = models.IntegerField(blank=True, null=True) unknown9 = models.IntegerField(blank=True, null=True) unknown10 = models.IntegerField(blank=True, null=True) unknown11 = models.IntegerField(blank=True, null=True) unknown12 = models.IntegerField(blank=True, null=True) sound = models.ForeignKey(SoundEntry, db_index=True, blank=True, null=True) unknown13 = models.IntegerField(blank=True, null=True) unknown14 = models.IntegerField(blank=True, null=True) unknown15 = models.IntegerField(blank=True, null=True) unknown16 = models.IntegerField(blank=True, null=True) unknown17 = models.IntegerField(blank=True, null=True) unknown18 = models.IntegerField(blank=True, null=True) unknown19 = models.IntegerField(blank=True, null=True) unknown20 = models.IntegerField(blank=True, null=True) unknown21 = models.IntegerField(blank=True, null=True) unknown22 = models.IntegerField(blank=True, null=True) unknown23 = models.IntegerField(blank=True, null=True) unknown24 = models.IntegerField(blank=True, null=True) unknown25 = models.IntegerField(blank=True, null=True) unknown26 = models.IntegerField(blank=True, null=True) unknown27 = models.IntegerField(blank=True, null=True) unknown28 = models.IntegerField(blank=True, null=True) unknown29 = models.IntegerField(blank=True, null=True) unknown30 = models.IntegerField(blank=True, null=True) unknown31 = models.IntegerField(blank=True, null=True) unknown32 = models.IntegerField(blank=True, null=True) unknown33 = models.IntegerField(blank=True, null=True) version = models.ForeignKey("Version", db_index=True) hash = models.CharField(maxlength=69)class SpellVisual(models.Model): precast_kit = models.ForeignKey(SpellVisualKit, db_index=True, blank=True, null=True) cast_kit = models.ForeignKey(SpellVisualKit, db_index=True, blank=True, null=True) target_kit = models.ForeignKey(SpellVisualKit, db_index=True, blank=True, null=True) buff_kit = models.ForeignKey(SpellVisualKit, db_index=True, blank=True, null=True) channel_kit = models.ForeignKey(SpellVisualKit, db_index=True, blank=True, null=True) has_missile_effect = models.IntegerField(blank=True, null=True) missile_effect = models.ForeignKey(SpellVisualEffectName, db_index=True, blank=True, null=True) flags = models.IntegerField(blank=True, null=True) unknown6 = models.IntegerField(blank=True, null=True) unknown7 = models.IntegerField(blank=True, null=True) unknown8 = models.IntegerField(blank=True, null=True) aoe_center_kit = models.ForeignKey(SpellVisualKit, db_index=True, blank=True, null=True) aoe_kit = models.ForeignKey(SpellVisualKit, db_index=True, blank=True, null=True) unknown11 = models.IntegerField(blank=True, null=True) unknown12 = models.IntegerField(blank=True, null=True) version = models.ForeignKey("Version", db_index=True) hash = models.CharField(maxlength=69)class SpellCategory(models.Model): unknown1 = models.IntegerField(blank=True, null=True) version = models.ForeignKey("Version", db_index=True) hash = models.CharField(maxlength=69)class Spell(models.Model): school = models.PositiveSmallIntegerField(blank=True, null=True) category = models.ForeignKey(SpellCategory, db_index=True, blank=True, null=True) unknown1 = models.IntegerField(blank=True, null=True) dispel_type = models.ForeignKey(SpellDispelType, db_index=True, blank=True, null=True) mechanic = models.ForeignKey(SpellMechanic, db_index=True, blank=True, null=True) unknown4 = models.IntegerField(blank=True, null=True) unknown5 = models.IntegerField(blank=True, null=True) unknown6 = models.IntegerField(blank=True, null=True) unknown7 = models.IntegerField(blank=True, null=True) unknown8 = models.IntegerField(blank=True, null=True) unknown9 = models.IntegerField(blank=True, null=True) creature_type = models.IntegerField(blank=True, null=True) focus_object = models.ForeignKey(SpellFocusObject, db_index=True, blank=True, null=True) caster_aura_state = models.IntegerField(blank=True, null=True) target_aura_state = models.IntegerField(blank=True, null=True) cast_time = models.ForeignKey(SpellCastTime, db_index=True, blank=True, null=True) category_cooldown = models.IntegerField(blank=True, null=True) spell_cooldown = models.IntegerField(blank=True, null=True) interrupt_flags = models.IntegerField(blank=True, null=True) aura_intterupt_flags = models.IntegerField(blank=True, null=True) category_interrupt_flags = models.IntegerField(blank=True, null=True) proc_flags = models.IntegerField(blank=True, null=True) proc_chance = models.IntegerField(blank=True, null=True) proc_charges = models.IntegerField(blank=True, null=True) level_max = models.IntegerField(blank=True, null=True) level_base = models.IntegerField(blank=True, null=True) level = models.IntegerField(blank=True, null=True) duration = models.ForeignKey(SpellDuration, db_index=True, blank=True, null=True) power_type = models.PositiveSmallIntegerField(db_index=True, blank=True, null=True) mana_cost = models.IntegerField(blank=True, null=True) mana_cost_per_level = models.IntegerField(blank=True, null=True) mana_per_second = models.IntegerField(blank=True, null=True) mana_per_second_per_level = models.IntegerField(blank=True, null=True) range = models.ForeignKey(SpellRange, db_index=True, blank=True, null=True) projectile_speed = models.IntegerField(blank=True, null=True) modal_next_spell = models.IntegerField(blank=True, null=True) stack_amount = models.IntegerField(blank=True, null=True) item_1 = models.ForeignKey("Item", db_index=True, blank=True, null=True) item_2 = models.ForeignKey("Item", db_index=True, blank=True, null=True) reagent_1 = models.ForeignKey("Item", db_index=True, blank=True, null=True) reagent_2 = models.ForeignKey("Item", db_index=True, blank=True, null=True) reagent_3 = models.ForeignKey("Item", db_index=True, blank=True, null=True) reagent_4 = models.ForeignKey("Item", db_index=True, blank=True, null=True) reagent_5 = models.ForeignKey("Item", db_index=True, blank=True, null=True) reagent_6 = models.ForeignKey("Item", db_index=True, blank=True, null=True) reagent_7 = models.ForeignKey("Item", db_index=True, blank=True, null=True) reagent_8 = models.ForeignKey("Item", db_index=True, blank=True, null=True) reagent_1_amount = models.IntegerField(blank=True, null=True) reagent_2_amount = models.IntegerField(blank=True, null=True) reagent_3_amount = models.IntegerField(blank=True, null=True) reagent_4_amount = models.IntegerField(blank=True, null=True) reagent_5_amount = models.IntegerField(blank=True, null=True) reagent_6_amount = models.IntegerField(blank=True, null=True) reagent_7_amount = models.IntegerField(blank=True, null=True) reagent_8_amount = models.IntegerField(blank=True, null=True) item_class = models.ForeignKey("ItemClass", db_index=True, blank=True, null=True) item_sub_class = models.ForeignKey("ItemSubClass", db_index=True, blank=True, null=True) effect_1 = models.ForeignKey(SpellEffectName, db_index=True, blank=True, null=True) effect_2 = models.ForeignKey(SpellEffectName, db_index=True, blank=True, null=True) effect_3 = models.ForeignKey(SpellEffectName, db_index=True, blank=True, null=True) effect_1_die_sides = models.IntegerField(blank=True, null=True) effect_2_die_sides = models.IntegerField(blank=True, null=True) effect_3_die_sides = models.IntegerField(blank=True, null=True) effect_1_base_dice = models.IntegerField(blank=True, null=True) effect_2_base_dice = models.IntegerField(blank=True, null=True) effect_3_base_dice = models.IntegerField(blank=True, null=True) effect_1_dice_per_level = models.IntegerField(blank=True, null=True) effect_2_dice_per_level = models.IntegerField(blank=True, null=True) effect_3_dice_per_level = models.IntegerField(blank=True, null=True) effect_1_points_per_level = models.IntegerField(blank=True, null=True) effect_2_points_per_level = models.IntegerField(blank=True, null=True) effect_3_points_per_level = models.IntegerField(blank=True, null=True) effect_1_base_points = models.IntegerField(blank=True, null=True) effect_2_base_points = models.IntegerField(blank=True, null=True) effect_3_base_points = models.IntegerField(blank=True, null=True) effect_1_mechanic = models.ForeignKey(SpellMechanic, db_index=True, blank=True, null=True) effect_2_mechanic = models.ForeignKey(SpellMechanic, db_index=True,blank=True, null=True) effect_3_mechanic = models.ForeignKey(SpellMechanic, db_index=True,blank=True, null=True) effect_1_implicit_target_1 = models.IntegerField(blank=True, null=True) effect_2_implicit_target_1 = models.IntegerField(blank=True, null=True) effect_3_implicit_target_1 = models.IntegerField(blank=True, null=True) effect_1_implicit_target_2 = models.IntegerField(blank=True, null=True) effect_2_implicit_target_2 = models.IntegerField(blank=True, null=True) effect_3_implicit_target_2 = models.IntegerField(blank=True, null=True) effect_1_radius = models.ForeignKey(SpellRadius, db_index=True, blank=True, null=True) effect_2_radius = models.ForeignKey(SpellRadius, db_index=True, blank=True, null=True) effect_3_radius = models.ForeignKey(SpellRadius, db_index=True, blank=True, null=True) effect_1_aura = models.IntegerField(blank=True, null=True) effect_2_aura = models.IntegerField(blank=True, null=True) effect_3_aura = models.IntegerField(blank=True, null=True) effect_1_amplitude = models.IntegerField(blank=True, null=True) effect_2_amplitude = models.IntegerField(blank=True, null=True) effect_3_amplitude = models.IntegerField(blank=True, null=True) effect_1_proc = models.IntegerField(blank=True, null=True) effect_2_proc = models.IntegerField(blank=True, null=True) effect_3_proc = models.IntegerField(blank=True, null=True) effect_1_chain_target = models.IntegerField(blank=True, null=True) effect_2_chain_target = models.IntegerField(blank=True, null=True) effect_3_chain_target = models.IntegerField(blank=True, null=True) effect_1_item = models.IntegerField(blank=True, null=True) effect_2_item = models.IntegerField(blank=True, null=True) effect_3_item = models.IntegerField(blank=True, null=True) effect_1_misc_value = models.IntegerField(blank=True, null=True) effect_2_misc_value = models.IntegerField(blank=True, null=True) effect_3_misc_value = models.IntegerField(blank=True, null=True) effect_1_trigger_spell = models.ForeignKey("Spell", db_index=True, blank=True, null=True) effect_2_trigger_spell = models.ForeignKey("Spell", db_index=True, blank=True, null=True) effect_3_trigger_spell = models.ForeignKey("Spell", db_index=True, blank=True, null=True) effect_1_proc_chance = models.IntegerField(blank=True, null=True) effect_2_proc_chance = models.IntegerField(blank=True, null=True) effect_3_proc_chance = models.IntegerField(blank=True, null=True) visual = models.ForeignKey(SpellVisual, db_index=True, blank=True, null=True) unknown21 = models.IntegerField(blank=True, null=True) icon = models.ForeignKey(SpellIcon, db_index=True, blank=True, null=True) target_icon = models.ForeignKey(SpellIcon, db_index=True, blank=True, null=True) priority = models.IntegerField(blank=True, null=True) name_en = models.CharField(maxlength=255, blank=True, null=True) name_kr = models.CharField(maxlength=255, blank=True, null=True) name_fr = models.CharField(maxlength=255, blank=True, null=True) name_de = models.CharField(maxlength=255, blank=True, null=True) name_cn = models.CharField(maxlength=255, blank=True, null=True) name_tw = models.CharField(maxlength=255, blank=True, null=True) name_07 = models.CharField(maxlength=255, blank=True, null=True) name_08 = models.CharField(maxlength=255, blank=True, null=True) name_flags = models.IntegerField(blank=True, null=True) rank_en = models.CharField(maxlength=255, blank=True, null=True) rank_kr = models.CharField(maxlength=255, blank=True, null=True) rank_fr = models.CharField(maxlength=255, blank=True, null=True) rank_de = models.CharField(maxlength=255, blank=True, null=True) rank_cn = models.CharField(maxlength=255, blank=True, null=True) rank_tw = models.CharField(maxlength=255, blank=True, null=True) rank_07 = models.CharField(maxlength=255, blank=True, null=True) rank_08 = models.CharField(maxlength=255, blank=True, null=True) rank_flags = models.IntegerField(blank=True, null=True) description_en = models.TextField(blank=True, null=True) description_kr = models.TextField(blank=True, null=True) description_fr = models.TextField(blank=True, null=True) description_de = models.TextField(blank=True, null=True) description_cn = models.TextField(blank=True, null=True) description_tw = models.TextField(blank=True, null=True) description_07 = models.TextField(blank=True, null=True) description_08 = models.TextField(blank=True, null=True) description_flags = models.IntegerField(blank=True, null=True) buff_description_en = models.TextField(blank=True, null=True) buff_description_kr = models.TextField(blank=True, null=True) buff_description_fr = models.TextField(blank=True, null=True) buff_description_de = models.TextField(blank=True, null=True) buff_description_cn = models.TextField(blank=True, null=True) buff_description_tw = models.TextField(blank=True, null=True) buff_description_07 = models.TextField(blank=True, null=True) buff_description_08 = models.TextField(blank=True, null=True) buff_description_flags = models.IntegerField(blank=True, null=True) mana_cost_percent = models.IntegerField(blank=True, null=True) cooldown_category = models.ForeignKey(SpellCategory, db_index=True, blank=True, null=True) cooldown = models.IntegerField(blank=True, null=True) target_max_level = models.IntegerField(blank=True, null=True) target_class = models.ForeignKey("ChrClass", to_field='id2', blank=True, null=True) unknown24 = models.IntegerField(blank=True, null=True) targets = models.IntegerField(blank=True, null=True) unknown26 = models.IntegerField(blank=True, null=True) damage_type = models.PositiveSmallIntegerField(blank=True, null=True) unknown33 = models.IntegerField(blank=True, null=True) unknown34 = models.IntegerField(blank=True, null=True) damage_multiplier_1 = models.IntegerField(blank=True, null=True) damage_multiplier_2 = models.IntegerField(blank=True, null=True) damage_multiplier_3 = models.IntegerField(blank=True, null=True) unknown29 = models.IntegerField(blank=True, null=True) unknown30 = models.IntegerField(blank=True, null=True) unknown31 = models.IntegerField(blank=True, null=True) unknown32 = models.IntegerField(blank=True, null=True) version = models.ForeignKey("Version", db_index=True) hash = models.IntegerField(blank=True, null=True)class SpellItemEnchantment(models.Model): classes = models.IntegerField(blank=True, null=True) unknown1 = models.IntegerField(blank=True, null=True) unknown2 = models.IntegerField(blank=True, null=True) stat_1 = models.PositiveSmallIntegerField(db_index=True, blank=True, null=True) unknown3 = models.IntegerField(blank=True, null=True) unknown4 = models.IntegerField(blank=True, null=True) stat_2 = models.PositiveSmallIntegerField(db_index=True, blank=True, null=True) unknown5 = models.IntegerField(blank=True, null=True) unknown6 = models.IntegerField(blank=True, null=True) spell = models.ForeignKey("Spell", db_index=True, blank=True, null=True) unknown7 = models.IntegerField(blank=True, null=True) unknown8 = models.IntegerField(blank=True, null=True) unknown9 = models.IntegerField(blank=True, null=True) unknown10 = models.IntegerField(blank=True, null=True) version = models.ForeignKey("Version", db_index=True) hash = models.IntegerField(blank=True, null=True)class QuestInfo(models.Model): name_en = models.CharField(maxlength=255, blank=True, null=True) name_kr = models.CharField(maxlength=255, blank=True, null=True) name_fr = models.CharField(maxlength=255, blank=True, null=True) name_de = models.CharField(maxlength=255, blank=True, null=True) name_cn = models.CharField(maxlength=255, blank=True, null=True) name_tw = models.CharField(maxlength=255, blank=True, null=True) name_07 = models.CharField(maxlength=255, blank=True, null=True) name_08 = models.CharField(maxlength=255, blank=True, null=True) name_flags = models.IntegerField(blank=True, null=True) version = models.ForeignKey("Version", db_index=True) hash = models.IntegerField(blank=True, null=True)class QuestSort(models.Model): name_en = models.CharField(maxlength=255, blank=True, null=True) name_kr = models.CharField(maxlength=255, blank=True, null=True) name_fr = models.CharField(maxlength=255, blank=True, null=True) name_de = models.CharField(maxlength=255, blank=True, null=True) name_cn = models.CharField(maxlength=255, blank=True, null=True) name_tw = models.CharField(maxlength=255, blank=True, null=True) name_07 = models.CharField(maxlength=255, blank=True, null=True) name_08 = models.CharField(maxlength=255, blank=True, null=True) name_flags = models.IntegerField(blank=True, null=True) version = models.ForeignKey("Version", db_index=True) hash = models.IntegerField(blank=True, null=True)class Quest(models.Model): unknown1 = models.IntegerField(blank=True, null=True) unknown2 = models.IntegerField(blank=True, null=True) level = models.IntegerField(blank=True, null=True) area = models.ForeignKey("AreaTable", db_index=True, blank=True, null=True) info = models.ForeignKey(QuestInfo, db_index=True, blank=True, null=True) unknown3 = models.IntegerField(blank=True, null=True) unknown4 = models.IntegerField(blank=True, null=True) unknown5 = models.IntegerField(blank=True, null=True) unknown6 = models.IntegerField(blank=True, null=True) next_quest = models.ForeignKey("self", db_index=True, blank=True, null=True) coins = models.IntegerField(blank=True, null=True) level_cap_coins = models.IntegerField(blank=True, null=True) reward_spell = models.ForeignKey("Spell", db_index=True, blank=True, null=True) starting_item = models.ForeignKey("Item", db_index=True, blank=True, null=True) flags = models.IntegerField(blank=True, null=True) given_item_1 = models.ForeignKey("Item", db_index=True, blank=True, null=True) given_Item_1_amount = models.IntegerField(blank=True, null=True) given_Item_2 = models.ForeignKey("Item", db_index=True, blank=True, null=True) given_Item_2_amount = models.IntegerField(blank=True, null=True) given_Item_3 = models.ForeignKey("Item", db_index=True, blank=True, null=True) given_Item_3_amount = models.IntegerField(blank=True, null=True) given_Item_4 = models.ForeignKey("Item", db_index=True, blank=True, null=True) given_Item_4_amount = models.IntegerField(blank=True, null=True) choice_Item_1 = models.ForeignKey("Item", db_index=True, blank=True, null=True) choice_Item_1_amount = models.IntegerField(blank=True, null=True) choice_Item_2 = models.ForeignKey("Item", db_index=True, blank=True, null=True) choice_Item_2_amount = models.IntegerField(blank=True, null=True) choice_Item_3 = models.ForeignKey("Item", db_index=True, blank=True, null=True) choice_Item_3_amount = models.IntegerField(blank=True, null=True) choice_Item_4 = models.ForeignKey("Item", db_index=True, blank=True, null=True) choice_Item_4_amount = models.IntegerField(blank=True, null=True) choice_Item_5 = models.ForeignKey("Item", db_index=True, blank=True, null=True) choice_Item_5_amount = models.IntegerField(blank=True, null=True) choice_Item_6 = models.ForeignKey("Item", db_index=True, blank=True, null=True) choice_Item_6_amount = models.IntegerField(blank=True, null=True) unknown7 = models.IntegerField(blank=True, null=True) unknown8 = models.IntegerField(blank=True, null=True) unknown9 = models.IntegerField(blank=True, null=True) unknown10 = models.IntegerField(blank=True, null=True) name_en = models.CharField(maxlength=255, blank=True, null=True) name_kr = models.CharField(maxlength=255, blank=True, null=True) name_fr = models.CharField(maxlength=255, blank=True, null=True) name_de = models.CharField(maxlength=255, blank=True, null=True) name_cn = models.CharField(maxlength=255, blank=True, null=True) name_tw = models.CharField(maxlength=255, blank=True, null=True) name_07 = models.CharField(maxlength=255, blank=True, null=True) name_08 = models.CharField(maxlength=255, blank=True, null=True) description_en = models.TextField(blank=True, null=True) description_kr = models.TextField(blank=True, null=True) description_fr = models.TextField(blank=True, null=True) description_de = models.TextField(blank=True, null=True) description_cn = models.TextField(blank=True, null=True) description_tw = models.TextField(blank=True, null=True) description_07 = models.TextField(blank=True, null=True) description_08 = models.TextField(blank=True, null=True) details_en = models.TextField(blank=True, null=True) details_kr = models.TextField(blank=True, null=True) details_fr = models.TextField(blank=True, null=True) details_de = models.TextField(blank=True, null=True) details_cn = models.TextField(blank=True, null=True) details_tw = models.TextField(blank=True, null=True) details_07 = models.TextField(blank=True, null=True) details_08 = models.TextField(blank=True, null=True) sub_description_en = models.TextField(blank=True, null=True) sub_description_kr = models.TextField(blank=True, null=True) sub_description_fr = models.TextField(blank=True, null=True) sub_description_de = models.TextField(blank=True, null=True) sub_description_cn = models.TextField(blank=True, null=True) sub_description_tw = models.TextField(blank=True, null=True) sub_description_07 = models.TextField(blank=True, null=True) sub_description_08 = models.TextField(blank=True, null=True) kill_creature_1 = models.ForeignKey("Creature", db_index=True, blank=True, null=True) kill_creature_1_amount = models.IntegerField(blank=True, null=True) collect_item_1 = models.ForeignKey("Item", db_index=True, blank=True, null=True) collect_item_1_amount = models.IntegerField(blank=True, null=True) kill_creature_2 = models.ForeignKey("Creature", db_index=True, blank=True, null=True) kill_creature_2_amount = models.IntegerField(blank=True, null=True) collect_item_2 = models.ForeignKey("Item", db_index=True, blank=True, null=True) collect_item_2_amount = models.IntegerField(blank=True, null=True) kill_creature_3 = models.ForeignKey("Creature", db_index=True, blank=True, null=True) kill_creature_3_amount = models.IntegerField(blank=True, null=True) collect_item_3 = models.ForeignKey("Item", db_index=True, blank=True, null=True) collect_item_3_amount = models.IntegerField(blank=True, null=True) kill_creature_4 = models.ForeignKey("Creature", db_index=True, blank=True, null=True) kill_creature_4_amount = models.IntegerField(blank=True, null=True) collect_item_4 = models.ForeignKey("Item", db_index=True, blank=True, null=True) collect_item_4_amount = models.IntegerField(blank=True, null=True) objective_1_en = models.TextField(blank=True, null=True) objective_1_kr = models.TextField(blank=True, null=True) objective_1_fr = models.TextField(blank=True, null=True) objective_1_de = models.TextField(blank=True, null=True) objective_1_cn = models.TextField(blank=True, null=True) objective_1_tw = models.TextField(blank=True, null=True) objective_1_07 = models.TextField(blank=True, null=True) objective_1_08 = models.TextField(blank=True, null=True) objective_2_en = models.TextField(blank=True, null=True) objective_2_kr = models.TextField(blank=True, null=True) objective_2_fr = models.TextField(blank=True, null=True) objective_2_de = models.TextField(blank=True, null=True) objective_2_cn = models.TextField(blank=True, null=True) objective_2_tw = models.TextField(blank=True, null=True) objective_2_07 = models.TextField(blank=True, null=True) objective_2_08 = models.TextField(blank=True, null=True) objective_3_en = models.TextField(blank=True, null=True) objective_3_kr = models.TextField(blank=True, null=True) objective_3_fr = models.TextField(blank=True, null=True) objective_3_de = models.TextField(blank=True, null=True) objective_3_cn = models.TextField(blank=True, null=True) objective_3_tw = models.TextField(blank=True, null=True) objective_3_07 = models.TextField(blank=True, null=True) objective_3_08 = models.TextField(blank=True, null=True) objective_4_en = models.TextField(blank=True, null=True) objective_4_kr = models.TextField(blank=True, null=True) objective_4_fr = models.TextField(blank=True, null=True) objective_4_de = models.TextField(blank=True, null=True) objective_4_cn = models.TextField(blank=True, null=True) objective_4_tw = models.TextField(blank=True, null=True) objective_4_07 = models.TextField(blank=True, null=True) objective_4_08 = models.TextField(blank=True, null=True) version = models.ForeignKey("Version", db_index=True) hash = models.IntegerField(blank=True, null=True) user = models.ForeignKey("User", db_index=True, blank=True, null=True)class GameObjectDisplayInfo(models.Model): path = models.CharField(maxlength=255, blank=True, null=True) unknown1 = models.IntegerField(blank=True, null=True) unknown2 = models.IntegerField(blank=True, null=True) unknown3 = models.IntegerField(blank=True, null=True) unknown4 = models.IntegerField(blank=True, null=True) unknown5 = models.IntegerField(blank=True, null=True) unknown6 = models.IntegerField(blank=True, null=True) unknown7 = models.IntegerField(blank=True, null=True) unknown8 = models.IntegerField(blank=True, null=True) unknown9 = models.IntegerField(blank=True, null=True) unknown10 = models.IntegerField(blank=True, null=True) version = models.ForeignKey("Version", db_index=True) hash = models.CharField(maxlength=32)class GameObject(models.Model): unknown1 = models.IntegerField(blank=True, null=True) unknown2 = models.IntegerField(blank=True, null=True) unknown3 = models.IntegerField(blank=True, null=True) name_en = models.CharField(maxlength=255, blank=True, null=True) name_kr = models.CharField(maxlength=255, blank=True, null=True) name_fr = models.CharField(maxlength=255, blank=True, null=True) name_de = models.CharField(maxlength=255, blank=True, null=True) name_cn = models.CharField(maxlength=255, blank=True, null=True) name_tw = models.CharField(maxlength=255, blank=True, null=True) name_07 = models.CharField(maxlength=255, blank=True, null=True) name_08 = models.CharField(maxlength=255, blank=True, null=True) version = models.ForeignKey("Version", db_index=True) hash = models.IntegerField(blank=True, null=True) user = models.ForeignKey("User", db_index=True, blank=True, null=True)class ChrClass(models.Model): unknown1 = models.IntegerField(blank=True, null=True) unknown2 = models.IntegerField(blank=True, null=True) unknown3 = models.IntegerField(blank=True, null=True) unknown4 = models.IntegerField(blank=True, null=True) name_en = models.CharField(maxlength=255, blank=True, null=True) name_kr = models.CharField(maxlength=255, blank=True, null=True) name_fr = models.CharField(maxlength=255, blank=True, null=True) name_de = models.CharField(maxlength=255, blank=True, null=True) name_cn = models.CharField(maxlength=255, blank=True, null=True) name_tw = models.CharField(maxlength=255, blank=True, null=True) name_07 = models.CharField(maxlength=255, blank=True, null=True) name_08 = models.CharField(maxlength=255, blank=True, null=True) name_flags = models.IntegerField(blank=True, null=True) constant_name = models.CharField(maxlength=255, blank=True, null=True) id2 = models.IntegerField(blank=True, null=True) unknown7 = models.IntegerField(blank=True, null=True) version = models.ForeignKey("Version", db_index=True) hash = models.CharField(maxlength=32)class ChrRace(models.Model): unknown1 = models.IntegerField(blank=True, null=True) order = models.IntegerField(blank=True, null=True) unknown2 = models.IntegerField(blank=True, null=True) male_model = models.ForeignKey("CreatureModelData", db_index=True, blank=True, null=True) female_model = models.ForeignKey("CreatureModelData", db_index=True, blank=True, null=True) constant_name = models.CharField(maxlength=135) unknown3 = models.FloatField(null=True, max_digits=12, decimal_places=31, blank=True) faction = models.PositiveSmallIntegerField(db_index=True) unknown4 = models.IntegerField(blank=True, null=True) unknown5 = models.IntegerField(blank=True, null=True) unknown6 = models.IntegerField(blank=True, null=True) unknown7 = models.IntegerField(blank=True, null=True) unknown8 = models.IntegerField(blank=True, null=True) starting_area = models.ForeignKey("AreaTable", db_index=True, blank=True, null=True) name_en = models.CharField(maxlength=255, blank=True, null=True) name_kr = models.CharField(maxlength=255, blank=True, null=True) name_fr = models.CharField(maxlength=255, blank=True, null=True) name_de = models.CharField(maxlength=255, blank=True, null=True) name_cn = models.CharField(maxlength=255, blank=True, null=True) name_tw = models.CharField(maxlength=255, blank=True, null=True) name_07 = models.CharField(maxlength=255, blank=True, null=True) name_08 = models.CharField(maxlength=255, blank=True, null=True) name_flags = models.IntegerField(blank=True, null=True) unknown9 = models.CharField(maxlength=255, blank=True, null=True) unknown10 = models.IntegerField(blank=True, null=True) features1 = models.CharField(maxlength=255, blank=True, null=True) features2 = models.CharField(maxlength=255, blank=True, null=True) features3 = models.CharField(maxlength=255, blank=True, null=True) version = models.IntegerField(blank=True, null=True) hash = models.CharField(maxlength=32)class FactionGroup(models.Model): unknown1 = models.IntegerField(blank=True, null=True) constant_name = models.CharField(maxlength=255, blank=True, null=True) name_en = models.CharField(maxlength=255, blank=True, null=True) name_kr = models.CharField(maxlength=255, blank=True, null=True) name_fr = models.CharField(maxlength=255, blank=True, null=True) name_de = models.CharField(maxlength=255, blank=True, null=True) name_cn = models.CharField(maxlength=255, blank=True, null=True) name_tw = models.CharField(maxlength=255, blank=True, null=True) name_07 = models.CharField(maxlength=255, blank=True, null=True) name_08 = models.CharField(maxlength=255, blank=True, null=True) name_flags = models.IntegerField(blank=True, null=True) version = models.ForeignKey("Version", db_index=True) hash = models.IntegerField(blank=True, null=True)class Faction(models.Model): unknown1 = models.IntegerField(blank=True, null=True) unknown2 = models.IntegerField(blank=True, null=True) faction_type = models.IntegerField(blank=True, null=True) unknown4 = models.IntegerField(blank=True, null=True) unknown5 = models.IntegerField(blank=True, null=True) unknown6 = models.IntegerField(blank=True, null=True) unknown7 = models.IntegerField(blank=True, null=True) unknown8 = models.IntegerField(blank=True, null=True) unknown9 = models.IntegerField(blank=True, null=True) unknown10 = models.IntegerField(blank=True, null=True) unknown11 = models.IntegerField(blank=True, null=True) unknown12 = models.IntegerField(blank=True, null=True) unknown13 = models.IntegerField(blank=True, null=True) unknown14 = models.IntegerField(blank=True, null=True) unknown15 = models.IntegerField(blank=True, null=True) unknown16 = models.IntegerField(blank=True, null=True) unknown17 = models.IntegerField(blank=True, null=True) parent = models.ForeignKey("self", db_index=True, blank=True, null=True) name_en = models.CharField(maxlength=255, blank=True, null=True) name_kr = models.CharField(maxlength=255, blank=True, null=True) name_fr = models.CharField(maxlength=255, blank=True, null=True) name_de = models.CharField(maxlength=255, blank=True, null=True) name_cn = models.CharField(maxlength=255, blank=True, null=True) name_tw = models.CharField(maxlength=255, blank=True, null=True) name_07 = models.CharField(maxlength=255, blank=True, null=True) name_08 = models.CharField(maxlength=255, blank=True, null=True) name_flags = models.IntegerField(blank=True, null=True) lore_en = models.CharField(maxlength=255, blank=True, null=True) lore_kr = models.CharField(maxlength=255, blank=True, null=True) lore_fr = models.CharField(maxlength=255, blank=True, null=True) lore_de = models.CharField(maxlength=255, blank=True, null=True) lore_cn = models.CharField(maxlength=255, blank=True, null=True) lore_tw = models.CharField(maxlength=255, blank=True, null=True) lore_07 = models.CharField(maxlength=255, blank=True, null=True) lore_08 = models.CharField(maxlength=255, blank=True, null=True) lore_flags = models.IntegerField(blank=True, null=True) version = models.ForeignKey("Version", db_index=True) hash = models.CharField(maxlength=32)class GameTip(models.Model): text_en = models.CharField(maxlength=255, blank=True, null=True) text_kr = models.CharField(maxlength=255, blank=True, null=True) text_fr = models.CharField(maxlength=255, blank=True, null=True) text_de = models.CharField(maxlength=255, blank=True, null=True) text_cn = models.CharField(maxlength=255, blank=True, null=True) text_tw = models.CharField(maxlength=255, blank=True, null=True) text_07 = models.CharField(maxlength=255, blank=True, null=True) text_08 = models.CharField(maxlength=255, blank=True, null=True) text_flags = models.IntegerField(blank=True, null=True) version = models.ForeignKey("Version", db_index=True) hash = models.CharField(maxlength=32)class Resistance(models.Model): unknown1 = models.IntegerField(blank=True, null=True) unknown2 = models.IntegerField(blank=True, null=True) name_en = models.CharField(maxlength=255, blank=True, null=True) name_kr = models.CharField(maxlength=255, blank=True, null=True) name_fr = models.CharField(maxlength=255, blank=True, null=True) name_de = models.CharField(maxlength=255, blank=True, null=True) name_cn = models.CharField(maxlength=255, blank=True, null=True) name_tw = models.CharField(maxlength=255, blank=True, null=True) name_07 = models.CharField(maxlength=255, blank=True, null=True) name_08 = models.CharField(maxlength=255, blank=True, null=True) name_flags = models.IntegerField(blank=True, null=True) version = models.ForeignKey("Version", db_index=True) hash = models.IntegerField(blank=True, null=True)class Language(models.Model): name_en = models.CharField(maxlength=255, blank=True, null=True) name_kr = models.CharField(maxlength=255, blank=True, null=True) name_fr = models.CharField(maxlength=255, blank=True, null=True) name_de = models.CharField(maxlength=255, blank=True, null=True) name_cn = models.CharField(maxlength=255, blank=True, null=True) name_tw = models.CharField(maxlength=255, blank=True, null=True) name_07 = models.CharField(maxlength=255, blank=True, null=True) name_08 = models.CharField(maxlength=255, blank=True, null=True) name_flags = models.IntegerField(blank=True, null=True) version = models.ForeignKey("Version", db_index=True) hash = models.IntegerField(blank=True, null=True)class LanguageWord(models.Model): language = models.ForeignKey(Language, db_index=True, blank=True, null=True) text_en = models.CharField(maxlength=255, blank=True, null=True) text_kr = models.CharField(maxlength=255, blank=True, null=True) text_fr = models.CharField(maxlength=255, blank=True, null=True) text_de = models.CharField(maxlength=255, blank=True, null=True) text_cn = models.CharField(maxlength=255, blank=True, null=True) text_tw = models.CharField(maxlength=255, blank=True, null=True) text_07 = models.CharField(maxlength=255, blank=True, null=True) text_08 = models.CharField(maxlength=255, blank=True, null=True) text_flags = models.IntegerField(blank=True, null=True) version = models.ForeignKey("Version", db_index=True) hash = models.IntegerField(blank=True, null=True)class LiquidType(models.Model): constant_name = models.CharField(maxlength=255, blank=True, null=True) unknown1 = models.IntegerField(blank=True, null=True) spell = models.ForeignKey("Spell", db_index=True, blank=True, null=True) version = models.ForeignKey("Version", db_index=True) hash = models.IntegerField(blank=True, null=True)class AnimationData(models.Model): constant_name = models.CharField(maxlength=255, blank=True, null=True) unknown1 = models.IntegerField(blank=True, null=True) unknown2 = models.IntegerField(blank=True, null=True) unknown3 = models.IntegerField(blank=True, null=True) unknown4 = models.IntegerField(blank=True, null=True) parent = models.ForeignKey("self", db_index=True, blank=True, null=True) version = models.ForeignKey("Version", db_index=True) hash = models.CharField(maxlength=32)class Emote(models.Model): constant_name = models.CharField(maxlength=255, blank=True, null=True) animation = models.ForeignKey(AnimationData, db_index=True, blank=True, null=True) unknown1 = models.IntegerField(blank=True, null=True) unknown2 = models.IntegerField(blank=True, null=True) unknown3 = models.IntegerField(blank=True, null=True) unknown4 = models.IntegerField(blank=True, null=True) version = models.ForeignKey("Version", db_index=True) hash = models.CharField(maxlength=32)class EmotesText(models.Model): name = models.CharField(maxlength=255, blank=True, null=True) emote = models.ForeignKey(Emote, db_index=True, blank=True, null=True) data_1 = models.ForeignKey("EmotesTextData", db_index=True, blank=True, null=True) data_2 = models.ForeignKey("EmotesTextData", db_index=True, blank=True, null=True) data_3 = models.ForeignKey("EmotesTextData", db_index=True, blank=True, null=True) unknown5 = models.IntegerField(blank=True, null=True) data_4 = models.ForeignKey("EmotesTextData", db_index=True, blank=True, null=True) unknown7 = models.IntegerField(blank=True, null=True) data_5 = models.ForeignKey("EmotesTextData", db_index=True, blank=True, null=True) unknown9 = models.IntegerField(blank=True, null=True) data_6 = models.ForeignKey("EmotesTextData", db_index=True, blank=True, null=True) data_7 = models.ForeignKey("EmotesTextData", db_index=True, blank=True, null=True) unknown12 = models.IntegerField(blank=True, null=True) unknown13 = models.IntegerField(blank=True, null=True) data_8 = models.ForeignKey("EmotesTextData", db_index=True, blank=True, null=True) unknown15 = models.IntegerField(blank=True, null=True) unknown16 = models.IntegerField(blank=True, null=True) unknown17 = models.IntegerField(blank=True, null=True) version = models.ForeignKey("Version", db_index=True) hash = models.CharField(maxlength=32)class EmotesTextData(models.Model): text_en = models.CharField(maxlength=255, blank=True, null=True) text_kr = models.CharField(maxlength=255, blank=True, null=True) text_fr = models.CharField(maxlength=255, blank=True, null=True) text_de = models.CharField(maxlength=255, blank=True, null=True) text_cn = models.CharField(maxlength=255, blank=True, null=True) text_tw = models.CharField(maxlength=255, blank=True, null=True) text_07 = models.CharField(maxlength=255, blank=True, null=True) text_08 = models.CharField(maxlength=255, blank=True, null=True) text_flags = models.IntegerField(blank=True, null=True) version = models.ForeignKey("Version", db_index=True) hash = models.CharField(maxlength=32)class EmotesTextSound(models.Model): text = models.ForeignKey(EmotesText, db_index=True, blank=True, null=True) race = models.ForeignKey("ChrRace", db_index=True, blank=True, null=True) gender = models.IntegerField(blank=True, null=True) sound = models.ForeignKey(SoundEntry, db_index=True, blank=True, null=True) version = models.ForeignKey("Version", db_index=True) hash = models.CharField(maxlength=32)class LoadingScreen(models.Model): constant_name = models.CharField(maxlength=255, blank=True, null=True) path = models.CharField(maxlength=255, blank=True, null=True) version = models.ForeignKey("Version", db_index=True) hash = models.IntegerField(blank=True, null=True)class Map(models.Model): constant_name = models.CharField(maxlength=255, blank=True, null=True) map_type = models.IntegerField(blank=True, null=True) unknown2 = models.IntegerField(blank=True, null=True) name_en = models.CharField(maxlength=255, blank=True, null=True) name_kr = models.CharField(maxlength=255, blank=True, null=True) name_fr = models.CharField(maxlength=255, blank=True, null=True) name_de = models.CharField(maxlength=255, blank=True, null=True) name_cn = models.CharField(maxlength=255, blank=True, null=True) name_tw = models.CharField(maxlength=255, blank=True, null=True) name_07 = models.CharField(maxlength=255, blank=True, null=True) name_08 = models.CharField(maxlength=255, blank=True, null=True) name_flags = models.IntegerField(blank=True, null=True) level_min = models.IntegerField(blank=True, null=True) level_max = models.IntegerField(blank=True, null=True) player_limit = models.IntegerField(blank=True, null=True) unknown6 = models.IntegerField(blank=True, null=True) unknown7 = models.FloatField(blank=True, null=True) unknown8 = models.FloatField(blank=True, null=True) unknown9 = models.IntegerField(blank=True, null=True) alliance_description_en = models.CharField(maxlength=255, blank=True, null=True) alliance_description_kr = models.CharField(maxlength=255, blank=True, null=True) alliance_description_fr = models.CharField(maxlength=255, blank=True, null=True) alliance_description_de = models.CharField(maxlength=255, blank=True, null=True) alliance_description_cn = models.CharField(maxlength=255, blank=True, null=True) alliance_description_tw = models.CharField(maxlength=255, blank=True, null=True) alliance_description_07 = models.CharField(maxlength=255, blank=True, null=True) alliance_description_08 = models.CharField(maxlength=255, blank=True, null=True) alliance_description_flags = models.IntegerField(blank=True, null=True) horde_description_en = models.CharField(maxlength=255, blank=True, null=True) horde_description_kr = models.CharField(maxlength=255, blank=True, null=True) horde_description_fr = models.CharField(maxlength=255, blank=True, null=True) horde_description_de = models.CharField(maxlength=255, blank=True, null=True) horde_description_cn = models.CharField(maxlength=255, blank=True, null=True) horde_description_tw = models.CharField(maxlength=255, blank=True, null=True) horde_description_07 = models.CharField(maxlength=255, blank=True, null=True) horde_description_08 = models.CharField(maxlength=255, blank=True, null=True) horde_description_flags = models.IntegerField(blank=True, null=True) loading_screen = models.ForeignKey("LoadingScreen", db_index=True, blank=True, null=True) unknown11 = models.IntegerField(blank=True, null=True) unknown12 = models.IntegerField(blank=True, null=True) unknown13 = models.FloatField(max_digits=12, decimal_places=31) version = models.ForeignKey("Version", db_index=True) hash = models.IntegerField(blank=True, null=True)class AreaTable(models.Model): area_map = models.ForeignKey(Map, db_index=True) parent = models.ForeignKey("self", blank=True, null=True, db_index=True) unknown1 = models.IntegerField(blank=True, null=True) unknown2 = models.IntegerField(blank=True, null=True) unknown3 = models.IntegerField(blank=True, null=True) unknown4 = models.IntegerField(blank=True, null=True) ambience = models.ForeignKey("SoundAmbience", db_index=True, blank=True, null=True) music = models.ForeignKey("ZoneMusic", db_index=True, blank=True, null=True) intro_music = models.ForeignKey("ZoneIntroMusicTable", db_index=True, blank=True, null=True) level = models.IntegerField(blank=True, null=True) name_en = models.CharField(maxlength=255, blank=True, null=True) name_kr = models.CharField(maxlength=255, blank=True, null=True) name_fr = models.CharField(maxlength=255, blank=True, null=True) name_de = models.CharField(maxlength=255, blank=True, null=True) name_cn = models.CharField(maxlength=255, blank=True, null=True) name_tw = models.CharField(maxlength=255, blank=True, null=True) name_07 = models.CharField(maxlength=255, blank=True, null=True) name_08 = models.CharField(maxlength=255, blank=True, null=True) name_flags = models.IntegerField(blank=True, null=True) faction = models.ForeignKey("FactionGroup", db_index=True, blank=True, null=True) unknown5 = models.IntegerField(blank=True, null=True) unknown6 = models.IntegerField(blank=True, null=True) unknown7 = models.IntegerField(blank=True, null=True) unknown8 = models.IntegerField(blank=True, null=True) version = models.ForeignKey("Version", db_index=True) hash = models.CharField(maxlength=32)class WMOAreaTable(models.Model): unknown1 = models.IntegerField(blank=True, null=True) unknown2 = models.IntegerField(blank=True, null=True) unknown3 = models.IntegerField(blank=True, null=True) unknown4 = models.IntegerField(blank=True, null=True) parent_area = models.ForeignKey("AreaTable", db_index=True, blank=True, null=True) unknown5 = models.IntegerField(blank=True, null=True) zone_music = models.ForeignKey(ZoneIntroMusicTable, db_index=True, blank=True, null=True) unknown7 = models.IntegerField(blank=True, null=True) unknown8 = models.IntegerField(blank=True, null=True) area = models.ForeignKey("AreaTable", db_index=True, blank=True, null=True) name_en = models.CharField(maxlength=255, blank=True, null=True) name_kr = models.CharField(maxlength=255, blank=True, null=True) name_fr = models.CharField(maxlength=255, blank=True, null=True) name_de = models.CharField(maxlength=255, blank=True, null=True) name_cn = models.CharField(maxlength=255, blank=True, null=True) name_tw = models.CharField(maxlength=255, blank=True, null=True) name_07 = models.CharField(maxlength=255, blank=True, null=True) name_08 = models.CharField(maxlength=255, blank=True, null=True) name_flags = models.IntegerField(blank=True, null=True) version = models.ForeignKey("Version", db_index=True) hash = models.CharField(maxlength=69)class HelmetGeosetVisData(models.Model): unknown1 = models.IntegerField(blank=True, null=True) unknown2 = models.IntegerField(blank=True, null=True) unknown3 = models.IntegerField(blank=True, null=True) unknown4 = models.IntegerField(blank=True, null=True) unknown5 = models.IntegerField(blank=True, null=True) version = models.ForeignKey("Version", db_index=True) hash = models.CharField(maxlength=32)class ItemVisual(models.Model): unknown1 = models.IntegerField(blank=True, null=True) unknown2 = models.IntegerField(blank=True, null=True) unknown3 = models.IntegerField(blank=True, null=True) unknown4 = models.IntegerField(blank=True, null=True) unknown5 = models.IntegerField(blank=True, null=True) unknown6 = models.IntegerField(blank=True, null=True) version = models.ForeignKey("Version", db_index=True) hash = models.CharField(maxlength=32)class ItemVisualEffect(models.Model): path = models.CharField(maxlength=255, blank=True, null=True) version = models.ForeignKey("Version", db_index=True) hash = models.CharField(maxlength=32)class ItemBagFamily(models.Model): name_en = models.CharField(maxlength=255, blank=True, null=True) name_kr = models.CharField(maxlength=255, blank=True, null=True) name_fr = models.CharField(maxlength=255, blank=True, null=True) name_de = models.CharField(maxlength=255, blank=True, null=True) name_cn = models.CharField(maxlength=255, blank=True, null=True) name_tw = models.CharField(maxlength=255, blank=True, null=True) name_07 = models.CharField(maxlength=255, blank=True, null=True) name_08 = models.CharField(maxlength=255, blank=True, null=True) name_flags = models.IntegerField(blank=True, null=True) version = models.ForeignKey("Version", db_index=True) hash = models.CharField(maxlength=32)class ItemClass(models.Model): unknown1 = models.IntegerField(blank=True, null=True) unknown2 = models.IntegerField(blank=True, null=True) name_en = models.CharField(maxlength=255, blank=True, null=True) name_kr = models.CharField(maxlength=255, blank=True, null=True) name_fr = models.CharField(maxlength=255, blank=True, null=True) name_de = models.CharField(maxlength=255, blank=True, null=True) name_cn = models.CharField(maxlength=255, blank=True, null=True) name_tw = models.CharField(maxlength=255, blank=True, null=True) name_07 = models.CharField(maxlength=255, blank=True, null=True) name_08 = models.CharField(maxlength=255, blank=True, null=True) name_flags = models.IntegerField(blank=True, null=True) version = models.ForeignKey("Version", db_index=True) hash = models.CharField(maxlength=32)class ItemDisplayInfo(models.Model): model_left = models.CharField(maxlength=255, blank=True, null=True) model_right = models.CharField(maxlength=255, blank=True, null=True) texture_left = models.CharField(maxlength=255, blank=True, null=True) texture_right = models.CharField(maxlength=255, blank=True, null=True) icon = models.CharField(maxlength=255, blank=True, null=True) unknown1 = models.IntegerField(blank=True, null=True) unknown2 = models.IntegerField(blank=True, null=True) unknown3 = models.IntegerField(blank=True, null=True) unknown4 = models.IntegerField(blank=True, null=True) unknown5 = models.IntegerField(blank=True, null=True) group_sounds = models.ForeignKey(ItemGroupSound, db_index=True, blank=True, null=True) vis_data_1 = models.ForeignKey(HelmetGeosetVisData, db_index=True, blank=True, null=True) vis_data_2 = models.ForeignKey(HelmetGeosetVisData, db_index=True, blank=True, null=True) texture_arm_upper = models.CharField(maxlength=255, blank=True, null=True) texture_arm_lower = models.CharField(maxlength=255, blank=True, null=True) texture_hand = models.CharField(maxlength=255, blank=True, null=True) texture_torso_upper = models.CharField(maxlength=255, blank=True, null=True) texture_torso_lower = models.CharField(maxlength=255, blank=True, null=True) texture_leg_upper = models.CharField(maxlength=255, blank=True, null=True) texture_leg_lower = models.CharField(maxlength=255, blank=True, null=True) texture_foot = models.CharField(maxlength=255, blank=True, null=True) visual = models.ForeignKey(ItemVisual, db_index=True, blank=True, null=True) version = models.ForeignKey("Version", db_index=True) hash = models.CharField(maxlength=32)class ItemPetFood(models.Model): name_en = models.CharField(maxlength=255, blank=True, null=True) name_kr = models.CharField(maxlength=255, blank=True, null=True) name_fr = models.CharField(maxlength=255, blank=True, null=True) name_de = models.CharField(maxlength=255, blank=True, null=True) name_cn = models.CharField(maxlength=255, blank=True, null=True) name_tw = models.CharField(maxlength=255, blank=True, null=True) name_07 = models.CharField(maxlength=255, blank=True, null=True) name_08 = models.CharField(maxlength=255, blank=True, null=True) name_flags = models.IntegerField(blank=True, null=True) version = models.ForeignKey("Version", db_index=True) hash = models.CharField(maxlength=32)class ItemRandomProperty(models.Model): unknown1 = models.CharField(maxlength=135) enchant_1 = models.ForeignKey(SpellItemEnchantment, db_index=True, blank=True, null=True) enchant_2 = models.ForeignKey(SpellItemEnchantment, db_index=True, blank=True, null=True) enchant_3 = models.ForeignKey(SpellItemEnchantment, db_index=True, blank=True, null=True) enchant_4 = models.ForeignKey(SpellItemEnchantment, db_index=True, blank=True, null=True) enchant_5 = models.ForeignKey(SpellItemEnchantment, db_index=True, blank=True, null=True) name_en = models.CharField(maxlength=255, blank=True, null=True) name_kr = models.CharField(maxlength=255, blank=True, null=True) name_fr = models.CharField(maxlength=255, blank=True, null=True) name_de = models.CharField(maxlength=255, blank=True, null=True) name_cn = models.CharField(maxlength=255, blank=True, null=True) name_tw = models.CharField(maxlength=255, blank=True, null=True) name_07 = models.CharField(maxlength=255, blank=True, null=True) name_08 = models.CharField(maxlength=255, blank=True, null=True) name_flags = models.IntegerField(blank=True, null=True) version = models.ForeignKey("Version", db_index=True) hash = models.CharField(maxlength=32)class Item(models.Model): item_class = models.ForeignKey("ItemClass", db_index=True, blank=True, null=True) item_sub_class = models.ForeignKey("ItemSubClass", db_index=True, blank=True, null=True) name_en = models.CharField(maxlength=255, blank=True, null=True) name_kr = models.CharField(maxlength=255, blank=True, null=True) name_fr = models.CharField(maxlength=255, blank=True, null=True) name_de = models.CharField(maxlength=255, blank=True, null=True) name_cn = models.CharField(maxlength=255, blank=True, null=True) name_tw = models.CharField(maxlength=255, blank=True, null=True) name_07 = models.CharField(maxlength=255, blank=True, null=True) name_08 = models.CharField(maxlength=255, blank=True, null=True) display = models.ForeignKey("ItemDisplayInfo", db_index=True, blank=True, null=True) quality = models.PositiveSmallIntegerField(db_index=True, blank=True, null=True) item_type = models.PositiveSmallIntegerField(db_index=True, blank=True, null=True) buy_price = models.IntegerField(blank=True, null=True) sell_price = models.IntegerField(blank=True, null=True) slot = models.PositiveSmallIntegerField(db_index=True, blank=True, null=True) required_class = models.IntegerField(blank=True, null=True) required_race = models.IntegerField(blank=True, null=True) level = models.IntegerField(blank=True, null=True) required_level = models.IntegerField(blank=True, null=True) required_skill = models.ForeignKey("SkillLine", db_index=True, blank=True, null=True) required_skill_level = models.IntegerField(blank=True, null=True) required_spell = models.ForeignKey("Spell", db_index=True, blank=True, null=True) required_rank = models.IntegerField(db_index=True, blank=True, null=True) unknown1 = models.IntegerField(blank=True, null=True) required_faction = models.ForeignKey("Faction", db_index=True, blank=True, null=True) required_faction_level = models.IntegerField(blank=True, null=True) stack_unique = models.IntegerField(blank=True, null=True) stack_normal = models.IntegerField(blank=True, null=True) container_slots = models.IntegerField(blank=True, null=True) stat_1 = models.PositiveSmallIntegerField(db_index=True, blank=True, null=True) stat_1_value = models.IntegerField(blank=True, null=True) stat_2 = models.PositiveSmallIntegerField(db_index=True, blank=True, null=True) stat_2_value = models.IntegerField(blank=True, null=True) stat_3 = models.PositiveSmallIntegerField(db_index=True, blank=True, null=True) stat_3_value = models.IntegerField(blank=True, null=True) stat_4 = models.PositiveSmallIntegerField(db_index=True, blank=True, null=True) stat_4_value = models.IntegerField(blank=True, null=True) stat_5 = models.PositiveSmallIntegerField(db_index=True, blank=True, null=True) stat_5_value = models.IntegerField(blank=True, null=True) stat_6 = models.PositiveSmallIntegerField(db_index=True, blank=True, null=True) stat_6_value = models.IntegerField(blank=True, null=True) stat_7 = models.PositiveSmallIntegerField(db_index=True, blank=True, null=True) stat_7_value = models.IntegerField(blank=True, null=True) stat_8 = models.PositiveSmallIntegerField(db_index=True, blank=True, null=True) stat_8_value = models.IntegerField(blank=True, null=True) stat_9 = models.PositiveSmallIntegerField(db_index=True, blank=True, null=True) stat_9_value = models.IntegerField(blank=True, null=True) stat_10 = models.PositiveSmallIntegerField(db_index=True, blank=True, null=True) stat_10_value = models.IntegerField(blank=True, null=True) damage_1_min = models.FloatField() damage_1_max = models.FloatField() damage_1_type = models.PositiveSmallIntegerField(db_index=True, blank=True, null=True) damage_2_min = models.FloatField() damage_2_max = models.FloatField() damage_2_type = models.PositiveSmallIntegerField(db_index=True, blank=True, null=True) damage_3_min = models.FloatField() damage_3_max = models.FloatField() damage_3_type = models.PositiveSmallIntegerField(db_index=True, blank=True, null=True) damage_4_min = models.FloatField() damage_4_max = models.FloatField() damage_4_type = models.PositiveSmallIntegerField(db_index=True, blank=True, null=True) damage_5_min = models.FloatField() damage_5_max = models.FloatField() damage_5_type = models.PositiveSmallIntegerField(db_index=True, blank=True, null=True) resist_0 = models.IntegerField(blank=True, null=True) resist_1 = models.IntegerField(blank=True, null=True) resist_2 = models.IntegerField(blank=True, null=True) resist_3 = models.IntegerField(blank=True, null=True) resist_4 = models.IntegerField(blank=True, null=True) resist_5 = models.IntegerField(blank=True, null=True) resist_6 = models.IntegerField(blank=True, null=True) weapon_speed = models.IntegerField(blank=True, null=True) ammo_type = models.PositiveSmallIntegerField(db_index=True, blank=True, null=True) range_odifier = models.FloatField(max_digits=12, decimal_places=31) spell_1 = models.ForeignKey("Spell", db_index=True, blank=True, null=True) spell_1_trigger = models.ForeignKey("Spell", db_index=True, blank=True, null=True) spell_1_charges = models.IntegerField(blank=True, null=True) spell_1_cooldown = models.IntegerField(blank=True, null=True) spell_1_category = models.ForeignKey("SpellCategory", db_index=True, blank=True, null=True) spell_1_category_cooldown = models.IntegerField(blank=True, null=True) spell_2 = models.ForeignKey("Spell", db_index=True, blank=True, null=True) spell_2_trigger = models.ForeignKey("Spell", db_index=True, blank=True, null=True) spell_2_charges = models.IntegerField(blank=True, null=True) spell_2_cooldown = models.IntegerField(blank=True, null=True) spell_2_category = models.ForeignKey("SpellCategory", db_index=True, blank=True, null=True) spell_2_category_cooldown = models.IntegerField(blank=True, null=True) spell_3 = models.ForeignKey("Spell", db_index=True, blank=True, null=True) spell_3_trigger = models.ForeignKey("Spell", db_index=True, blank=True, null=True) spell_3_charges = models.IntegerField(blank=True, null=True) spell_3_cooldown = models.IntegerField(blank=True, null=True) spell_3_category = models.ForeignKey("SpellCategory", db_index=True, blank=True, null=True) spell_3_category_cooldown = models.IntegerField(blank=True, null=True) spell_4 = models.ForeignKey("Spell", db_index=True, blank=True, null=True) spell_4_trigger = models.ForeignKey("Spell", db_index=True, blank=True, null=True) spell_4_charges = models.IntegerField(blank=True, null=True) spell_4_cooldown = models.IntegerField(blank=True, null=True) spell_4_category = models.ForeignKey("SpellCategory", db_index=True, blank=True, null=True) spell_4_category_cooldown = models.IntegerField(blank=True, null=True) spell_5 = models.ForeignKey("Spell", db_index=True, blank=True, null=True) spell_5_trigger = models.ForeignKey("Spell", db_index=True, blank=True, null=True) spell_5_charges = models.IntegerField(blank=True, null=True) spell_5_cooldown = models.IntegerField(blank=True, null=True) spell_5_category = models.ForeignKey("SpellCategory", db_index=True, blank=True, null=True) spell_5_category_cooldown = models.IntegerField(blank=True, null=True) bond = models.PositiveSmallIntegerField(db_index=True, blank=True, null=True) description_en = models.CharField(maxlength=255, blank=True, null=True) description_kr = models.CharField(maxlength=255, blank=True, null=True) description_fr = models.CharField(maxlength=255, blank=True, null=True) description_de = models.CharField(maxlength=255, blank=True, null=True) description_cn = models.CharField(maxlength=255, blank=True, null=True) description_tw = models.CharField(maxlength=255, blank=True, null=True) description_07 = models.CharField(maxlength=255, blank=True, null=True) description_08 = models.CharField(maxlength=255, blank=True, null=True) book_text = models.ForeignKey("PageText", db_index=True, blank=True, null=True) book_pages = models.IntegerField(blank=True, null=True) book_stationary = models.IntegerField(blank=True, null=True) begin_quest = models.ForeignKey("Quest", db_index=True, blank=True, null=True) required_lockpick_level = models.IntegerField(blank=True, null=True) material = models.ForeignKey("Material", db_index=True, blank=True, null=True) sheath = models.PositiveSmallIntegerField(db_index=True, blank=True, null=True) random_property = models.IntegerField(blank=True, null=True) block = models.IntegerField(blank=True, null=True) itemset = models.ForeignKey("ItemSet", db_index=True, blank=True, null=True) durability = models.IntegerField(blank=True, null=True) area = models.ForeignKey("AreaTable", db_index=True, blank=True, null=True) area_map = models.ForeignKey("Map", db_index=True, blank=True, null=True) bag_family = models.ForeignKey("ItemBagFamily", db_index=True, blank=True, null=True) version = models.ForeignKey("Version", db_index=True) hash = models.CharField(maxlength=32) user = models.ForeignKey("User", db_index=True, blank=True, null=True)class ItemSet(models.Model): name_en = models.CharField(maxlength=255, blank=True, null=True) name_kr = models.CharField(maxlength=255, blank=True, null=True) name_fr = models.CharField(maxlength=255, blank=True, null=True) name_de = models.CharField(maxlength=255, blank=True, null=True) name_cn = models.CharField(maxlength=255, blank=True, null=True) name_tw = models.CharField(maxlength=255, blank=True, null=True) name_07 = models.CharField(maxlength=255, blank=True, null=True) name_08 = models.CharField(maxlength=255, blank=True, null=True) name_flags = models.IntegerField(blank=True, null=True) item_1 = models.ForeignKey("Item", db_index=True, blank=True, null=True) item_2 = models.ForeignKey("Item", db_index=True, blank=True, null=True) item_3 = models.ForeignKey("Item", db_index=True, blank=True, null=True) item_4 = models.ForeignKey("Item", db_index=True, blank=True, null=True) item_5 = models.ForeignKey("Item", db_index=True, blank=True, null=True) item_6 = models.ForeignKey("Item", db_index=True, blank=True, null=True) item_7 = models.ForeignKey("Item", db_index=True, blank=True, null=True) item_8 = models.ForeignKey("Item", db_index=True, blank=True, null=True) item_9 = models.ForeignKey("Item", db_index=True, blank=True, null=True) item_10 = models.ForeignKey("Item", db_index=True, blank=True, null=True) unknown3 = models.IntegerField(blank=True, null=True) unknown4 = models.IntegerField(blank=True, null=True) unknown5 = models.IntegerField(blank=True, null=True) unknown6 = models.IntegerField(blank=True, null=True) unknown7 = models.IntegerField(blank=True, null=True) unknown8 = models.IntegerField(blank=True, null=True) unknown9 = models.IntegerField(blank=True, null=True) spell_1 = models.ForeignKey("Spell", db_index=True, blank=True, null=True) spell_2 = models.ForeignKey("Spell", db_index=True, blank=True, null=True) spell_3 = models.ForeignKey("Spell", db_index=True, blank=True, null=True) spell_4 = models.ForeignKey("Spell", db_index=True, blank=True, null=True) spell_5 = models.ForeignKey("Spell", db_index=True, blank=True, null=True) spell_6 = models.ForeignKey("Spell", db_index=True, blank=True, null=True) spell_7 = models.ForeignKey("Spell", db_index=True, blank=True, null=True) spell_8 = models.ForeignKey("Spell", db_index=True, blank=True, null=True) bonus_1 = models.PositiveSmallIntegerField(blank=True, null=True) bonus_2 = models.PositiveSmallIntegerField(blank=True, null=True) bonus_3 = models.PositiveSmallIntegerField(blank=True, null=True) bonus_4 = models.PositiveSmallIntegerField(blank=True, null=True) bonus_5 = models.PositiveSmallIntegerField(blank=True, null=True) bonus_6 = models.PositiveSmallIntegerField(blank=True, null=True) bonus_7 = models.PositiveSmallIntegerField(blank=True, null=True) bonus_8 = models.PositiveSmallIntegerField(blank=True, null=True) required_skill_line = models.ForeignKey("SkillLine", db_index=True, blank=True, null=True) required_skill_level = models.IntegerField(blank=True, null=True) version = models.ForeignKey("Version", db_index=True) hash = models.CharField(maxlength=32)class ItemSubClass(models.Model): item_class = models.ForeignKey("ItemClass", db_index=True, blank=True, null=True, primary_key=True) item_sub_class = models.IntegerField(blank=True, null=True, primary_key=True) unknown1 = models.IntegerField(blank=True, null=True) unknown2 = models.IntegerField(blank=True, null=True) unknown3 = models.IntegerField(blank=True, null=True) unknown4 = models.IntegerField(blank=True, null=True) unknown5 = models.IntegerField(blank=True, null=True) unknown6 = models.IntegerField(blank=True, null=True) unknown7 = models.IntegerField(blank=True, null=True) hands = models.PositiveSmallIntegerField(blank=True, null=True) name_en = models.CharField(maxlength=255, blank=True, null=True) name_kr = models.CharField(maxlength=255, blank=True, null=True) name_fr = models.CharField(maxlength=255, blank=True, null=True) name_de = models.CharField(maxlength=255, blank=True, null=True) name_cn = models.CharField(maxlength=255, blank=True, null=True) name_tw = models.CharField(maxlength=255, blank=True, null=True) name_07 = models.CharField(maxlength=255, blank=True, null=True) name_08 = models.CharField(maxlength=255, blank=True, null=True) name_flags = models.IntegerField(blank=True, null=True) version = models.ForeignKey("Version", db_index=True) hash = models.CharField(maxlength=32)class TalentTab(models.Model): name_en = models.CharField(maxlength=255, blank=True, null=True) name_kr = models.CharField(maxlength=255, blank=True, null=True) name_fr = models.CharField(maxlength=255, blank=True, null=True) name_de = models.CharField(maxlength=255, blank=True, null=True) name_cn = models.CharField(maxlength=255, blank=True, null=True) name_tw = models.CharField(maxlength=255, blank=True, null=True) name_07 = models.CharField(maxlength=255, blank=True, null=True) name_08 = models.CharField(maxlength=255, blank=True, null=True) name_flags = models.IntegerField(blank=True, null=True) icon = models.ForeignKey("SpellIcon", db_index=True, blank=True, null=True) unknown1 = models.IntegerField(blank=True, null=True) required_class = models.IntegerField(blank=True, null=True) order = models.PositiveSmallIntegerField(blank=True, null=True) constant_name = models.CharField(maxlength=255, blank=True, null=True) version = models.ForeignKey("Version", db_index=True) hash = models.IntegerField(blank=True, null=True)class Talent(models.Model): tab = models.ForeignKey(TalentTab, db_index=True, blank=True, null=True) row = models.PositiveSmallIntegerField(blank=True, null=True) col = models.PositiveSmallIntegerField(blank=True, null=True) spell_1 = models.ForeignKey("Spell", db_index=True, blank=True, null=True) spell_2 = models.ForeignKey("Spell", db_index=True, blank=True, null=True) spell_3 = models.ForeignKey("Spell", db_index=True, blank=True, null=True) spell_4 = models.ForeignKey("Spell", db_index=True, blank=True, null=True) spell_5 = models.ForeignKey("Spell", db_index=True, blank=True, null=True) unknown1 = models.IntegerField(blank=True, null=True) unknown2 = models.IntegerField(blank=True, null=True) unknown3 = models.IntegerField(blank=True, null=True) unknown4 = models.IntegerField(blank=True, null=True) required_talent = models.ForeignKey("self", db_index=True, blank=True, null=True) version = models.ForeignKey("Version", db_index=True) hash = models.IntegerField(blank=True, null=True)class SkillLineAbility(models.Model): skill_line = models.ForeignKey("SkillLine", db_index=True, blank=True, null=True) spell = models.ForeignKey("Spell", db_index=True, blank=True, null=True) unknown1 = models.IntegerField(blank=True, null=True) unknown2 = models.IntegerField(blank=True, null=True) unknown3 = models.IntegerField(blank=True, null=True) unknown4 = models.IntegerField(blank=True, null=True) unknown5 = models.IntegerField(blank=True, null=True) parent_spell = models.ForeignKey("Spell", db_index=True, blank=True, null=True) skill_level_required = models.IntegerField(blank=True, null=True) green_level = models.IntegerField(blank=True, null=True) gray_level = models.IntegerField(blank=True, null=True) unknown6 = models.IntegerField(blank=True, null=True) unknown7 = models.IntegerField(blank=True, null=True) unknown8 = models.IntegerField(blank=True, null=True) version = models.ForeignKey("Version", db_index=True) hash = models.IntegerField(blank=True, null=True)class SkillRaceClassInfo(models.Model): skill_line = models.ForeignKey("SkillLine", db_index=True, blank=True, null=True) required_race = models.IntegerField(blank=True, null=True) unknown1 = models.IntegerField(blank=True, null=True) required_class = models.IntegerField(blank=True, null=True) unknown2 = models.IntegerField(blank=True, null=True) unknown3 = models.IntegerField(blank=True, null=True) unknown4 = models.IntegerField(blank=True, null=True) version = models.ForeignKey("Version", db_index=True) hash = models.IntegerField(blank=True, null=True)