From 58854d415c5ab6b19fcd530edd7726f35cc143f4 Mon Sep 17 00:00:00 2001 From: Walter Pagani Date: Tue, 12 Jan 2021 07:02:37 -0300 Subject: refact(tables): converting from HTML to Markdown part #7 (#337) * Holidays.md * item_loot_items.md * game_weather.md * creature_classlevelstats.md * game_event_condition.md * game_event.md * item_instance.md * pet_aura.md * character_queststatus.md * gossip_menu_option_locale.md * arena_team.md * access_requirement.md * character_aura.md * guild_member.md * character_equipmentsets.md * character_pet.md * Spell.md * SkillLine.md * creature_addon.md * gm_ticket.md * character_stats.md * spell_area.md * gossip_menu_option.md * creature_text.md * quest_template_addon.md * Achievement_Criteria.md * fix powerType Spell.md * loot_template.md * Emotes.md * quest_template.md * npc_text.md * gameobject_template.md * spell_dbc.md * worldstates.md * FactionTemplate.md * Achievement.md * AreaTable.md * DBC-AreaTrigger.md --- docs/item_instance.md | 195 ++++++++------------------------------------------ 1 file changed, 31 insertions(+), 164 deletions(-) (limited to 'docs/item_instance.md') diff --git a/docs/item_instance.md b/docs/item_instance.md index 1412621..217f5c5 100644 --- a/docs/item_instance.md +++ b/docs/item_instance.md @@ -8,170 +8,37 @@ This table holds individual item instance information for all items currently eq **Structure** - ---------- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -

Field

Type

Attributes

Key

Null

Default

Extra

Comment

guid

int(10)

unsigned

PRI

NO

0

 

 

itemEntry

mediumint(8)

unsigned

 

NO

0

 

 

owner_guid

int(10)

unsigned

 

NO

0

 

 

creatorGuid

int(10)

unsigned

 

NO

0

 

 

giftCreatorGuid

int(10)

unsigned

 

NO

0

 

 

count

int(10)

unsigned

 

NO

1

 

 

duration

int(10)

unsigned

 

NO

0

 

 

charges

tinytext

signed

 

YES

 

 

 

flags

mediunint(8)

unsigned

 

NO

0

 

 

enchantments

text

signed

 

NO

 

 

 

randomPropertyId

smallint(5)

signed

 

NO

0

 

 

durability

smallint(5)

unsigned

 

NO

0

 

 

playedTime

int(10)

unsigned

 

NO

0

 

 

text

text

signed

 

YES

 

 

 

+| Field | Type | Attributes | Key | Null | Default | Extra | Comment | +|------------------------|--------------|------------|-----|------|---------|-------|---------| +| [guid][1] | int(10) | unsigned | PRI | NO | | | | +| [itemEntry][2] | mediumint(8) | unsigned | | NO | | | | +| [owner_guid][3] | int(10) | unsigned | | NO | | | | +| [creatorGuid][4] | int(10) | unsigned | | NO | | | | +| [giftCreatorGuid][5] | int(10) | unsigned | | NO | | | | +| [count][6] | int(10) | unsigned | | NO | | | | +| [duration][7] | int(10) | unsigned | | NO | | | | +| [charges][8] | tinytext | | | YES | NULL | | | +| [flags][9] | mediunint(8) | unsigned | | NO | | | | +| [enchantments][10] | text | | | NO | | | | +| [randomPropertyId][11] | smallint(5) | signed | | NO | | | | +| [durability][12] | smallint(5) | unsigned | | NO | | | | +| [playedTime][13] | int(10) | unsigned | | NO | | | | +| [text][14] | text | | | YES | NULL | | | + +[1]: #guid +[2]: #itementry +[3]: #owner_guid +[4]: #creatorguid +[5]: #giftcreatorguid +[6]: #count +[7]: #duration +[8]: #charges +[9]: #flags +[10]: #enchantments +[11]: #randompropertyid +[12]: #durability +[13]: #playedtime +[14]: #text **Description of the fields** -- cgit