· 6 years ago · Mar 24, 2019, 04:48 PM
1CREATE TABLE IF NOT EXISTS `item_template` (
2 `entry` mediumint(8) unsigned NOT NULL DEFAULT 0,
3 `patch` tinyint(3) unsigned NOT NULL DEFAULT 0 COMMENT 'Content patch in which this exact version of the entry was added',
4 `class` tinyint(3) unsigned NOT NULL DEFAULT 0,
5 `subclass` tinyint(3) unsigned NOT NULL DEFAULT 0,
6 `name` varchar(255) NOT NULL DEFAULT '',
7 `description` varchar(255) NOT NULL DEFAULT '',
8 `display_id` mediumint(8) unsigned NOT NULL DEFAULT 0,
9 `quality` tinyint(3) unsigned NOT NULL DEFAULT 0,
10 `flags` int(10) unsigned NOT NULL DEFAULT 0,
11 `buy_count` tinyint(3) unsigned NOT NULL DEFAULT 1,
12 `buy_price` int(10) unsigned NOT NULL DEFAULT 0,
13 `sell_price` int(10) unsigned NOT NULL DEFAULT 0,
14 `inventory_type` tinyint(3) unsigned NOT NULL DEFAULT 0,
15 `allowable_class` mediumint(9) NOT NULL DEFAULT -1,
16 `allowable_race` mediumint(9) NOT NULL DEFAULT -1,
17 `item_level` tinyint(3) unsigned NOT NULL DEFAULT 0,
18 `required_level` tinyint(3) unsigned NOT NULL DEFAULT 0,
19 `required_skill` smallint(5) unsigned NOT NULL DEFAULT 0,
20 `required_skill_rank` smallint(5) unsigned NOT NULL DEFAULT 0,
21 `required_spell` mediumint(8) unsigned NOT NULL DEFAULT 0,
22 `required_honor_rank` mediumint(8) unsigned NOT NULL DEFAULT 0,
23 `required_city_rank` mediumint(8) unsigned NOT NULL DEFAULT 0,
24 `required_reputation_faction` smallint(5) unsigned NOT NULL DEFAULT 0,
25 `required_reputation_rank` smallint(5) unsigned NOT NULL DEFAULT 0,
26 `max_count` smallint(5) unsigned NOT NULL DEFAULT 0,
27 `stackable` smallint(5) unsigned NOT NULL DEFAULT 1,
28 `container_slots` tinyint(3) unsigned NOT NULL DEFAULT 0,
29 `stat_type1` tinyint(3) unsigned NOT NULL DEFAULT 0,
30 `stat_value1` smallint(6) NOT NULL DEFAULT 0,
31 `stat_type2` tinyint(3) unsigned NOT NULL DEFAULT 0,
32 `stat_value2` smallint(6) NOT NULL DEFAULT 0,
33 `stat_type3` tinyint(3) unsigned NOT NULL DEFAULT 0,
34 `stat_value3` smallint(6) NOT NULL DEFAULT 0,
35 `stat_type4` tinyint(3) unsigned NOT NULL DEFAULT 0,
36 `stat_value4` smallint(6) NOT NULL DEFAULT 0,
37 `stat_type5` tinyint(3) unsigned NOT NULL DEFAULT 0,
38 `stat_value5` smallint(6) NOT NULL DEFAULT 0,
39 `stat_type6` tinyint(3) unsigned NOT NULL DEFAULT 0,
40 `stat_value6` smallint(6) NOT NULL DEFAULT 0,
41 `stat_type7` tinyint(3) unsigned NOT NULL DEFAULT 0,
42 `stat_value7` smallint(6) NOT NULL DEFAULT 0,
43 `stat_type8` tinyint(3) unsigned NOT NULL DEFAULT 0,
44 `stat_value8` smallint(6) NOT NULL DEFAULT 0,
45 `stat_type9` tinyint(3) unsigned NOT NULL DEFAULT 0,
46 `stat_value9` smallint(6) NOT NULL DEFAULT 0,
47 `stat_type10` tinyint(3) unsigned NOT NULL DEFAULT 0,
48 `stat_value10` smallint(6) NOT NULL DEFAULT 0,
49 `delay` smallint(5) unsigned NOT NULL DEFAULT 1000,
50 `range_mod` float NOT NULL DEFAULT 0,
51 `ammo_type` tinyint(3) unsigned NOT NULL DEFAULT 0,
52 `dmg_min1` float NOT NULL DEFAULT 0,
53 `dmg_max1` float NOT NULL DEFAULT 0,
54 `dmg_type1` tinyint(3) unsigned NOT NULL DEFAULT 0,
55 `dmg_min2` float NOT NULL DEFAULT 0,
56 `dmg_max2` float NOT NULL DEFAULT 0,
57 `dmg_type2` tinyint(3) unsigned NOT NULL DEFAULT 0,
58 `dmg_min3` float NOT NULL DEFAULT 0,
59 `dmg_max3` float NOT NULL DEFAULT 0,
60 `dmg_type3` tinyint(3) unsigned NOT NULL DEFAULT 0,
61 `dmg_min4` float NOT NULL DEFAULT 0,
62 `dmg_max4` float NOT NULL DEFAULT 0,
63 `dmg_type4` tinyint(3) unsigned NOT NULL DEFAULT 0,
64 `dmg_min5` float NOT NULL DEFAULT 0,
65 `dmg_max5` float NOT NULL DEFAULT 0,
66 `dmg_type5` tinyint(3) unsigned NOT NULL DEFAULT 0,
67 `block` mediumint(8) unsigned NOT NULL DEFAULT 0,
68 `armor` smallint(5) NOT NULL DEFAULT 0,
69 `holy_res` smallint(5) NOT NULL DEFAULT 0,
70 `fire_res` smallint(5) NOT NULL DEFAULT 0,
71 `nature_res` smallint(5) NOT NULL DEFAULT 0,
72 `frost_res` smallint(5) NOT NULL DEFAULT 0,
73 `shadow_res` smallint(5) NOT NULL DEFAULT 0,
74 `arcane_res` smallint(5) NOT NULL DEFAULT 0,
75 `spellid_1` mediumint(8) unsigned NOT NULL DEFAULT 0,
76 `spelltrigger_1` tinyint(3) unsigned NOT NULL DEFAULT 0,
77 `spellcharges_1` tinyint(4) NOT NULL DEFAULT 0,
78 `spellppmrate_1` float NOT NULL DEFAULT 0,
79 `spellcooldown_1` int(11) NOT NULL DEFAULT -1,
80 `spellcategory_1` smallint(5) unsigned NOT NULL DEFAULT 0,
81 `spellcategorycooldown_1` int(11) NOT NULL DEFAULT -1,
82 `spellid_2` mediumint(8) unsigned NOT NULL DEFAULT 0,
83 `spelltrigger_2` tinyint(3) unsigned NOT NULL DEFAULT 0,
84 `spellcharges_2` tinyint(4) NOT NULL DEFAULT 0,
85 `spellppmrate_2` float NOT NULL DEFAULT 0,
86 `spellcooldown_2` int(11) NOT NULL DEFAULT -1,
87 `spellcategory_2` smallint(5) unsigned NOT NULL DEFAULT 0,
88 `spellcategorycooldown_2` int(11) NOT NULL DEFAULT -1,
89 `spellid_3` mediumint(8) unsigned NOT NULL DEFAULT 0,
90 `spelltrigger_3` tinyint(3) unsigned NOT NULL DEFAULT 0,
91 `spellcharges_3` tinyint(4) NOT NULL DEFAULT 0,
92 `spellppmrate_3` float NOT NULL DEFAULT 0,
93 `spellcooldown_3` int(11) NOT NULL DEFAULT -1,
94 `spellcategory_3` smallint(5) unsigned NOT NULL DEFAULT 0,
95 `spellcategorycooldown_3` int(11) NOT NULL DEFAULT -1,
96 `spellid_4` mediumint(8) unsigned NOT NULL DEFAULT 0,
97 `spelltrigger_4` tinyint(3) unsigned NOT NULL DEFAULT 0,
98 `spellcharges_4` tinyint(4) NOT NULL DEFAULT 0,
99 `spellppmrate_4` float NOT NULL DEFAULT 0,
100 `spellcooldown_4` int(11) NOT NULL DEFAULT -1,
101 `spellcategory_4` smallint(5) unsigned NOT NULL DEFAULT 0,
102 `spellcategorycooldown_4` int(11) NOT NULL DEFAULT -1,
103 `spellid_5` mediumint(8) unsigned NOT NULL DEFAULT 0,
104 `spelltrigger_5` tinyint(3) unsigned NOT NULL DEFAULT 0,
105 `spellcharges_5` tinyint(4) NOT NULL DEFAULT 0,
106 `spellppmrate_5` float NOT NULL DEFAULT 0,
107 `spellcooldown_5` int(11) NOT NULL DEFAULT -1,
108 `spellcategory_5` smallint(5) unsigned NOT NULL DEFAULT 0,
109 `spellcategorycooldown_5` int(11) NOT NULL DEFAULT -1,
110 `bonding` tinyint(3) unsigned NOT NULL DEFAULT 0,
111 `page_text` mediumint(8) unsigned NOT NULL DEFAULT 0,
112 `page_language` tinyint(3) unsigned NOT NULL DEFAULT 0,
113 `page_material` tinyint(3) unsigned NOT NULL DEFAULT 0,
114 `start_quest` mediumint(8) unsigned NOT NULL DEFAULT 0,
115 `lock_id` mediumint(8) unsigned NOT NULL DEFAULT 0,
116 `material` tinyint(4) NOT NULL DEFAULT 0,
117 `sheath` tinyint(3) unsigned NOT NULL DEFAULT 0,
118 `random_property` mediumint(8) unsigned NOT NULL DEFAULT 0,
119 `set_id` mediumint(8) unsigned NOT NULL DEFAULT 0,
120 `max_durability` smallint(5) unsigned NOT NULL DEFAULT 0,
121 `area_bound` mediumint(8) unsigned NOT NULL DEFAULT 0,
122 `map_bound` smallint(6) NOT NULL DEFAULT 0,
123 `duration` int(11) unsigned NOT NULL DEFAULT 0,
124 `bag_family` mediumint(9) NOT NULL DEFAULT 0,
125 `disenchant_id` mediumint(8) unsigned NOT NULL DEFAULT 0,
126 `food_type` tinyint(3) unsigned NOT NULL DEFAULT 0,
127 `min_money_loot` int(10) unsigned NOT NULL DEFAULT 0,
128 `max_money_loot` int(10) unsigned NOT NULL DEFAULT 0,
129 `extra_flags` tinyint(1) unsigned NOT NULL DEFAULT 0,
130 `other_team_entry` int(11) unsigned DEFAULT 1,
131 PRIMARY KEY (`entry`,`patch`),
132 KEY `items_index` (`class`)
133) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Item System';