Item instancesTable: Difference between revisions
Jump to navigation
Jump to search
Created page with '{| border=1 |- ! field ! type ! foreign key ! description |- | id | int(10) unsigned | | |- | char_id_owner | int(10) unsigned | | |- | char_id_guardian | int(10) unsigned | | …' |
m add to category (Engine documents) |
||
| Line 136: | Line 136: | ||
| | | | ||
|} | |} | ||
[[Category:Engine documents]] | |||
Revision as of 00:20, 23 October 2010
| 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) |