blocked_spells

Relationships

erDiagram
    blocked_spells {
        mediumintunsigned spellid
        int zoneid
    }
    spells_new {
        int id
        int descnum
        int effectdescnum
        int effectdescnum2
        int typedescnum
        varchar teleport_zone
    }
    zone {
        int zoneidnumber
        varchar short_name
        tinyintunsigned version
        varchar content_flags
        varchar content_flags_disabled
    }
    blocked_spells ||--o{ spells_new : "One-to-One"
    blocked_spells ||--o{ zone : "One-to-One"

Relationship Type	Local Key	Relates to Table	Foreign Key
One-to-One	spellid	spells_new	id
One-to-One	zoneid	zone	zoneidnumber

Schema

Column	Data Type	Description
id	int	Unique Blocked Spells Identifier
spellid	mediumint	Spell Identifier
type	tinyint	Blocked Spell Type
zoneid	int	Zone Identifier
x	float	X Coordinate
y	float	Y Coordinate
z	float	Z Coordinate
x_diff	float	X Radius
y_diff	float	Y Radius
z_diff	float	Z Radius
message	varchar	Message when blocked
description	varchar	Blocked spells description
min_expansion	tinyint
max_expansion	tinyint
content_flags	varchar
content_flags_disabled	varchar