Item instancesTable
| field | type | foreign key | description |
|---|---|---|---|
| id | int(10) unsigned | ||
| char_id_owner | int(10) unsigned | Y | Key into the CharactersTable for the owner of this item. |
| char_id_guardian | int(10) unsigned | Y | Key into the CharactersTable for the guardian of this item. |
| parent_item_id | int(10) unsigned | Y | |
| location_in_parent | smallint(4) | ||
| stack_count | int(10) unsigned | ||
| creator_mark_id | int(10) unsigned | Y | Key into the CharactersTable for the creator of this item if craftet. |
| guild_mark_id | int(10) unsigned | Y | |
| loc_instance | int(11) unsigned | ||
| loc_sector_id | smallint(4) unsigned | Y | |
| 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 | Y | Key into the ItemStatsTable for the standard version of this item. |
| item_stats_id_unique | int(10) unsigned | Y | Key into the ItemStatsTable for unique versions of this item. |
| 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) |