1 | -- MySQL dump 10.11 |
---|
2 | -- |
---|
3 | -- Host: localhost Database: characters |
---|
4 | -- ------------------------------------------------------ |
---|
5 | -- Server version 5.0.34-log |
---|
6 | |
---|
7 | /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; |
---|
8 | /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; |
---|
9 | /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; |
---|
10 | /*!40101 SET NAMES utf8 */; |
---|
11 | /*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */; |
---|
12 | /*!40103 SET TIME_ZONE='+00:00' */; |
---|
13 | /*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */; |
---|
14 | /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */; |
---|
15 | /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */; |
---|
16 | /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; |
---|
17 | |
---|
18 | -- |
---|
19 | -- Table structure for table `arena_team` |
---|
20 | -- |
---|
21 | |
---|
22 | DROP TABLE IF EXISTS `arena_team`; |
---|
23 | CREATE TABLE `arena_team` ( |
---|
24 | `arenateamid` int(10) unsigned NOT NULL default '0', |
---|
25 | `name` char(255) NOT NULL, |
---|
26 | `captainguid` int(10) unsigned NOT NULL default '0', |
---|
27 | `type` tinyint(3) unsigned NOT NULL default '0', |
---|
28 | `BackgroundColor` int(10) unsigned NOT NULL default '0', |
---|
29 | `EmblemStyle` int(10) unsigned NOT NULL default '0', |
---|
30 | `EmblemColor` int(10) unsigned NOT NULL default '0', |
---|
31 | `BorderStyle` int(10) unsigned NOT NULL default '0', |
---|
32 | `BorderColor` int(10) unsigned NOT NULL default '0', |
---|
33 | PRIMARY KEY (`arenateamid`) |
---|
34 | ) ENGINE=InnoDB DEFAULT CHARSET=utf8; |
---|
35 | |
---|
36 | -- |
---|
37 | -- Dumping data for table `arena_team` |
---|
38 | -- |
---|
39 | |
---|
40 | LOCK TABLES `arena_team` WRITE; |
---|
41 | /*!40000 ALTER TABLE `arena_team` DISABLE KEYS */; |
---|
42 | /*!40000 ALTER TABLE `arena_team` ENABLE KEYS */; |
---|
43 | UNLOCK TABLES; |
---|
44 | |
---|
45 | -- |
---|
46 | -- Table structure for table `arena_team_member` |
---|
47 | -- |
---|
48 | |
---|
49 | DROP TABLE IF EXISTS `arena_team_member`; |
---|
50 | CREATE TABLE `arena_team_member` ( |
---|
51 | `arenateamid` int(10) unsigned NOT NULL default '0', |
---|
52 | `guid` int(10) unsigned NOT NULL default '0', |
---|
53 | `played_week` int(10) unsigned NOT NULL default '0', |
---|
54 | `wons_week` int(10) unsigned NOT NULL default '0', |
---|
55 | `played_season` int(10) unsigned NOT NULL default '0', |
---|
56 | `wons_season` int(10) unsigned NOT NULL default '0', |
---|
57 | `points_to_add` int(10) unsigned NOT NULL default '0' |
---|
58 | ) ENGINE=InnoDB DEFAULT CHARSET=utf8; |
---|
59 | |
---|
60 | -- |
---|
61 | -- Dumping data for table `arena_team_member` |
---|
62 | -- |
---|
63 | |
---|
64 | LOCK TABLES `arena_team_member` WRITE; |
---|
65 | /*!40000 ALTER TABLE `arena_team_member` DISABLE KEYS */; |
---|
66 | /*!40000 ALTER TABLE `arena_team_member` ENABLE KEYS */; |
---|
67 | UNLOCK TABLES; |
---|
68 | |
---|
69 | -- |
---|
70 | -- Table structure for table `arena_team_stats` |
---|
71 | -- |
---|
72 | |
---|
73 | DROP TABLE IF EXISTS `arena_team_stats`; |
---|
74 | CREATE TABLE `arena_team_stats` ( |
---|
75 | `arenateamid` int(10) unsigned NOT NULL default '0', |
---|
76 | `rating` int(10) unsigned NOT NULL default '0', |
---|
77 | `games` int(10) unsigned NOT NULL default '0', |
---|
78 | `wins` int(10) unsigned NOT NULL default '0', |
---|
79 | `played` int(10) unsigned NOT NULL default '0', |
---|
80 | `wins2` int(10) unsigned NOT NULL default '0', |
---|
81 | `rank` int(10) unsigned NOT NULL default '0', |
---|
82 | PRIMARY KEY (`arenateamid`) |
---|
83 | ) ENGINE=InnoDB DEFAULT CHARSET=utf8; |
---|
84 | |
---|
85 | -- |
---|
86 | -- Dumping data for table `arena_team_stats` |
---|
87 | -- |
---|
88 | |
---|
89 | LOCK TABLES `arena_team_stats` WRITE; |
---|
90 | /*!40000 ALTER TABLE `arena_team_stats` DISABLE KEYS */; |
---|
91 | /*!40000 ALTER TABLE `arena_team_stats` ENABLE KEYS */; |
---|
92 | UNLOCK TABLES; |
---|
93 | |
---|
94 | -- |
---|
95 | -- Table structure for table `auctionhouse` |
---|
96 | -- |
---|
97 | |
---|
98 | DROP TABLE IF EXISTS `auctionhouse`; |
---|
99 | CREATE TABLE `auctionhouse` ( |
---|
100 | `id` int(11) unsigned NOT NULL default '0', |
---|
101 | `auctioneerguid` int(11) unsigned NOT NULL default '0', |
---|
102 | `itemguid` int(11) unsigned NOT NULL default '0', |
---|
103 | `item_template` int(11) unsigned NOT NULL default '0' COMMENT 'Item Identifier', |
---|
104 | `itemowner` int(11) unsigned NOT NULL default '0', |
---|
105 | `buyoutprice` int(11) NOT NULL default '0', |
---|
106 | `time` bigint(40) NOT NULL default '0', |
---|
107 | `buyguid` int(11) unsigned NOT NULL default '0', |
---|
108 | `lastbid` int(11) NOT NULL default '0', |
---|
109 | `startbid` int(11) NOT NULL default '0', |
---|
110 | `deposit` int(11) NOT NULL default '0', |
---|
111 | `location` tinyint(3) unsigned NOT NULL default '3', |
---|
112 | PRIMARY KEY (`id`), |
---|
113 | UNIQUE KEY `item_guid` (`itemguid`) |
---|
114 | ) ENGINE=InnoDB DEFAULT CHARSET=utf8; |
---|
115 | |
---|
116 | -- |
---|
117 | -- Dumping data for table `auctionhouse` |
---|
118 | -- |
---|
119 | |
---|
120 | LOCK TABLES `auctionhouse` WRITE; |
---|
121 | /*!40000 ALTER TABLE `auctionhouse` DISABLE KEYS */; |
---|
122 | /*!40000 ALTER TABLE `auctionhouse` ENABLE KEYS */; |
---|
123 | UNLOCK TABLES; |
---|
124 | |
---|
125 | -- |
---|
126 | -- Table structure for table `bugreport` |
---|
127 | -- |
---|
128 | |
---|
129 | DROP TABLE IF EXISTS `bugreport`; |
---|
130 | CREATE TABLE `bugreport` ( |
---|
131 | `id` int(11) NOT NULL auto_increment COMMENT 'Identifier', |
---|
132 | `type` varchar(255) NOT NULL default '', |
---|
133 | `content` varchar(255) NOT NULL default '', |
---|
134 | PRIMARY KEY (`id`) |
---|
135 | ) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Debug System'; |
---|
136 | |
---|
137 | -- |
---|
138 | -- Dumping data for table `bugreport` |
---|
139 | -- |
---|
140 | |
---|
141 | LOCK TABLES `bugreport` WRITE; |
---|
142 | /*!40000 ALTER TABLE `bugreport` DISABLE KEYS */; |
---|
143 | /*!40000 ALTER TABLE `bugreport` ENABLE KEYS */; |
---|
144 | UNLOCK TABLES; |
---|
145 | |
---|
146 | -- |
---|
147 | -- Table structure for table `character_action` |
---|
148 | -- |
---|
149 | |
---|
150 | DROP TABLE IF EXISTS `character_action`; |
---|
151 | CREATE TABLE `character_action` ( |
---|
152 | `guid` int(11) unsigned NOT NULL default '0' COMMENT 'Global Unique Identifier', |
---|
153 | `button` tinyint(3) unsigned NOT NULL default '0', |
---|
154 | `action` smallint(5) unsigned NOT NULL default '0', |
---|
155 | `type` tinyint(3) unsigned NOT NULL default '0', |
---|
156 | `misc` tinyint(3) unsigned NOT NULL default '0', |
---|
157 | PRIMARY KEY (`guid`,`button`) |
---|
158 | ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Player System'; |
---|
159 | |
---|
160 | -- |
---|
161 | -- Dumping data for table `character_action` |
---|
162 | -- |
---|
163 | |
---|
164 | LOCK TABLES `character_action` WRITE; |
---|
165 | /*!40000 ALTER TABLE `character_action` DISABLE KEYS */; |
---|
166 | /*!40000 ALTER TABLE `character_action` ENABLE KEYS */; |
---|
167 | UNLOCK TABLES; |
---|
168 | |
---|
169 | -- |
---|
170 | -- Table structure for table `character_aura` |
---|
171 | -- |
---|
172 | |
---|
173 | DROP TABLE IF EXISTS `character_aura`; |
---|
174 | CREATE TABLE `character_aura` ( |
---|
175 | `guid` int(11) unsigned NOT NULL default '0' COMMENT 'Global Unique Identifier', |
---|
176 | `caster_guid` bigint(20) unsigned NOT NULL default '0' COMMENT 'Full Global Unique Identifier', |
---|
177 | `spell` int(11) unsigned NOT NULL default '0', |
---|
178 | `effect_index` int(11) unsigned NOT NULL default '0', |
---|
179 | `amount` int(11) NOT NULL default '0', |
---|
180 | `maxduration` int(11) NOT NULL default '0', |
---|
181 | `remaintime` int(11) NOT NULL default '0', |
---|
182 | `remaincharges` int(11) NOT NULL default '0', |
---|
183 | PRIMARY KEY (`guid`,`spell`,`effect_index`) |
---|
184 | ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Player System'; |
---|
185 | |
---|
186 | -- |
---|
187 | -- Dumping data for table `character_aura` |
---|
188 | -- |
---|
189 | |
---|
190 | LOCK TABLES `character_aura` WRITE; |
---|
191 | /*!40000 ALTER TABLE `character_aura` DISABLE KEYS */; |
---|
192 | /*!40000 ALTER TABLE `character_aura` ENABLE KEYS */; |
---|
193 | UNLOCK TABLES; |
---|
194 | |
---|
195 | -- |
---|
196 | -- Table structure for table `character_declinedname` |
---|
197 | -- |
---|
198 | |
---|
199 | DROP TABLE IF EXISTS `character_declinedname`; |
---|
200 | CREATE TABLE `character_declinedname` ( |
---|
201 | `guid` int(11) unsigned NOT NULL default '0' COMMENT 'Global Unique Identifier', |
---|
202 | `genitive` varchar(15) NOT NULL default '', |
---|
203 | `dative` varchar(15) NOT NULL default '', |
---|
204 | `accusative` varchar(15) NOT NULL default '', |
---|
205 | `instrumental` varchar(15) NOT NULL default '', |
---|
206 | `prepositional` varchar(15) NOT NULL default '', |
---|
207 | PRIMARY KEY (`guid`) |
---|
208 | ) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC; |
---|
209 | |
---|
210 | -- |
---|
211 | -- Dumping data for table `character_declinedname` |
---|
212 | -- |
---|
213 | |
---|
214 | LOCK TABLES `character_declinedname` WRITE; |
---|
215 | /*!40000 ALTER TABLE `character_declinedname` DISABLE KEYS */; |
---|
216 | /*!40000 ALTER TABLE `character_declinedname` ENABLE KEYS */; |
---|
217 | UNLOCK TABLES; |
---|
218 | |
---|
219 | -- |
---|
220 | -- Table structure for table `character_gifts` |
---|
221 | -- |
---|
222 | |
---|
223 | DROP TABLE IF EXISTS `character_gifts`; |
---|
224 | CREATE TABLE `character_gifts` ( |
---|
225 | `guid` int(20) unsigned NOT NULL default '0', |
---|
226 | `item_guid` int(11) unsigned NOT NULL default '0', |
---|
227 | `entry` int(20) unsigned NOT NULL default '0', |
---|
228 | `flags` int(20) unsigned NOT NULL default '0', |
---|
229 | PRIMARY KEY (`item_guid`), |
---|
230 | KEY `idx_guid` (`guid`) |
---|
231 | ) ENGINE=InnoDB DEFAULT CHARSET=utf8; |
---|
232 | |
---|
233 | -- |
---|
234 | -- Dumping data for table `character_gifts` |
---|
235 | -- |
---|
236 | |
---|
237 | LOCK TABLES `character_gifts` WRITE; |
---|
238 | /*!40000 ALTER TABLE `character_gifts` DISABLE KEYS */; |
---|
239 | /*!40000 ALTER TABLE `character_gifts` ENABLE KEYS */; |
---|
240 | UNLOCK TABLES; |
---|
241 | |
---|
242 | -- |
---|
243 | -- Table structure for table `character_homebind` |
---|
244 | -- |
---|
245 | |
---|
246 | DROP TABLE IF EXISTS `character_homebind`; |
---|
247 | CREATE TABLE `character_homebind` ( |
---|
248 | `guid` int(11) unsigned NOT NULL default '0' COMMENT 'Global Unique Identifier', |
---|
249 | `map` int(11) unsigned NOT NULL default '0' COMMENT 'Map Identifier', |
---|
250 | `zone` int(11) unsigned NOT NULL default '0' COMMENT 'Zone Identifier', |
---|
251 | `position_x` float NOT NULL default '0', |
---|
252 | `position_y` float NOT NULL default '0', |
---|
253 | `position_z` float NOT NULL default '0', |
---|
254 | PRIMARY KEY (`guid`) |
---|
255 | ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Player System'; |
---|
256 | |
---|
257 | -- |
---|
258 | -- Dumping data for table `character_homebind` |
---|
259 | -- |
---|
260 | |
---|
261 | LOCK TABLES `character_homebind` WRITE; |
---|
262 | /*!40000 ALTER TABLE `character_homebind` DISABLE KEYS */; |
---|
263 | /*!40000 ALTER TABLE `character_homebind` ENABLE KEYS */; |
---|
264 | UNLOCK TABLES; |
---|
265 | |
---|
266 | -- |
---|
267 | -- Table structure for table `character_instance` |
---|
268 | -- |
---|
269 | |
---|
270 | DROP TABLE IF EXISTS `character_instance`; |
---|
271 | CREATE TABLE `character_instance` ( |
---|
272 | `guid` int(11) unsigned NOT NULL default '0', |
---|
273 | `instance` int(11) unsigned NOT NULL default '0', |
---|
274 | `permanent` tinyint(1) unsigned NOT NULL default '0', |
---|
275 | PRIMARY KEY (`guid`,`instance`), |
---|
276 | KEY `instance` (`instance`) |
---|
277 | ) ENGINE=InnoDB DEFAULT CHARSET=utf8; |
---|
278 | |
---|
279 | -- |
---|
280 | -- Dumping data for table `character_instance` |
---|
281 | -- |
---|
282 | |
---|
283 | LOCK TABLES `character_instance` WRITE; |
---|
284 | /*!40000 ALTER TABLE `character_instance` DISABLE KEYS */; |
---|
285 | /*!40000 ALTER TABLE `character_instance` ENABLE KEYS */; |
---|
286 | UNLOCK TABLES; |
---|
287 | |
---|
288 | -- |
---|
289 | -- Table structure for table `character_inventory` |
---|
290 | -- |
---|
291 | |
---|
292 | DROP TABLE IF EXISTS `character_inventory`; |
---|
293 | CREATE TABLE `character_inventory` ( |
---|
294 | `guid` int(11) unsigned NOT NULL default '0' COMMENT 'Global Unique Identifier', |
---|
295 | `bag` int(11) unsigned NOT NULL default '0', |
---|
296 | `slot` tinyint(3) unsigned NOT NULL default '0', |
---|
297 | `item` int(11) unsigned NOT NULL default '0' COMMENT 'Item Global Unique Identifier', |
---|
298 | `item_template` int(11) unsigned NOT NULL default '0' COMMENT 'Item Identifier', |
---|
299 | PRIMARY KEY (`item`), |
---|
300 | KEY `idx_guid` (`guid`) |
---|
301 | ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Player System'; |
---|
302 | |
---|
303 | -- |
---|
304 | -- Dumping data for table `character_inventory` |
---|
305 | -- |
---|
306 | |
---|
307 | LOCK TABLES `character_inventory` WRITE; |
---|
308 | /*!40000 ALTER TABLE `character_inventory` DISABLE KEYS */; |
---|
309 | /*!40000 ALTER TABLE `character_inventory` ENABLE KEYS */; |
---|
310 | UNLOCK TABLES; |
---|
311 | |
---|
312 | -- |
---|
313 | -- Table structure for table `character_pet` |
---|
314 | -- |
---|
315 | |
---|
316 | DROP TABLE IF EXISTS `character_pet`; |
---|
317 | CREATE TABLE `character_pet` ( |
---|
318 | `id` int(11) unsigned NOT NULL default '0', |
---|
319 | `entry` int(11) unsigned NOT NULL default '0', |
---|
320 | `owner` int(11) unsigned NOT NULL default '0', |
---|
321 | `modelid` int(11) unsigned default '0', |
---|
322 | `CreatedBySpell` int(11) unsigned NOT NULL default '0', |
---|
323 | `PetType` tinyint(3) unsigned NOT NULL default '0', |
---|
324 | `level` int(11) unsigned NOT NULL default '1', |
---|
325 | `exp` int(11) unsigned NOT NULL default '0', |
---|
326 | `Reactstate` tinyint(1) unsigned NOT NULL default '0', |
---|
327 | `loyaltypoints` int(11) NOT NULL default '0', |
---|
328 | `loyalty` int(11) unsigned NOT NULL default '0', |
---|
329 | `trainpoint` int(11) NOT NULL default '0', |
---|
330 | `name` varchar(100) default 'Pet', |
---|
331 | `renamed` tinyint(1) unsigned NOT NULL default '0', |
---|
332 | `slot` int(11) unsigned NOT NULL default '0', |
---|
333 | `curhealth` int(11) unsigned NOT NULL default '1', |
---|
334 | `curmana` int(11) unsigned NOT NULL default '0', |
---|
335 | `curhappiness` int(11) unsigned NOT NULL default '0', |
---|
336 | `savetime` bigint(20) unsigned NOT NULL default '0', |
---|
337 | `resettalents_cost` int(11) unsigned NOT NULL default '0', |
---|
338 | `resettalents_time` bigint(20) unsigned NOT NULL default '0', |
---|
339 | `abdata` longtext, |
---|
340 | `teachspelldata` longtext, |
---|
341 | PRIMARY KEY (`id`), |
---|
342 | KEY `owner` (`owner`) |
---|
343 | ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Pet System'; |
---|
344 | |
---|
345 | -- |
---|
346 | -- Dumping data for table `character_pet` |
---|
347 | -- |
---|
348 | |
---|
349 | LOCK TABLES `character_pet` WRITE; |
---|
350 | /*!40000 ALTER TABLE `character_pet` DISABLE KEYS */; |
---|
351 | /*!40000 ALTER TABLE `character_pet` ENABLE KEYS */; |
---|
352 | UNLOCK TABLES; |
---|
353 | |
---|
354 | -- |
---|
355 | -- Table structure for table `character_pet_declinedname` |
---|
356 | -- |
---|
357 | |
---|
358 | DROP TABLE IF EXISTS `character_pet_declinedname`; |
---|
359 | CREATE TABLE `character_pet_declinedname` ( |
---|
360 | `id` int(11) unsigned NOT NULL default '0', |
---|
361 | `owner` int(11) unsigned NOT NULL default '0', |
---|
362 | `genitive` varchar(12) NOT NULL default '', |
---|
363 | `dative` varchar(12) NOT NULL default '', |
---|
364 | `accusative` varchar(12) NOT NULL default '', |
---|
365 | `instrumental` varchar(12) NOT NULL default '', |
---|
366 | `prepositional` varchar(12) NOT NULL default '', |
---|
367 | PRIMARY KEY (`id`), |
---|
368 | KEY `owner_key` (`owner`) |
---|
369 | ) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC; |
---|
370 | |
---|
371 | -- |
---|
372 | -- Dumping data for table `character_pet_declinedname` |
---|
373 | -- |
---|
374 | |
---|
375 | LOCK TABLES `character_pet_declinedname` WRITE; |
---|
376 | /*!40000 ALTER TABLE `character_pet_declinedname` DISABLE KEYS */; |
---|
377 | /*!40000 ALTER TABLE `character_pet_declinedname` ENABLE KEYS */; |
---|
378 | UNLOCK TABLES; |
---|
379 | |
---|
380 | -- |
---|
381 | -- Table structure for table `character_queststatus` |
---|
382 | -- |
---|
383 | |
---|
384 | DROP TABLE IF EXISTS `character_queststatus`; |
---|
385 | CREATE TABLE `character_queststatus` ( |
---|
386 | `guid` int(11) unsigned NOT NULL default '0' COMMENT 'Global Unique Identifier', |
---|
387 | `quest` int(11) unsigned NOT NULL default '0' COMMENT 'Quest Identifier', |
---|
388 | `status` int(11) unsigned NOT NULL default '0', |
---|
389 | `rewarded` tinyint(1) unsigned NOT NULL default '0', |
---|
390 | `explored` tinyint(1) unsigned NOT NULL default '0', |
---|
391 | `timer` bigint(20) unsigned NOT NULL default '0', |
---|
392 | `mobcount1` int(11) unsigned NOT NULL default '0', |
---|
393 | `mobcount2` int(11) unsigned NOT NULL default '0', |
---|
394 | `mobcount3` int(11) unsigned NOT NULL default '0', |
---|
395 | `mobcount4` int(11) unsigned NOT NULL default '0', |
---|
396 | `itemcount1` int(11) unsigned NOT NULL default '0', |
---|
397 | `itemcount2` int(11) unsigned NOT NULL default '0', |
---|
398 | `itemcount3` int(11) unsigned NOT NULL default '0', |
---|
399 | `itemcount4` int(11) unsigned NOT NULL default '0', |
---|
400 | PRIMARY KEY (`guid`,`quest`) |
---|
401 | ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Player System'; |
---|
402 | |
---|
403 | -- |
---|
404 | -- Dumping data for table `character_queststatus` |
---|
405 | -- |
---|
406 | |
---|
407 | LOCK TABLES `character_queststatus` WRITE; |
---|
408 | /*!40000 ALTER TABLE `character_queststatus` DISABLE KEYS */; |
---|
409 | /*!40000 ALTER TABLE `character_queststatus` ENABLE KEYS */; |
---|
410 | UNLOCK TABLES; |
---|
411 | |
---|
412 | -- |
---|
413 | -- Table structure for table `character_queststatus_daily` |
---|
414 | -- |
---|
415 | |
---|
416 | DROP TABLE IF EXISTS `character_queststatus_daily`; |
---|
417 | CREATE TABLE `character_queststatus_daily` ( |
---|
418 | `guid` int(11) unsigned NOT NULL default '0' COMMENT 'Global Unique Identifier', |
---|
419 | `quest` int(11) unsigned NOT NULL default '0' COMMENT 'Quest Identifier', |
---|
420 | `time` bigint(20) unsigned NOT NULL default '0', |
---|
421 | PRIMARY KEY (`guid`,`quest`), |
---|
422 | KEY `idx_guid` (`guid`) |
---|
423 | ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Player System'; |
---|
424 | |
---|
425 | -- |
---|
426 | -- Dumping data for table `character_queststatus_daily` |
---|
427 | -- |
---|
428 | |
---|
429 | LOCK TABLES `character_queststatus_daily` WRITE; |
---|
430 | /*!40000 ALTER TABLE `character_queststatus_daily` DISABLE KEYS */; |
---|
431 | /*!40000 ALTER TABLE `character_queststatus_daily` ENABLE KEYS */; |
---|
432 | UNLOCK TABLES; |
---|
433 | |
---|
434 | -- |
---|
435 | -- Table structure for table `character_reputation` |
---|
436 | -- |
---|
437 | |
---|
438 | DROP TABLE IF EXISTS `character_reputation`; |
---|
439 | CREATE TABLE `character_reputation` ( |
---|
440 | `guid` int(11) unsigned NOT NULL default '0' COMMENT 'Global Unique Identifier', |
---|
441 | `faction` int(11) unsigned NOT NULL default '0', |
---|
442 | `standing` int(11) NOT NULL default '0', |
---|
443 | `flags` int(11) NOT NULL default '0', |
---|
444 | PRIMARY KEY (`guid`,`faction`) |
---|
445 | ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Player System'; |
---|
446 | |
---|
447 | -- |
---|
448 | -- Dumping data for table `character_reputation` |
---|
449 | -- |
---|
450 | |
---|
451 | LOCK TABLES `character_reputation` WRITE; |
---|
452 | /*!40000 ALTER TABLE `character_reputation` DISABLE KEYS */; |
---|
453 | /*!40000 ALTER TABLE `character_reputation` ENABLE KEYS */; |
---|
454 | UNLOCK TABLES; |
---|
455 | |
---|
456 | -- |
---|
457 | -- Table structure for table `character_social` |
---|
458 | -- |
---|
459 | |
---|
460 | DROP TABLE IF EXISTS `character_social`; |
---|
461 | CREATE TABLE `character_social` ( |
---|
462 | `guid` int(11) unsigned NOT NULL default '0' COMMENT 'Character Global Unique Identifier', |
---|
463 | `friend` int(11) unsigned NOT NULL default '0' COMMENT 'Friend Global Unique Identifier', |
---|
464 | `flags` tinyint(1) unsigned NOT NULL default '0' COMMENT 'Friend Flags', |
---|
465 | `note` varchar(48) NOT NULL default '' COMMENT 'Friend Note', |
---|
466 | PRIMARY KEY (`guid`,`friend`,`flags`), |
---|
467 | KEY `guid` (`guid`), |
---|
468 | KEY `friend` (`friend`), |
---|
469 | KEY `guid_flags` (`guid`,`flags`), |
---|
470 | KEY `friend_flags` (`friend`,`flags`) |
---|
471 | ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Player System'; |
---|
472 | |
---|
473 | -- |
---|
474 | -- Dumping data for table `character_social` |
---|
475 | -- |
---|
476 | |
---|
477 | LOCK TABLES `character_social` WRITE; |
---|
478 | /*!40000 ALTER TABLE `character_social` DISABLE KEYS */; |
---|
479 | /*!40000 ALTER TABLE `character_social` ENABLE KEYS */; |
---|
480 | UNLOCK TABLES; |
---|
481 | |
---|
482 | -- |
---|
483 | -- Table structure for table `character_spell` |
---|
484 | -- |
---|
485 | |
---|
486 | DROP TABLE IF EXISTS `character_spell`; |
---|
487 | CREATE TABLE `character_spell` ( |
---|
488 | `guid` int(11) unsigned NOT NULL default '0' COMMENT 'Global Unique Identifier', |
---|
489 | `spell` int(11) unsigned NOT NULL default '0' COMMENT 'Spell Identifier', |
---|
490 | `slot` int(11) unsigned NOT NULL default '0', |
---|
491 | `active` tinyint(3) unsigned NOT NULL default '1', |
---|
492 | `disabled` tinyint(3) unsigned NOT NULL default '0', |
---|
493 | PRIMARY KEY (`guid`,`spell`) |
---|
494 | ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Player System'; |
---|
495 | |
---|
496 | -- |
---|
497 | -- Dumping data for table `character_spell` |
---|
498 | -- |
---|
499 | |
---|
500 | LOCK TABLES `character_spell` WRITE; |
---|
501 | /*!40000 ALTER TABLE `character_spell` DISABLE KEYS */; |
---|
502 | /*!40000 ALTER TABLE `character_spell` ENABLE KEYS */; |
---|
503 | UNLOCK TABLES; |
---|
504 | |
---|
505 | -- |
---|
506 | -- Table structure for table `character_spell_cooldown` |
---|
507 | -- |
---|
508 | |
---|
509 | DROP TABLE IF EXISTS `character_spell_cooldown`; |
---|
510 | CREATE TABLE `character_spell_cooldown` ( |
---|
511 | `guid` int(11) unsigned NOT NULL default '0' COMMENT 'Global Unique Identifier, Low part', |
---|
512 | `spell` int(11) unsigned NOT NULL default '0' COMMENT 'Spell Identifier', |
---|
513 | `item` int(11) unsigned NOT NULL default '0' COMMENT 'Item Identifier', |
---|
514 | `time` bigint(20) unsigned NOT NULL default '0', |
---|
515 | PRIMARY KEY (`guid`,`spell`) |
---|
516 | ) ENGINE=InnoDB DEFAULT CHARSET=utf8; |
---|
517 | |
---|
518 | -- |
---|
519 | -- Dumping data for table `character_spell_cooldown` |
---|
520 | -- |
---|
521 | |
---|
522 | LOCK TABLES `character_spell_cooldown` WRITE; |
---|
523 | /*!40000 ALTER TABLE `character_spell_cooldown` DISABLE KEYS */; |
---|
524 | /*!40000 ALTER TABLE `character_spell_cooldown` ENABLE KEYS */; |
---|
525 | UNLOCK TABLES; |
---|
526 | |
---|
527 | -- |
---|
528 | -- Table structure for table `character_ticket` |
---|
529 | -- |
---|
530 | |
---|
531 | DROP TABLE IF EXISTS `character_ticket`; |
---|
532 | CREATE TABLE `character_ticket` ( |
---|
533 | `ticket_id` int(11) unsigned NOT NULL auto_increment, |
---|
534 | `guid` int(11) unsigned NOT NULL default '0', |
---|
535 | `ticket_text` text, |
---|
536 | `ticket_lastchange` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, |
---|
537 | PRIMARY KEY (`ticket_id`) |
---|
538 | ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Player System'; |
---|
539 | |
---|
540 | -- |
---|
541 | -- Dumping data for table `character_ticket` |
---|
542 | -- |
---|
543 | |
---|
544 | LOCK TABLES `character_ticket` WRITE; |
---|
545 | /*!40000 ALTER TABLE `character_ticket` DISABLE KEYS */; |
---|
546 | /*!40000 ALTER TABLE `character_ticket` ENABLE KEYS */; |
---|
547 | UNLOCK TABLES; |
---|
548 | |
---|
549 | -- |
---|
550 | -- Table structure for table `character_tutorial` |
---|
551 | -- |
---|
552 | |
---|
553 | DROP TABLE IF EXISTS `character_tutorial`; |
---|
554 | CREATE TABLE `character_tutorial` ( |
---|
555 | `account` bigint(20) unsigned NOT NULL auto_increment COMMENT 'Account Identifier', |
---|
556 | `realmid` int(11) unsigned NOT NULL default '0' COMMENT 'Realm Identifier', |
---|
557 | `tut0` int(11) unsigned NOT NULL default '0', |
---|
558 | `tut1` int(11) unsigned NOT NULL default '0', |
---|
559 | `tut2` int(11) unsigned NOT NULL default '0', |
---|
560 | `tut3` int(11) unsigned NOT NULL default '0', |
---|
561 | `tut4` int(11) unsigned NOT NULL default '0', |
---|
562 | `tut5` int(11) unsigned NOT NULL default '0', |
---|
563 | `tut6` int(11) unsigned NOT NULL default '0', |
---|
564 | `tut7` int(11) unsigned NOT NULL default '0', |
---|
565 | PRIMARY KEY (`account`,`realmid`), |
---|
566 | KEY `acc_key` (`account`) |
---|
567 | ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Player System'; |
---|
568 | |
---|
569 | -- |
---|
570 | -- Dumping data for table `character_tutorial` |
---|
571 | -- |
---|
572 | |
---|
573 | LOCK TABLES `character_tutorial` WRITE; |
---|
574 | /*!40000 ALTER TABLE `character_tutorial` DISABLE KEYS */; |
---|
575 | /*!40000 ALTER TABLE `character_tutorial` ENABLE KEYS */; |
---|
576 | UNLOCK TABLES; |
---|
577 | |
---|
578 | -- |
---|
579 | -- Table structure for table `characters` |
---|
580 | -- |
---|
581 | |
---|
582 | DROP TABLE IF EXISTS `characters`; |
---|
583 | CREATE TABLE `characters` ( |
---|
584 | `guid` int(11) unsigned NOT NULL default '0' COMMENT 'Global Unique Identifier', |
---|
585 | `account` int(11) unsigned NOT NULL default '0' COMMENT 'Account Identifier', |
---|
586 | `data` longtext, |
---|
587 | `name` varchar(12) NOT NULL default '', |
---|
588 | `race` tinyint(3) unsigned NOT NULL default '0', |
---|
589 | `class` tinyint(3) unsigned NOT NULL default '0', |
---|
590 | `position_x` float NOT NULL default '0', |
---|
591 | `position_y` float NOT NULL default '0', |
---|
592 | `position_z` float NOT NULL default '0', |
---|
593 | `map` int(11) unsigned NOT NULL default '0' COMMENT 'Map Identifier', |
---|
594 | `dungeon_difficulty` tinyint(1) unsigned NOT NULL default '0', |
---|
595 | `orientation` float NOT NULL default '0', |
---|
596 | `taximask` longtext, |
---|
597 | `online` tinyint(3) unsigned NOT NULL default '0', |
---|
598 | `cinematic` tinyint(3) unsigned NOT NULL default '0', |
---|
599 | `totaltime` int(11) unsigned NOT NULL default '0', |
---|
600 | `leveltime` int(11) unsigned NOT NULL default '0', |
---|
601 | `logout_time` bigint(20) unsigned NOT NULL default '0', |
---|
602 | `is_logout_resting` tinyint(3) unsigned NOT NULL default '0', |
---|
603 | `rest_bonus` float NOT NULL default '0', |
---|
604 | `resettalents_cost` int(11) unsigned NOT NULL default '0', |
---|
605 | `resettalents_time` bigint(20) unsigned NOT NULL default '0', |
---|
606 | `trans_x` float NOT NULL default '0', |
---|
607 | `trans_y` float NOT NULL default '0', |
---|
608 | `trans_z` float NOT NULL default '0', |
---|
609 | `trans_o` float NOT NULL default '0', |
---|
610 | `transguid` bigint(20) unsigned NOT NULL default '0', |
---|
611 | `extra_flags` tinyint(3) unsigned NOT NULL default '0', |
---|
612 | `stable_slots` tinyint(1) unsigned NOT NULL default '0', |
---|
613 | `at_login` int(11) unsigned NOT NULL default '0', |
---|
614 | `zone` int(11) unsigned NOT NULL default '0', |
---|
615 | `death_expire_time` bigint(20) unsigned NOT NULL default '0', |
---|
616 | `taxi_path` text, |
---|
617 | PRIMARY KEY (`guid`), |
---|
618 | KEY `idx_account` (`account`), |
---|
619 | KEY `idx_online` (`online`), |
---|
620 | KEY `idx_name` (`name`) |
---|
621 | ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Player System'; |
---|
622 | |
---|
623 | -- |
---|
624 | -- Dumping data for table `characters` |
---|
625 | -- |
---|
626 | |
---|
627 | LOCK TABLES `characters` WRITE; |
---|
628 | /*!40000 ALTER TABLE `characters` DISABLE KEYS */; |
---|
629 | /*!40000 ALTER TABLE `characters` ENABLE KEYS */; |
---|
630 | UNLOCK TABLES; |
---|
631 | |
---|
632 | -- |
---|
633 | -- Table structure for table `corpse` |
---|
634 | -- |
---|
635 | |
---|
636 | DROP TABLE IF EXISTS `corpse`; |
---|
637 | CREATE TABLE `corpse` ( |
---|
638 | `guid` int(11) unsigned NOT NULL default '0' COMMENT 'Global Unique Identifier', |
---|
639 | `player` int(11) unsigned NOT NULL default '0' COMMENT 'Character Global Unique Identifier', |
---|
640 | `position_x` float NOT NULL default '0', |
---|
641 | `position_y` float NOT NULL default '0', |
---|
642 | `position_z` float NOT NULL default '0', |
---|
643 | `orientation` float NOT NULL default '0', |
---|
644 | `zone` int(11) unsigned NOT NULL default '38' COMMENT 'Zone Identifier', |
---|
645 | `map` int(11) unsigned NOT NULL default '0' COMMENT 'Map Identifier', |
---|
646 | `data` longtext, |
---|
647 | `time` bigint(20) unsigned NOT NULL default '0', |
---|
648 | `corpse_type` tinyint(3) unsigned NOT NULL default '0', |
---|
649 | `instance` int(11) unsigned NOT NULL default '0', |
---|
650 | PRIMARY KEY (`guid`), |
---|
651 | KEY `idx_type` (`corpse_type`), |
---|
652 | KEY `instance` (`instance`) |
---|
653 | ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Death System'; |
---|
654 | |
---|
655 | -- |
---|
656 | -- Dumping data for table `corpse` |
---|
657 | -- |
---|
658 | |
---|
659 | LOCK TABLES `corpse` WRITE; |
---|
660 | /*!40000 ALTER TABLE `corpse` DISABLE KEYS */; |
---|
661 | /*!40000 ALTER TABLE `corpse` ENABLE KEYS */; |
---|
662 | UNLOCK TABLES; |
---|
663 | |
---|
664 | -- |
---|
665 | -- Table structure for table `game_event_condition_save` |
---|
666 | -- |
---|
667 | |
---|
668 | DROP TABLE IF EXISTS `game_event_condition_save`; |
---|
669 | CREATE TABLE `game_event_condition_save` ( |
---|
670 | `event_id` mediumint(8) unsigned NOT NULL, |
---|
671 | `condition_id` mediumint(8) unsigned NOT NULL default '0', |
---|
672 | `done` float default '0', |
---|
673 | PRIMARY KEY (`event_id`,`condition_id`) |
---|
674 | ) ENGINE=InnoDB DEFAULT CHARSET=utf8; |
---|
675 | |
---|
676 | -- |
---|
677 | -- Dumping data for table `game_event_condition_save` |
---|
678 | -- |
---|
679 | |
---|
680 | LOCK TABLES `game_event_condition_save` WRITE; |
---|
681 | /*!40000 ALTER TABLE `game_event_condition_save` DISABLE KEYS */; |
---|
682 | /*!40000 ALTER TABLE `game_event_condition_save` ENABLE KEYS */; |
---|
683 | UNLOCK TABLES; |
---|
684 | |
---|
685 | -- |
---|
686 | -- Table structure for table `game_event_save` |
---|
687 | -- |
---|
688 | |
---|
689 | DROP TABLE IF EXISTS `game_event_save`; |
---|
690 | CREATE TABLE `game_event_save` ( |
---|
691 | `event_id` mediumint(8) unsigned NOT NULL, |
---|
692 | `state` tinyint(3) unsigned NOT NULL default '1', |
---|
693 | `next_start` timestamp NOT NULL default '0000-00-00 00:00:00', |
---|
694 | PRIMARY KEY (`event_id`) |
---|
695 | ) ENGINE=InnoDB DEFAULT CHARSET=utf8; |
---|
696 | |
---|
697 | -- |
---|
698 | -- Dumping data for table `game_event_save` |
---|
699 | -- |
---|
700 | |
---|
701 | LOCK TABLES `game_event_save` WRITE; |
---|
702 | /*!40000 ALTER TABLE `game_event_save` DISABLE KEYS */; |
---|
703 | /*!40000 ALTER TABLE `game_event_save` ENABLE KEYS */; |
---|
704 | UNLOCK TABLES; |
---|
705 | |
---|
706 | -- |
---|
707 | -- Table structure for table `group_instance` |
---|
708 | -- |
---|
709 | |
---|
710 | DROP TABLE IF EXISTS `group_instance`; |
---|
711 | CREATE TABLE `group_instance` ( |
---|
712 | `leaderGuid` int(11) unsigned NOT NULL default '0', |
---|
713 | `instance` int(11) unsigned NOT NULL default '0', |
---|
714 | `permanent` tinyint(1) unsigned NOT NULL default '0', |
---|
715 | PRIMARY KEY (`leaderGuid`,`instance`), |
---|
716 | KEY `instance` (`instance`) |
---|
717 | ) ENGINE=InnoDB DEFAULT CHARSET=utf8; |
---|
718 | |
---|
719 | -- |
---|
720 | -- Dumping data for table `group_instance` |
---|
721 | -- |
---|
722 | |
---|
723 | LOCK TABLES `group_instance` WRITE; |
---|
724 | /*!40000 ALTER TABLE `group_instance` DISABLE KEYS */; |
---|
725 | /*!40000 ALTER TABLE `group_instance` ENABLE KEYS */; |
---|
726 | UNLOCK TABLES; |
---|
727 | |
---|
728 | -- |
---|
729 | -- Table structure for table `group_member` |
---|
730 | -- |
---|
731 | |
---|
732 | DROP TABLE IF EXISTS `group_member`; |
---|
733 | CREATE TABLE `group_member` ( |
---|
734 | `leaderGuid` int(11) unsigned NOT NULL, |
---|
735 | `memberGuid` int(11) unsigned NOT NULL, |
---|
736 | `assistant` tinyint(1) unsigned NOT NULL, |
---|
737 | `subgroup` smallint(6) unsigned NOT NULL, |
---|
738 | PRIMARY KEY (`leaderGuid`,`memberGuid`) |
---|
739 | ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Groups'; |
---|
740 | |
---|
741 | -- |
---|
742 | -- Dumping data for table `group_member` |
---|
743 | -- |
---|
744 | |
---|
745 | LOCK TABLES `group_member` WRITE; |
---|
746 | /*!40000 ALTER TABLE `group_member` DISABLE KEYS */; |
---|
747 | /*!40000 ALTER TABLE `group_member` ENABLE KEYS */; |
---|
748 | UNLOCK TABLES; |
---|
749 | |
---|
750 | -- |
---|
751 | -- Table structure for table `groups` |
---|
752 | -- |
---|
753 | |
---|
754 | DROP TABLE IF EXISTS `groups`; |
---|
755 | CREATE TABLE `groups` ( |
---|
756 | `leaderGuid` int(11) unsigned NOT NULL, |
---|
757 | `mainTank` int(11) unsigned NOT NULL, |
---|
758 | `mainAssistant` int(11) unsigned NOT NULL, |
---|
759 | `lootMethod` tinyint(4) unsigned NOT NULL, |
---|
760 | `looterGuid` int(11) unsigned NOT NULL, |
---|
761 | `lootThreshold` tinyint(4) unsigned NOT NULL, |
---|
762 | `icon1` int(11) unsigned NOT NULL, |
---|
763 | `icon2` int(11) unsigned NOT NULL, |
---|
764 | `icon3` int(11) unsigned NOT NULL, |
---|
765 | `icon4` int(11) unsigned NOT NULL, |
---|
766 | `icon5` int(11) unsigned NOT NULL, |
---|
767 | `icon6` int(11) unsigned NOT NULL, |
---|
768 | `icon7` int(11) unsigned NOT NULL, |
---|
769 | `icon8` int(11) unsigned NOT NULL, |
---|
770 | `isRaid` tinyint(1) unsigned NOT NULL, |
---|
771 | `difficulty` tinyint(3) unsigned NOT NULL default '0', |
---|
772 | PRIMARY KEY (`leaderGuid`) |
---|
773 | ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Groups'; |
---|
774 | |
---|
775 | -- |
---|
776 | -- Dumping data for table `groups` |
---|
777 | -- |
---|
778 | |
---|
779 | LOCK TABLES `groups` WRITE; |
---|
780 | /*!40000 ALTER TABLE `groups` DISABLE KEYS */; |
---|
781 | /*!40000 ALTER TABLE `groups` ENABLE KEYS */; |
---|
782 | UNLOCK TABLES; |
---|
783 | |
---|
784 | -- |
---|
785 | -- Table structure for table `guild` |
---|
786 | -- |
---|
787 | |
---|
788 | DROP TABLE IF EXISTS `guild`; |
---|
789 | CREATE TABLE `guild` ( |
---|
790 | `guildid` int(6) unsigned NOT NULL default '0', |
---|
791 | `name` varchar(255) NOT NULL default '', |
---|
792 | `leaderguid` int(6) unsigned NOT NULL default '0', |
---|
793 | `EmblemStyle` int(5) NOT NULL default '0', |
---|
794 | `EmblemColor` int(5) NOT NULL default '0', |
---|
795 | `BorderStyle` int(5) NOT NULL default '0', |
---|
796 | `BorderColor` int(5) NOT NULL default '0', |
---|
797 | `BackgroundColor` int(5) NOT NULL default '0', |
---|
798 | `info` text NOT NULL, |
---|
799 | `motd` varchar(255) NOT NULL default '', |
---|
800 | `createdate` datetime default NULL, |
---|
801 | `BankMoney` bigint(20) NOT NULL default '0', |
---|
802 | PRIMARY KEY (`guildid`) |
---|
803 | ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Guild System'; |
---|
804 | |
---|
805 | -- |
---|
806 | -- Dumping data for table `guild` |
---|
807 | -- |
---|
808 | |
---|
809 | LOCK TABLES `guild` WRITE; |
---|
810 | /*!40000 ALTER TABLE `guild` DISABLE KEYS */; |
---|
811 | /*!40000 ALTER TABLE `guild` ENABLE KEYS */; |
---|
812 | UNLOCK TABLES; |
---|
813 | |
---|
814 | -- |
---|
815 | -- Table structure for table `guild_bank_eventlog` |
---|
816 | -- |
---|
817 | |
---|
818 | DROP TABLE IF EXISTS `guild_bank_eventlog`; |
---|
819 | CREATE TABLE `guild_bank_eventlog` ( |
---|
820 | `guildid` int(11) unsigned NOT NULL default '0', |
---|
821 | `LogGuid` int(11) unsigned NOT NULL default '0', |
---|
822 | `LogEntry` tinyint(1) unsigned NOT NULL default '0', |
---|
823 | `TabId` tinyint(1) unsigned NOT NULL default '0', |
---|
824 | `PlayerGuid` int(11) unsigned NOT NULL default '0', |
---|
825 | `ItemOrMoney` int(11) unsigned NOT NULL default '0', |
---|
826 | `ItemStackCount` tinyint(3) unsigned NOT NULL default '0', |
---|
827 | `DestTabId` tinyint(1) unsigned NOT NULL default '0', |
---|
828 | `TimeStamp` bigint(20) unsigned NOT NULL default '0', |
---|
829 | PRIMARY KEY (`guildid`,`LogGuid`), |
---|
830 | KEY `guildid_key` (`guildid`) |
---|
831 | ) ENGINE=InnoDB DEFAULT CHARSET=utf8; |
---|
832 | |
---|
833 | -- |
---|
834 | -- Dumping data for table `guild_bank_eventlog` |
---|
835 | -- |
---|
836 | |
---|
837 | LOCK TABLES `guild_bank_eventlog` WRITE; |
---|
838 | /*!40000 ALTER TABLE `guild_bank_eventlog` DISABLE KEYS */; |
---|
839 | /*!40000 ALTER TABLE `guild_bank_eventlog` ENABLE KEYS */; |
---|
840 | UNLOCK TABLES; |
---|
841 | |
---|
842 | -- |
---|
843 | -- Table structure for table `guild_bank_item` |
---|
844 | -- |
---|
845 | |
---|
846 | DROP TABLE IF EXISTS `guild_bank_item`; |
---|
847 | CREATE TABLE `guild_bank_item` ( |
---|
848 | `guildid` int(11) unsigned NOT NULL default '0', |
---|
849 | `TabId` tinyint(1) unsigned NOT NULL default '0', |
---|
850 | `SlotId` tinyint(3) unsigned NOT NULL default '0', |
---|
851 | `item_guid` int(11) unsigned NOT NULL default '0', |
---|
852 | `item_entry` int(11) unsigned NOT NULL default '0', |
---|
853 | PRIMARY KEY (`guildid`,`TabId`,`SlotId`), |
---|
854 | KEY `guildid_key` (`guildid`) |
---|
855 | ) ENGINE=InnoDB DEFAULT CHARSET=utf8; |
---|
856 | |
---|
857 | -- |
---|
858 | -- Dumping data for table `guild_bank_item` |
---|
859 | -- |
---|
860 | |
---|
861 | LOCK TABLES `guild_bank_item` WRITE; |
---|
862 | /*!40000 ALTER TABLE `guild_bank_item` DISABLE KEYS */; |
---|
863 | /*!40000 ALTER TABLE `guild_bank_item` ENABLE KEYS */; |
---|
864 | UNLOCK TABLES; |
---|
865 | |
---|
866 | -- |
---|
867 | -- Table structure for table `guild_bank_right` |
---|
868 | -- |
---|
869 | |
---|
870 | DROP TABLE IF EXISTS `guild_bank_right`; |
---|
871 | CREATE TABLE `guild_bank_right` ( |
---|
872 | `guildid` int(11) unsigned NOT NULL default '0', |
---|
873 | `TabId` tinyint(1) unsigned NOT NULL default '0', |
---|
874 | `rid` int(11) unsigned NOT NULL default '0', |
---|
875 | `gbright` tinyint(3) unsigned NOT NULL default '0', |
---|
876 | `SlotPerDay` int(11) unsigned NOT NULL default '0', |
---|
877 | PRIMARY KEY (`guildid`,`TabId`,`rid`), |
---|
878 | KEY `guildid_key` (`guildid`) |
---|
879 | ) ENGINE=InnoDB DEFAULT CHARSET=utf8; |
---|
880 | |
---|
881 | -- |
---|
882 | -- Dumping data for table `guild_bank_right` |
---|
883 | -- |
---|
884 | |
---|
885 | LOCK TABLES `guild_bank_right` WRITE; |
---|
886 | /*!40000 ALTER TABLE `guild_bank_right` DISABLE KEYS */; |
---|
887 | /*!40000 ALTER TABLE `guild_bank_right` ENABLE KEYS */; |
---|
888 | UNLOCK TABLES; |
---|
889 | |
---|
890 | -- |
---|
891 | -- Table structure for table `guild_bank_tab` |
---|
892 | -- |
---|
893 | |
---|
894 | DROP TABLE IF EXISTS `guild_bank_tab`; |
---|
895 | CREATE TABLE `guild_bank_tab` ( |
---|
896 | `guildid` int(11) unsigned NOT NULL default '0', |
---|
897 | `TabId` tinyint(1) unsigned NOT NULL default '0', |
---|
898 | `TabName` varchar(100) NOT NULL default '', |
---|
899 | `TabIcon` varchar(100) NOT NULL default '', |
---|
900 | `TabText` varchar(500) NOT NULL default '', |
---|
901 | PRIMARY KEY (`guildid`,`TabId`), |
---|
902 | KEY `guildid_key` (`guildid`) |
---|
903 | ) ENGINE=InnoDB DEFAULT CHARSET=utf8; |
---|
904 | |
---|
905 | -- |
---|
906 | -- Dumping data for table `guild_bank_tab` |
---|
907 | -- |
---|
908 | |
---|
909 | LOCK TABLES `guild_bank_tab` WRITE; |
---|
910 | /*!40000 ALTER TABLE `guild_bank_tab` DISABLE KEYS */; |
---|
911 | /*!40000 ALTER TABLE `guild_bank_tab` ENABLE KEYS */; |
---|
912 | UNLOCK TABLES; |
---|
913 | |
---|
914 | -- |
---|
915 | -- Table structure for table `guild_eventlog` |
---|
916 | -- |
---|
917 | |
---|
918 | DROP TABLE IF EXISTS `guild_eventlog`; |
---|
919 | CREATE TABLE `guild_eventlog` ( |
---|
920 | `guildid` int(11) NOT NULL COMMENT 'Guild Identificator', |
---|
921 | `LogGuid` int(11) NOT NULL COMMENT 'Log entry identificator', |
---|
922 | `EventType` tinyint(1) NOT NULL COMMENT 'Event type', |
---|
923 | `PlayerGuid1` int(11) NOT NULL COMMENT 'Player 1', |
---|
924 | `PlayerGuid2` int(11) NOT NULL COMMENT 'Player 2', |
---|
925 | `NewRank` tinyint(2) NOT NULL COMMENT 'New rank(in case promotion/demotion)', |
---|
926 | `TimeStamp` bigint(20) NOT NULL COMMENT 'Event UNIX time' |
---|
927 | ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='Guild Eventlog'; |
---|
928 | |
---|
929 | -- |
---|
930 | -- Dumping data for table `guild_eventlog` |
---|
931 | -- |
---|
932 | |
---|
933 | LOCK TABLES `guild_eventlog` WRITE; |
---|
934 | /*!40000 ALTER TABLE `guild_eventlog` DISABLE KEYS */; |
---|
935 | /*!40000 ALTER TABLE `guild_eventlog` ENABLE KEYS */; |
---|
936 | UNLOCK TABLES; |
---|
937 | |
---|
938 | -- |
---|
939 | -- Table structure for table `guild_member` |
---|
940 | -- |
---|
941 | |
---|
942 | DROP TABLE IF EXISTS `guild_member`; |
---|
943 | CREATE TABLE `guild_member` ( |
---|
944 | `guildid` int(6) unsigned NOT NULL default '0', |
---|
945 | `guid` int(11) unsigned NOT NULL default '0', |
---|
946 | `rank` tinyint(2) unsigned NOT NULL default '0', |
---|
947 | `pnote` varchar(255) NOT NULL default '', |
---|
948 | `offnote` varchar(255) NOT NULL default '', |
---|
949 | `BankResetTimeMoney` int(11) unsigned NOT NULL default '0', |
---|
950 | `BankRemMoney` int(11) unsigned NOT NULL default '0', |
---|
951 | `BankResetTimeTab0` int(11) unsigned NOT NULL default '0', |
---|
952 | `BankRemSlotsTab0` int(11) unsigned NOT NULL default '0', |
---|
953 | `BankResetTimeTab1` int(11) unsigned NOT NULL default '0', |
---|
954 | `BankRemSlotsTab1` int(11) unsigned NOT NULL default '0', |
---|
955 | `BankResetTimeTab2` int(11) unsigned NOT NULL default '0', |
---|
956 | `BankRemSlotsTab2` int(11) unsigned NOT NULL default '0', |
---|
957 | `BankResetTimeTab3` int(11) unsigned NOT NULL default '0', |
---|
958 | `BankRemSlotsTab3` int(11) unsigned NOT NULL default '0', |
---|
959 | `BankResetTimeTab4` int(11) unsigned NOT NULL default '0', |
---|
960 | `BankRemSlotsTab4` int(11) unsigned NOT NULL default '0', |
---|
961 | `BankResetTimeTab5` int(11) unsigned NOT NULL default '0', |
---|
962 | `BankRemSlotsTab5` int(11) unsigned NOT NULL default '0', |
---|
963 | KEY `guildid_key` (`guildid`), |
---|
964 | KEY `guildid_rank_key` (`guildid`,`rank`), |
---|
965 | KEY `guid_key` (`guid`) |
---|
966 | ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Guild System'; |
---|
967 | |
---|
968 | -- |
---|
969 | -- Dumping data for table `guild_member` |
---|
970 | -- |
---|
971 | |
---|
972 | LOCK TABLES `guild_member` WRITE; |
---|
973 | /*!40000 ALTER TABLE `guild_member` DISABLE KEYS */; |
---|
974 | /*!40000 ALTER TABLE `guild_member` ENABLE KEYS */; |
---|
975 | UNLOCK TABLES; |
---|
976 | |
---|
977 | -- |
---|
978 | -- Table structure for table `guild_rank` |
---|
979 | -- |
---|
980 | |
---|
981 | DROP TABLE IF EXISTS `guild_rank`; |
---|
982 | CREATE TABLE `guild_rank` ( |
---|
983 | `guildid` int(6) unsigned NOT NULL default '0', |
---|
984 | `rid` int(11) unsigned NOT NULL, |
---|
985 | `rname` varchar(255) NOT NULL default '', |
---|
986 | `rights` int(3) unsigned NOT NULL default '0', |
---|
987 | `BankMoneyPerDay` int(11) unsigned NOT NULL default '0', |
---|
988 | PRIMARY KEY (`guildid`,`rid`) |
---|
989 | ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Guild System'; |
---|
990 | |
---|
991 | -- |
---|
992 | -- Dumping data for table `guild_rank` |
---|
993 | -- |
---|
994 | |
---|
995 | LOCK TABLES `guild_rank` WRITE; |
---|
996 | /*!40000 ALTER TABLE `guild_rank` DISABLE KEYS */; |
---|
997 | /*!40000 ALTER TABLE `guild_rank` ENABLE KEYS */; |
---|
998 | UNLOCK TABLES; |
---|
999 | |
---|
1000 | -- |
---|
1001 | -- Table structure for table `has_logged_in_before` |
---|
1002 | -- |
---|
1003 | |
---|
1004 | DROP TABLE IF EXISTS `has_logged_in_before`; |
---|
1005 | CREATE TABLE `has_logged_in_before` ( |
---|
1006 | `guid` int(11) unsigned NOT NULL default '0', |
---|
1007 | PRIMARY KEY (`guid`) |
---|
1008 | ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='ImpConfig check'; |
---|
1009 | |
---|
1010 | -- |
---|
1011 | -- Dumping data for table `has_logged_in_before` |
---|
1012 | -- |
---|
1013 | |
---|
1014 | LOCK TABLES `has_logged_in_before` WRITE; |
---|
1015 | /*!40000 ALTER TABLE `has_logged_in_before` DISABLE KEYS */; |
---|
1016 | /*!40000 ALTER TABLE `has_logged_in_before` ENABLE KEYS */; |
---|
1017 | UNLOCK TABLES; |
---|
1018 | |
---|
1019 | -- |
---|
1020 | -- Table structure for table `instance` |
---|
1021 | -- |
---|
1022 | |
---|
1023 | DROP TABLE IF EXISTS `instance`; |
---|
1024 | CREATE TABLE `instance` ( |
---|
1025 | `id` int(11) unsigned NOT NULL default '0', |
---|
1026 | `map` int(11) unsigned NOT NULL default '0', |
---|
1027 | `resettime` bigint(40) NOT NULL default '0', |
---|
1028 | `difficulty` tinyint(1) unsigned NOT NULL default '0', |
---|
1029 | `data` longtext, |
---|
1030 | PRIMARY KEY (`id`), |
---|
1031 | KEY `map` (`map`), |
---|
1032 | KEY `resettime` (`resettime`) |
---|
1033 | ) ENGINE=InnoDB DEFAULT CHARSET=utf8; |
---|
1034 | |
---|
1035 | -- |
---|
1036 | -- Dumping data for table `instance` |
---|
1037 | -- |
---|
1038 | |
---|
1039 | LOCK TABLES `instance` WRITE; |
---|
1040 | /*!40000 ALTER TABLE `instance` DISABLE KEYS */; |
---|
1041 | /*!40000 ALTER TABLE `instance` ENABLE KEYS */; |
---|
1042 | UNLOCK TABLES; |
---|
1043 | |
---|
1044 | -- |
---|
1045 | -- Table structure for table `instance_reset` |
---|
1046 | -- |
---|
1047 | |
---|
1048 | DROP TABLE IF EXISTS `instance_reset`; |
---|
1049 | CREATE TABLE `instance_reset` ( |
---|
1050 | `mapid` int(11) unsigned NOT NULL default '0', |
---|
1051 | `resettime` bigint(40) NOT NULL default '0', |
---|
1052 | PRIMARY KEY (`mapid`) |
---|
1053 | ) ENGINE=InnoDB DEFAULT CHARSET=utf8; |
---|
1054 | |
---|
1055 | -- |
---|
1056 | -- Dumping data for table `instance_reset` |
---|
1057 | -- |
---|
1058 | |
---|
1059 | LOCK TABLES `instance_reset` WRITE; |
---|
1060 | /*!40000 ALTER TABLE `instance_reset` DISABLE KEYS */; |
---|
1061 | /*!40000 ALTER TABLE `instance_reset` ENABLE KEYS */; |
---|
1062 | UNLOCK TABLES; |
---|
1063 | |
---|
1064 | -- |
---|
1065 | -- Table structure for table `item_instance` |
---|
1066 | -- |
---|
1067 | |
---|
1068 | DROP TABLE IF EXISTS `item_instance`; |
---|
1069 | CREATE TABLE `item_instance` ( |
---|
1070 | `guid` int(11) unsigned NOT NULL default '0', |
---|
1071 | `owner_guid` int(11) unsigned NOT NULL default '0', |
---|
1072 | `data` longtext, |
---|
1073 | PRIMARY KEY (`guid`), |
---|
1074 | KEY `idx_owner_guid` (`owner_guid`) |
---|
1075 | ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Item System'; |
---|
1076 | |
---|
1077 | -- |
---|
1078 | -- Dumping data for table `item_instance` |
---|
1079 | -- |
---|
1080 | |
---|
1081 | LOCK TABLES `item_instance` WRITE; |
---|
1082 | /*!40000 ALTER TABLE `item_instance` DISABLE KEYS */; |
---|
1083 | /*!40000 ALTER TABLE `item_instance` ENABLE KEYS */; |
---|
1084 | UNLOCK TABLES; |
---|
1085 | |
---|
1086 | -- |
---|
1087 | -- Table structure for table `item_text` |
---|
1088 | -- |
---|
1089 | |
---|
1090 | DROP TABLE IF EXISTS `item_text`; |
---|
1091 | CREATE TABLE `item_text` ( |
---|
1092 | `id` int(11) unsigned NOT NULL default '0', |
---|
1093 | `text` longtext, |
---|
1094 | PRIMARY KEY (`id`) |
---|
1095 | ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Item System'; |
---|
1096 | |
---|
1097 | -- |
---|
1098 | -- Dumping data for table `item_text` |
---|
1099 | -- |
---|
1100 | |
---|
1101 | LOCK TABLES `item_text` WRITE; |
---|
1102 | /*!40000 ALTER TABLE `item_text` DISABLE KEYS */; |
---|
1103 | /*!40000 ALTER TABLE `item_text` ENABLE KEYS */; |
---|
1104 | UNLOCK TABLES; |
---|
1105 | |
---|
1106 | -- |
---|
1107 | -- Table structure for table `mail` |
---|
1108 | -- |
---|
1109 | |
---|
1110 | DROP TABLE IF EXISTS `mail`; |
---|
1111 | CREATE TABLE `mail` ( |
---|
1112 | `id` int(11) unsigned NOT NULL default '0' COMMENT 'Identifier', |
---|
1113 | `messageType` tinyint(3) unsigned NOT NULL default '0', |
---|
1114 | `stationery` tinyint(3) NOT NULL default '41', |
---|
1115 | `mailTemplateId` mediumint(8) unsigned NOT NULL default '0', |
---|
1116 | `sender` int(11) unsigned NOT NULL default '0' COMMENT 'Character Global Unique Identifier', |
---|
1117 | `receiver` int(11) unsigned NOT NULL default '0' COMMENT 'Character Global Unique Identifier', |
---|
1118 | `subject` longtext, |
---|
1119 | `itemTextId` int(11) unsigned NOT NULL default '0', |
---|
1120 | `has_items` tinyint(3) unsigned NOT NULL default '0', |
---|
1121 | `expire_time` bigint(40) NOT NULL default '0', |
---|
1122 | `deliver_time` bigint(40) NOT NULL default '0', |
---|
1123 | `money` int(11) unsigned NOT NULL default '0', |
---|
1124 | `cod` int(11) unsigned NOT NULL default '0', |
---|
1125 | `checked` tinyint(3) unsigned NOT NULL default '0', |
---|
1126 | PRIMARY KEY (`id`), |
---|
1127 | KEY `idx_receiver` (`receiver`) |
---|
1128 | ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Mail System'; |
---|
1129 | |
---|
1130 | -- |
---|
1131 | -- Dumping data for table `mail` |
---|
1132 | -- |
---|
1133 | |
---|
1134 | LOCK TABLES `mail` WRITE; |
---|
1135 | /*!40000 ALTER TABLE `mail` DISABLE KEYS */; |
---|
1136 | /*!40000 ALTER TABLE `mail` ENABLE KEYS */; |
---|
1137 | UNLOCK TABLES; |
---|
1138 | |
---|
1139 | -- |
---|
1140 | -- Table structure for table `mail_items` |
---|
1141 | -- |
---|
1142 | |
---|
1143 | DROP TABLE IF EXISTS `mail_items`; |
---|
1144 | CREATE TABLE `mail_items` ( |
---|
1145 | `mail_id` int(11) NOT NULL default '0', |
---|
1146 | `item_guid` int(11) NOT NULL default '0', |
---|
1147 | `item_template` int(11) NOT NULL default '0', |
---|
1148 | `receiver` int(11) unsigned NOT NULL default '0' COMMENT 'Character Global Unique Identifier', |
---|
1149 | PRIMARY KEY (`mail_id`,`item_guid`), |
---|
1150 | KEY `idx_receiver` (`receiver`) |
---|
1151 | ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC; |
---|
1152 | |
---|
1153 | -- |
---|
1154 | -- Dumping data for table `mail_items` |
---|
1155 | -- |
---|
1156 | |
---|
1157 | LOCK TABLES `mail_items` WRITE; |
---|
1158 | /*!40000 ALTER TABLE `mail_items` DISABLE KEYS */; |
---|
1159 | /*!40000 ALTER TABLE `mail_items` ENABLE KEYS */; |
---|
1160 | UNLOCK TABLES; |
---|
1161 | |
---|
1162 | -- |
---|
1163 | -- Table structure for table `pet_aura` |
---|
1164 | -- |
---|
1165 | |
---|
1166 | DROP TABLE IF EXISTS `pet_aura`; |
---|
1167 | CREATE TABLE `pet_aura` ( |
---|
1168 | `guid` int(11) unsigned NOT NULL default '0' COMMENT 'Global Unique Identifier', |
---|
1169 | `caster_guid` bigint(20) unsigned NOT NULL default '0' COMMENT 'Full Global Unique Identifier', |
---|
1170 | `spell` int(11) unsigned NOT NULL default '0', |
---|
1171 | `effect_index` int(11) unsigned NOT NULL default '0', |
---|
1172 | `amount` int(11) NOT NULL default '0', |
---|
1173 | `maxduration` int(11) NOT NULL default '0', |
---|
1174 | `remaintime` int(11) NOT NULL default '0', |
---|
1175 | `remaincharges` int(11) NOT NULL default '0', |
---|
1176 | PRIMARY KEY (`guid`,`spell`,`effect_index`) |
---|
1177 | ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Pet System'; |
---|
1178 | |
---|
1179 | -- |
---|
1180 | -- Dumping data for table `pet_aura` |
---|
1181 | -- |
---|
1182 | |
---|
1183 | LOCK TABLES `pet_aura` WRITE; |
---|
1184 | /*!40000 ALTER TABLE `pet_aura` DISABLE KEYS */; |
---|
1185 | /*!40000 ALTER TABLE `pet_aura` ENABLE KEYS */; |
---|
1186 | UNLOCK TABLES; |
---|
1187 | |
---|
1188 | -- |
---|
1189 | -- Table structure for table `pet_spell` |
---|
1190 | -- |
---|
1191 | |
---|
1192 | DROP TABLE IF EXISTS `pet_spell`; |
---|
1193 | CREATE TABLE `pet_spell` ( |
---|
1194 | `guid` int(11) unsigned NOT NULL default '0' COMMENT 'Global Unique Identifier', |
---|
1195 | `spell` int(11) unsigned NOT NULL default '0' COMMENT 'Spell Identifier', |
---|
1196 | `slot` int(11) unsigned NOT NULL default '0', |
---|
1197 | `active` int(11) unsigned NOT NULL default '0', |
---|
1198 | PRIMARY KEY (`guid`,`spell`) |
---|
1199 | ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Pet System'; |
---|
1200 | |
---|
1201 | -- |
---|
1202 | -- Dumping data for table `pet_spell` |
---|
1203 | -- |
---|
1204 | |
---|
1205 | LOCK TABLES `pet_spell` WRITE; |
---|
1206 | /*!40000 ALTER TABLE `pet_spell` DISABLE KEYS */; |
---|
1207 | /*!40000 ALTER TABLE `pet_spell` ENABLE KEYS */; |
---|
1208 | UNLOCK TABLES; |
---|
1209 | |
---|
1210 | -- |
---|
1211 | -- Table structure for table `pet_spell_cooldown` |
---|
1212 | -- |
---|
1213 | |
---|
1214 | DROP TABLE IF EXISTS `pet_spell_cooldown`; |
---|
1215 | CREATE TABLE `pet_spell_cooldown` ( |
---|
1216 | `guid` int(11) unsigned NOT NULL default '0' COMMENT 'Global Unique Identifier, Low part', |
---|
1217 | `spell` int(11) unsigned NOT NULL default '0' COMMENT 'Spell Identifier', |
---|
1218 | `time` bigint(20) unsigned NOT NULL default '0', |
---|
1219 | PRIMARY KEY (`guid`,`spell`) |
---|
1220 | ) ENGINE=InnoDB DEFAULT CHARSET=utf8; |
---|
1221 | |
---|
1222 | -- |
---|
1223 | -- Dumping data for table `pet_spell_cooldown` |
---|
1224 | -- |
---|
1225 | |
---|
1226 | LOCK TABLES `pet_spell_cooldown` WRITE; |
---|
1227 | /*!40000 ALTER TABLE `pet_spell_cooldown` DISABLE KEYS */; |
---|
1228 | /*!40000 ALTER TABLE `pet_spell_cooldown` ENABLE KEYS */; |
---|
1229 | UNLOCK TABLES; |
---|
1230 | |
---|
1231 | -- |
---|
1232 | -- Table structure for table `petition` |
---|
1233 | -- |
---|
1234 | |
---|
1235 | DROP TABLE IF EXISTS `petition`; |
---|
1236 | CREATE TABLE `petition` ( |
---|
1237 | `ownerguid` int(10) unsigned NOT NULL, |
---|
1238 | `petitionguid` int(10) unsigned default '0', |
---|
1239 | `name` varchar(255) NOT NULL default '', |
---|
1240 | `type` int(10) unsigned NOT NULL default '0', |
---|
1241 | PRIMARY KEY (`ownerguid`,`type`), |
---|
1242 | UNIQUE KEY `index_ownerguid_petitionguid` (`ownerguid`,`petitionguid`) |
---|
1243 | ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Guild System'; |
---|
1244 | |
---|
1245 | -- |
---|
1246 | -- Dumping data for table `petition` |
---|
1247 | -- |
---|
1248 | |
---|
1249 | LOCK TABLES `petition` WRITE; |
---|
1250 | /*!40000 ALTER TABLE `petition` DISABLE KEYS */; |
---|
1251 | /*!40000 ALTER TABLE `petition` ENABLE KEYS */; |
---|
1252 | UNLOCK TABLES; |
---|
1253 | |
---|
1254 | -- |
---|
1255 | -- Table structure for table `petition_sign` |
---|
1256 | -- |
---|
1257 | |
---|
1258 | DROP TABLE IF EXISTS `petition_sign`; |
---|
1259 | CREATE TABLE `petition_sign` ( |
---|
1260 | `ownerguid` int(10) unsigned NOT NULL, |
---|
1261 | `petitionguid` int(11) unsigned NOT NULL default '0', |
---|
1262 | `playerguid` int(11) unsigned NOT NULL default '0', |
---|
1263 | `player_account` int(11) unsigned NOT NULL default '0', |
---|
1264 | `type` int(10) unsigned NOT NULL default '0', |
---|
1265 | PRIMARY KEY (`petitionguid`,`playerguid`) |
---|
1266 | ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Guild System'; |
---|
1267 | |
---|
1268 | -- |
---|
1269 | -- Dumping data for table `petition_sign` |
---|
1270 | -- |
---|
1271 | |
---|
1272 | LOCK TABLES `petition_sign` WRITE; |
---|
1273 | /*!40000 ALTER TABLE `petition_sign` DISABLE KEYS */; |
---|
1274 | /*!40000 ALTER TABLE `petition_sign` ENABLE KEYS */; |
---|
1275 | UNLOCK TABLES; |
---|
1276 | |
---|
1277 | -- |
---|
1278 | -- Table structure for table `saved_variables` |
---|
1279 | -- |
---|
1280 | |
---|
1281 | DROP TABLE IF EXISTS `saved_variables`; |
---|
1282 | CREATE TABLE `saved_variables` ( |
---|
1283 | `NextArenaPointDistributionTime` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP |
---|
1284 | ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Variable Saves'; |
---|
1285 | |
---|
1286 | -- |
---|
1287 | -- Dumping data for table `saved_variables` |
---|
1288 | -- |
---|
1289 | |
---|
1290 | LOCK TABLES `saved_variables` WRITE; |
---|
1291 | /*!40000 ALTER TABLE `saved_variables` DISABLE KEYS */; |
---|
1292 | /*!40000 ALTER TABLE `saved_variables` ENABLE KEYS */; |
---|
1293 | UNLOCK TABLES; |
---|
1294 | /*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */; |
---|
1295 | |
---|
1296 | /*!40101 SET SQL_MODE=@OLD_SQL_MODE */; |
---|
1297 | /*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */; |
---|
1298 | /*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */; |
---|
1299 | /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */; |
---|
1300 | /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */; |
---|
1301 | /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */; |
---|
1302 | /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */; |
---|
1303 | |
---|
1304 | -- Dump completed on 2008-10-14 13:27:52 |
---|