· 8 years ago · Dec 23, 2017, 01:08 PM
1DROP TABLE IF EXISTS `item_template`;
2CREATE TABLE `item_template` (
3 `entry` mediumint(8) unsigned NOT NULL DEFAULT '0',
4 `class` tinyint(3) unsigned NOT NULL DEFAULT '0',
5 `subclass` tinyint(3) unsigned NOT NULL DEFAULT '0',
6 `unk0` int(11) NOT NULL DEFAULT '-1',
7 `name` varchar(255) NOT NULL DEFAULT '',
8 `displayid` mediumint(8) unsigned NOT NULL DEFAULT '0',
9 `Quality` tinyint(3) unsigned NOT NULL DEFAULT '0',
10 `Flags` bigint(20) NOT NULL DEFAULT '0',
11 `FlagsExtra` int(10) unsigned NOT NULL DEFAULT '0',
12 `BuyCount` tinyint(3) unsigned NOT NULL DEFAULT '1',
13 `BuyPrice` bigint(20) NOT NULL DEFAULT '0',
14 `SellPrice` int(10) unsigned NOT NULL DEFAULT '0',
15 `InventoryType` tinyint(3) unsigned NOT NULL DEFAULT '0',
16 `AllowableClass` int(11) NOT NULL DEFAULT '-1',
17 `AllowableRace` int(11) NOT NULL DEFAULT '-1',
18 `ItemLevel` smallint(5) unsigned NOT NULL DEFAULT '0',
19 `RequiredLevel` tinyint(3) unsigned NOT NULL DEFAULT '0',
20 `RequiredSkill` smallint(5) unsigned NOT NULL DEFAULT '0',
21 `RequiredSkillRank` smallint(5) unsigned NOT NULL DEFAULT '0',
22 `requiredspell` mediumint(8) unsigned NOT NULL DEFAULT '0',
23 `requiredhonorrank` mediumint(8) unsigned NOT NULL DEFAULT '0',
24 `RequiredCityRank` mediumint(8) unsigned NOT NULL DEFAULT '0',
25 `RequiredReputationFaction` smallint(5) unsigned NOT NULL DEFAULT '0',
26 `RequiredReputationRank` smallint(5) unsigned NOT NULL DEFAULT '0',
27 `maxcount` int(11) NOT NULL DEFAULT '0',
28 `stackable` int(11) DEFAULT '1',
29 `ContainerSlots` tinyint(3) unsigned NOT NULL DEFAULT '0',
30 `StatsCount` tinyint(3) unsigned NOT NULL DEFAULT '0',
31 `stat_type1` tinyint(3) unsigned NOT NULL DEFAULT '0',
32 `stat_value1` smallint(6) NOT NULL DEFAULT '0',
33 `stat_unk1_1` int(11) unsigned NOT NULL DEFAULT '0',
34 `stat_unk2_1` int(11) unsigned NOT NULL DEFAULT '0',
35 `stat_type2` tinyint(3) unsigned NOT NULL DEFAULT '0',
36 `stat_value2` smallint(6) NOT NULL DEFAULT '0',
37 `stat_unk1_2` int(11) unsigned NOT NULL DEFAULT '0',
38 `stat_unk2_2` smallint(6) unsigned NOT NULL DEFAULT '0',
39 `stat_type3` tinyint(3) unsigned NOT NULL DEFAULT '0',
40 `stat_value3` smallint(6) NOT NULL DEFAULT '0',
41 `stat_unk1_3` int(11) unsigned NOT NULL DEFAULT '0',
42 `stat_unk2_3` int(11) unsigned NOT NULL DEFAULT '0',
43 `stat_type4` tinyint(3) unsigned NOT NULL DEFAULT '0',
44 `stat_value4` smallint(6) NOT NULL DEFAULT '0',
45 `stat_unk1_4` int(11) unsigned NOT NULL DEFAULT '0',
46 `stat_unk2_4` int(11) unsigned NOT NULL DEFAULT '0',
47 `stat_type5` tinyint(3) unsigned NOT NULL DEFAULT '0',
48 `stat_value5` smallint(6) NOT NULL DEFAULT '0',
49 `stat_unk1_5` int(11) unsigned NOT NULL DEFAULT '0',
50 `stat_unk2_5` int(11) unsigned NOT NULL DEFAULT '0',
51 `stat_type6` tinyint(3) unsigned NOT NULL DEFAULT '0',
52 `stat_value6` smallint(6) NOT NULL DEFAULT '0',
53 `stat_unk1_6` int(11) unsigned NOT NULL DEFAULT '0',
54 `stat_unk2_6` int(11) unsigned NOT NULL DEFAULT '0',
55 `stat_type7` tinyint(3) unsigned NOT NULL DEFAULT '0',
56 `stat_value7` smallint(6) NOT NULL DEFAULT '0',
57 `stat_unk1_7` int(11) unsigned NOT NULL DEFAULT '0',
58 `stat_unk2_7` int(11) unsigned NOT NULL DEFAULT '0',
59 `stat_type8` tinyint(3) unsigned NOT NULL DEFAULT '0',
60 `stat_value8` smallint(6) NOT NULL DEFAULT '0',
61 `stat_unk1_8` int(11) unsigned NOT NULL DEFAULT '0',
62 `stat_unk2_8` int(11) unsigned NOT NULL DEFAULT '0',
63 `stat_type9` tinyint(3) unsigned NOT NULL DEFAULT '0',
64 `stat_value9` smallint(6) NOT NULL DEFAULT '0',
65 `stat_unk1_9` int(11) unsigned NOT NULL DEFAULT '0',
66 `stat_unk2_9` int(11) unsigned NOT NULL DEFAULT '0',
67 `stat_type10` tinyint(3) unsigned NOT NULL DEFAULT '0',
68 `stat_value10` smallint(6) NOT NULL DEFAULT '0',
69 `stat_unk1_10` int(11) unsigned NOT NULL DEFAULT '0',
70 `stat_unk2_10` int(11) unsigned NOT NULL DEFAULT '0',
71 `ScalingStatDistribution` smallint(6) NOT NULL DEFAULT '0',
72 `ScalingStatValue` int(6) unsigned NOT NULL DEFAULT '0',
73 `damagetype` tinyint(3) unsigned NOT NULL DEFAULT '0',
74 `delay` smallint(5) unsigned NOT NULL DEFAULT '1000',
75 `RangedModRange` float NOT NULL DEFAULT '0',
76 `spellid_1` mediumint(8) NOT NULL DEFAULT '0',
77 `spelltrigger_1` tinyint(3) unsigned NOT NULL DEFAULT '0',
78 `spellcharges_1` smallint(4) DEFAULT NULL,
79 `spellppmRate_1` float NOT NULL DEFAULT '0',
80 `spellcooldown_1` int(11) NOT NULL DEFAULT '-1',
81 `spellcategory_1` smallint(5) unsigned NOT NULL DEFAULT '0',
82 `spellcategorycooldown_1` int(11) NOT NULL DEFAULT '-1',
83 `spellid_2` mediumint(8) NOT NULL DEFAULT '0',
84 `spelltrigger_2` tinyint(3) unsigned NOT NULL DEFAULT '0',
85 `spellcharges_2` smallint(4) DEFAULT NULL,
86 `spellppmRate_2` float NOT NULL DEFAULT '0',
87 `spellcooldown_2` int(11) NOT NULL DEFAULT '-1',
88 `spellcategory_2` smallint(5) unsigned NOT NULL DEFAULT '0',
89 `spellcategorycooldown_2` int(11) NOT NULL DEFAULT '-1',
90 `spellid_3` mediumint(8) NOT NULL DEFAULT '0',
91 `spelltrigger_3` tinyint(3) unsigned NOT NULL DEFAULT '0',
92 `spellcharges_3` smallint(4) DEFAULT NULL,
93 `spellppmRate_3` float NOT NULL DEFAULT '0',
94 `spellcooldown_3` int(11) NOT NULL DEFAULT '-1',
95 `spellcategory_3` smallint(5) unsigned NOT NULL DEFAULT '0',
96 `spellcategorycooldown_3` int(11) NOT NULL DEFAULT '-1',
97 `spellid_4` mediumint(8) NOT NULL DEFAULT '0',
98 `spelltrigger_4` tinyint(3) unsigned NOT NULL DEFAULT '0',
99 `spellcharges_4` smallint(4) DEFAULT NULL,
100 `spellppmRate_4` float NOT NULL DEFAULT '0',
101 `spellcooldown_4` int(11) NOT NULL DEFAULT '-1',
102 `spellcategory_4` smallint(5) unsigned NOT NULL DEFAULT '0',
103 `spellcategorycooldown_4` int(11) NOT NULL DEFAULT '-1',
104 `spellid_5` mediumint(8) NOT NULL DEFAULT '0',
105 `spelltrigger_5` tinyint(3) unsigned NOT NULL DEFAULT '0',
106 `spellcharges_5` smallint(4) DEFAULT NULL,
107 `spellppmRate_5` float NOT NULL DEFAULT '0',
108 `spellcooldown_5` int(11) NOT NULL DEFAULT '-1',
109 `spellcategory_5` smallint(5) unsigned NOT NULL DEFAULT '0',
110 `spellcategorycooldown_5` int(11) NOT NULL DEFAULT '-1',
111 `bonding` tinyint(3) unsigned NOT NULL DEFAULT '0',
112 `description` varchar(255) NOT NULL DEFAULT '',
113 `PageText` mediumint(8) unsigned NOT NULL DEFAULT '0',
114 `LanguageID` tinyint(3) unsigned NOT NULL DEFAULT '0',
115 `PageMaterial` tinyint(3) unsigned NOT NULL DEFAULT '0',
116 `startquest` mediumint(8) unsigned NOT NULL DEFAULT '0',
117 `lockid` mediumint(8) unsigned NOT NULL DEFAULT '0',
118 `Material` tinyint(4) NOT NULL DEFAULT '0',
119 `sheath` tinyint(3) unsigned NOT NULL DEFAULT '0',
120 `RandomProperty` mediumint(8) NOT NULL DEFAULT '0',
121 `RandomSuffix` mediumint(8) unsigned NOT NULL DEFAULT '0',
122 `block` mediumint(8) unsigned NOT NULL DEFAULT '0',
123 `itemset` mediumint(8) unsigned NOT NULL DEFAULT '0',
124 `MaxDurability` smallint(5) unsigned NOT NULL DEFAULT '0',
125 `area` mediumint(8) unsigned NOT NULL DEFAULT '0',
126 `Map` smallint(6) NOT NULL DEFAULT '0',
127 `BagFamily` mediumint(9) NOT NULL DEFAULT '0',
128 `TotemCategory` mediumint(9) NOT NULL DEFAULT '0',
129 `socketColor_1` tinyint(4) NOT NULL DEFAULT '0',
130 `socketContent_1` mediumint(9) NOT NULL DEFAULT '0',
131 `socketColor_2` tinyint(4) NOT NULL DEFAULT '0',
132 `socketContent_2` mediumint(9) NOT NULL DEFAULT '0',
133 `socketColor_3` tinyint(4) NOT NULL DEFAULT '0',
134 `socketContent_3` mediumint(9) NOT NULL DEFAULT '0',
135 `socketBonus` mediumint(9) NOT NULL DEFAULT '0',
136 `GemProperties` mediumint(9) NOT NULL DEFAULT '0',
137 `RequiredDisenchantSkill` smallint(6) NOT NULL DEFAULT '-1',
138 `ArmorDamageModifier` float NOT NULL DEFAULT '0',
139 `Duration` int(11) NOT NULL DEFAULT '0' COMMENT 'Duration in seconds. Negative value means realtime, postive value ingame time',
140 `ItemLimitCategory` smallint(6) NOT NULL DEFAULT '0',
141 `HolidayId` int(11) unsigned NOT NULL DEFAULT '0',
142 `StatScalingFactor` float NOT NULL DEFAULT '0',
143 `ScriptName` varchar(64) NOT NULL DEFAULT '',
144 `DisenchantID` mediumint(8) unsigned NOT NULL DEFAULT '0',
145 `FoodType` tinyint(3) unsigned NOT NULL DEFAULT '0',
146 `minMoneyLoot` int(10) unsigned NOT NULL DEFAULT '0',
147 `maxMoneyLoot` int(10) unsigned NOT NULL DEFAULT '0',
148 `WDBVerified` smallint(5) DEFAULT '1',
149 PRIMARY KEY (`entry`),
150 KEY `idx_name` (`name`),
151 KEY `items_index` (`class`)
152) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Item System';