|
|
| Line 1: |
Line 1: |
| {| border=1
| | spam |
| |-
| |
| ! field
| |
| ! type
| |
| ! foreign key
| |
| ! description
| |
| |-
| |
| | id
| |
| | int(10) unsigned
| |
| |
| |
| |
| |
| |-
| |
| | char_id_owner
| |
| | int(10) unsigned
| |
| |
| |
| |
| |
| |-
| |
| | char_id_guardian
| |
| | int(10) unsigned
| |
| |
| |
| |
| |
| |-
| |
| | parent_item_id
| |
| | int(10) unsigned
| |
| |
| |
| |
| |
| |-
| |
| | location_in_parent
| |
| | smallint(4)
| |
| |
| |
| |
| |
| |-
| |
| | stack_count
| |
| | int(10) unsigned
| |
| |
| |
| |
| |
| |-
| |
| | creator_mark_id
| |
| | int(10) unsigned
| |
| |
| |
| |
| |
| |-
| |
| | guild_mark_id
| |
| | int(10) unsigned
| |
| |
| |
| |
| |
| |-
| |
| | loc_instance
| |
| | int(11) unsigned
| |
| |
| |
| |
| |
| |-
| |
| | loc_sector_id
| |
| | smallint(4) unsigned
| |
| |
| |
| |
| |
| |-
| |
| | loc_x
| |
| | float(14,6)
| |
| |
| |
| |
| |
| |-
| |
| | loc_y
| |
| | float(14,6)
| |
| |
| |
| |
| |
| |-
| |
| | loc_z
| |
| | float(14,6)
| |
| |
| |
| |
| |
| |-
| |
| | loc_yrot
| |
| | float(14,6)
| |
| |
| |
| |
| |
| |-
| |
| | decay_resistance
| |
| | float(3,2)
| |
| |
| |
| |
| |
| |-
| |
| | item_quality
| |
| | float(5,2)
| |
| |
| |
| |
| |
| |-
| |
| | crafted_quality
| |
| | float(5,2)
| |
| |
| |
| |
| |
| |-
| |
| | item_stats_id_standard
| |
| | int(10) unsigned
| |
| |
| |
| |
| |
| |-
| |
| | item_stats_id_unique
| |
| | int(10) unsigned
| |
| |
| |
| |
| |
| |-
| |
| | flags
| |
| | varchar(200)
| |
| |
| |
| |
| |
| |-
| |
| | lock_str
| |
| | int(5)
| |
| |
| |
| |
| |
| |-
| |
| | lock_skill
| |
| | int(2)
| |
| |
| |
| |
| |
| |-
| |
| | openable_locks
| |
| | varchar(100)
| |
| |
| |
| |
| |
| |-
| |
| | item_name
| |
| | varchar(100)
| |
| |
| |
| |
| |
| |-
| |
| | item_description
| |
| | varchar(255)
| |
| |
| |
| |
| |
| |-
| |
| | charges
| |
| | int(3)
| |
| |
| |
| |
| |
| |}
| |
| | |
| | |
| [[Category:Engine documents]]
| |