· 8 years ago · Mar 11, 2018, 10:26 AM
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 `stat_type1` tinyint(3) NOT NULL default '0',
31 `stat_value1` smallint(6) NOT NULL default '0',
32 `stat_type2` tinyint(3) NOT NULL default '0',
33 `stat_value2` smallint(6) NOT NULL default '0',
34 `stat_type3` tinyint(3) NOT NULL default '0',
35 `stat_value3` smallint(6) NOT NULL default '0',
36 `stat_type4` tinyint(3) NOT NULL default '0',
37 `stat_value4` smallint(6) NOT NULL default '0',
38 `stat_type5` tinyint(3) NOT NULL default '0',
39 `stat_value5` smallint(6) NOT NULL default '0',
40 `stat_type6` tinyint(3) NOT NULL default '0',
41 `stat_value6` smallint(6) NOT NULL default '0',
42 `stat_type7` tinyint(3) NOT NULL default '0',
43 `stat_value7` smallint(6) NOT NULL default '0',
44 `stat_type8` tinyint(3) NOT NULL default '0',
45 `stat_value8` smallint(6) NOT NULL default '0',
46 `stat_type9` tinyint(3) NOT NULL default '0',
47 `stat_value9` smallint(6) NOT NULL default '0',
48 `stat_type10` tinyint(3) NOT NULL default '0',
49 `stat_value10` smallint(6) NOT NULL default '0',
50 `ScalingStatDistribution` smallint(6) NOT NULL default '0',
51 `ScalingStatValue` int(6) unsigned NOT NULL default '0',
52 `damageType` tinyint(3) unsigned NOT NULL default '0',
53 `delay` smallint(5) unsigned NOT NULL default '1000',
54 `RangedModRange` float NOT NULL default '0',
55 `spellid_1` mediumint(8) NOT NULL default '0',
56 `spelltrigger_1` tinyint(3) unsigned NOT NULL default '0',
57 `spellcharges_1` smallint(4) default NULL,
58 `spellppmRate_1` float NOT NULL default '0',
59 `spellcooldown_1` int(11) NOT NULL default '-1',
60 `spellcategory_1` smallint(5) unsigned NOT NULL default '0',
61 `spellcategorycooldown_1` int(11) NOT NULL default '-1',
62 `spellid_2` mediumint(8) NOT NULL default '0',
63 `spelltrigger_2` tinyint(3) unsigned NOT NULL default '0',
64 `spellcharges_2` smallint(4) default NULL,
65 `spellppmRate_2` float NOT NULL default '0',
66 `spellcooldown_2` int(11) NOT NULL default '-1',
67 `spellcategory_2` smallint(5) unsigned NOT NULL default '0',
68 `spellcategorycooldown_2` int(11) NOT NULL default '-1',
69 `spellid_3` mediumint(8) NOT NULL default '0',
70 `spelltrigger_3` tinyint(3) unsigned NOT NULL default '0',
71 `spellcharges_3` smallint(4) default NULL,
72 `spellppmRate_3` float NOT NULL default '0',
73 `spellcooldown_3` int(11) NOT NULL default '-1',
74 `spellcategory_3` smallint(5) unsigned NOT NULL default '0',
75 `spellcategorycooldown_3` int(11) NOT NULL default '-1',
76 `spellid_4` mediumint(8) NOT NULL default '0',
77 `spelltrigger_4` tinyint(3) unsigned NOT NULL default '0',
78 `spellcharges_4` smallint(4) default NULL,
79 `spellppmRate_4` float NOT NULL default '0',
80 `spellcooldown_4` int(11) NOT NULL default '-1',
81 `spellcategory_4` smallint(5) unsigned NOT NULL default '0',
82 `spellcategorycooldown_4` int(11) NOT NULL default '-1',
83 `spellid_5` mediumint(8) NOT NULL default '0',
84 `spelltrigger_5` tinyint(3) unsigned NOT NULL default '0',
85 `spellcharges_5` smallint(4) default NULL,
86 `spellppmRate_5` float NOT NULL default '0',
87 `spellcooldown_5` int(11) NOT NULL default '-1',
88 `spellcategory_5` smallint(5) unsigned NOT NULL default '0',
89 `spellcategorycooldown_5` int(11) NOT NULL default '-1',
90 `bonding` tinyint(3) unsigned NOT NULL default '0',
91 `description` varchar(255) NOT NULL default '',
92 `PageText` mediumint(8) unsigned NOT NULL default '0',
93 `LanguageID` tinyint(3) unsigned NOT NULL default '0',
94 `PageMaterial` tinyint(3) unsigned NOT NULL default '0',
95 `startquest` mediumint(8) unsigned NOT NULL default '0',
96 `lockid` mediumint(8) unsigned NOT NULL default '0',
97 `Material` tinyint(4) NOT NULL default '0',
98 `sheath` tinyint(3) unsigned NOT NULL default '0',
99 `RandomProperty` mediumint(8) NOT NULL default '0',
100 `RandomSuffix` mediumint(8) unsigned NOT NULL default '0',
101 `block` mediumint(8) unsigned NOT NULL default '0',
102 `itemset` mediumint(8) unsigned NOT NULL default '0',
103 `MaxDurability` smallint(5) unsigned NOT NULL default '0',
104 `area` mediumint(8) unsigned NOT NULL default '0',
105 `Map` smallint(6) NOT NULL default '0',
106 `BagFamily` mediumint(9) NOT NULL default '0',
107 `TotemCategory` mediumint(9) NOT NULL default '0',
108 `socketColor_1` tinyint(4) NOT NULL default '0',
109 `socketContent_1` mediumint(9) NOT NULL default '0',
110 `socketColor_2` tinyint(4) NOT NULL default '0',
111 `socketContent_2` mediumint(9) NOT NULL default '0',
112 `socketColor_3` tinyint(4) NOT NULL default '0',
113 `socketContent_3` mediumint(9) NOT NULL default '0',
114 `socketBonus` mediumint(9) NOT NULL default '0',
115 `GemProperties` mediumint(9) NOT NULL default '0',
116 `RequiredDisenchantSkill` smallint(6) NOT NULL default '-1',
117 `ArmorDamageModifier` float NOT NULL default '0',
118 `Duration` int(11) NOT NULL default '0' COMMENT 'Duration in seconds. Negative value means realtime, postive value ingame time',
119 `ItemLimitCategory` smallint(6) NOT NULL default '0',
120 `HolidayId` int(11) unsigned NOT NULL default '0',
121 `ScriptName` varchar(64) NOT NULL default '',
122 `DisenchantID` mediumint(8) unsigned NOT NULL default '0',
123 `FoodType` tinyint(3) unsigned NOT NULL default '0',
124 `minMoneyLoot` int(10) unsigned NOT NULL default '0',
125 `maxMoneyLoot` int(10) unsigned NOT NULL default '0',
126 `WDBVerified` smallint(5) default '1',
127 PRIMARY KEY (`entry`),
128 KEY `idx_name` (`name`),
129 KEY `items_index` (`class`)
130) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Item System';