from django.db import models
from django.contrib.auth.models import User
from django.contrib.contenttypes.models import ContentType
from 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.PositiveIntegerField(null=True, blank=True)
	level_max = models.PositiveIntegerField(null=True, blank=True)
	horde_react = models.PositiveIntegerField(null=True, blank=True, choices=REACTIONS)
	alliance_react = models.PositiveIntegerField(null=True, blank=True, choices=REACTIONS)

	def __str__(self):
		return self.creature.name_en

class 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.PositiveIntegerField(primary_key=True, blank=True, null=True)
	pos_y = models.PositiveIntegerField(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.PositiveIntegerField(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, blank=True, null=True)
	name_01 = 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 = models.TextField(blank=True, null=True)
	unknown1 = models.IntegerField(blank=True, null=True)
	creature_type = models.ForeignKey("CreatureType", blank=True, null=True)
	family = models.ForeignKey("CreatureFamily", blank=True, null=True)
	flag = models.PositiveIntegerField(blank=True, null=True)
	unknown2 = models.IntegerField(blank=True, null=True)
	spell_data = models.ForeignKey("CreatureSpellData", blank=True, null=True)
	display = models.ForeignKey("CreatureDisplayInfo", blank=True, null=True)
	unknown3 = models.SmallIntegerField(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 NPC(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)
	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 ItemText(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)
	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 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.PositiveIntegerField(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.PositiveIntegerField(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)
	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)
	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.PositiveIntegerField(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.FloatField(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)
	unknown59 = 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)
	unknown116 = 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)
	unknown161 = models.IntegerField(blank=True, null=True)
	targets = models.IntegerField(blank=True, null=True)
	unknown163 = models.IntegerField(blank=True, null=True)
	damage_type = models.PositiveIntegerField(blank=True, null=True)
	unknown165 = models.IntegerField(blank=True, null=True)
	unknown166 = 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)
	unknown170 = models.IntegerField(blank=True, null=True)
	unknown171 = models.IntegerField(blank=True, null=True)
	unknown172 = 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.PositiveIntegerField(db_index=True, blank=True, null=True)
	unknown3 = models.IntegerField(blank=True, null=True)
	unknown4 = models.IntegerField(blank=True, null=True)
	stat_2 = models.PositiveIntegerField(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 = models.CharField(maxlength=255, blank=True, null=True)
	description = models.TextField(blank=True, null=True)
	details = models.TextField(blank=True, null=True)
	sub_description = 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 = models.TextField(blank=True, null=True)
	objective_2 = models.TextField(blank=True, null=True)
	objective_3 = models.TextField(blank=True, null=True)
	objective_4 = 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.PositiveIntegerField(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 = models.CharField(maxlength=255, blank=True, null=True)
	name_01 = models.CharField(maxlength=255, blank=True, null=True)
	name_02 = models.CharField(maxlength=255, blank=True, null=True)
	name_03 = models.CharField(maxlength=255, blank=True, null=True)
	display = models.ForeignKey("ItemDisplayInfo", db_index=True, blank=True, null=True)
	quality = models.PositiveIntegerField(db_index=True, blank=True, null=True)
	item_type = models.PositiveIntegerField(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.PositiveIntegerField(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.PositiveIntegerField(db_index=True, blank=True, null=True)
	stat_1_value = models.IntegerField(blank=True, null=True)
	stat_2 = models.PositiveIntegerField(db_index=True, blank=True, null=True)
	stat_2_value = models.IntegerField(blank=True, null=True)
	stat_3 = models.PositiveIntegerField(db_index=True, blank=True, null=True)
	stat_3_value = models.IntegerField(blank=True, null=True)
	stat_4 = models.PositiveIntegerField(db_index=True, blank=True, null=True)
	stat_4_value = models.IntegerField(blank=True, null=True)
	stat_5 = models.PositiveIntegerField(db_index=True, blank=True, null=True)
	stat_5_value = models.IntegerField(blank=True, null=True)
	stat_6 = models.PositiveIntegerField(db_index=True, blank=True, null=True)
	stat_6_value = models.IntegerField(blank=True, null=True)
	stat_7 = models.PositiveIntegerField(db_index=True, blank=True, null=True)
	stat_7_value = models.IntegerField(blank=True, null=True)
	stat_8 = models.PositiveIntegerField(db_index=True, blank=True, null=True)
	stat_8_value = models.IntegerField(blank=True, null=True)
	stat_9 = models.PositiveIntegerField(db_index=True, blank=True, null=True)
	stat_9_value = models.IntegerField(blank=True, null=True)
	stat_10 = models.PositiveIntegerField(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.PositiveIntegerField(db_index=True, blank=True, null=True)
	damage_2_min = models.FloatField()
	damage_2_max = models.FloatField()
	damage_2_type = models.PositiveIntegerField(db_index=True, blank=True, null=True)
	damage_3_min = models.FloatField()
	damage_3_max = models.FloatField()
	damage_3_type = models.PositiveIntegerField(db_index=True, blank=True, null=True)
	damage_4_min = models.FloatField()
	damage_4_max = models.FloatField()
	damage_4_type = models.PositiveIntegerField(db_index=True, blank=True, null=True)
	damage_5_min = models.FloatField()
	damage_5_max = models.FloatField()
	damage_5_type = models.PositiveIntegerField(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.PositiveIntegerField(db_index=True, blank=True, null=True)
	range_modifier = 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.PositiveIntegerField(db_index=True, blank=True, null=True)
	description = 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.PositiveIntegerField(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)

	def __str__(self):
		return self.name_en

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.PositiveIntegerField(blank=True, null=True)
	bonus_2 = models.PositiveIntegerField(blank=True, null=True)
	bonus_3 = models.PositiveIntegerField(blank=True, null=True)
	bonus_4 = models.PositiveIntegerField(blank=True, null=True)
	bonus_5 = models.PositiveIntegerField(blank=True, null=True)
	bonus_6 = models.PositiveIntegerField(blank=True, null=True)
	bonus_7 = models.PositiveIntegerField(blank=True, null=True)
	bonus_8 = models.PositiveIntegerField(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.PositiveIntegerField(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.PositiveIntegerField(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.PositiveIntegerField(blank=True, null=True)
	col = models.PositiveIntegerField(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)