Skip to content



    doors {
        varchar content_flags
        varchar content_flags_disabled
        int dz_switch_id
        int keyitem
        varchar zone
        varchar dest_zone
        intunsigned dest_instance
        smallint version
    content_flags {
        varchar flag_name
    dynamic_zones {
        int dz_switch_id
        intunsigned id
        intunsigned compass_zone_id
        int instance_id
        intunsigned safe_return_zone_id
    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
    doors ||--o{ content_flags : "One-to-One"
    doors ||--o{ content_flags : "One-to-One"
    doors ||--o{ dynamic_zones : "One-to-One"
    doors ||--o{ items : "One-to-One"
    doors ||--o{ zone : "One-to-One"
    doors ||--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 dz_switch_id dynamic_zones dz_switch_id
One-to-One keyitem items id
One-to-One zone zone short_name
One-to-One dest_zone zone short_name


Column Data Type Description
id int Unique Entry Identifier
doorid smallint Unique Door Identifier
zone varchar Zone Short Name
version smallint Zone Version: -1 For All
name varchar This is the name of the door, such as 'IT11161' or 'POPCREATE501', for names of objects you can see.
pos_y float Door Y Coordinate
pos_x float Door X Coordinate
pos_z float Door Z Coordinate
heading float Door Heading Coordinate
opentype smallint Door Open Type
guild smallint Guild Identifier
lockpick smallint Lockpicking Skill Required: -1 = Unpickable
keyitem int Item Identifier
nokeyring tinyint No Key Ring: 0 = False, 1 = True
triggerdoor smallint Trigger Door: 0 For Current Door or use a Unique Door Identifier
triggertype smallint Trigger Type: 1 = Open a Type 255 door, 255 = Will Not Open
disable_timer tinyint Disable Timer
doorisopen smallint Door Is Open: 0 = False, 1 = True
door_param int Door Parameter
dest_zone varchar Zone Short Name
dest_instance int Destination Instance
dest_x float Destination X Coordinate
dest_y float Destination Y Coordinate
dest_z float Destination Z Coordinate
dest_heading float Destination Heading Coordinate
invert_state int This column will basically behave like such: if the door has a click type and it is to raise up like a door, it will be raised on spawn of the door. Meaning it is inverted. Another example: If a Door Open Type is set to a spinning object on click, you could set this to 1 to have the door be spinning on spawn.
incline int Incline
size smallint Size
buffer float Unused
client_version_mask int Client Version Mask
is_ldon_door smallint Is LDoN Door: 0 = False, 1 = True
dz_switch_id int Dynamic Zone Switch Identifier
min_expansion tinyint Minimum Expansion](../../../../server/operation/expansion-list)
max_expansion tinyint Maximum Expansion](../../../../server/operation/expansion-list)
content_flags varchar Content Flags Required to be Enabled
content_flags_disabled varchar Content Flags Required to be Disabled