Skip to content



    ground_spawns {
        varchar content_flags
        varchar content_flags_disabled
        intunsigned item
        smallint version
        intunsigned zoneid
    content_flags {
        varchar flag_name
    items {
        int id
        int book
        varchar name
        int recasttype
        int icon
        mediumint bardeffect
        int clickeffect
        int focuseffect
        int proceffect
        int scrolleffect
        int worneffect
    zone {
        int zoneidnumber
        varchar short_name
        tinyintunsigned version
        varchar content_flags
        varchar content_flags_disabled
    ground_spawns ||--o{ content_flags : "One-to-One"
    ground_spawns ||--o{ content_flags : "One-to-One"
    ground_spawns ||--o{ items : "One-to-One"
    ground_spawns ||--o{ zone : "One-to-One"
    ground_spawns ||--o{ zone : "One-to-One"

Relationship Type Local Key Relates to Table Foreign Key
One-to-One content_flags content_flags flag_name
One-to-One content_flags_disabled content_flags flag_name
One-to-One item items id
One-to-One version zone version
One-to-One zoneid zone zoneidnumber


Column Data Type Description
id int Unique Ground Spawn Identifier
zoneid int Zone Identifier
version smallint Version: -1 For All
max_x float Maximum X Coordinate
max_y float Maximum Y Coordinate
max_z float Maximum Z Coordinate
min_x float Minimum X Coordinate
min_y float Minimum Y Coordinate
heading float Heading Coordinate
name varchar Name
item int Item Identifier
max_allowed int Max Allowed
comment varchar Comment
respawn_timer int Respawn Timer in Seconds
fix_z tinyint
min_expansion tinyint Minimum Expansion
max_expansion tinyint Maximum Expansion
content_flags varchar Content Flags Required to be Enabled
content_flags_disabled varchar Content Flags Required to be Disabled