bot_buffs

Relationships

erDiagram
    bot_buffs {
        varchar bot_id
        varchar spell_id
    }
    bot_data {
        varchar bot_id
        varchar owner_id
        varchar spells_id
        varchar zone_id
    }
    spells_new {
        int id
        int descnum
        int effectdescnum
        int effectdescnum2
        int typedescnum
        varchar teleport_zone
    }
    bot_buffs ||--o{ bot_data : "One-to-One"
    bot_buffs ||--o{ spells_new : "One-to-One"

Relationship Type	Local Key	Relates to Table	Foreign Key
One-to-One	bot_id	bot_data	bot_id
One-to-One	spell_id	spells_new	id

Schema

Column	Data Type	Description
buffs_index	int	Unique Entry Identifier
bot_id	int	Bot Identifier
spell_id	int	Spell Identifier
caster_level	tinyint	Caster level
duration_formula	int	Duration Formula
tics_remaining	int	Tics Remaining
poison_counters	int	Poison Counter
disease_counters	int	Disease Counter
curse_counters	int	Curse Counter
corruption_counters	int	Corruption Counter
numhits	int	Number of Hits
melee_rune	int	Melee Rune
magic_rune	int	Magic Rune
dot_rune	int	Damage Over Time Rune
persistent	tinyint	Persistent: 0 = False, 1 = True
caston_x	int	X Coordinate
caston_y	int	Y Coordinate
caston_z	int	Z Coordinate
extra_di_chance	int	Extra DI Chance
instrument_mod	int	Instrument Modifier