Skip to content



    bot_data {
        varchar bot_id
        varchar owner_id
        varchar spells_id
        varchar zone_id
    bot_guild_members {
        varchar bot_id
        varchar guild_id
    bot_heal_rotation_members {
        varchar bot_id
        varchar heal_rotation_index
    bot_inspect_messages {
        varchar bot_id
    bot_inventories {
        varchar bot_id
        varchar item_id
        varchar augment_1
        varchar augment_2
        varchar augment_3
        varchar augment_4
        varchar augment_5
        varchar augment_6
    bot_pets {
        varchar bot_id
        varchar pets_index
        varchar spell_id
    bot_data ||--o{ bot_guild_members : "One-to-One"
    bot_data ||--o{ bot_heal_rotation_members : "Has-Many"
    bot_data ||--o{ bot_inspect_messages : "One-to-One"
    bot_data ||--o{ bot_inventories : "Has-Many"
    bot_data ||--o{ bot_pets : "One-to-One"

    bot_data {
        varchar bot_id
        varchar owner_id
        varchar spells_id
        varchar zone_id
    bot_stances {
        varchar bot_id
        varchar stance_id
    bot_timers {
        varchar bot_id
        varchar bot_data
    character_data {
        intunsigned id
        varchar name
        varchar nane
        intunsigned zone_instance
        intunsigned zone_id
    npc_spells {
        intunsigned id
        intunsigned parent_list
    zone {
        int zoneidnumber
        varchar short_name
        tinyintunsigned version
        varchar content_flags
        varchar content_flags_disabled
    bot_data ||--o{ bot_stances : "One-to-One"
    bot_data ||--o{ bot_timers : "Has-Many"
    bot_data ||--o{ character_data : "One-to-One"
    bot_data ||--o{ npc_spells : "One-to-One"
    bot_data ||--o{ zone : "One-to-One"

Relationship Type Local Key Relates to Table Foreign Key
One-to-One bot_id bot_guild_members bot_id
Has-Many bot_id bot_heal_rotation_members bot_id
One-to-One bot_id bot_inspect_messages bot_id
Has-Many bot_id bot_inventories bot_id
One-to-One bot_id bot_pets bot_id
One-to-One bot_id bot_stances bot_id
Has-Many bot_id bot_timers bot_id
One-to-One owner_id character_data id
One-to-One spells_id npc_spells id
One-to-One zone_id zone zoneidnumber


Column Data Type Description
bot_id int Unique Bot Identifier
owner_id int Owner Character Identifier
spells_id int Bot Spell List Identifier
name varchar Name
last_name varchar Last Name
title varchar Title
suffix varchar Suffix
zone_id smallint Zone Identifier
gender tinyint Gender
race smallint Race
class tinyint Class
level tinyint Level
deity int Deity
creation_day int UNIX Timestamp of creation date
last_spawn int UNIX Timestamp of last spawn_conditions
time_spawned int Time spawned
size float Size
face int Face
hair_color int Hair Color
hair_style int Hair Style
beard int Beard
beard_color int Beard Color
eye_color_1 int Eye Color 1
eye_color_2 int Eye Color 2
drakkin_heritage int Drakkin Heritage
drakkin_tattoo int Drakkin Tattoo
drakkin_details int Drakkin Details
ac smallint Armor Class
atk mediumint Attack
hp int Health
mana int Mana
str mediumint Strength
sta mediumint Stamina
cha mediumint Charisma
dex mediumint Dexterity
int mediumint Intelligence
agi mediumint Agility
wis mediumint Wisdom
fire smallint Fire Resistance
cold smallint Cold Resistance
magic smallint Magic Resistance
poison smallint Poison Resistance
disease smallint Disease Resistance
corruption smallint Corruption Resistance
show_helm int Show Helm: 0 = False, 1= True
follow_distance int Follow Distance
stop_melee_level tinyint Stop Melee Level
expansion_bitmask int Expansion Bitmask
enforce_spell_settings tinyint Enforce Spell Settings: 0 = False, 1 = True
archery_setting tinyint Archery Setting: 0 = False, 1 = True
caster_range int Caster Range