· 8 years ago · Feb 18, 2018, 10:34 PM
1-- --------------------------------------------------------
2-- Host: 127.0.0.1
3-- Server version: 10.2.10-MariaDB - mariadb.org binary distribution
4-- Server OS: Win64
5-- HeidiSQL Version: 9.4.0.5125
6-- --------------------------------------------------------
7
8/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
9/*!40101 SET NAMES utf8 */;
10/*!50503 SET NAMES utf8mb4 */;
11/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
12/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
13
14-- Dumping structure for table doffchar.character_custom_items
15CREATE TABLE IF NOT EXISTS `character_custom_items` (
16 `entry` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
17 `guid` mediumint(8) unsigned NOT NULL DEFAULT 0,
18 `name` varchar(255) NOT NULL DEFAULT '',
19 `class` tinyint(3) unsigned NOT NULL DEFAULT 0,
20 `subclass` tinyint(3) unsigned NOT NULL DEFAULT 0,
21 `SoundOverrideSubclass` tinyint(3) NOT NULL DEFAULT -1,
22 `displayid` mediumint(8) unsigned NOT NULL DEFAULT 0,
23 `Quality` tinyint(3) unsigned NOT NULL DEFAULT 0,
24 `Flags` bigint(20) NOT NULL DEFAULT 0,
25 `FlagsExtra` int(10) unsigned NOT NULL DEFAULT 0,
26 `Flags3` int(10) unsigned NOT NULL DEFAULT 0,
27 `Unk430_1` float unsigned NOT NULL DEFAULT 1,
28 `Unk430_2` float NOT NULL DEFAULT 1,
29 `BuyCount` tinyint(3) unsigned NOT NULL DEFAULT 1,
30 `BuyPrice` bigint(20) NOT NULL DEFAULT 0,
31 `SellPrice` int(10) unsigned NOT NULL DEFAULT 0,
32 `InventoryType` tinyint(3) unsigned NOT NULL DEFAULT 0,
33 `AllowableClass` int(11) NOT NULL DEFAULT -1,
34 `AllowableRace` int(11) NOT NULL DEFAULT -1,
35 `ItemLevel` smallint(5) unsigned NOT NULL DEFAULT 0,
36 `RequiredLevel` tinyint(3) unsigned NOT NULL DEFAULT 0,
37 `RequiredSkill` smallint(5) unsigned NOT NULL DEFAULT 0,
38 `RequiredSkillRank` smallint(5) unsigned NOT NULL DEFAULT 0,
39 `requiredspell` mediumint(8) unsigned NOT NULL DEFAULT 0,
40 `requiredhonorrank` mediumint(8) unsigned NOT NULL DEFAULT 0,
41 `RequiredCityRank` mediumint(8) unsigned NOT NULL DEFAULT 0,
42 `RequiredReputationFaction` smallint(5) unsigned NOT NULL DEFAULT 0,
43 `RequiredReputationRank` smallint(5) unsigned NOT NULL DEFAULT 0,
44 `maxcount` int(11) NOT NULL DEFAULT 0,
45 `stackable` int(11) DEFAULT 1,
46 `ContainerSlots` tinyint(3) unsigned NOT NULL DEFAULT 0,
47 `stat_type1` tinyint(3) NOT NULL DEFAULT 0,
48 `stat_value1` int(11) NOT NULL DEFAULT 0,
49 `stat_unk1_1` int(11) NOT NULL DEFAULT 0,
50 `stat_unk2_1` int(11) NOT NULL DEFAULT 0,
51 `stat_type2` tinyint(3) NOT NULL DEFAULT 0,
52 `stat_value2` int(11) NOT NULL DEFAULT 0,
53 `stat_unk1_2` int(11) NOT NULL DEFAULT 0,
54 `stat_unk2_2` int(11) NOT NULL DEFAULT 0,
55 `stat_type3` tinyint(3) NOT NULL DEFAULT 0,
56 `stat_value3` int(11) NOT NULL DEFAULT 0,
57 `stat_unk1_3` int(11) NOT NULL DEFAULT 0,
58 `stat_unk2_3` int(11) NOT NULL DEFAULT 0,
59 `stat_type4` tinyint(3) NOT NULL DEFAULT 0,
60 `stat_value4` int(11) NOT NULL DEFAULT 0,
61 `stat_unk1_4` int(11) NOT NULL DEFAULT 0,
62 `stat_unk2_4` int(11) NOT NULL DEFAULT 0,
63 `stat_type5` tinyint(3) NOT NULL DEFAULT 0,
64 `stat_value5` int(10) unsigned NOT NULL DEFAULT 0,
65 `stat_unk1_5` int(11) NOT NULL DEFAULT 0,
66 `stat_unk2_5` int(11) NOT NULL DEFAULT 0,
67 `stat_type6` tinyint(3) NOT NULL DEFAULT 0,
68 `stat_value6` mediumint(9) NOT NULL DEFAULT 0,
69 `stat_unk1_6` int(11) NOT NULL DEFAULT 0,
70 `stat_unk2_6` int(11) NOT NULL DEFAULT 0,
71 `stat_type7` tinyint(3) NOT NULL DEFAULT 0,
72 `stat_value7` int(11) NOT NULL DEFAULT 0,
73 `stat_unk1_7` int(11) NOT NULL DEFAULT 0,
74 `stat_unk2_7` int(11) NOT NULL DEFAULT 0,
75 `stat_type8` tinyint(3) NOT NULL DEFAULT 0,
76 `stat_value8` int(11) NOT NULL DEFAULT 0,
77 `stat_unk1_8` int(11) NOT NULL DEFAULT 0,
78 `stat_unk2_8` int(11) NOT NULL DEFAULT 0,
79 `stat_type9` tinyint(3) NOT NULL DEFAULT 0,
80 `stat_value9` int(11) NOT NULL DEFAULT 0,
81 `stat_unk1_9` int(11) NOT NULL DEFAULT 0,
82 `stat_unk2_9` int(11) NOT NULL DEFAULT 0,
83 `stat_type10` tinyint(3) NOT NULL DEFAULT 0,
84 `stat_value10` int(11) NOT NULL DEFAULT 0,
85 `stat_unk1_10` int(11) NOT NULL DEFAULT 0,
86 `stat_unk2_10` int(11) NOT NULL DEFAULT 0,
87 `ScalingStatDistribution` smallint(6) NOT NULL DEFAULT 0,
88 `ScalingStatValue` smallint(6) NOT NULL DEFAULT 0,
89 `RequiredDisenchantSkill` smallint(6) NOT NULL DEFAULT 0,
90 `DamageType` tinyint(3) unsigned NOT NULL DEFAULT 0,
91 `delay` int(10) unsigned NOT NULL DEFAULT 1000,
92 `RangedModRange` float NOT NULL DEFAULT 0,
93 `spellid_1` int(11) NOT NULL DEFAULT 0,
94 `spelltrigger_1` int(10) unsigned NOT NULL DEFAULT 0,
95 `spellcharges_1` int(11) DEFAULT NULL,
96 `spellcooldown_1` int(11) NOT NULL DEFAULT -1,
97 `spellcategory_1` int(10) unsigned NOT NULL DEFAULT 0,
98 `spellcategorycooldown_1` int(11) NOT NULL DEFAULT -1,
99 `spellid_2` int(11) NOT NULL DEFAULT 0,
100 `spelltrigger_2` int(10) unsigned NOT NULL DEFAULT 0,
101 `spellcharges_2` int(11) DEFAULT NULL,
102 `spellcooldown_2` int(11) NOT NULL DEFAULT -1,
103 `spellcategory_2` int(10) unsigned NOT NULL DEFAULT 0,
104 `spellcategorycooldown_2` int(11) NOT NULL DEFAULT -1,
105 `spellid_3` bigint(20) NOT NULL DEFAULT 0,
106 `spelltrigger_3` int(10) unsigned NOT NULL DEFAULT 0,
107 `spellcharges_3` int(11) DEFAULT NULL,
108 `spellcooldown_3` int(11) NOT NULL DEFAULT -1,
109 `spellcategory_3` int(10) unsigned NOT NULL DEFAULT 0,
110 `spellcategorycooldown_3` int(11) NOT NULL DEFAULT -1,
111 `spellid_4` int(11) NOT NULL DEFAULT 0,
112 `spelltrigger_4` int(10) unsigned NOT NULL DEFAULT 0,
113 `spellcharges_4` int(11) DEFAULT NULL,
114 `spellcooldown_4` int(11) NOT NULL DEFAULT -1,
115 `spellcategory_4` int(10) unsigned NOT NULL DEFAULT 0,
116 `spellcategorycooldown_4` int(11) NOT NULL DEFAULT -1,
117 `spellid_5` int(11) NOT NULL DEFAULT 0,
118 `spelltrigger_5` int(10) unsigned NOT NULL DEFAULT 0,
119 `spellcharges_5` int(11) DEFAULT NULL,
120 `spellcooldown_5` int(11) NOT NULL DEFAULT -1,
121 `spellcategory_5` bigint(20) unsigned NOT NULL DEFAULT 0,
122 `spellcategorycooldown_5` int(11) NOT NULL DEFAULT -1,
123 `bonding` int(11) NOT NULL DEFAULT 0,
124 `description` varchar(255) NOT NULL DEFAULT '',
125 `PageText` mediumint(8) unsigned NOT NULL DEFAULT 0,
126 `LanguageID` tinyint(3) unsigned NOT NULL DEFAULT 0,
127 `PageMaterial` tinyint(3) unsigned NOT NULL DEFAULT 0,
128 `startquest` mediumint(8) unsigned NOT NULL DEFAULT 0,
129 `lockid` mediumint(8) unsigned NOT NULL DEFAULT 0,
130 `Material` tinyint(4) NOT NULL DEFAULT 0,
131 `sheath` tinyint(3) unsigned NOT NULL DEFAULT 0,
132 `RandomProperty` mediumint(8) NOT NULL DEFAULT 0,
133 `RandomSuffix` mediumint(8) unsigned NOT NULL DEFAULT 0,
134 `itemset` mediumint(8) unsigned NOT NULL DEFAULT 0,
135 `MaxDurability` smallint(5) unsigned NOT NULL DEFAULT 0,
136 `area` mediumint(8) unsigned NOT NULL DEFAULT 0,
137 `Map` smallint(6) NOT NULL DEFAULT 0,
138 `BagFamily` mediumint(8) NOT NULL DEFAULT 0,
139 `TotemCategory` mediumint(8) NOT NULL DEFAULT 0,
140 `socketColor_1` tinyint(4) NOT NULL DEFAULT 0,
141 `socketContent_1` mediumint(8) NOT NULL DEFAULT 0,
142 `socketColor_2` tinyint(4) NOT NULL DEFAULT 0,
143 `socketContent_2` mediumint(8) NOT NULL DEFAULT 0,
144 `socketColor_3` tinyint(4) NOT NULL DEFAULT 0,
145 `socketContent_3` mediumint(8) NOT NULL DEFAULT 0,
146 `socketBonus` mediumint(8) NOT NULL DEFAULT 0,
147 `GemProperties` mediumint(8) NOT NULL DEFAULT 0,
148 `ArmorDamageModifier` float NOT NULL DEFAULT 0,
149 `duration` int(10) unsigned NOT NULL DEFAULT 0,
150 `ItemLimitCategory` smallint(6) NOT NULL DEFAULT 0,
151 `HolidayId` int(11) unsigned NOT NULL DEFAULT 0,
152 `StatScalingFactor` float NOT NULL DEFAULT 0,
153 `CurrencySubstitutionId` int(10) unsigned NOT NULL DEFAULT 0,
154 `CurrencySubstitutionCount` int(10) unsigned NOT NULL DEFAULT 0,
155 `flagsCustom` int(10) unsigned NOT NULL DEFAULT 0,
156 `ScriptName` text DEFAULT NULL,
157 `verifiedbuild` text DEFAULT NULL,
158 `dmg_min` int(10) unsigned NOT NULL DEFAULT 0,
159 `dmg_max` int(10) unsigned NOT NULL DEFAULT 0,
160 `WDBVerified` smallint(6) DEFAULT 1,
161 PRIMARY KEY (`entry`)
162) ENGINE=MyISAM AUTO_INCREMENT=2000006 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;
163
164-- Data exporting was unselected.
165-- Dumping structure for table doffchar.character_custom_item_templates
166CREATE TABLE IF NOT EXISTS `character_custom_item_templates` (
167 `guid` mediumint(8) unsigned NOT NULL DEFAULT 0,
168 `number` mediumint(8) unsigned NOT NULL DEFAULT 0,
169 `templatename` varchar(255) NOT NULL DEFAULT '',
170 `templateicon` varchar(255) NOT NULL DEFAULT '',
171 `name` varchar(255) NOT NULL DEFAULT '',
172 `class` tinyint(3) unsigned NOT NULL DEFAULT 0,
173 `subclass` tinyint(3) unsigned NOT NULL DEFAULT 0,
174 `SoundOverrideSubclass` tinyint(3) NOT NULL DEFAULT -1,
175 `displayid` mediumint(8) unsigned NOT NULL DEFAULT 0,
176 `Quality` tinyint(3) unsigned NOT NULL DEFAULT 0,
177 `Flags` bigint(20) NOT NULL DEFAULT 0,
178 `FlagsExtra` int(10) unsigned NOT NULL DEFAULT 0,
179 `Flags3` int(10) unsigned NOT NULL DEFAULT 0,
180 `Unk430_1` float unsigned NOT NULL DEFAULT 1,
181 `Unk430_2` float NOT NULL DEFAULT 1,
182 `BuyCount` tinyint(3) unsigned NOT NULL DEFAULT 1,
183 `BuyPrice` bigint(20) NOT NULL DEFAULT 0,
184 `SellPrice` int(10) unsigned NOT NULL DEFAULT 0,
185 `InventoryType` tinyint(3) unsigned NOT NULL DEFAULT 0,
186 `AllowableClass` int(11) NOT NULL DEFAULT -1,
187 `AllowableRace` int(11) NOT NULL DEFAULT -1,
188 `ItemLevel` smallint(5) unsigned NOT NULL DEFAULT 0,
189 `RequiredLevel` tinyint(3) unsigned NOT NULL DEFAULT 0,
190 `RequiredSkill` smallint(5) unsigned NOT NULL DEFAULT 0,
191 `RequiredSkillRank` smallint(5) unsigned NOT NULL DEFAULT 0,
192 `requiredspell` mediumint(8) unsigned NOT NULL DEFAULT 0,
193 `requiredhonorrank` mediumint(8) unsigned NOT NULL DEFAULT 0,
194 `RequiredCityRank` mediumint(8) unsigned NOT NULL DEFAULT 0,
195 `RequiredReputationFaction` smallint(5) unsigned NOT NULL DEFAULT 0,
196 `RequiredReputationRank` smallint(5) unsigned NOT NULL DEFAULT 0,
197 `maxcount` int(11) NOT NULL DEFAULT 0,
198 `stackable` int(11) DEFAULT 1,
199 `ContainerSlots` tinyint(3) unsigned NOT NULL DEFAULT 0,
200 `stat_type1` tinyint(3) NOT NULL DEFAULT 0,
201 `stat_value1` int(11) NOT NULL DEFAULT 0,
202 `stat_unk1_1` int(11) NOT NULL DEFAULT 0,
203 `stat_unk2_1` int(11) NOT NULL DEFAULT 0,
204 `stat_type2` tinyint(3) NOT NULL DEFAULT 0,
205 `stat_value2` int(11) NOT NULL DEFAULT 0,
206 `stat_unk1_2` int(11) NOT NULL DEFAULT 0,
207 `stat_unk2_2` int(11) NOT NULL DEFAULT 0,
208 `stat_type3` tinyint(3) NOT NULL DEFAULT 0,
209 `stat_value3` int(11) NOT NULL DEFAULT 0,
210 `stat_unk1_3` int(11) NOT NULL DEFAULT 0,
211 `stat_unk2_3` int(11) NOT NULL DEFAULT 0,
212 `stat_type4` tinyint(3) NOT NULL DEFAULT 0,
213 `stat_value4` int(11) NOT NULL DEFAULT 0,
214 `stat_unk1_4` int(11) NOT NULL DEFAULT 0,
215 `stat_unk2_4` int(11) NOT NULL DEFAULT 0,
216 `stat_type5` tinyint(3) NOT NULL DEFAULT 0,
217 `stat_value5` int(10) unsigned NOT NULL DEFAULT 0,
218 `stat_unk1_5` int(11) NOT NULL DEFAULT 0,
219 `stat_unk2_5` int(11) NOT NULL DEFAULT 0,
220 `stat_type6` tinyint(3) NOT NULL DEFAULT 0,
221 `stat_value6` mediumint(9) NOT NULL DEFAULT 0,
222 `stat_unk1_6` int(11) NOT NULL DEFAULT 0,
223 `stat_unk2_6` int(11) NOT NULL DEFAULT 0,
224 `stat_type7` tinyint(3) NOT NULL DEFAULT 0,
225 `stat_value7` int(11) NOT NULL DEFAULT 0,
226 `stat_unk1_7` int(11) NOT NULL DEFAULT 0,
227 `stat_unk2_7` int(11) NOT NULL DEFAULT 0,
228 `stat_type8` tinyint(3) NOT NULL DEFAULT 0,
229 `stat_value8` int(11) NOT NULL DEFAULT 0,
230 `stat_unk1_8` int(11) NOT NULL DEFAULT 0,
231 `stat_unk2_8` int(11) NOT NULL DEFAULT 0,
232 `stat_type9` tinyint(3) NOT NULL DEFAULT 0,
233 `stat_value9` int(11) NOT NULL DEFAULT 0,
234 `stat_unk1_9` int(11) NOT NULL DEFAULT 0,
235 `stat_unk2_9` int(11) NOT NULL DEFAULT 0,
236 `stat_type10` tinyint(3) NOT NULL DEFAULT 0,
237 `stat_value10` int(11) NOT NULL DEFAULT 0,
238 `stat_unk1_10` int(11) NOT NULL DEFAULT 0,
239 `stat_unk2_10` int(11) NOT NULL DEFAULT 0,
240 `ScalingStatDistribution` smallint(6) NOT NULL DEFAULT 0,
241 `ScalingStatValue` smallint(6) NOT NULL DEFAULT 0,
242 `RequiredDisenchantSkill` smallint(6) NOT NULL DEFAULT 0,
243 `DamageType` tinyint(3) unsigned NOT NULL DEFAULT 0,
244 `delay` int(10) unsigned NOT NULL DEFAULT 1000,
245 `RangedModRange` float NOT NULL DEFAULT 0,
246 `spellid_1` int(11) NOT NULL DEFAULT 0,
247 `spelltrigger_1` int(10) unsigned NOT NULL DEFAULT 0,
248 `spellcharges_1` int(11) DEFAULT NULL,
249 `spellcooldown_1` int(11) NOT NULL DEFAULT -1,
250 `spellcategory_1` int(10) unsigned NOT NULL DEFAULT 0,
251 `spellcategorycooldown_1` int(11) NOT NULL DEFAULT -1,
252 `spellid_2` int(11) NOT NULL DEFAULT 0,
253 `spelltrigger_2` int(10) unsigned NOT NULL DEFAULT 0,
254 `spellcharges_2` int(11) DEFAULT NULL,
255 `spellcooldown_2` int(11) NOT NULL DEFAULT -1,
256 `spellcategory_2` int(10) unsigned NOT NULL DEFAULT 0,
257 `spellcategorycooldown_2` int(11) NOT NULL DEFAULT -1,
258 `spellid_3` bigint(20) NOT NULL DEFAULT 0,
259 `spelltrigger_3` int(10) unsigned NOT NULL DEFAULT 0,
260 `spellcharges_3` int(11) DEFAULT NULL,
261 `spellcooldown_3` int(11) NOT NULL DEFAULT -1,
262 `spellcategory_3` int(10) unsigned NOT NULL DEFAULT 0,
263 `spellcategorycooldown_3` int(11) NOT NULL DEFAULT -1,
264 `spellid_4` int(11) NOT NULL DEFAULT 0,
265 `spelltrigger_4` int(10) unsigned NOT NULL DEFAULT 0,
266 `spellcharges_4` int(11) DEFAULT NULL,
267 `spellcooldown_4` int(11) NOT NULL DEFAULT -1,
268 `spellcategory_4` int(10) unsigned NOT NULL DEFAULT 0,
269 `spellcategorycooldown_4` int(11) NOT NULL DEFAULT -1,
270 `spellid_5` int(11) NOT NULL DEFAULT 0,
271 `spelltrigger_5` int(10) unsigned NOT NULL DEFAULT 0,
272 `spellcharges_5` int(11) DEFAULT NULL,
273 `spellcooldown_5` int(11) NOT NULL DEFAULT -1,
274 `spellcategory_5` bigint(20) unsigned NOT NULL DEFAULT 0,
275 `spellcategorycooldown_5` int(11) NOT NULL DEFAULT -1,
276 `bonding` tinyint(3) unsigned NOT NULL DEFAULT 0,
277 `description` varchar(255) NOT NULL DEFAULT '',
278 `PageText` mediumint(8) unsigned NOT NULL DEFAULT 0,
279 `LanguageID` tinyint(3) unsigned NOT NULL DEFAULT 0,
280 `PageMaterial` tinyint(3) unsigned NOT NULL DEFAULT 0,
281 `startquest` mediumint(8) unsigned NOT NULL DEFAULT 0,
282 `lockid` mediumint(8) unsigned NOT NULL DEFAULT 0,
283 `Material` tinyint(4) NOT NULL DEFAULT 0,
284 `sheath` tinyint(3) unsigned NOT NULL DEFAULT 0,
285 `RandomProperty` mediumint(8) NOT NULL DEFAULT 0,
286 `RandomSuffix` mediumint(8) unsigned NOT NULL DEFAULT 0,
287 `itemset` mediumint(8) unsigned NOT NULL DEFAULT 0,
288 `MaxDurability` smallint(5) unsigned NOT NULL DEFAULT 0,
289 `area` mediumint(8) unsigned NOT NULL DEFAULT 0,
290 `Map` smallint(6) NOT NULL DEFAULT 0,
291 `BagFamily` mediumint(8) NOT NULL DEFAULT 0,
292 `TotemCategory` mediumint(8) NOT NULL DEFAULT 0,
293 `socketColor_1` tinyint(4) NOT NULL DEFAULT 0,
294 `socketContent_1` mediumint(8) NOT NULL DEFAULT 0,
295 `socketColor_2` tinyint(4) NOT NULL DEFAULT 0,
296 `socketContent_2` mediumint(8) NOT NULL DEFAULT 0,
297 `socketColor_3` tinyint(4) NOT NULL DEFAULT 0,
298 `socketContent_3` mediumint(8) NOT NULL DEFAULT 0,
299 `socketBonus` mediumint(8) NOT NULL DEFAULT 0,
300 `GemProperties` mediumint(8) NOT NULL DEFAULT 0,
301 `ArmorDamageModifier` float NOT NULL DEFAULT 0,
302 `duration` int(10) unsigned NOT NULL DEFAULT 0,
303 `ItemLimitCategory` smallint(6) NOT NULL DEFAULT 0,
304 `HolidayId` int(11) unsigned NOT NULL DEFAULT 0,
305 `StatScalingFactor` float NOT NULL DEFAULT 0,
306 `CurrencySubstitutionId` int(10) unsigned NOT NULL DEFAULT 0,
307 `CurrencySubstitutionCount` int(10) unsigned NOT NULL DEFAULT 0,
308 `flagsCustom` int(10) unsigned NOT NULL DEFAULT 0,
309 `ScriptName` text DEFAULT NULL,
310 `verifiedbuild` text DEFAULT NULL,
311 `dmg_min` int(10) unsigned NOT NULL DEFAULT 0,
312 `dmg_max` int(10) unsigned NOT NULL DEFAULT 0,
313 `WDBVerified` smallint(6) DEFAULT 1
314) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;
315
316-- Data exporting was unselected.
317-- Dumping structure for table doffchar.donation_store_logs
318CREATE TABLE IF NOT EXISTS `donation_store_logs` (
319 `guid` int(10) unsigned NOT NULL,
320 `player` text NOT NULL,
321 `item` text NOT NULL,
322 `price` bigint(20) unsigned NOT NULL,
323 `olddp` bigint(20) unsigned NOT NULL,
324 `newdp` bigint(20) unsigned NOT NULL,
325 `time` text NOT NULL
326) ENGINE=InnoDB DEFAULT CHARSET=utf8;
327
328-- Data exporting was unselected.
329/*!40101 SET SQL_MODE=IFNULL(@OLD_SQL_MODE, '') */;
330/*!40014 SET FOREIGN_KEY_CHECKS=IF(@OLD_FOREIGN_KEY_CHECKS IS NULL, 1, @OLD_FOREIGN_KEY_CHECKS) */;
331/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;