adPGGBEM

1-- MySQL dump 10.16  Distrib 10.1.6-MariaDB, for Win64 (AMD64)
2--
3-- Host: localhost    Database: characters
4-- ------------------------------------------------------
5-- Server version	5.7.14-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 `account_data`
20--
21
22DROP TABLE IF EXISTS `account_data`;
23/*!40101 SET @saved_cs_client     = @@character_set_client */;
24/*!40101 SET character_set_client = utf8 */;
25CREATE TABLE `account_data` (
26  `accountId` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Account Identifier',
27  `type` tinyint(3) unsigned NOT NULL DEFAULT '0',
28  `time` int(10) unsigned NOT NULL DEFAULT '0',
29  `data` blob NOT NULL,
30  PRIMARY KEY (`accountId`,`type`)
31) ENGINE=InnoDB DEFAULT CHARSET=utf8;
32/*!40101 SET character_set_client = @saved_cs_client */;
33
34--
35-- Dumping data for table `account_data`
36--
37
38LOCK TABLES `account_data` WRITE;
39/*!40000 ALTER TABLE `account_data` DISABLE KEYS */;
40/*!40000 ALTER TABLE `account_data` ENABLE KEYS */;
41UNLOCK TABLES;
42
43--
44-- Table structure for table `account_instance_times`
45--
46
47DROP TABLE IF EXISTS `account_instance_times`;
48/*!40101 SET @saved_cs_client     = @@character_set_client */;
49/*!40101 SET character_set_client = utf8 */;
50CREATE TABLE `account_instance_times` (
51  `accountId` int(10) unsigned NOT NULL,
52  `instanceId` int(10) unsigned NOT NULL DEFAULT '0',
53  `releaseTime` bigint(20) unsigned NOT NULL DEFAULT '0',
54  PRIMARY KEY (`accountId`,`instanceId`)
55) ENGINE=InnoDB DEFAULT CHARSET=utf8;
56/*!40101 SET character_set_client = @saved_cs_client */;
57
58--
59-- Dumping data for table `account_instance_times`
60--
61
62LOCK TABLES `account_instance_times` WRITE;
63/*!40000 ALTER TABLE `account_instance_times` DISABLE KEYS */;
64/*!40000 ALTER TABLE `account_instance_times` ENABLE KEYS */;
65UNLOCK TABLES;
66
67--
68-- Table structure for table `account_tutorial`
69--
70
71DROP TABLE IF EXISTS `account_tutorial`;
72/*!40101 SET @saved_cs_client     = @@character_set_client */;
73/*!40101 SET character_set_client = utf8 */;
74CREATE TABLE `account_tutorial` (
75  `accountId` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Account Identifier',
76  `tut0` int(10) unsigned NOT NULL DEFAULT '0',
77  `tut1` int(10) unsigned NOT NULL DEFAULT '0',
78  `tut2` int(10) unsigned NOT NULL DEFAULT '0',
79  `tut3` int(10) unsigned NOT NULL DEFAULT '0',
80  `tut4` int(10) unsigned NOT NULL DEFAULT '0',
81  `tut5` int(10) unsigned NOT NULL DEFAULT '0',
82  `tut6` int(10) unsigned NOT NULL DEFAULT '0',
83  `tut7` int(10) unsigned NOT NULL DEFAULT '0',
84  PRIMARY KEY (`accountId`)
85) ENGINE=InnoDB DEFAULT CHARSET=utf8;
86/*!40101 SET character_set_client = @saved_cs_client */;
87
88--
89-- Dumping data for table `account_tutorial`
90--
91
92LOCK TABLES `account_tutorial` WRITE;
93/*!40000 ALTER TABLE `account_tutorial` DISABLE KEYS */;
94/*!40000 ALTER TABLE `account_tutorial` ENABLE KEYS */;
95UNLOCK TABLES;
96
97--
98-- Table structure for table `addons`
99--
100
101DROP TABLE IF EXISTS `addons`;
102/*!40101 SET @saved_cs_client     = @@character_set_client */;
103/*!40101 SET character_set_client = utf8 */;
104CREATE TABLE `addons` (
105  `name` varchar(120) NOT NULL DEFAULT '',
106  `crc` int(10) unsigned NOT NULL DEFAULT '0',
107  PRIMARY KEY (`name`)
108) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Addons';
109/*!40101 SET character_set_client = @saved_cs_client */;
110
111--
112-- Dumping data for table `addons`
113--
114
115LOCK TABLES `addons` WRITE;
116/*!40000 ALTER TABLE `addons` DISABLE KEYS */;
117/*!40000 ALTER TABLE `addons` ENABLE KEYS */;
118UNLOCK TABLES;
119
120--
121-- Table structure for table `arena_team`
122--
123
124DROP TABLE IF EXISTS `arena_team`;
125/*!40101 SET @saved_cs_client     = @@character_set_client */;
126/*!40101 SET character_set_client = utf8 */;
127CREATE TABLE `arena_team` (
128  `arenaTeamId` int(10) unsigned NOT NULL DEFAULT '0',
129  `name` varchar(24) NOT NULL,
130  `captainGuid` int(10) unsigned NOT NULL DEFAULT '0',
131  `type` tinyint(3) unsigned NOT NULL DEFAULT '0',
132  `rating` smallint(5) unsigned NOT NULL DEFAULT '0',
133  `seasonGames` smallint(5) unsigned NOT NULL DEFAULT '0',
134  `seasonWins` smallint(5) unsigned NOT NULL DEFAULT '0',
135  `weekGames` smallint(5) unsigned NOT NULL DEFAULT '0',
136  `weekWins` smallint(5) unsigned NOT NULL DEFAULT '0',
137  `rank` int(10) unsigned NOT NULL DEFAULT '0',
138  `backgroundColor` int(10) unsigned NOT NULL DEFAULT '0',
139  `emblemStyle` tinyint(3) unsigned NOT NULL DEFAULT '0',
140  `emblemColor` int(10) unsigned NOT NULL DEFAULT '0',
141  `borderStyle` tinyint(3) unsigned NOT NULL DEFAULT '0',
142  `borderColor` int(10) unsigned NOT NULL DEFAULT '0',
143  PRIMARY KEY (`arenaTeamId`)
144) ENGINE=InnoDB DEFAULT CHARSET=utf8;
145/*!40101 SET character_set_client = @saved_cs_client */;
146
147--
148-- Dumping data for table `arena_team`
149--
150
151LOCK TABLES `arena_team` WRITE;
152/*!40000 ALTER TABLE `arena_team` DISABLE KEYS */;
153/*!40000 ALTER TABLE `arena_team` ENABLE KEYS */;
154UNLOCK TABLES;
155
156--
157-- Table structure for table `arena_team_member`
158--
159
160DROP TABLE IF EXISTS `arena_team_member`;
161/*!40101 SET @saved_cs_client     = @@character_set_client */;
162/*!40101 SET character_set_client = utf8 */;
163CREATE TABLE `arena_team_member` (
164  `arenaTeamId` int(10) unsigned NOT NULL DEFAULT '0',
165  `guid` int(10) unsigned NOT NULL DEFAULT '0',
166  `weekGames` smallint(5) unsigned NOT NULL DEFAULT '0',
167  `weekWins` smallint(5) unsigned NOT NULL DEFAULT '0',
168  `seasonGames` smallint(5) unsigned NOT NULL DEFAULT '0',
169  `seasonWins` smallint(5) unsigned NOT NULL DEFAULT '0',
170  `personalRating` smallint(5) unsigned NOT NULL DEFAULT '0',
171  PRIMARY KEY (`arenaTeamId`,`guid`)
172) ENGINE=InnoDB DEFAULT CHARSET=utf8;
173/*!40101 SET character_set_client = @saved_cs_client */;
174
175--
176-- Dumping data for table `arena_team_member`
177--
178
179LOCK TABLES `arena_team_member` WRITE;
180/*!40000 ALTER TABLE `arena_team_member` DISABLE KEYS */;
181/*!40000 ALTER TABLE `arena_team_member` ENABLE KEYS */;
182UNLOCK TABLES;
183
184--
185-- Table structure for table `auctionbidders`
186--
187
188DROP TABLE IF EXISTS `auctionbidders`;
189/*!40101 SET @saved_cs_client     = @@character_set_client */;
190/*!40101 SET character_set_client = utf8 */;
191CREATE TABLE `auctionbidders` (
192  `id` int(10) unsigned NOT NULL DEFAULT '0',
193  `bidderguid` int(10) unsigned NOT NULL DEFAULT '0',
194  PRIMARY KEY (`id`,`bidderguid`)
195) ENGINE=InnoDB DEFAULT CHARSET=utf8;
196/*!40101 SET character_set_client = @saved_cs_client */;
197
198--
199-- Dumping data for table `auctionbidders`
200--
201
202LOCK TABLES `auctionbidders` WRITE;
203/*!40000 ALTER TABLE `auctionbidders` DISABLE KEYS */;
204/*!40000 ALTER TABLE `auctionbidders` ENABLE KEYS */;
205UNLOCK TABLES;
206
207--
208-- Table structure for table `auctionhouse`
209--
210
211DROP TABLE IF EXISTS `auctionhouse`;
212/*!40101 SET @saved_cs_client     = @@character_set_client */;
213/*!40101 SET character_set_client = utf8 */;
214CREATE TABLE `auctionhouse` (
215  `id` int(10) unsigned NOT NULL DEFAULT '0',
216  `houseid` tinyint(3) unsigned NOT NULL DEFAULT '7',
217  `itemguid` int(10) unsigned NOT NULL DEFAULT '0',
218  `itemowner` int(10) unsigned NOT NULL DEFAULT '0',
219  `buyoutprice` int(10) unsigned NOT NULL DEFAULT '0',
220  `time` int(10) unsigned NOT NULL DEFAULT '0',
221  `buyguid` int(10) unsigned NOT NULL DEFAULT '0',
222  `lastbid` int(10) unsigned NOT NULL DEFAULT '0',
223  `startbid` int(10) unsigned NOT NULL DEFAULT '0',
224  `deposit` int(10) unsigned NOT NULL DEFAULT '0',
225  PRIMARY KEY (`id`),
226  UNIQUE KEY `item_guid` (`itemguid`)
227) ENGINE=InnoDB DEFAULT CHARSET=utf8;
228/*!40101 SET character_set_client = @saved_cs_client */;
229
230--
231-- Dumping data for table `auctionhouse`
232--
233
234LOCK TABLES `auctionhouse` WRITE;
235/*!40000 ALTER TABLE `auctionhouse` DISABLE KEYS */;
236/*!40000 ALTER TABLE `auctionhouse` ENABLE KEYS */;
237UNLOCK TABLES;
238
239--
240-- Table structure for table `banned_addons`
241--
242
243DROP TABLE IF EXISTS `banned_addons`;
244/*!40101 SET @saved_cs_client     = @@character_set_client */;
245/*!40101 SET character_set_client = utf8 */;
246CREATE TABLE `banned_addons` (
247  `Id` int(10) unsigned NOT NULL AUTO_INCREMENT,
248  `Name` varchar(255) NOT NULL,
249  `Version` varchar(255) NOT NULL DEFAULT '',
250  `Timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
251  PRIMARY KEY (`Id`),
252  UNIQUE KEY `idx_name_ver` (`Name`,`Version`)
253) ENGINE=InnoDB DEFAULT CHARSET=utf8;
254/*!40101 SET character_set_client = @saved_cs_client */;
255
256--
257-- Dumping data for table `banned_addons`
258--
259
260LOCK TABLES `banned_addons` WRITE;
261/*!40000 ALTER TABLE `banned_addons` DISABLE KEYS */;
262/*!40000 ALTER TABLE `banned_addons` ENABLE KEYS */;
263UNLOCK TABLES;
264
265--
266-- Table structure for table `battleground_deserters`
267--
268
269DROP TABLE IF EXISTS `battleground_deserters`;
270/*!40101 SET @saved_cs_client     = @@character_set_client */;
271/*!40101 SET character_set_client = utf8 */;
272CREATE TABLE `battleground_deserters` (
273  `guid` int(10) unsigned NOT NULL COMMENT 'characters.guid',
274  `type` tinyint(3) unsigned NOT NULL COMMENT 'type of the desertion',
275  `datetime` datetime NOT NULL COMMENT 'datetime of the desertion'
276) ENGINE=InnoDB DEFAULT CHARSET=latin1;
277/*!40101 SET character_set_client = @saved_cs_client */;
278
279--
280-- Dumping data for table `battleground_deserters`
281--
282
283LOCK TABLES `battleground_deserters` WRITE;
284/*!40000 ALTER TABLE `battleground_deserters` DISABLE KEYS */;
285/*!40000 ALTER TABLE `battleground_deserters` ENABLE KEYS */;
286UNLOCK TABLES;
287
288--
289-- Table structure for table `bugreport`
290--
291
292DROP TABLE IF EXISTS `bugreport`;
293/*!40101 SET @saved_cs_client     = @@character_set_client */;
294/*!40101 SET character_set_client = utf8 */;
295CREATE TABLE `bugreport` (
296  `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Identifier',
297  `type` longtext NOT NULL,
298  `content` longtext NOT NULL,
299  PRIMARY KEY (`id`)
300) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Debug System';
301/*!40101 SET character_set_client = @saved_cs_client */;
302
303--
304-- Dumping data for table `bugreport`
305--
306
307LOCK TABLES `bugreport` WRITE;
308/*!40000 ALTER TABLE `bugreport` DISABLE KEYS */;
309/*!40000 ALTER TABLE `bugreport` ENABLE KEYS */;
310UNLOCK TABLES;
311
312--
313-- Table structure for table `calendar_events`
314--
315
316DROP TABLE IF EXISTS `calendar_events`;
317/*!40101 SET @saved_cs_client     = @@character_set_client */;
318/*!40101 SET character_set_client = utf8 */;
319CREATE TABLE `calendar_events` (
320  `id` bigint(20) unsigned NOT NULL DEFAULT '0',
321  `creator` int(10) unsigned NOT NULL DEFAULT '0',
322  `title` varchar(255) NOT NULL DEFAULT '',
323  `description` varchar(255) NOT NULL DEFAULT '',
324  `type` tinyint(1) unsigned NOT NULL DEFAULT '4',
325  `dungeon` int(10) NOT NULL DEFAULT '-1',
326  `eventtime` int(10) unsigned NOT NULL DEFAULT '0',
327  `flags` int(10) unsigned NOT NULL DEFAULT '0',
328  `time2` int(10) unsigned NOT NULL DEFAULT '0',
329  PRIMARY KEY (`id`)
330) ENGINE=InnoDB DEFAULT CHARSET=utf8;
331/*!40101 SET character_set_client = @saved_cs_client */;
332
333--
334-- Dumping data for table `calendar_events`
335--
336
337LOCK TABLES `calendar_events` WRITE;
338/*!40000 ALTER TABLE `calendar_events` DISABLE KEYS */;
339/*!40000 ALTER TABLE `calendar_events` ENABLE KEYS */;
340UNLOCK TABLES;
341
342--
343-- Table structure for table `calendar_invites`
344--
345
346DROP TABLE IF EXISTS `calendar_invites`;
347/*!40101 SET @saved_cs_client     = @@character_set_client */;
348/*!40101 SET character_set_client = utf8 */;
349CREATE TABLE `calendar_invites` (
350  `id` bigint(20) unsigned NOT NULL DEFAULT '0',
351  `event` bigint(20) unsigned NOT NULL DEFAULT '0',
352  `invitee` int(10) unsigned NOT NULL DEFAULT '0',
353  `sender` int(10) unsigned NOT NULL DEFAULT '0',
354  `status` tinyint(1) unsigned NOT NULL DEFAULT '0',
355  `statustime` int(10) unsigned NOT NULL DEFAULT '0',
356  `rank` tinyint(1) unsigned NOT NULL DEFAULT '0',
357  `text` varchar(255) NOT NULL DEFAULT '',
358  PRIMARY KEY (`id`)
359) ENGINE=InnoDB DEFAULT CHARSET=utf8;
360/*!40101 SET character_set_client = @saved_cs_client */;
361
362--
363-- Dumping data for table `calendar_invites`
364--
365
366LOCK TABLES `calendar_invites` WRITE;
367/*!40000 ALTER TABLE `calendar_invites` DISABLE KEYS */;
368/*!40000 ALTER TABLE `calendar_invites` ENABLE KEYS */;
369UNLOCK TABLES;
370
371--
372-- Table structure for table `channels`
373--
374
375DROP TABLE IF EXISTS `channels`;
376/*!40101 SET @saved_cs_client     = @@character_set_client */;
377/*!40101 SET character_set_client = utf8 */;
378CREATE TABLE `channels` (
379  `name` varchar(128) NOT NULL,
380  `team` int(10) unsigned NOT NULL,
381  `announce` tinyint(3) unsigned NOT NULL DEFAULT '1',
382  `ownership` tinyint(3) unsigned NOT NULL DEFAULT '1',
383  `password` varchar(32) DEFAULT NULL,
384  `bannedList` text,
385  `lastUsed` int(10) unsigned NOT NULL,
386  PRIMARY KEY (`name`,`team`)
387) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Channel System';
388/*!40101 SET character_set_client = @saved_cs_client */;
389
390--
391-- Dumping data for table `channels`
392--
393
394LOCK TABLES `channels` WRITE;
395/*!40000 ALTER TABLE `channels` DISABLE KEYS */;
396/*!40000 ALTER TABLE `channels` ENABLE KEYS */;
397UNLOCK TABLES;
398
399--
400-- Table structure for table `character_account_data`
401--
402
403DROP TABLE IF EXISTS `character_account_data`;
404/*!40101 SET @saved_cs_client     = @@character_set_client */;
405/*!40101 SET character_set_client = utf8 */;
406CREATE TABLE `character_account_data` (
407  `guid` int(10) unsigned NOT NULL DEFAULT '0',
408  `type` tinyint(3) unsigned NOT NULL DEFAULT '0',
409  `time` int(10) unsigned NOT NULL DEFAULT '0',
410  `data` blob NOT NULL,
411  PRIMARY KEY (`guid`,`type`)
412) ENGINE=InnoDB DEFAULT CHARSET=utf8;
413/*!40101 SET character_set_client = @saved_cs_client */;
414
415--
416-- Dumping data for table `character_account_data`
417--
418
419LOCK TABLES `character_account_data` WRITE;
420/*!40000 ALTER TABLE `character_account_data` DISABLE KEYS */;
421/*!40000 ALTER TABLE `character_account_data` ENABLE KEYS */;
422UNLOCK TABLES;
423
424--
425-- Table structure for table `character_achievement`
426--
427
428DROP TABLE IF EXISTS `character_achievement`;
429/*!40101 SET @saved_cs_client     = @@character_set_client */;
430/*!40101 SET character_set_client = utf8 */;
431CREATE TABLE `character_achievement` (
432  `guid` int(10) unsigned NOT NULL,
433  `achievement` smallint(5) unsigned NOT NULL,
434  `date` int(10) unsigned NOT NULL DEFAULT '0',
435  PRIMARY KEY (`guid`,`achievement`)
436) ENGINE=InnoDB DEFAULT CHARSET=utf8;
437/*!40101 SET character_set_client = @saved_cs_client */;
438
439--
440-- Dumping data for table `character_achievement`
441--
442
443LOCK TABLES `character_achievement` WRITE;
444/*!40000 ALTER TABLE `character_achievement` DISABLE KEYS */;
445/*!40000 ALTER TABLE `character_achievement` ENABLE KEYS */;
446UNLOCK TABLES;
447
448--
449-- Table structure for table `character_achievement_progress`
450--
451
452DROP TABLE IF EXISTS `character_achievement_progress`;
453/*!40101 SET @saved_cs_client     = @@character_set_client */;
454/*!40101 SET character_set_client = utf8 */;
455CREATE TABLE `character_achievement_progress` (
456  `guid` int(10) unsigned NOT NULL,
457  `criteria` smallint(5) unsigned NOT NULL,
458  `counter` int(10) unsigned NOT NULL,
459  `date` int(10) unsigned NOT NULL DEFAULT '0',
460  PRIMARY KEY (`guid`,`criteria`)
461) ENGINE=InnoDB DEFAULT CHARSET=utf8;
462/*!40101 SET character_set_client = @saved_cs_client */;
463
464--
465-- Dumping data for table `character_achievement_progress`
466--
467
468LOCK TABLES `character_achievement_progress` WRITE;
469/*!40000 ALTER TABLE `character_achievement_progress` DISABLE KEYS */;
470/*!40000 ALTER TABLE `character_achievement_progress` ENABLE KEYS */;
471UNLOCK TABLES;
472
473--
474-- Table structure for table `character_action`
475--
476
477DROP TABLE IF EXISTS `character_action`;
478/*!40101 SET @saved_cs_client     = @@character_set_client */;
479/*!40101 SET character_set_client = utf8 */;
480CREATE TABLE `character_action` (
481  `guid` int(10) unsigned NOT NULL DEFAULT '0',
482  `spec` tinyint(3) unsigned NOT NULL DEFAULT '0',
483  `button` tinyint(3) unsigned NOT NULL DEFAULT '0',
484  `action` int(10) unsigned NOT NULL DEFAULT '0',
485  `type` tinyint(3) unsigned NOT NULL DEFAULT '0',
486  PRIMARY KEY (`guid`,`spec`,`button`)
487) ENGINE=InnoDB DEFAULT CHARSET=utf8;
488/*!40101 SET character_set_client = @saved_cs_client */;
489
490--
491-- Dumping data for table `character_action`
492--
493
494LOCK TABLES `character_action` WRITE;
495/*!40000 ALTER TABLE `character_action` DISABLE KEYS */;
496/*!40000 ALTER TABLE `character_action` ENABLE KEYS */;
497UNLOCK TABLES;
498
499--
500-- Table structure for table `character_arena_stats`
501--
502
503DROP TABLE IF EXISTS `character_arena_stats`;
504/*!40101 SET @saved_cs_client     = @@character_set_client */;
505/*!40101 SET character_set_client = utf8 */;
506CREATE TABLE `character_arena_stats` (
507  `guid` int(10) unsigned NOT NULL DEFAULT '0',
508  `slot` tinyint(3) unsigned NOT NULL DEFAULT '0',
509  `matchMakerRating` smallint(5) unsigned NOT NULL DEFAULT '0',
510  PRIMARY KEY (`guid`,`slot`)
511) ENGINE=InnoDB DEFAULT CHARSET=utf8;
512/*!40101 SET character_set_client = @saved_cs_client */;
513
514--
515-- Dumping data for table `character_arena_stats`
516--
517
518LOCK TABLES `character_arena_stats` WRITE;
519/*!40000 ALTER TABLE `character_arena_stats` DISABLE KEYS */;
520/*!40000 ALTER TABLE `character_arena_stats` ENABLE KEYS */;
521UNLOCK TABLES;
522
523--
524-- Table structure for table `character_aura`
525--
526
527DROP TABLE IF EXISTS `character_aura`;
528/*!40101 SET @saved_cs_client     = @@character_set_client */;
529/*!40101 SET character_set_client = utf8 */;
530CREATE TABLE `character_aura` (
531  `guid` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Global Unique Identifier',
532  `casterGuid` bigint(20) unsigned NOT NULL DEFAULT '0' COMMENT 'Full Global Unique Identifier',
533  `spell` mediumint(8) unsigned NOT NULL DEFAULT '0',
534  `effectMask` tinyint(3) unsigned NOT NULL DEFAULT '0',
535  `recalculateMask` tinyint(3) unsigned NOT NULL DEFAULT '0',
536  `stackCount` tinyint(3) unsigned NOT NULL DEFAULT '1',
537  `amount0` int(11) NOT NULL DEFAULT '0',
538  `amount1` int(11) NOT NULL DEFAULT '0',
539  `amount2` int(11) NOT NULL DEFAULT '0',
540  `base_amount0` int(11) NOT NULL DEFAULT '0',
541  `base_amount1` int(11) NOT NULL DEFAULT '0',
542  `base_amount2` int(11) NOT NULL DEFAULT '0',
543  `maxDuration` int(11) NOT NULL DEFAULT '0',
544  `remainTime` int(11) NOT NULL DEFAULT '0',
545  `remainCharges` tinyint(3) unsigned NOT NULL DEFAULT '0',
546  `critChance` float NOT NULL DEFAULT '0',
547  `applyResilience` tinyint(3) NOT NULL DEFAULT '0',
548  PRIMARY KEY (`guid`,`casterGuid`,`spell`,`effectMask`)
549) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Player System';
550/*!40101 SET character_set_client = @saved_cs_client */;
551
552--
553-- Dumping data for table `character_aura`
554--
555
556LOCK TABLES `character_aura` WRITE;
557/*!40000 ALTER TABLE `character_aura` DISABLE KEYS */;
558/*!40000 ALTER TABLE `character_aura` ENABLE KEYS */;
559UNLOCK TABLES;
560
561--
562-- Table structure for table `character_banned`
563--
564
565DROP TABLE IF EXISTS `character_banned`;
566/*!40101 SET @saved_cs_client     = @@character_set_client */;
567/*!40101 SET character_set_client = utf8 */;
568CREATE TABLE `character_banned` (
569  `guid` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Global Unique Identifier',
570  `bandate` int(10) unsigned NOT NULL DEFAULT '0',
571  `unbandate` int(10) unsigned NOT NULL DEFAULT '0',
572  `bannedby` varchar(50) NOT NULL,
573  `banreason` varchar(255) NOT NULL,
574  `active` tinyint(3) unsigned NOT NULL DEFAULT '1',
575  PRIMARY KEY (`guid`,`bandate`)
576) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Ban List';
577/*!40101 SET character_set_client = @saved_cs_client */;
578
579--
580-- Dumping data for table `character_banned`
581--
582
583LOCK TABLES `character_banned` WRITE;
584/*!40000 ALTER TABLE `character_banned` DISABLE KEYS */;
585/*!40000 ALTER TABLE `character_banned` ENABLE KEYS */;
586UNLOCK TABLES;
587
588--
589-- Table structure for table `character_battleground_data`
590--
591
592DROP TABLE IF EXISTS `character_battleground_data`;
593/*!40101 SET @saved_cs_client     = @@character_set_client */;
594/*!40101 SET character_set_client = utf8 */;
595CREATE TABLE `character_battleground_data` (
596  `guid` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Global Unique Identifier',
597  `instanceId` int(10) unsigned NOT NULL COMMENT 'Instance Identifier',
598  `team` smallint(5) unsigned NOT NULL,
599  `joinX` float NOT NULL DEFAULT '0',
600  `joinY` float NOT NULL DEFAULT '0',
601  `joinZ` float NOT NULL DEFAULT '0',
602  `joinO` float NOT NULL DEFAULT '0',
603  `joinMapId` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Map Identifier',
604  `taxiStart` int(10) unsigned NOT NULL DEFAULT '0',
605  `taxiEnd` int(10) unsigned NOT NULL DEFAULT '0',
606  `mountSpell` mediumint(8) unsigned NOT NULL DEFAULT '0',
607  PRIMARY KEY (`guid`)
608) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Player System';
609/*!40101 SET character_set_client = @saved_cs_client */;
610
611--
612-- Dumping data for table `character_battleground_data`
613--
614
615LOCK TABLES `character_battleground_data` WRITE;
616/*!40000 ALTER TABLE `character_battleground_data` DISABLE KEYS */;
617/*!40000 ALTER TABLE `character_battleground_data` ENABLE KEYS */;
618UNLOCK TABLES;
619
620--
621-- Table structure for table `character_battleground_random`
622--
623
624DROP TABLE IF EXISTS `character_battleground_random`;
625/*!40101 SET @saved_cs_client     = @@character_set_client */;
626/*!40101 SET character_set_client = utf8 */;
627CREATE TABLE `character_battleground_random` (
628  `guid` int(10) unsigned NOT NULL DEFAULT '0',
629  PRIMARY KEY (`guid`)
630) ENGINE=InnoDB DEFAULT CHARSET=utf8;
631/*!40101 SET character_set_client = @saved_cs_client */;
632
633--
634-- Dumping data for table `character_battleground_random`
635--
636
637LOCK TABLES `character_battleground_random` WRITE;
638/*!40000 ALTER TABLE `character_battleground_random` DISABLE KEYS */;
639/*!40000 ALTER TABLE `character_battleground_random` ENABLE KEYS */;
640UNLOCK TABLES;
641
642--
643-- Table structure for table `character_declinedname`
644--
645
646DROP TABLE IF EXISTS `character_declinedname`;
647/*!40101 SET @saved_cs_client     = @@character_set_client */;
648/*!40101 SET character_set_client = utf8 */;
649CREATE TABLE `character_declinedname` (
650  `guid` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Global Unique Identifier',
651  `genitive` varchar(15) NOT NULL DEFAULT '',
652  `dative` varchar(15) NOT NULL DEFAULT '',
653  `accusative` varchar(15) NOT NULL DEFAULT '',
654  `instrumental` varchar(15) NOT NULL DEFAULT '',
655  `prepositional` varchar(15) NOT NULL DEFAULT '',
656  PRIMARY KEY (`guid`)
657) ENGINE=InnoDB DEFAULT CHARSET=utf8;
658/*!40101 SET character_set_client = @saved_cs_client */;
659
660--
661-- Dumping data for table `character_declinedname`
662--
663
664LOCK TABLES `character_declinedname` WRITE;
665/*!40000 ALTER TABLE `character_declinedname` DISABLE KEYS */;
666/*!40000 ALTER TABLE `character_declinedname` ENABLE KEYS */;
667UNLOCK TABLES;
668
669--
670-- Table structure for table `character_equipmentsets`
671--
672
673DROP TABLE IF EXISTS `character_equipmentsets`;
674/*!40101 SET @saved_cs_client     = @@character_set_client */;
675/*!40101 SET character_set_client = utf8 */;
676CREATE TABLE `character_equipmentsets` (
677  `guid` int(10) unsigned NOT NULL DEFAULT '0',
678  `setguid` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
679  `setindex` tinyint(3) unsigned NOT NULL DEFAULT '0',
680  `name` varchar(31) NOT NULL,
681  `iconname` varchar(100) NOT NULL,
682  `ignore_mask` int(11) unsigned NOT NULL DEFAULT '0',
683  `item0` int(11) unsigned NOT NULL DEFAULT '0',
684  `item1` int(11) unsigned NOT NULL DEFAULT '0',
685  `item2` int(11) unsigned NOT NULL DEFAULT '0',
686  `item3` int(11) unsigned NOT NULL DEFAULT '0',
687  `item4` int(11) unsigned NOT NULL DEFAULT '0',
688  `item5` int(11) unsigned NOT NULL DEFAULT '0',
689  `item6` int(11) unsigned NOT NULL DEFAULT '0',
690  `item7` int(11) unsigned NOT NULL DEFAULT '0',
691  `item8` int(11) unsigned NOT NULL DEFAULT '0',
692  `item9` int(11) unsigned NOT NULL DEFAULT '0',
693  `item10` int(11) unsigned NOT NULL DEFAULT '0',
694  `item11` int(11) unsigned NOT NULL DEFAULT '0',
695  `item12` int(11) unsigned NOT NULL DEFAULT '0',
696  `item13` int(11) unsigned NOT NULL DEFAULT '0',
697  `item14` int(11) unsigned NOT NULL DEFAULT '0',
698  `item15` int(11) unsigned NOT NULL DEFAULT '0',
699  `item16` int(11) unsigned NOT NULL DEFAULT '0',
700  `item17` int(11) unsigned NOT NULL DEFAULT '0',
701  `item18` int(11) unsigned NOT NULL DEFAULT '0',
702  PRIMARY KEY (`setguid`),
703  UNIQUE KEY `idx_set` (`guid`,`setguid`,`setindex`),
704  KEY `Idx_setindex` (`setindex`)
705) ENGINE=InnoDB DEFAULT CHARSET=utf8;
706/*!40101 SET character_set_client = @saved_cs_client */;
707
708--
709-- Dumping data for table `character_equipmentsets`
710--
711
712LOCK TABLES `character_equipmentsets` WRITE;
713/*!40000 ALTER TABLE `character_equipmentsets` DISABLE KEYS */;
714/*!40000 ALTER TABLE `character_equipmentsets` ENABLE KEYS */;
715UNLOCK TABLES;
716
717--
718-- Table structure for table `character_fishingsteps`
719--
720
721DROP TABLE IF EXISTS `character_fishingsteps`;
722/*!40101 SET @saved_cs_client     = @@character_set_client */;
723/*!40101 SET character_set_client = utf8 */;
724CREATE TABLE `character_fishingsteps` (
725  `guid` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Global Unique Identifier',
726  `fishingSteps` tinyint(3) unsigned NOT NULL DEFAULT '0',
727  PRIMARY KEY (`guid`)
728) ENGINE=InnoDB DEFAULT CHARSET=utf8;
729/*!40101 SET character_set_client = @saved_cs_client */;
730
731--
732-- Dumping data for table `character_fishingsteps`
733--
734
735LOCK TABLES `character_fishingsteps` WRITE;
736/*!40000 ALTER TABLE `character_fishingsteps` DISABLE KEYS */;
737/*!40000 ALTER TABLE `character_fishingsteps` ENABLE KEYS */;
738UNLOCK TABLES;
739
740--
741-- Table structure for table `character_gifts`
742--
743
744DROP TABLE IF EXISTS `character_gifts`;
745/*!40101 SET @saved_cs_client     = @@character_set_client */;
746/*!40101 SET character_set_client = utf8 */;
747CREATE TABLE `character_gifts` (
748  `guid` int(10) unsigned NOT NULL DEFAULT '0',
749  `item_guid` int(10) unsigned NOT NULL DEFAULT '0',
750  `entry` int(10) unsigned NOT NULL DEFAULT '0',
751  `flags` int(10) unsigned NOT NULL DEFAULT '0',
752  PRIMARY KEY (`item_guid`),
753  KEY `idx_guid` (`guid`)
754) ENGINE=InnoDB DEFAULT CHARSET=utf8;
755/*!40101 SET character_set_client = @saved_cs_client */;
756
757--
758-- Dumping data for table `character_gifts`
759--
760
761LOCK TABLES `character_gifts` WRITE;
762/*!40000 ALTER TABLE `character_gifts` DISABLE KEYS */;
763/*!40000 ALTER TABLE `character_gifts` ENABLE KEYS */;
764UNLOCK TABLES;
765
766--
767-- Table structure for table `character_glyphs`
768--
769
770DROP TABLE IF EXISTS `character_glyphs`;
771/*!40101 SET @saved_cs_client     = @@character_set_client */;
772/*!40101 SET character_set_client = utf8 */;
773CREATE TABLE `character_glyphs` (
774  `guid` int(10) unsigned NOT NULL,
775  `talentGroup` tinyint(3) unsigned NOT NULL DEFAULT '0',
776  `glyph1` smallint(5) unsigned DEFAULT '0',
777  `glyph2` smallint(5) unsigned DEFAULT '0',
778  `glyph3` smallint(5) unsigned DEFAULT '0',
779  `glyph4` smallint(5) unsigned DEFAULT '0',
780  `glyph5` smallint(5) unsigned DEFAULT '0',
781  `glyph6` smallint(5) unsigned DEFAULT '0',
782  PRIMARY KEY (`guid`,`talentGroup`)
783) ENGINE=InnoDB DEFAULT CHARSET=utf8;
784/*!40101 SET character_set_client = @saved_cs_client */;
785
786--
787-- Dumping data for table `character_glyphs`
788--
789
790LOCK TABLES `character_glyphs` WRITE;
791/*!40000 ALTER TABLE `character_glyphs` DISABLE KEYS */;
792/*!40000 ALTER TABLE `character_glyphs` ENABLE KEYS */;
793UNLOCK TABLES;
794
795--
796-- Table structure for table `character_homebind`
797--
798
799DROP TABLE IF EXISTS `character_homebind`;
800/*!40101 SET @saved_cs_client     = @@character_set_client */;
801/*!40101 SET character_set_client = utf8 */;
802CREATE TABLE `character_homebind` (
803  `guid` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Global Unique Identifier',
804  `mapId` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Map Identifier',
805  `zoneId` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Zone Identifier',
806  `posX` float NOT NULL DEFAULT '0',
807  `posY` float NOT NULL DEFAULT '0',
808  `posZ` float NOT NULL DEFAULT '0',
809  PRIMARY KEY (`guid`)
810) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Player System';
811/*!40101 SET character_set_client = @saved_cs_client */;
812
813--
814-- Dumping data for table `character_homebind`
815--
816
817LOCK TABLES `character_homebind` WRITE;
818/*!40000 ALTER TABLE `character_homebind` DISABLE KEYS */;
819/*!40000 ALTER TABLE `character_homebind` ENABLE KEYS */;
820UNLOCK TABLES;
821
822--
823-- Table structure for table `character_instance`
824--
825
826DROP TABLE IF EXISTS `character_instance`;
827/*!40101 SET @saved_cs_client     = @@character_set_client */;
828/*!40101 SET character_set_client = utf8 */;
829CREATE TABLE `character_instance` (
830  `guid` int(10) unsigned NOT NULL DEFAULT '0',
831  `instance` int(10) unsigned NOT NULL DEFAULT '0',
832  `permanent` tinyint(3) unsigned NOT NULL DEFAULT '0',
833  `extendState` tinyint(2) unsigned NOT NULL DEFAULT '1',
834  PRIMARY KEY (`guid`,`instance`),
835  KEY `instance` (`instance`)
836) ENGINE=InnoDB DEFAULT CHARSET=utf8;
837/*!40101 SET character_set_client = @saved_cs_client */;
838
839--
840-- Dumping data for table `character_instance`
841--
842
843LOCK TABLES `character_instance` WRITE;
844/*!40000 ALTER TABLE `character_instance` DISABLE KEYS */;
845/*!40000 ALTER TABLE `character_instance` ENABLE KEYS */;
846UNLOCK TABLES;
847
848--
849-- Table structure for table `character_inventory`
850--
851
852DROP TABLE IF EXISTS `character_inventory`;
853/*!40101 SET @saved_cs_client     = @@character_set_client */;
854/*!40101 SET character_set_client = utf8 */;
855CREATE TABLE `character_inventory` (
856  `guid` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Global Unique Identifier',
857  `bag` int(10) unsigned NOT NULL DEFAULT '0',
858  `slot` tinyint(3) unsigned NOT NULL DEFAULT '0',
859  `item` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Item Global Unique Identifier',
860  PRIMARY KEY (`item`),
861  UNIQUE KEY `guid` (`guid`,`bag`,`slot`),
862  KEY `idx_guid` (`guid`)
863) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Player System';
864/*!40101 SET character_set_client = @saved_cs_client */;
865
866--
867-- Dumping data for table `character_inventory`
868--
869
870LOCK TABLES `character_inventory` WRITE;
871/*!40000 ALTER TABLE `character_inventory` DISABLE KEYS */;
872/*!40000 ALTER TABLE `character_inventory` ENABLE KEYS */;
873UNLOCK TABLES;
874
875--
876-- Table structure for table `character_pet`
877--
878
879DROP TABLE IF EXISTS `character_pet`;
880/*!40101 SET @saved_cs_client     = @@character_set_client */;
881/*!40101 SET character_set_client = utf8 */;
882CREATE TABLE `character_pet` (
883  `id` int(10) unsigned NOT NULL DEFAULT '0',
884  `entry` int(10) unsigned NOT NULL DEFAULT '0',
885  `owner` int(10) unsigned NOT NULL DEFAULT '0',
886  `modelid` int(10) unsigned DEFAULT '0',
887  `CreatedBySpell` mediumint(8) unsigned NOT NULL DEFAULT '0',
888  `PetType` tinyint(3) unsigned NOT NULL DEFAULT '0',
889  `level` smallint(5) unsigned NOT NULL DEFAULT '1',
890  `exp` int(10) unsigned NOT NULL DEFAULT '0',
891  `Reactstate` tinyint(3) unsigned NOT NULL DEFAULT '0',
892  `name` varchar(21) NOT NULL DEFAULT 'Pet',
893  `renamed` tinyint(3) unsigned NOT NULL DEFAULT '0',
894  `slot` tinyint(3) unsigned NOT NULL DEFAULT '0',
895  `curhealth` int(10) unsigned NOT NULL DEFAULT '1',
896  `curmana` int(10) unsigned NOT NULL DEFAULT '0',
897  `curhappiness` int(10) unsigned NOT NULL DEFAULT '0',
898  `savetime` int(10) unsigned NOT NULL DEFAULT '0',
899  `abdata` text,
900  PRIMARY KEY (`id`),
901  KEY `owner` (`owner`),
902  KEY `idx_slot` (`slot`)
903) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Pet System';
904/*!40101 SET character_set_client = @saved_cs_client */;
905
906--
907-- Dumping data for table `character_pet`
908--
909
910LOCK TABLES `character_pet` WRITE;
911/*!40000 ALTER TABLE `character_pet` DISABLE KEYS */;
912/*!40000 ALTER TABLE `character_pet` ENABLE KEYS */;
913UNLOCK TABLES;
914
915--
916-- Table structure for table `character_pet_declinedname`
917--
918
919DROP TABLE IF EXISTS `character_pet_declinedname`;
920/*!40101 SET @saved_cs_client     = @@character_set_client */;
921/*!40101 SET character_set_client = utf8 */;
922CREATE TABLE `character_pet_declinedname` (
923  `id` int(10) unsigned NOT NULL DEFAULT '0',
924  `owner` int(10) unsigned NOT NULL DEFAULT '0',
925  `genitive` varchar(12) NOT NULL DEFAULT '',
926  `dative` varchar(12) NOT NULL DEFAULT '',
927  `accusative` varchar(12) NOT NULL DEFAULT '',
928  `instrumental` varchar(12) NOT NULL DEFAULT '',
929  `prepositional` varchar(12) NOT NULL DEFAULT '',
930  PRIMARY KEY (`id`),
931  KEY `owner_key` (`owner`)
932) ENGINE=InnoDB DEFAULT CHARSET=utf8;
933/*!40101 SET character_set_client = @saved_cs_client */;
934
935--
936-- Dumping data for table `character_pet_declinedname`
937--
938
939LOCK TABLES `character_pet_declinedname` WRITE;
940/*!40000 ALTER TABLE `character_pet_declinedname` DISABLE KEYS */;
941/*!40000 ALTER TABLE `character_pet_declinedname` ENABLE KEYS */;
942UNLOCK TABLES;
943
944--
945-- Table structure for table `character_queststatus`
946--
947
948DROP TABLE IF EXISTS `character_queststatus`;
949/*!40101 SET @saved_cs_client     = @@character_set_client */;
950/*!40101 SET character_set_client = utf8 */;
951CREATE TABLE `character_queststatus` (
952  `guid` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Global Unique Identifier',
953  `quest` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Quest Identifier',
954  `status` tinyint(3) unsigned NOT NULL DEFAULT '0',
955  `explored` tinyint(3) unsigned NOT NULL DEFAULT '0',
956  `timer` int(10) unsigned NOT NULL DEFAULT '0',
957  `mobcount1` smallint(5) unsigned NOT NULL DEFAULT '0',
958  `mobcount2` smallint(5) unsigned NOT NULL DEFAULT '0',
959  `mobcount3` smallint(5) unsigned NOT NULL DEFAULT '0',
960  `mobcount4` smallint(5) unsigned NOT NULL DEFAULT '0',
961  `itemcount1` smallint(5) unsigned NOT NULL DEFAULT '0',
962  `itemcount2` smallint(5) unsigned NOT NULL DEFAULT '0',
963  `itemcount3` smallint(5) unsigned NOT NULL DEFAULT '0',
964  `itemcount4` smallint(5) unsigned NOT NULL DEFAULT '0',
965  `itemcount5` smallint(5) unsigned NOT NULL DEFAULT '0',
966  `itemcount6` smallint(5) unsigned NOT NULL DEFAULT '0',
967  `playercount` smallint(5) unsigned NOT NULL DEFAULT '0',
968  PRIMARY KEY (`guid`,`quest`)
969) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Player System';
970/*!40101 SET character_set_client = @saved_cs_client */;
971
972--
973-- Dumping data for table `character_queststatus`
974--
975
976LOCK TABLES `character_queststatus` WRITE;
977/*!40000 ALTER TABLE `character_queststatus` DISABLE KEYS */;
978/*!40000 ALTER TABLE `character_queststatus` ENABLE KEYS */;
979UNLOCK TABLES;
980
981--
982-- Table structure for table `character_queststatus_daily`
983--
984
985DROP TABLE IF EXISTS `character_queststatus_daily`;
986/*!40101 SET @saved_cs_client     = @@character_set_client */;
987/*!40101 SET character_set_client = utf8 */;
988CREATE TABLE `character_queststatus_daily` (
989  `guid` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Global Unique Identifier',
990  `quest` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Quest Identifier',
991  `time` int(10) unsigned NOT NULL DEFAULT '0',
992  PRIMARY KEY (`guid`,`quest`),
993  KEY `idx_guid` (`guid`)
994) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Player System';
995/*!40101 SET character_set_client = @saved_cs_client */;
996
997--
998-- Dumping data for table `character_queststatus_daily`
999--
1000
1001LOCK TABLES `character_queststatus_daily` WRITE;
1002/*!40000 ALTER TABLE `character_queststatus_daily` DISABLE KEYS */;
1003/*!40000 ALTER TABLE `character_queststatus_daily` ENABLE KEYS */;
1004UNLOCK TABLES;
1005
1006--
1007-- Table structure for table `character_queststatus_monthly`
1008--
1009
1010DROP TABLE IF EXISTS `character_queststatus_monthly`;
1011/*!40101 SET @saved_cs_client     = @@character_set_client */;
1012/*!40101 SET character_set_client = utf8 */;
1013CREATE TABLE `character_queststatus_monthly` (
1014  `guid` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Global Unique Identifier',
1015  `quest` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Quest Identifier',
1016  PRIMARY KEY (`guid`,`quest`),
1017  KEY `idx_guid` (`guid`)
1018) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Player System';
1019/*!40101 SET character_set_client = @saved_cs_client */;
1020
1021--
1022-- Dumping data for table `character_queststatus_monthly`
1023--
1024
1025LOCK TABLES `character_queststatus_monthly` WRITE;
1026/*!40000 ALTER TABLE `character_queststatus_monthly` DISABLE KEYS */;
1027/*!40000 ALTER TABLE `character_queststatus_monthly` ENABLE KEYS */;
1028UNLOCK TABLES;
1029
1030--
1031-- Table structure for table `character_queststatus_rewarded`
1032--
1033
1034DROP TABLE IF EXISTS `character_queststatus_rewarded`;
1035/*!40101 SET @saved_cs_client     = @@character_set_client */;
1036/*!40101 SET character_set_client = utf8 */;
1037CREATE TABLE `character_queststatus_rewarded` (
1038  `guid` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Global Unique Identifier',
1039  `quest` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Quest Identifier',
1040  `active` tinyint(10) unsigned NOT NULL DEFAULT '1',
1041  PRIMARY KEY (`guid`,`quest`)
1042) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Player System';
1043/*!40101 SET character_set_client = @saved_cs_client */;
1044
1045--
1046-- Dumping data for table `character_queststatus_rewarded`
1047--
1048
1049LOCK TABLES `character_queststatus_rewarded` WRITE;
1050/*!40000 ALTER TABLE `character_queststatus_rewarded` DISABLE KEYS */;
1051/*!40000 ALTER TABLE `character_queststatus_rewarded` ENABLE KEYS */;
1052UNLOCK TABLES;
1053
1054--
1055-- Table structure for table `character_queststatus_seasonal`
1056--
1057
1058DROP TABLE IF EXISTS `character_queststatus_seasonal`;
1059/*!40101 SET @saved_cs_client     = @@character_set_client */;
1060/*!40101 SET character_set_client = utf8 */;
1061CREATE TABLE `character_queststatus_seasonal` (
1062  `guid` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Global Unique Identifier',
1063  `quest` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Quest Identifier',
1064  `event` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Event Identifier',
1065  PRIMARY KEY (`guid`,`quest`),
1066  KEY `idx_guid` (`guid`)
1067) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Player System';
1068/*!40101 SET character_set_client = @saved_cs_client */;
1069
1070--
1071-- Dumping data for table `character_queststatus_seasonal`
1072--
1073
1074LOCK TABLES `character_queststatus_seasonal` WRITE;
1075/*!40000 ALTER TABLE `character_queststatus_seasonal` DISABLE KEYS */;
1076/*!40000 ALTER TABLE `character_queststatus_seasonal` ENABLE KEYS */;
1077UNLOCK TABLES;
1078
1079--
1080-- Table structure for table `character_queststatus_weekly`
1081--
1082
1083DROP TABLE IF EXISTS `character_queststatus_weekly`;
1084/*!40101 SET @saved_cs_client     = @@character_set_client */;
1085/*!40101 SET character_set_client = utf8 */;
1086CREATE TABLE `character_queststatus_weekly` (
1087  `guid` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Global Unique Identifier',
1088  `quest` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Quest Identifier',
1089  PRIMARY KEY (`guid`,`quest`),
1090  KEY `idx_guid` (`guid`)
1091) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Player System';
1092/*!40101 SET character_set_client = @saved_cs_client */;
1093
1094--
1095-- Dumping data for table `character_queststatus_weekly`
1096--
1097
1098LOCK TABLES `character_queststatus_weekly` WRITE;
1099/*!40000 ALTER TABLE `character_queststatus_weekly` DISABLE KEYS */;
1100/*!40000 ALTER TABLE `character_queststatus_weekly` ENABLE KEYS */;
1101UNLOCK TABLES;
1102
1103--
1104-- Table structure for table `character_reputation`
1105--
1106
1107DROP TABLE IF EXISTS `character_reputation`;
1108/*!40101 SET @saved_cs_client     = @@character_set_client */;
1109/*!40101 SET character_set_client = utf8 */;
1110CREATE TABLE `character_reputation` (
1111  `guid` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Global Unique Identifier',
1112  `faction` smallint(5) unsigned NOT NULL DEFAULT '0',
1113  `standing` int(11) NOT NULL DEFAULT '0',
1114  `flags` smallint(5) unsigned NOT NULL DEFAULT '0',
1115  PRIMARY KEY (`guid`,`faction`)
1116) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Player System';
1117/*!40101 SET character_set_client = @saved_cs_client */;
1118
1119--
1120-- Dumping data for table `character_reputation`
1121--
1122
1123LOCK TABLES `character_reputation` WRITE;
1124/*!40000 ALTER TABLE `character_reputation` DISABLE KEYS */;
1125/*!40000 ALTER TABLE `character_reputation` ENABLE KEYS */;
1126UNLOCK TABLES;
1127
1128--
1129-- Table structure for table `character_skills`
1130--
1131
1132DROP TABLE IF EXISTS `character_skills`;
1133/*!40101 SET @saved_cs_client     = @@character_set_client */;
1134/*!40101 SET character_set_client = utf8 */;
1135CREATE TABLE `character_skills` (
1136  `guid` int(10) unsigned NOT NULL COMMENT 'Global Unique Identifier',
1137  `skill` smallint(5) unsigned NOT NULL,
1138  `value` smallint(5) unsigned NOT NULL,
1139  `max` smallint(5) unsigned NOT NULL,
1140  PRIMARY KEY (`guid`,`skill`)
1141) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Player System';
1142/*!40101 SET character_set_client = @saved_cs_client */;
1143
1144--
1145-- Dumping data for table `character_skills`
1146--
1147
1148LOCK TABLES `character_skills` WRITE;
1149/*!40000 ALTER TABLE `character_skills` DISABLE KEYS */;
1150/*!40000 ALTER TABLE `character_skills` ENABLE KEYS */;
1151UNLOCK TABLES;
1152
1153--
1154-- Table structure for table `character_social`
1155--
1156
1157DROP TABLE IF EXISTS `character_social`;
1158/*!40101 SET @saved_cs_client     = @@character_set_client */;
1159/*!40101 SET character_set_client = utf8 */;
1160CREATE TABLE `character_social` (
1161  `guid` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Character Global Unique Identifier',
1162  `friend` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Friend Global Unique Identifier',
1163  `flags` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT 'Friend Flags',
1164  `note` varchar(48) NOT NULL DEFAULT '' COMMENT 'Friend Note',
1165  PRIMARY KEY (`guid`,`friend`,`flags`),
1166  KEY `friend` (`friend`)
1167) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Player System';
1168/*!40101 SET character_set_client = @saved_cs_client */;
1169
1170--
1171-- Dumping data for table `character_social`
1172--
1173
1174LOCK TABLES `character_social` WRITE;
1175/*!40000 ALTER TABLE `character_social` DISABLE KEYS */;
1176/*!40000 ALTER TABLE `character_social` ENABLE KEYS */;
1177UNLOCK TABLES;
1178
1179--
1180-- Table structure for table `character_spell`
1181--
1182
1183DROP TABLE IF EXISTS `character_spell`;
1184/*!40101 SET @saved_cs_client     = @@character_set_client */;
1185/*!40101 SET character_set_client = utf8 */;
1186CREATE TABLE `character_spell` (
1187  `guid` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Global Unique Identifier',
1188  `spell` mediumint(8) unsigned NOT NULL DEFAULT '0' COMMENT 'Spell Identifier',
1189  `active` tinyint(3) unsigned NOT NULL DEFAULT '1',
1190  `disabled` tinyint(3) unsigned NOT NULL DEFAULT '0',
1191  PRIMARY KEY (`guid`,`spell`)
1192) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Player System';
1193/*!40101 SET character_set_client = @saved_cs_client */;
1194
1195--
1196-- Dumping data for table `character_spell`
1197--
1198
1199LOCK TABLES `character_spell` WRITE;
1200/*!40000 ALTER TABLE `character_spell` DISABLE KEYS */;
1201/*!40000 ALTER TABLE `character_spell` ENABLE KEYS */;
1202UNLOCK TABLES;
1203
1204--
1205-- Table structure for table `character_spell_cooldown`
1206--
1207
1208DROP TABLE IF EXISTS `character_spell_cooldown`;
1209/*!40101 SET @saved_cs_client     = @@character_set_client */;
1210/*!40101 SET character_set_client = utf8 */;
1211CREATE TABLE `character_spell_cooldown` (
1212  `guid` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Global Unique Identifier, Low part',
1213  `spell` mediumint(8) unsigned NOT NULL DEFAULT '0' COMMENT 'Spell Identifier',
1214  `item` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Item Identifier',
1215  `time` int(10) unsigned NOT NULL DEFAULT '0',
1216  `categoryId` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Spell category Id',
1217  `categoryEnd` int(10) unsigned NOT NULL DEFAULT '0',
1218  PRIMARY KEY (`guid`,`spell`)
1219) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1220/*!40101 SET character_set_client = @saved_cs_client */;
1221
1222--
1223-- Dumping data for table `character_spell_cooldown`
1224--
1225
1226LOCK TABLES `character_spell_cooldown` WRITE;
1227/*!40000 ALTER TABLE `character_spell_cooldown` DISABLE KEYS */;
1228/*!40000 ALTER TABLE `character_spell_cooldown` ENABLE KEYS */;
1229UNLOCK TABLES;
1230
1231--
1232-- Table structure for table `character_stats`
1233--
1234
1235DROP TABLE IF EXISTS `character_stats`;
1236/*!40101 SET @saved_cs_client     = @@character_set_client */;
1237/*!40101 SET character_set_client = utf8 */;
1238CREATE TABLE `character_stats` (
1239  `guid` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Global Unique Identifier, Low part',
1240  `maxhealth` int(10) unsigned NOT NULL DEFAULT '0',
1241  `maxpower1` int(10) unsigned NOT NULL DEFAULT '0',
1242  `maxpower2` int(10) unsigned NOT NULL DEFAULT '0',
1243  `maxpower3` int(10) unsigned NOT NULL DEFAULT '0',
1244  `maxpower4` int(10) unsigned NOT NULL DEFAULT '0',
1245  `maxpower5` int(10) unsigned NOT NULL DEFAULT '0',
1246  `maxpower6` int(10) unsigned NOT NULL DEFAULT '0',
1247  `maxpower7` int(10) unsigned NOT NULL DEFAULT '0',
1248  `strength` int(10) unsigned NOT NULL DEFAULT '0',
1249  `agility` int(10) unsigned NOT NULL DEFAULT '0',
1250  `stamina` int(10) unsigned NOT NULL DEFAULT '0',
1251  `intellect` int(10) unsigned NOT NULL DEFAULT '0',
1252  `spirit` int(10) unsigned NOT NULL DEFAULT '0',
1253  `armor` int(10) unsigned NOT NULL DEFAULT '0',
1254  `resHoly` int(10) unsigned NOT NULL DEFAULT '0',
1255  `resFire` int(10) unsigned NOT NULL DEFAULT '0',
1256  `resNature` int(10) unsigned NOT NULL DEFAULT '0',
1257  `resFrost` int(10) unsigned NOT NULL DEFAULT '0',
1258  `resShadow` int(10) unsigned NOT NULL DEFAULT '0',
1259  `resArcane` int(10) unsigned NOT NULL DEFAULT '0',
1260  `blockPct` float unsigned NOT NULL DEFAULT '0',
1261  `dodgePct` float unsigned NOT NULL DEFAULT '0',
1262  `parryPct` float unsigned NOT NULL DEFAULT '0',
1263  `critPct` float unsigned NOT NULL DEFAULT '0',
1264  `rangedCritPct` float unsigned NOT NULL DEFAULT '0',
1265  `spellCritPct` float unsigned NOT NULL DEFAULT '0',
1266  `attackPower` int(10) unsigned NOT NULL DEFAULT '0',
1267  `rangedAttackPower` int(10) unsigned NOT NULL DEFAULT '0',
1268  `spellPower` int(10) unsigned NOT NULL DEFAULT '0',
1269  `resilience` int(10) unsigned NOT NULL DEFAULT '0',
1270  PRIMARY KEY (`guid`)
1271) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1272/*!40101 SET character_set_client = @saved_cs_client */;
1273
1274--
1275-- Dumping data for table `character_stats`
1276--
1277
1278LOCK TABLES `character_stats` WRITE;
1279/*!40000 ALTER TABLE `character_stats` DISABLE KEYS */;
1280/*!40000 ALTER TABLE `character_stats` ENABLE KEYS */;
1281UNLOCK TABLES;
1282
1283--
1284-- Table structure for table `character_talent`
1285--
1286
1287DROP TABLE IF EXISTS `character_talent`;
1288/*!40101 SET @saved_cs_client     = @@character_set_client */;
1289/*!40101 SET character_set_client = utf8 */;
1290CREATE TABLE `character_talent` (
1291  `guid` int(10) unsigned NOT NULL,
1292  `spell` mediumint(8) unsigned NOT NULL,
1293  `talentGroup` tinyint(3) unsigned NOT NULL DEFAULT '0',
1294  PRIMARY KEY (`guid`,`spell`,`talentGroup`)
1295) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1296/*!40101 SET character_set_client = @saved_cs_client */;
1297
1298--
1299-- Dumping data for table `character_talent`
1300--
1301
1302LOCK TABLES `character_talent` WRITE;
1303/*!40000 ALTER TABLE `character_talent` DISABLE KEYS */;
1304/*!40000 ALTER TABLE `character_talent` ENABLE KEYS */;
1305UNLOCK TABLES;
1306
1307--
1308-- Table structure for table `characters`
1309--
1310
1311DROP TABLE IF EXISTS `characters`;
1312/*!40101 SET @saved_cs_client     = @@character_set_client */;
1313/*!40101 SET character_set_client = utf8 */;
1314CREATE TABLE `characters` (
1315  `guid` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Global Unique Identifier',
1316  `account` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Account Identifier',
1317  `name` varchar(12) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
1318  `race` tinyint(3) unsigned NOT NULL DEFAULT '0',
1319  `class` tinyint(3) unsigned NOT NULL DEFAULT '0',
1320  `gender` tinyint(3) unsigned NOT NULL DEFAULT '0',
1321  `level` tinyint(3) unsigned NOT NULL DEFAULT '0',
1322  `xp` int(10) unsigned NOT NULL DEFAULT '0',
1323  `money` int(10) unsigned NOT NULL DEFAULT '0',
1324  `skin` tinyint(3) unsigned NOT NULL DEFAULT '0',
1325  `face` tinyint(3) unsigned NOT NULL DEFAULT '0',
1326  `hairStyle` tinyint(3) unsigned NOT NULL DEFAULT '0',
1327  `hairColor` tinyint(3) unsigned NOT NULL DEFAULT '0',
1328  `facialStyle` tinyint(3) unsigned NOT NULL DEFAULT '0',
1329  `bankSlots` tinyint(3) unsigned NOT NULL DEFAULT '0',
1330  `restState` tinyint(3) unsigned NOT NULL DEFAULT '0',
1331  `playerFlags` int(10) unsigned NOT NULL DEFAULT '0',
1332  `position_x` float NOT NULL DEFAULT '0',
1333  `position_y` float NOT NULL DEFAULT '0',
1334  `position_z` float NOT NULL DEFAULT '0',
1335  `map` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Map Identifier',
1336  `instance_id` int(10) unsigned NOT NULL DEFAULT '0',
1337  `instance_mode_mask` tinyint(3) unsigned NOT NULL DEFAULT '0',
1338  `orientation` float NOT NULL DEFAULT '0',
1339  `taximask` text NOT NULL,
1340  `online` tinyint(3) unsigned NOT NULL DEFAULT '0',
1341  `cinematic` tinyint(3) unsigned NOT NULL DEFAULT '0',
1342  `totaltime` int(10) unsigned NOT NULL DEFAULT '0',
1343  `leveltime` int(10) unsigned NOT NULL DEFAULT '0',
1344  `logout_time` int(10) unsigned NOT NULL DEFAULT '0',
1345  `is_logout_resting` tinyint(3) unsigned NOT NULL DEFAULT '0',
1346  `rest_bonus` float NOT NULL DEFAULT '0',
1347  `resettalents_cost` int(10) unsigned NOT NULL DEFAULT '0',
1348  `resettalents_time` int(10) unsigned NOT NULL DEFAULT '0',
1349  `trans_x` float NOT NULL DEFAULT '0',
1350  `trans_y` float NOT NULL DEFAULT '0',
1351  `trans_z` float NOT NULL DEFAULT '0',
1352  `trans_o` float NOT NULL DEFAULT '0',
1353  `transguid` mediumint(8) unsigned NOT NULL DEFAULT '0',
1354  `extra_flags` smallint(5) unsigned NOT NULL DEFAULT '0',
1355  `stable_slots` tinyint(3) unsigned NOT NULL DEFAULT '0',
1356  `at_login` smallint(5) unsigned NOT NULL DEFAULT '0',
1357  `zone` smallint(5) unsigned NOT NULL DEFAULT '0',
1358  `death_expire_time` int(10) unsigned NOT NULL DEFAULT '0',
1359  `taxi_path` text,
1360  `arenaPoints` int(10) unsigned NOT NULL DEFAULT '0',
1361  `totalHonorPoints` int(10) unsigned NOT NULL DEFAULT '0',
1362  `todayHonorPoints` int(10) unsigned NOT NULL DEFAULT '0',
1363  `yesterdayHonorPoints` int(10) unsigned NOT NULL DEFAULT '0',
1364  `totalKills` int(10) unsigned NOT NULL DEFAULT '0',
1365  `todayKills` smallint(5) unsigned NOT NULL DEFAULT '0',
1366  `yesterdayKills` smallint(5) unsigned NOT NULL DEFAULT '0',
1367  `chosenTitle` int(10) unsigned NOT NULL DEFAULT '0',
1368  `knownCurrencies` bigint(20) unsigned NOT NULL DEFAULT '0',
1369  `watchedFaction` int(10) unsigned NOT NULL DEFAULT '0',
1370  `drunk` tinyint(3) unsigned NOT NULL DEFAULT '0',
1371  `health` int(10) unsigned NOT NULL DEFAULT '0',
1372  `power1` int(10) unsigned NOT NULL DEFAULT '0',
1373  `power2` int(10) unsigned NOT NULL DEFAULT '0',
1374  `power3` int(10) unsigned NOT NULL DEFAULT '0',
1375  `power4` int(10) unsigned NOT NULL DEFAULT '0',
1376  `power5` int(10) unsigned NOT NULL DEFAULT '0',
1377  `power6` int(10) unsigned NOT NULL DEFAULT '0',
1378  `power7` int(10) unsigned NOT NULL DEFAULT '0',
1379  `latency` mediumint(8) unsigned NOT NULL DEFAULT '0',
1380  `talentGroupsCount` tinyint(3) unsigned NOT NULL DEFAULT '1',
1381  `activeTalentGroup` tinyint(3) unsigned NOT NULL DEFAULT '0',
1382  `exploredZones` longtext,
1383  `equipmentCache` longtext,
1384  `ammoId` int(10) unsigned NOT NULL DEFAULT '0',
1385  `knownTitles` longtext,
1386  `actionBars` tinyint(3) unsigned NOT NULL DEFAULT '0',
1387  `grantableLevels` tinyint(3) unsigned NOT NULL DEFAULT '0',
1388  `deleteInfos_Account` int(10) unsigned DEFAULT NULL,
1389  `deleteInfos_Name` varchar(12) DEFAULT NULL,
1390  `deleteDate` int(10) unsigned DEFAULT NULL,
1391  PRIMARY KEY (`guid`),
1392  KEY `idx_account` (`account`),
1393  KEY `idx_online` (`online`),
1394  KEY `idx_name` (`name`)
1395) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Player System';
1396/*!40101 SET character_set_client = @saved_cs_client */;
1397
1398--
1399-- Dumping data for table `characters`
1400--
1401
1402LOCK TABLES `characters` WRITE;
1403/*!40000 ALTER TABLE `characters` DISABLE KEYS */;
1404/*!40000 ALTER TABLE `characters` ENABLE KEYS */;
1405UNLOCK TABLES;
1406
1407--
1408-- Table structure for table `corpse`
1409--
1410
1411DROP TABLE IF EXISTS `corpse`;
1412/*!40101 SET @saved_cs_client     = @@character_set_client */;
1413/*!40101 SET character_set_client = utf8 */;
1414CREATE TABLE `corpse` (
1415  `guid` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Character Global Unique Identifier',
1416  `posX` float NOT NULL DEFAULT '0',
1417  `posY` float NOT NULL DEFAULT '0',
1418  `posZ` float NOT NULL DEFAULT '0',
1419  `orientation` float NOT NULL DEFAULT '0',
1420  `mapId` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Map Identifier',
1421  `phaseMask` int(10) unsigned NOT NULL DEFAULT '1',
1422  `displayId` int(10) unsigned NOT NULL DEFAULT '0',
1423  `itemCache` text NOT NULL,
1424  `bytes1` int(10) unsigned NOT NULL DEFAULT '0',
1425  `bytes2` int(10) unsigned NOT NULL DEFAULT '0',
1426  `guildId` int(10) unsigned NOT NULL DEFAULT '0',
1427  `flags` tinyint(3) unsigned NOT NULL DEFAULT '0',
1428  `dynFlags` tinyint(3) unsigned NOT NULL DEFAULT '0',
1429  `time` int(10) unsigned NOT NULL DEFAULT '0',
1430  `corpseType` tinyint(3) unsigned NOT NULL DEFAULT '0',
1431  `instanceId` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Instance Identifier',
1432  PRIMARY KEY (`guid`),
1433  KEY `idx_type` (`corpseType`),
1434  KEY `idx_instance` (`instanceId`),
1435  KEY `idx_time` (`time`)
1436) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Death System';
1437/*!40101 SET character_set_client = @saved_cs_client */;
1438
1439--
1440-- Dumping data for table `corpse`
1441--
1442
1443LOCK TABLES `corpse` WRITE;
1444/*!40000 ALTER TABLE `corpse` DISABLE KEYS */;
1445/*!40000 ALTER TABLE `corpse` ENABLE KEYS */;
1446UNLOCK TABLES;
1447
1448--
1449-- Table structure for table `creature_respawn`
1450--
1451
1452DROP TABLE IF EXISTS `creature_respawn`;
1453/*!40101 SET @saved_cs_client     = @@character_set_client */;
1454/*!40101 SET character_set_client = utf8 */;
1455CREATE TABLE `creature_respawn` (
1456  `guid` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Global Unique Identifier',
1457  `respawnTime` bigint(20) unsigned NOT NULL DEFAULT '0',
1458  `mapId` smallint(10) unsigned NOT NULL DEFAULT '0',
1459  `instanceId` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Instance Identifier',
1460  PRIMARY KEY (`guid`,`instanceId`),
1461  KEY `idx_instance` (`instanceId`)
1462) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Grid Loading System';
1463/*!40101 SET character_set_client = @saved_cs_client */;
1464
1465--
1466-- Dumping data for table `creature_respawn`
1467--
1468
1469LOCK TABLES `creature_respawn` WRITE;
1470/*!40000 ALTER TABLE `creature_respawn` DISABLE KEYS */;
1471/*!40000 ALTER TABLE `creature_respawn` ENABLE KEYS */;
1472UNLOCK TABLES;
1473
1474--
1475-- Table structure for table `game_event_condition_save`
1476--
1477
1478DROP TABLE IF EXISTS `game_event_condition_save`;
1479/*!40101 SET @saved_cs_client     = @@character_set_client */;
1480/*!40101 SET character_set_client = utf8 */;
1481CREATE TABLE `game_event_condition_save` (
1482  `eventEntry` tinyint(3) unsigned NOT NULL,
1483  `condition_id` int(10) unsigned NOT NULL DEFAULT '0',
1484  `done` float DEFAULT '0',
1485  PRIMARY KEY (`eventEntry`,`condition_id`)
1486) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1487/*!40101 SET character_set_client = @saved_cs_client */;
1488
1489--
1490-- Dumping data for table `game_event_condition_save`
1491--
1492
1493LOCK TABLES `game_event_condition_save` WRITE;
1494/*!40000 ALTER TABLE `game_event_condition_save` DISABLE KEYS */;
1495/*!40000 ALTER TABLE `game_event_condition_save` ENABLE KEYS */;
1496UNLOCK TABLES;
1497
1498--
1499-- Table structure for table `game_event_save`
1500--
1501
1502DROP TABLE IF EXISTS `game_event_save`;
1503/*!40101 SET @saved_cs_client     = @@character_set_client */;
1504/*!40101 SET character_set_client = utf8 */;
1505CREATE TABLE `game_event_save` (
1506  `eventEntry` tinyint(3) unsigned NOT NULL,
1507  `state` tinyint(3) unsigned NOT NULL DEFAULT '1',
1508  `next_start` int(10) unsigned NOT NULL DEFAULT '0',
1509  PRIMARY KEY (`eventEntry`)
1510) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1511/*!40101 SET character_set_client = @saved_cs_client */;
1512
1513--
1514-- Dumping data for table `game_event_save`
1515--
1516
1517LOCK TABLES `game_event_save` WRITE;
1518/*!40000 ALTER TABLE `game_event_save` DISABLE KEYS */;
1519/*!40000 ALTER TABLE `game_event_save` ENABLE KEYS */;
1520UNLOCK TABLES;
1521
1522--
1523-- Table structure for table `gameobject_respawn`
1524--
1525
1526DROP TABLE IF EXISTS `gameobject_respawn`;
1527/*!40101 SET @saved_cs_client     = @@character_set_client */;
1528/*!40101 SET character_set_client = utf8 */;
1529CREATE TABLE `gameobject_respawn` (
1530  `guid` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Global Unique Identifier',
1531  `respawnTime` bigint(20) unsigned NOT NULL DEFAULT '0',
1532  `mapId` smallint(10) unsigned NOT NULL DEFAULT '0',
1533  `instanceId` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Instance Identifier',
1534  PRIMARY KEY (`guid`,`instanceId`),
1535  KEY `idx_instance` (`instanceId`)
1536) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Grid Loading System';
1537/*!40101 SET character_set_client = @saved_cs_client */;
1538
1539--
1540-- Dumping data for table `gameobject_respawn`
1541--
1542
1543LOCK TABLES `gameobject_respawn` WRITE;
1544/*!40000 ALTER TABLE `gameobject_respawn` DISABLE KEYS */;
1545/*!40000 ALTER TABLE `gameobject_respawn` ENABLE KEYS */;
1546UNLOCK TABLES;
1547
1548--
1549-- Table structure for table `gm_subsurvey`
1550--
1551
1552DROP TABLE IF EXISTS `gm_subsurvey`;
1553/*!40101 SET @saved_cs_client     = @@character_set_client */;
1554/*!40101 SET character_set_client = utf8 */;
1555CREATE TABLE `gm_subsurvey` (
1556  `surveyId` int(10) unsigned NOT NULL AUTO_INCREMENT,
1557  `questionId` int(10) unsigned NOT NULL DEFAULT '0',
1558  `answer` int(10) unsigned NOT NULL DEFAULT '0',
1559  `answerComment` text NOT NULL,
1560  PRIMARY KEY (`surveyId`,`questionId`)
1561) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Player System';
1562/*!40101 SET character_set_client = @saved_cs_client */;
1563
1564--
1565-- Dumping data for table `gm_subsurvey`
1566--
1567
1568LOCK TABLES `gm_subsurvey` WRITE;
1569/*!40000 ALTER TABLE `gm_subsurvey` DISABLE KEYS */;
1570/*!40000 ALTER TABLE `gm_subsurvey` ENABLE KEYS */;
1571UNLOCK TABLES;
1572
1573--
1574-- Table structure for table `gm_survey`
1575--
1576
1577DROP TABLE IF EXISTS `gm_survey`;
1578/*!40101 SET @saved_cs_client     = @@character_set_client */;
1579/*!40101 SET character_set_client = utf8 */;
1580CREATE TABLE `gm_survey` (
1581  `surveyId` int(10) unsigned NOT NULL AUTO_INCREMENT,
1582  `guid` int(10) unsigned NOT NULL DEFAULT '0',
1583  `mainSurvey` int(10) unsigned NOT NULL DEFAULT '0',
1584  `comment` longtext NOT NULL,
1585  `createTime` int(10) unsigned NOT NULL DEFAULT '0',
1586  PRIMARY KEY (`surveyId`)
1587) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Player System';
1588/*!40101 SET character_set_client = @saved_cs_client */;
1589
1590--
1591-- Dumping data for table `gm_survey`
1592--
1593
1594LOCK TABLES `gm_survey` WRITE;
1595/*!40000 ALTER TABLE `gm_survey` DISABLE KEYS */;
1596/*!40000 ALTER TABLE `gm_survey` ENABLE KEYS */;
1597UNLOCK TABLES;
1598
1599--
1600-- Table structure for table `gm_ticket`
1601--
1602
1603DROP TABLE IF EXISTS `gm_ticket`;
1604/*!40101 SET @saved_cs_client     = @@character_set_client */;
1605/*!40101 SET character_set_client = utf8 */;
1606CREATE TABLE `gm_ticket` (
1607  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
1608  `type` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT '0 open, 1 closed, 2 character deleted',
1609  `playerGuid` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Global Unique Identifier of ticket creator',
1610  `name` varchar(12) NOT NULL COMMENT 'Name of ticket creator',
1611  `description` text NOT NULL,
1612  `createTime` int(10) unsigned NOT NULL DEFAULT '0',
1613  `mapId` smallint(5) unsigned NOT NULL DEFAULT '0',
1614  `posX` float NOT NULL DEFAULT '0',
1615  `posY` float NOT NULL DEFAULT '0',
1616  `posZ` float NOT NULL DEFAULT '0',
1617  `lastModifiedTime` int(10) unsigned NOT NULL DEFAULT '0',
1618  `closedBy` int(10) NOT NULL DEFAULT '0',
1619  `assignedTo` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'GUID of admin to whom ticket is assigned',
1620  `comment` text NOT NULL,
1621  `response` text NOT NULL,
1622  `completed` tinyint(3) unsigned NOT NULL DEFAULT '0',
1623  `escalated` tinyint(3) unsigned NOT NULL DEFAULT '0',
1624  `viewed` tinyint(3) unsigned NOT NULL DEFAULT '0',
1625  `needMoreHelp` tinyint(3) unsigned NOT NULL DEFAULT '0',
1626  `resolvedBy` int(10) NOT NULL DEFAULT '0' COMMENT 'GUID of GM who resolved the ticket',
1627  PRIMARY KEY (`id`)
1628) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Player System';
1629/*!40101 SET character_set_client = @saved_cs_client */;
1630
1631--
1632-- Dumping data for table `gm_ticket`
1633--
1634
1635LOCK TABLES `gm_ticket` WRITE;
1636/*!40000 ALTER TABLE `gm_ticket` DISABLE KEYS */;
1637/*!40000 ALTER TABLE `gm_ticket` ENABLE KEYS */;
1638UNLOCK TABLES;
1639
1640--
1641-- Table structure for table `group_instance`
1642--
1643
1644DROP TABLE IF EXISTS `group_instance`;
1645/*!40101 SET @saved_cs_client     = @@character_set_client */;
1646/*!40101 SET character_set_client = utf8 */;
1647CREATE TABLE `group_instance` (
1648  `guid` int(10) unsigned NOT NULL DEFAULT '0',
1649  `instance` int(10) unsigned NOT NULL DEFAULT '0',
1650  `permanent` tinyint(3) unsigned NOT NULL DEFAULT '0',
1651  PRIMARY KEY (`guid`,`instance`),
1652  KEY `instance` (`instance`)
1653) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1654/*!40101 SET character_set_client = @saved_cs_client */;
1655
1656--
1657-- Dumping data for table `group_instance`
1658--
1659
1660LOCK TABLES `group_instance` WRITE;
1661/*!40000 ALTER TABLE `group_instance` DISABLE KEYS */;
1662/*!40000 ALTER TABLE `group_instance` ENABLE KEYS */;
1663UNLOCK TABLES;
1664
1665--
1666-- Table structure for table `group_member`
1667--
1668
1669DROP TABLE IF EXISTS `group_member`;
1670/*!40101 SET @saved_cs_client     = @@character_set_client */;
1671/*!40101 SET character_set_client = utf8 */;
1672CREATE TABLE `group_member` (
1673  `guid` int(10) unsigned NOT NULL,
1674  `memberGuid` int(10) unsigned NOT NULL,
1675  `memberFlags` tinyint(3) unsigned NOT NULL DEFAULT '0',
1676  `subgroup` tinyint(3) unsigned NOT NULL DEFAULT '0',
1677  `roles` tinyint(3) unsigned NOT NULL DEFAULT '0',
1678  PRIMARY KEY (`memberGuid`)
1679) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Groups';
1680/*!40101 SET character_set_client = @saved_cs_client */;
1681
1682--
1683-- Dumping data for table `group_member`
1684--
1685
1686LOCK TABLES `group_member` WRITE;
1687/*!40000 ALTER TABLE `group_member` DISABLE KEYS */;
1688/*!40000 ALTER TABLE `group_member` ENABLE KEYS */;
1689UNLOCK TABLES;
1690
1691--
1692-- Table structure for table `groups`
1693--
1694
1695DROP TABLE IF EXISTS `groups`;
1696/*!40101 SET @saved_cs_client     = @@character_set_client */;
1697/*!40101 SET character_set_client = utf8 */;
1698CREATE TABLE `groups` (
1699  `guid` int(10) unsigned NOT NULL,
1700  `leaderGuid` int(10) unsigned NOT NULL,
1701  `lootMethod` tinyint(3) unsigned NOT NULL,
1702  `looterGuid` int(10) unsigned NOT NULL,
1703  `lootThreshold` tinyint(3) unsigned NOT NULL,
1704  `icon1` bigint(20) unsigned NOT NULL,
1705  `icon2` bigint(20) unsigned NOT NULL,
1706  `icon3` bigint(20) unsigned NOT NULL,
1707  `icon4` bigint(20) unsigned NOT NULL,
1708  `icon5` bigint(20) unsigned NOT NULL,
1709  `icon6` bigint(20) unsigned NOT NULL,
1710  `icon7` bigint(20) unsigned NOT NULL,
1711  `icon8` bigint(20) unsigned NOT NULL,
1712  `groupType` tinyint(3) unsigned NOT NULL,
1713  `difficulty` tinyint(3) unsigned NOT NULL DEFAULT '0',
1714  `raidDifficulty` tinyint(3) unsigned NOT NULL DEFAULT '0',
1715  `masterLooterGuid` int(10) unsigned NOT NULL,
1716  PRIMARY KEY (`guid`),
1717  KEY `leaderGuid` (`leaderGuid`)
1718) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Groups';
1719/*!40101 SET character_set_client = @saved_cs_client */;
1720
1721--
1722-- Dumping data for table `groups`
1723--
1724
1725LOCK TABLES `groups` WRITE;
1726/*!40000 ALTER TABLE `groups` DISABLE KEYS */;
1727/*!40000 ALTER TABLE `groups` ENABLE KEYS */;
1728UNLOCK TABLES;
1729
1730--
1731-- Table structure for table `guild`
1732--
1733
1734DROP TABLE IF EXISTS `guild`;
1735/*!40101 SET @saved_cs_client     = @@character_set_client */;
1736/*!40101 SET character_set_client = utf8 */;
1737CREATE TABLE `guild` (
1738  `guildid` int(10) unsigned NOT NULL DEFAULT '0',
1739  `name` varchar(24) NOT NULL DEFAULT '',
1740  `leaderguid` int(10) unsigned NOT NULL DEFAULT '0',
1741  `EmblemStyle` tinyint(3) unsigned NOT NULL DEFAULT '0',
1742  `EmblemColor` tinyint(3) unsigned NOT NULL DEFAULT '0',
1743  `BorderStyle` tinyint(3) unsigned NOT NULL DEFAULT '0',
1744  `BorderColor` tinyint(3) unsigned NOT NULL DEFAULT '0',
1745  `BackgroundColor` tinyint(3) unsigned NOT NULL DEFAULT '0',
1746  `info` varchar(500) NOT NULL DEFAULT '',
1747  `motd` varchar(128) NOT NULL DEFAULT '',
1748  `createdate` int(10) unsigned NOT NULL DEFAULT '0',
1749  `BankMoney` bigint(20) unsigned NOT NULL DEFAULT '0',
1750  PRIMARY KEY (`guildid`)
1751) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Guild System';
1752/*!40101 SET character_set_client = @saved_cs_client */;
1753
1754--
1755-- Dumping data for table `guild`
1756--
1757
1758LOCK TABLES `guild` WRITE;
1759/*!40000 ALTER TABLE `guild` DISABLE KEYS */;
1760/*!40000 ALTER TABLE `guild` ENABLE KEYS */;
1761UNLOCK TABLES;
1762
1763--
1764-- Table structure for table `guild_bank_eventlog`
1765--
1766
1767DROP TABLE IF EXISTS `guild_bank_eventlog`;
1768/*!40101 SET @saved_cs_client     = @@character_set_client */;
1769/*!40101 SET character_set_client = utf8 */;
1770CREATE TABLE `guild_bank_eventlog` (
1771  `guildid` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Guild Identificator',
1772  `LogGuid` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Log record identificator - auxiliary column',
1773  `TabId` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT 'Guild bank TabId',
1774  `EventType` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT 'Event type',
1775  `PlayerGuid` int(10) unsigned NOT NULL DEFAULT '0',
1776  `ItemOrMoney` int(10) unsigned NOT NULL DEFAULT '0',
1777  `ItemStackCount` smallint(5) unsigned NOT NULL DEFAULT '0',
1778  `DestTabId` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT 'Destination Tab Id',
1779  `TimeStamp` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Event UNIX time',
1780  PRIMARY KEY (`guildid`,`LogGuid`,`TabId`),
1781  KEY `guildid_key` (`guildid`),
1782  KEY `Idx_PlayerGuid` (`PlayerGuid`),
1783  KEY `Idx_LogGuid` (`LogGuid`)
1784) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1785/*!40101 SET character_set_client = @saved_cs_client */;
1786
1787--
1788-- Dumping data for table `guild_bank_eventlog`
1789--
1790
1791LOCK TABLES `guild_bank_eventlog` WRITE;
1792/*!40000 ALTER TABLE `guild_bank_eventlog` DISABLE KEYS */;
1793/*!40000 ALTER TABLE `guild_bank_eventlog` ENABLE KEYS */;
1794UNLOCK TABLES;
1795
1796--
1797-- Table structure for table `guild_bank_item`
1798--
1799
1800DROP TABLE IF EXISTS `guild_bank_item`;
1801/*!40101 SET @saved_cs_client     = @@character_set_client */;
1802/*!40101 SET character_set_client = utf8 */;
1803CREATE TABLE `guild_bank_item` (
1804  `guildid` int(10) unsigned NOT NULL DEFAULT '0',
1805  `TabId` tinyint(3) unsigned NOT NULL DEFAULT '0',
1806  `SlotId` tinyint(3) unsigned NOT NULL DEFAULT '0',
1807  `item_guid` int(10) unsigned NOT NULL DEFAULT '0',
1808  PRIMARY KEY (`guildid`,`TabId`,`SlotId`),
1809  KEY `guildid_key` (`guildid`),
1810  KEY `Idx_item_guid` (`item_guid`)
1811) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1812/*!40101 SET character_set_client = @saved_cs_client */;
1813
1814--
1815-- Dumping data for table `guild_bank_item`
1816--
1817
1818LOCK TABLES `guild_bank_item` WRITE;
1819/*!40000 ALTER TABLE `guild_bank_item` DISABLE KEYS */;
1820/*!40000 ALTER TABLE `guild_bank_item` ENABLE KEYS */;
1821UNLOCK TABLES;
1822
1823--
1824-- Table structure for table `guild_bank_right`
1825--
1826
1827DROP TABLE IF EXISTS `guild_bank_right`;
1828/*!40101 SET @saved_cs_client     = @@character_set_client */;
1829/*!40101 SET character_set_client = utf8 */;
1830CREATE TABLE `guild_bank_right` (
1831  `guildid` int(10) unsigned NOT NULL DEFAULT '0',
1832  `TabId` tinyint(3) unsigned NOT NULL DEFAULT '0',
1833  `rid` tinyint(3) unsigned NOT NULL DEFAULT '0',
1834  `gbright` tinyint(3) unsigned NOT NULL DEFAULT '0',
1835  `SlotPerDay` int(10) unsigned NOT NULL DEFAULT '0',
1836  PRIMARY KEY (`guildid`,`TabId`,`rid`),
1837  KEY `guildid_key` (`guildid`)
1838) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1839/*!40101 SET character_set_client = @saved_cs_client */;
1840
1841--
1842-- Dumping data for table `guild_bank_right`
1843--
1844
1845LOCK TABLES `guild_bank_right` WRITE;
1846/*!40000 ALTER TABLE `guild_bank_right` DISABLE KEYS */;
1847/*!40000 ALTER TABLE `guild_bank_right` ENABLE KEYS */;
1848UNLOCK TABLES;
1849
1850--
1851-- Table structure for table `guild_bank_tab`
1852--
1853
1854DROP TABLE IF EXISTS `guild_bank_tab`;
1855/*!40101 SET @saved_cs_client     = @@character_set_client */;
1856/*!40101 SET character_set_client = utf8 */;
1857CREATE TABLE `guild_bank_tab` (
1858  `guildid` int(10) unsigned NOT NULL DEFAULT '0',
1859  `TabId` tinyint(3) unsigned NOT NULL DEFAULT '0',
1860  `TabName` varchar(16) NOT NULL DEFAULT '',
1861  `TabIcon` varchar(100) NOT NULL DEFAULT '',
1862  `TabText` varchar(500) DEFAULT NULL,
1863  PRIMARY KEY (`guildid`,`TabId`),
1864  KEY `guildid_key` (`guildid`)
1865) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1866/*!40101 SET character_set_client = @saved_cs_client */;
1867
1868--
1869-- Dumping data for table `guild_bank_tab`
1870--
1871
1872LOCK TABLES `guild_bank_tab` WRITE;
1873/*!40000 ALTER TABLE `guild_bank_tab` DISABLE KEYS */;
1874/*!40000 ALTER TABLE `guild_bank_tab` ENABLE KEYS */;
1875UNLOCK TABLES;
1876
1877--
1878-- Table structure for table `guild_eventlog`
1879--
1880
1881DROP TABLE IF EXISTS `guild_eventlog`;
1882/*!40101 SET @saved_cs_client     = @@character_set_client */;
1883/*!40101 SET character_set_client = utf8 */;
1884CREATE TABLE `guild_eventlog` (
1885  `guildid` int(10) unsigned NOT NULL COMMENT 'Guild Identificator',
1886  `LogGuid` int(10) unsigned NOT NULL COMMENT 'Log record identificator - auxiliary column',
1887  `EventType` tinyint(3) unsigned NOT NULL COMMENT 'Event type',
1888  `PlayerGuid1` int(10) unsigned NOT NULL COMMENT 'Player 1',
1889  `PlayerGuid2` int(10) unsigned NOT NULL COMMENT 'Player 2',
1890  `NewRank` tinyint(3) unsigned NOT NULL COMMENT 'New rank(in case promotion/demotion)',
1891  `TimeStamp` int(10) unsigned NOT NULL COMMENT 'Event UNIX time',
1892  PRIMARY KEY (`guildid`,`LogGuid`),
1893  KEY `Idx_PlayerGuid1` (`PlayerGuid1`),
1894  KEY `Idx_PlayerGuid2` (`PlayerGuid2`),
1895  KEY `Idx_LogGuid` (`LogGuid`)
1896) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Guild Eventlog';
1897/*!40101 SET character_set_client = @saved_cs_client */;
1898
1899--
1900-- Dumping data for table `guild_eventlog`
1901--
1902
1903LOCK TABLES `guild_eventlog` WRITE;
1904/*!40000 ALTER TABLE `guild_eventlog` DISABLE KEYS */;
1905/*!40000 ALTER TABLE `guild_eventlog` ENABLE KEYS */;
1906UNLOCK TABLES;
1907
1908--
1909-- Table structure for table `guild_member`
1910--
1911
1912DROP TABLE IF EXISTS `guild_member`;
1913/*!40101 SET @saved_cs_client     = @@character_set_client */;
1914/*!40101 SET character_set_client = utf8 */;
1915CREATE TABLE `guild_member` (
1916  `guildid` int(10) unsigned NOT NULL COMMENT 'Guild Identificator',
1917  `guid` int(10) unsigned NOT NULL,
1918  `rank` tinyint(3) unsigned NOT NULL,
1919  `pnote` varchar(31) NOT NULL DEFAULT '',
1920  `offnote` varchar(31) NOT NULL DEFAULT '',
1921  UNIQUE KEY `guid_key` (`guid`),
1922  KEY `guildid_key` (`guildid`),
1923  KEY `guildid_rank_key` (`guildid`,`rank`)
1924) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Guild System';
1925/*!40101 SET character_set_client = @saved_cs_client */;
1926
1927--
1928-- Dumping data for table `guild_member`
1929--
1930
1931LOCK TABLES `guild_member` WRITE;
1932/*!40000 ALTER TABLE `guild_member` DISABLE KEYS */;
1933/*!40000 ALTER TABLE `guild_member` ENABLE KEYS */;
1934UNLOCK TABLES;
1935
1936--
1937-- Table structure for table `guild_member_withdraw`
1938--
1939
1940DROP TABLE IF EXISTS `guild_member_withdraw`;
1941/*!40101 SET @saved_cs_client     = @@character_set_client */;
1942/*!40101 SET character_set_client = utf8 */;
1943CREATE TABLE `guild_member_withdraw` (
1944  `guid` int(10) unsigned NOT NULL,
1945  `tab0` int(10) unsigned NOT NULL DEFAULT '0',
1946  `tab1` int(10) unsigned NOT NULL DEFAULT '0',
1947  `tab2` int(10) unsigned NOT NULL DEFAULT '0',
1948  `tab3` int(10) unsigned NOT NULL DEFAULT '0',
1949  `tab4` int(10) unsigned NOT NULL DEFAULT '0',
1950  `tab5` int(10) unsigned NOT NULL DEFAULT '0',
1951  `money` int(10) unsigned NOT NULL DEFAULT '0',
1952  PRIMARY KEY (`guid`)
1953) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Guild Member Daily Withdraws';
1954/*!40101 SET character_set_client = @saved_cs_client */;
1955
1956--
1957-- Dumping data for table `guild_member_withdraw`
1958--
1959
1960LOCK TABLES `guild_member_withdraw` WRITE;
1961/*!40000 ALTER TABLE `guild_member_withdraw` DISABLE KEYS */;
1962/*!40000 ALTER TABLE `guild_member_withdraw` ENABLE KEYS */;
1963UNLOCK TABLES;
1964
1965--
1966-- Table structure for table `guild_rank`
1967--
1968
1969DROP TABLE IF EXISTS `guild_rank`;
1970/*!40101 SET @saved_cs_client     = @@character_set_client */;
1971/*!40101 SET character_set_client = utf8 */;
1972CREATE TABLE `guild_rank` (
1973  `guildid` int(10) unsigned NOT NULL DEFAULT '0',
1974  `rid` tinyint(3) unsigned NOT NULL,
1975  `rname` varchar(20) NOT NULL DEFAULT '',
1976  `rights` mediumint(8) unsigned NOT NULL DEFAULT '0',
1977  `BankMoneyPerDay` int(10) unsigned NOT NULL DEFAULT '0',
1978  PRIMARY KEY (`guildid`,`rid`),
1979  KEY `Idx_rid` (`rid`)
1980) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Guild System';
1981/*!40101 SET character_set_client = @saved_cs_client */;
1982
1983--
1984-- Dumping data for table `guild_rank`
1985--
1986
1987LOCK TABLES `guild_rank` WRITE;
1988/*!40000 ALTER TABLE `guild_rank` DISABLE KEYS */;
1989/*!40000 ALTER TABLE `guild_rank` ENABLE KEYS */;
1990UNLOCK TABLES;
1991
1992--
1993-- Table structure for table `instance`
1994--
1995
1996DROP TABLE IF EXISTS `instance`;
1997/*!40101 SET @saved_cs_client     = @@character_set_client */;
1998/*!40101 SET character_set_client = utf8 */;
1999CREATE TABLE `instance` (
2000  `id` int(10) unsigned NOT NULL DEFAULT '0',
2001  `map` smallint(5) unsigned NOT NULL DEFAULT '0',
2002  `resettime` bigint(20) unsigned NOT NULL DEFAULT '0',
2003  `difficulty` tinyint(3) unsigned NOT NULL DEFAULT '0',
2004  `completedEncounters` int(10) unsigned NOT NULL DEFAULT '0',
2005  `data` tinytext NOT NULL,
2006  PRIMARY KEY (`id`),
2007  KEY `map` (`map`),
2008  KEY `resettime` (`resettime`),
2009  KEY `difficulty` (`difficulty`)
2010) ENGINE=InnoDB DEFAULT CHARSET=utf8;
2011/*!40101 SET character_set_client = @saved_cs_client */;
2012
2013--
2014-- Dumping data for table `instance`
2015--
2016
2017LOCK TABLES `instance` WRITE;
2018/*!40000 ALTER TABLE `instance` DISABLE KEYS */;
2019/*!40000 ALTER TABLE `instance` ENABLE KEYS */;
2020UNLOCK TABLES;
2021
2022--
2023-- Table structure for table `instance_reset`
2024--
2025
2026DROP TABLE IF EXISTS `instance_reset`;
2027/*!40101 SET @saved_cs_client     = @@character_set_client */;
2028/*!40101 SET character_set_client = utf8 */;
2029CREATE TABLE `instance_reset` (
2030  `mapid` smallint(5) unsigned NOT NULL DEFAULT '0',
2031  `difficulty` tinyint(3) unsigned NOT NULL DEFAULT '0',
2032  `resettime` bigint(20) unsigned NOT NULL DEFAULT '0',
2033  PRIMARY KEY (`mapid`,`difficulty`),
2034  KEY `difficulty` (`difficulty`)
2035) ENGINE=InnoDB DEFAULT CHARSET=utf8;
2036/*!40101 SET character_set_client = @saved_cs_client */;
2037
2038--
2039-- Dumping data for table `instance_reset`
2040--
2041
2042LOCK TABLES `instance_reset` WRITE;
2043/*!40000 ALTER TABLE `instance_reset` DISABLE KEYS */;
2044/*!40000 ALTER TABLE `instance_reset` ENABLE KEYS */;
2045UNLOCK TABLES;
2046
2047--
2048-- Table structure for table `item_instance`
2049--
2050
2051DROP TABLE IF EXISTS `item_instance`;
2052/*!40101 SET @saved_cs_client     = @@character_set_client */;
2053/*!40101 SET character_set_client = utf8 */;
2054CREATE TABLE `item_instance` (
2055  `guid` int(10) unsigned NOT NULL DEFAULT '0',
2056  `itemEntry` mediumint(8) unsigned NOT NULL DEFAULT '0',
2057  `owner_guid` int(10) unsigned NOT NULL DEFAULT '0',
2058  `creatorGuid` int(10) unsigned NOT NULL DEFAULT '0',
2059  `giftCreatorGuid` int(10) unsigned NOT NULL DEFAULT '0',
2060  `count` int(10) unsigned NOT NULL DEFAULT '1',
2061  `duration` int(10) NOT NULL DEFAULT '0',
2062  `charges` tinytext,
2063  `flags` mediumint(8) unsigned NOT NULL DEFAULT '0',
2064  `enchantments` text NOT NULL,
2065  `randomPropertyId` smallint(5) NOT NULL DEFAULT '0',
2066  `durability` smallint(5) unsigned NOT NULL DEFAULT '0',
2067  `playedTime` int(10) unsigned NOT NULL DEFAULT '0',
2068  `text` text,
2069  PRIMARY KEY (`guid`),
2070  KEY `idx_owner_guid` (`owner_guid`)
2071) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Item System';
2072/*!40101 SET character_set_client = @saved_cs_client */;
2073
2074--
2075-- Dumping data for table `item_instance`
2076--
2077
2078LOCK TABLES `item_instance` WRITE;
2079/*!40000 ALTER TABLE `item_instance` DISABLE KEYS */;
2080/*!40000 ALTER TABLE `item_instance` ENABLE KEYS */;
2081UNLOCK TABLES;
2082
2083--
2084-- Table structure for table `item_loot_items`
2085--
2086
2087DROP TABLE IF EXISTS `item_loot_items`;
2088/*!40101 SET @saved_cs_client     = @@character_set_client */;
2089/*!40101 SET character_set_client = utf8 */;
2090CREATE TABLE `item_loot_items` (
2091  `container_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'guid of container (item_instance.guid)',
2092  `item_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'loot item entry (item_instance.itemEntry)',
2093  `item_count` int(10) NOT NULL DEFAULT '0' COMMENT 'stack size',
2094  `follow_rules` tinyint(1) NOT NULL DEFAULT '0' COMMENT 'follow loot rules',
2095  `ffa` tinyint(1) NOT NULL DEFAULT '0' COMMENT 'free-for-all',
2096  `blocked` tinyint(1) NOT NULL DEFAULT '0',
2097  `counted` tinyint(1) NOT NULL DEFAULT '0',
2098  `under_threshold` tinyint(1) NOT NULL DEFAULT '0',
2099  `needs_quest` tinyint(1) NOT NULL DEFAULT '0' COMMENT 'quest drop',
2100  `rnd_prop` int(10) NOT NULL DEFAULT '0' COMMENT 'random enchantment added when originally rolled',
2101  `rnd_suffix` int(10) NOT NULL DEFAULT '0' COMMENT 'random suffix added when originally rolled'
2102) ENGINE=InnoDB DEFAULT CHARSET=latin1;
2103/*!40101 SET character_set_client = @saved_cs_client */;
2104
2105--
2106-- Dumping data for table `item_loot_items`
2107--
2108
2109LOCK TABLES `item_loot_items` WRITE;
2110/*!40000 ALTER TABLE `item_loot_items` DISABLE KEYS */;
2111/*!40000 ALTER TABLE `item_loot_items` ENABLE KEYS */;
2112UNLOCK TABLES;
2113
2114--
2115-- Table structure for table `item_loot_money`
2116--
2117
2118DROP TABLE IF EXISTS `item_loot_money`;
2119/*!40101 SET @saved_cs_client     = @@character_set_client */;
2120/*!40101 SET character_set_client = utf8 */;
2121CREATE TABLE `item_loot_money` (
2122  `container_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'guid of container (item_instance.guid)',
2123  `money` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'money loot (in copper)',
2124  PRIMARY KEY (`container_id`)
2125) ENGINE=InnoDB DEFAULT CHARSET=latin1;
2126/*!40101 SET character_set_client = @saved_cs_client */;
2127
2128--
2129-- Dumping data for table `item_loot_money`
2130--
2131
2132LOCK TABLES `item_loot_money` WRITE;
2133/*!40000 ALTER TABLE `item_loot_money` DISABLE KEYS */;
2134/*!40000 ALTER TABLE `item_loot_money` ENABLE KEYS */;
2135UNLOCK TABLES;
2136
2137--
2138-- Table structure for table `item_refund_instance`
2139--
2140
2141DROP TABLE IF EXISTS `item_refund_instance`;
2142/*!40101 SET @saved_cs_client     = @@character_set_client */;
2143/*!40101 SET character_set_client = utf8 */;
2144CREATE TABLE `item_refund_instance` (
2145  `item_guid` int(10) unsigned NOT NULL COMMENT 'Item GUID',
2146  `player_guid` int(10) unsigned NOT NULL COMMENT 'Player GUID',
2147  `paidMoney` int(10) unsigned NOT NULL DEFAULT '0',
2148  `paidExtendedCost` smallint(5) unsigned NOT NULL DEFAULT '0',
2149  PRIMARY KEY (`item_guid`,`player_guid`)
2150) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Item Refund System';
2151/*!40101 SET character_set_client = @saved_cs_client */;
2152
2153--
2154-- Dumping data for table `item_refund_instance`
2155--
2156
2157LOCK TABLES `item_refund_instance` WRITE;
2158/*!40000 ALTER TABLE `item_refund_instance` DISABLE KEYS */;
2159/*!40000 ALTER TABLE `item_refund_instance` ENABLE KEYS */;
2160UNLOCK TABLES;
2161
2162--
2163-- Table structure for table `item_soulbound_trade_data`
2164--
2165
2166DROP TABLE IF EXISTS `item_soulbound_trade_data`;
2167/*!40101 SET @saved_cs_client     = @@character_set_client */;
2168/*!40101 SET character_set_client = utf8 */;
2169CREATE TABLE `item_soulbound_trade_data` (
2170  `itemGuid` int(10) unsigned NOT NULL COMMENT 'Item GUID',
2171  `allowedPlayers` text NOT NULL COMMENT 'Space separated GUID list of players who can receive this item in trade',
2172  PRIMARY KEY (`itemGuid`)
2173) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Item Refund System';
2174/*!40101 SET character_set_client = @saved_cs_client */;
2175
2176--
2177-- Dumping data for table `item_soulbound_trade_data`
2178--
2179
2180LOCK TABLES `item_soulbound_trade_data` WRITE;
2181/*!40000 ALTER TABLE `item_soulbound_trade_data` DISABLE KEYS */;
2182/*!40000 ALTER TABLE `item_soulbound_trade_data` ENABLE KEYS */;
2183UNLOCK TABLES;
2184
2185--
2186-- Table structure for table `lag_reports`
2187--
2188
2189DROP TABLE IF EXISTS `lag_reports`;
2190/*!40101 SET @saved_cs_client     = @@character_set_client */;
2191/*!40101 SET character_set_client = utf8 */;
2192CREATE TABLE `lag_reports` (
2193  `reportId` int(10) unsigned NOT NULL AUTO_INCREMENT,
2194  `guid` int(10) unsigned NOT NULL DEFAULT '0',
2195  `lagType` tinyint(3) unsigned NOT NULL DEFAULT '0',
2196  `mapId` smallint(5) unsigned NOT NULL DEFAULT '0',
2197  `posX` float NOT NULL DEFAULT '0',
2198  `posY` float NOT NULL DEFAULT '0',
2199  `posZ` float NOT NULL DEFAULT '0',
2200  `latency` int(10) unsigned NOT NULL DEFAULT '0',
2201  `createTime` int(10) unsigned NOT NULL DEFAULT '0',
2202  PRIMARY KEY (`reportId`)
2203) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Player System';
2204/*!40101 SET character_set_client = @saved_cs_client */;
2205
2206--
2207-- Dumping data for table `lag_reports`
2208--
2209
2210LOCK TABLES `lag_reports` WRITE;
2211/*!40000 ALTER TABLE `lag_reports` DISABLE KEYS */;
2212/*!40000 ALTER TABLE `lag_reports` ENABLE KEYS */;
2213UNLOCK TABLES;
2214
2215--
2216-- Table structure for table `lfg_data`
2217--
2218
2219DROP TABLE IF EXISTS `lfg_data`;
2220/*!40101 SET @saved_cs_client     = @@character_set_client */;
2221/*!40101 SET character_set_client = utf8 */;
2222CREATE TABLE `lfg_data` (
2223  `guid` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Global Unique Identifier',
2224  `dungeon` int(10) unsigned NOT NULL DEFAULT '0',
2225  `state` tinyint(3) unsigned NOT NULL DEFAULT '0',
2226  PRIMARY KEY (`guid`)
2227) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='LFG Data';
2228/*!40101 SET character_set_client = @saved_cs_client */;
2229
2230--
2231-- Dumping data for table `lfg_data`
2232--
2233
2234LOCK TABLES `lfg_data` WRITE;
2235/*!40000 ALTER TABLE `lfg_data` DISABLE KEYS */;
2236/*!40000 ALTER TABLE `lfg_data` ENABLE KEYS */;
2237UNLOCK TABLES;
2238
2239--
2240-- Table structure for table `mail`
2241--
2242
2243DROP TABLE IF EXISTS `mail`;
2244/*!40101 SET @saved_cs_client     = @@character_set_client */;
2245/*!40101 SET character_set_client = utf8 */;
2246CREATE TABLE `mail` (
2247  `id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Identifier',
2248  `messageType` tinyint(3) unsigned NOT NULL DEFAULT '0',
2249  `stationery` tinyint(3) NOT NULL DEFAULT '41',
2250  `mailTemplateId` smallint(5) unsigned NOT NULL DEFAULT '0',
2251  `sender` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Character Global Unique Identifier',
2252  `receiver` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Character Global Unique Identifier',
2253  `subject` longtext,
2254  `body` longtext,
2255  `has_items` tinyint(3) unsigned NOT NULL DEFAULT '0',
2256  `expire_time` int(10) unsigned NOT NULL DEFAULT '0',
2257  `deliver_time` int(10) unsigned NOT NULL DEFAULT '0',
2258  `money` int(10) unsigned NOT NULL DEFAULT '0',
2259  `cod` int(10) unsigned NOT NULL DEFAULT '0',
2260  `checked` tinyint(3) unsigned NOT NULL DEFAULT '0',
2261  PRIMARY KEY (`id`),
2262  KEY `idx_receiver` (`receiver`)
2263) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Mail System';
2264/*!40101 SET character_set_client = @saved_cs_client */;
2265
2266--
2267-- Dumping data for table `mail`
2268--
2269
2270LOCK TABLES `mail` WRITE;
2271/*!40000 ALTER TABLE `mail` DISABLE KEYS */;
2272/*!40000 ALTER TABLE `mail` ENABLE KEYS */;
2273UNLOCK TABLES;
2274
2275--
2276-- Table structure for table `mail_items`
2277--
2278
2279DROP TABLE IF EXISTS `mail_items`;
2280/*!40101 SET @saved_cs_client     = @@character_set_client */;
2281/*!40101 SET character_set_client = utf8 */;
2282CREATE TABLE `mail_items` (
2283  `mail_id` int(10) unsigned NOT NULL DEFAULT '0',
2284  `item_guid` int(10) unsigned NOT NULL DEFAULT '0',
2285  `receiver` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Character Global Unique Identifier',
2286  PRIMARY KEY (`item_guid`),
2287  KEY `idx_receiver` (`receiver`),
2288  KEY `idx_mail_id` (`mail_id`)
2289) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;
2290/*!40101 SET character_set_client = @saved_cs_client */;
2291
2292--
2293-- Dumping data for table `mail_items`
2294--
2295
2296LOCK TABLES `mail_items` WRITE;
2297/*!40000 ALTER TABLE `mail_items` DISABLE KEYS */;
2298/*!40000 ALTER TABLE `mail_items` ENABLE KEYS */;
2299UNLOCK TABLES;
2300
2301--
2302-- Table structure for table `pet_aura`
2303--
2304
2305DROP TABLE IF EXISTS `pet_aura`;
2306/*!40101 SET @saved_cs_client     = @@character_set_client */;
2307/*!40101 SET character_set_client = utf8 */;
2308CREATE TABLE `pet_aura` (
2309  `guid` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Global Unique Identifier',
2310  `casterGuid` bigint(20) unsigned NOT NULL DEFAULT '0' COMMENT 'Full Global Unique Identifier',
2311  `spell` mediumint(8) unsigned NOT NULL DEFAULT '0',
2312  `effectMask` tinyint(3) unsigned NOT NULL DEFAULT '0',
2313  `recalculateMask` tinyint(3) unsigned NOT NULL DEFAULT '0',
2314  `stackCount` tinyint(3) unsigned NOT NULL DEFAULT '1',
2315  `amount0` mediumint(8) NOT NULL,
2316  `amount1` mediumint(8) NOT NULL,
2317  `amount2` mediumint(8) NOT NULL,
2318  `base_amount0` mediumint(8) NOT NULL,
2319  `base_amount1` mediumint(8) NOT NULL,
2320  `base_amount2` mediumint(8) NOT NULL,
2321  `maxDuration` int(11) NOT NULL DEFAULT '0',
2322  `remainTime` int(11) NOT NULL DEFAULT '0',
2323  `remainCharges` tinyint(3) unsigned NOT NULL DEFAULT '0',
2324  `critChance` float NOT NULL DEFAULT '0',
2325  `applyResilience` tinyint(3) NOT NULL DEFAULT '0',
2326  PRIMARY KEY (`guid`,`casterGuid`,`spell`,`effectMask`)
2327) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Pet System';
2328/*!40101 SET character_set_client = @saved_cs_client */;
2329
2330--
2331-- Dumping data for table `pet_aura`
2332--
2333
2334LOCK TABLES `pet_aura` WRITE;
2335/*!40000 ALTER TABLE `pet_aura` DISABLE KEYS */;
2336/*!40000 ALTER TABLE `pet_aura` ENABLE KEYS */;
2337UNLOCK TABLES;
2338
2339--
2340-- Table structure for table `pet_spell`
2341--
2342
2343DROP TABLE IF EXISTS `pet_spell`;
2344/*!40101 SET @saved_cs_client     = @@character_set_client */;
2345/*!40101 SET character_set_client = utf8 */;
2346CREATE TABLE `pet_spell` (
2347  `guid` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Global Unique Identifier',
2348  `spell` mediumint(8) unsigned NOT NULL DEFAULT '0' COMMENT 'Spell Identifier',
2349  `active` tinyint(3) unsigned NOT NULL DEFAULT '0',
2350  PRIMARY KEY (`guid`,`spell`)
2351) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Pet System';
2352/*!40101 SET character_set_client = @saved_cs_client */;
2353
2354--
2355-- Dumping data for table `pet_spell`
2356--
2357
2358LOCK TABLES `pet_spell` WRITE;
2359/*!40000 ALTER TABLE `pet_spell` DISABLE KEYS */;
2360/*!40000 ALTER TABLE `pet_spell` ENABLE KEYS */;
2361UNLOCK TABLES;
2362
2363--
2364-- Table structure for table `pet_spell_cooldown`
2365--
2366
2367DROP TABLE IF EXISTS `pet_spell_cooldown`;
2368/*!40101 SET @saved_cs_client     = @@character_set_client */;
2369/*!40101 SET character_set_client = utf8 */;
2370CREATE TABLE `pet_spell_cooldown` (
2371  `guid` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Global Unique Identifier, Low part',
2372  `spell` mediumint(8) unsigned NOT NULL DEFAULT '0' COMMENT 'Spell Identifier',
2373  `time` int(10) unsigned NOT NULL DEFAULT '0',
2374  `categoryId` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Spell category Id',
2375  `categoryEnd` int(10) unsigned NOT NULL DEFAULT '0',
2376  PRIMARY KEY (`guid`,`spell`)
2377) ENGINE=InnoDB DEFAULT CHARSET=utf8;
2378/*!40101 SET character_set_client = @saved_cs_client */;
2379
2380--
2381-- Dumping data for table `pet_spell_cooldown`
2382--
2383
2384LOCK TABLES `pet_spell_cooldown` WRITE;
2385/*!40000 ALTER TABLE `pet_spell_cooldown` DISABLE KEYS */;
2386/*!40000 ALTER TABLE `pet_spell_cooldown` ENABLE KEYS */;
2387UNLOCK TABLES;
2388
2389--
2390-- Table structure for table `petition`
2391--
2392
2393DROP TABLE IF EXISTS `petition`;
2394/*!40101 SET @saved_cs_client     = @@character_set_client */;
2395/*!40101 SET character_set_client = utf8 */;
2396CREATE TABLE `petition` (
2397  `ownerguid` int(10) unsigned NOT NULL,
2398  `petitionguid` int(10) unsigned DEFAULT '0',
2399  `name` varchar(24) NOT NULL,
2400  `type` tinyint(3) unsigned NOT NULL DEFAULT '0',
2401  PRIMARY KEY (`ownerguid`,`type`),
2402  UNIQUE KEY `index_ownerguid_petitionguid` (`ownerguid`,`petitionguid`)
2403) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Guild System';
2404/*!40101 SET character_set_client = @saved_cs_client */;
2405
2406--
2407-- Dumping data for table `petition`
2408--
2409
2410LOCK TABLES `petition` WRITE;
2411/*!40000 ALTER TABLE `petition` DISABLE KEYS */;
2412/*!40000 ALTER TABLE `petition` ENABLE KEYS */;
2413UNLOCK TABLES;
2414
2415--
2416-- Table structure for table `petition_sign`
2417--
2418
2419DROP TABLE IF EXISTS `petition_sign`;
2420/*!40101 SET @saved_cs_client     = @@character_set_client */;
2421/*!40101 SET character_set_client = utf8 */;
2422CREATE TABLE `petition_sign` (
2423  `ownerguid` int(10) unsigned NOT NULL,
2424  `petitionguid` int(10) unsigned NOT NULL DEFAULT '0',
2425  `playerguid` int(10) unsigned NOT NULL DEFAULT '0',
2426  `player_account` int(10) unsigned NOT NULL DEFAULT '0',
2427  `type` tinyint(3) unsigned NOT NULL DEFAULT '0',
2428  PRIMARY KEY (`petitionguid`,`playerguid`),
2429  KEY `Idx_playerguid` (`playerguid`),
2430  KEY `Idx_ownerguid` (`ownerguid`)
2431) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Guild System';
2432/*!40101 SET character_set_client = @saved_cs_client */;
2433
2434--
2435-- Dumping data for table `petition_sign`
2436--
2437
2438LOCK TABLES `petition_sign` WRITE;
2439/*!40000 ALTER TABLE `petition_sign` DISABLE KEYS */;
2440/*!40000 ALTER TABLE `petition_sign` ENABLE KEYS */;
2441UNLOCK TABLES;
2442
2443--
2444-- Table structure for table `pool_quest_save`
2445--
2446
2447DROP TABLE IF EXISTS `pool_quest_save`;
2448/*!40101 SET @saved_cs_client     = @@character_set_client */;
2449/*!40101 SET character_set_client = utf8 */;
2450CREATE TABLE `pool_quest_save` (
2451  `pool_id` int(10) unsigned NOT NULL DEFAULT '0',
2452  `quest_id` int(10) unsigned NOT NULL DEFAULT '0',
2453  PRIMARY KEY (`pool_id`,`quest_id`)
2454) ENGINE=InnoDB DEFAULT CHARSET=utf8;
2455/*!40101 SET character_set_client = @saved_cs_client */;
2456
2457--
2458-- Dumping data for table `pool_quest_save`
2459--
2460
2461LOCK TABLES `pool_quest_save` WRITE;
2462/*!40000 ALTER TABLE `pool_quest_save` DISABLE KEYS */;
2463/*!40000 ALTER TABLE `pool_quest_save` ENABLE KEYS */;
2464UNLOCK TABLES;
2465
2466--
2467-- Table structure for table `pvpstats_battlegrounds`
2468--
2469
2470DROP TABLE IF EXISTS `pvpstats_battlegrounds`;
2471/*!40101 SET @saved_cs_client     = @@character_set_client */;
2472/*!40101 SET character_set_client = utf8 */;
2473CREATE TABLE `pvpstats_battlegrounds` (
2474  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
2475  `winner_faction` tinyint(4) NOT NULL,
2476  `bracket_id` tinyint(3) unsigned NOT NULL,
2477  `type` tinyint(3) unsigned NOT NULL,
2478  `date` datetime NOT NULL,
2479  PRIMARY KEY (`id`)
2480) ENGINE=InnoDB DEFAULT CHARSET=latin1;
2481/*!40101 SET character_set_client = @saved_cs_client */;
2482
2483--
2484-- Dumping data for table `pvpstats_battlegrounds`
2485--
2486
2487LOCK TABLES `pvpstats_battlegrounds` WRITE;
2488/*!40000 ALTER TABLE `pvpstats_battlegrounds` DISABLE KEYS */;
2489/*!40000 ALTER TABLE `pvpstats_battlegrounds` ENABLE KEYS */;
2490UNLOCK TABLES;
2491
2492--
2493-- Table structure for table `pvpstats_players`
2494--
2495
2496DROP TABLE IF EXISTS `pvpstats_players`;
2497/*!40101 SET @saved_cs_client     = @@character_set_client */;
2498/*!40101 SET character_set_client = utf8 */;
2499CREATE TABLE `pvpstats_players` (
2500  `battleground_id` bigint(20) unsigned NOT NULL,
2501  `character_guid` int(10) unsigned NOT NULL,
2502  `winner` bit(1) NOT NULL,
2503  `score_killing_blows` mediumint(8) unsigned NOT NULL,
2504  `score_deaths` mediumint(8) unsigned NOT NULL,
2505  `score_honorable_kills` mediumint(8) unsigned NOT NULL,
2506  `score_bonus_honor` mediumint(8) unsigned NOT NULL,
2507  `score_damage_done` mediumint(8) unsigned NOT NULL,
2508  `score_healing_done` mediumint(8) unsigned NOT NULL,
2509  `attr_1` mediumint(8) unsigned NOT NULL DEFAULT '0',
2510  `attr_2` mediumint(8) unsigned NOT NULL DEFAULT '0',
2511  `attr_3` mediumint(8) unsigned NOT NULL DEFAULT '0',
2512  `attr_4` mediumint(8) unsigned NOT NULL DEFAULT '0',
2513  `attr_5` mediumint(8) unsigned NOT NULL DEFAULT '0',
2514  PRIMARY KEY (`battleground_id`,`character_guid`)
2515) ENGINE=InnoDB DEFAULT CHARSET=latin1;
2516/*!40101 SET character_set_client = @saved_cs_client */;
2517
2518--
2519-- Dumping data for table `pvpstats_players`
2520--
2521
2522LOCK TABLES `pvpstats_players` WRITE;
2523/*!40000 ALTER TABLE `pvpstats_players` DISABLE KEYS */;
2524/*!40000 ALTER TABLE `pvpstats_players` ENABLE KEYS */;
2525UNLOCK TABLES;
2526
2527--
2528-- Table structure for table `quest_tracker`
2529--
2530
2531DROP TABLE IF EXISTS `quest_tracker`;
2532/*!40101 SET @saved_cs_client     = @@character_set_client */;
2533/*!40101 SET character_set_client = utf8 */;
2534CREATE TABLE `quest_tracker` (
2535  `id` mediumint(8) unsigned NOT NULL DEFAULT '0',
2536  `character_guid` int(10) unsigned NOT NULL DEFAULT '0',
2537  `quest_accept_time` datetime NOT NULL,
2538  `quest_complete_time` datetime DEFAULT NULL,
2539  `quest_abandon_time` datetime DEFAULT NULL,
2540  `completed_by_gm` tinyint(1) NOT NULL DEFAULT '0',
2541  `core_hash` varchar(120) NOT NULL DEFAULT '0',
2542  `core_revision` varchar(120) NOT NULL DEFAULT '0'
2543) ENGINE=InnoDB DEFAULT CHARSET=latin1;
2544/*!40101 SET character_set_client = @saved_cs_client */;
2545
2546--
2547-- Dumping data for table `quest_tracker`
2548--
2549
2550LOCK TABLES `quest_tracker` WRITE;
2551/*!40000 ALTER TABLE `quest_tracker` DISABLE KEYS */;
2552/*!40000 ALTER TABLE `quest_tracker` ENABLE KEYS */;
2553UNLOCK TABLES;
2554
2555--
2556-- Table structure for table `reserved_name`
2557--
2558
2559DROP TABLE IF EXISTS `reserved_name`;
2560/*!40101 SET @saved_cs_client     = @@character_set_client */;
2561/*!40101 SET character_set_client = utf8 */;
2562CREATE TABLE `reserved_name` (
2563  `name` varchar(12) NOT NULL DEFAULT '',
2564  PRIMARY KEY (`name`)
2565) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Player Reserved Names';
2566/*!40101 SET character_set_client = @saved_cs_client */;
2567
2568--
2569-- Dumping data for table `reserved_name`
2570--
2571
2572LOCK TABLES `reserved_name` WRITE;
2573/*!40000 ALTER TABLE `reserved_name` DISABLE KEYS */;
2574/*!40000 ALTER TABLE `reserved_name` ENABLE KEYS */;
2575UNLOCK TABLES;
2576
2577--
2578-- Table structure for table `updates`
2579--
2580
2581DROP TABLE IF EXISTS `updates`;
2582/*!40101 SET @saved_cs_client     = @@character_set_client */;
2583/*!40101 SET character_set_client = utf8 */;
2584CREATE TABLE `updates` (
2585  `name` varchar(200) NOT NULL COMMENT 'filename with extension of the update.',
2586  `hash` char(40) DEFAULT '' COMMENT 'sha1 hash of the sql file.',
2587  `state` enum('RELEASED','ARCHIVED') NOT NULL DEFAULT 'RELEASED' COMMENT 'defines if an update is released or archived.',
2588  `timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT 'timestamp when the query was applied.',
2589  `speed` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'time the query takes to apply in ms.',
2590  PRIMARY KEY (`name`)
2591) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='List of all applied updates in this database.';
2592/*!40101 SET character_set_client = @saved_cs_client */;
2593
2594--
2595-- Dumping data for table `updates`
2596--
2597
2598LOCK TABLES `updates` WRITE;
2599/*!40000 ALTER TABLE `updates` DISABLE KEYS */;
2600INSERT INTO `updates` VALUES
2601('2015_03_20_00_characters.sql','B761760804EA73BD297F296C5C1919687DF7191C','ARCHIVED','2015-03-21 21:44:15',0),
2602('2015_03_20_01_characters.sql','894F08B70449A5481FFAF394EE5571D7FC4D8A3A','ARCHIVED','2015-03-21 21:44:15',0),
2603('2015_03_20_02_characters.sql','97D7BE0CAADC79F3F11B9FD296B8C6CD40FE593B','ARCHIVED','2015-03-21 21:44:51',0),
2604('2015_06_26_00_characters_335.sql','C2CC6E50AFA1ACCBEBF77CC519AAEB09F3BBAEBC','ARCHIVED','2015-07-13 23:49:22',0),
2605('2015_09_28_00_characters_335.sql','F8682A431D50E54BDC4AC0E7DBED21AE8AAB6AD4','ARCHIVED','2015-09-28 21:00:00',0),
2606('2015_08_26_00_characters_335.sql','C7D6A3A00FECA3EBFF1E71744CA40D3076582374','ARCHIVED','2015-08-26 21:00:00',0),
2607('2015_10_06_00_characters.sql','16842FDD7E8547F2260D3312F53EFF8761EFAB35','ARCHIVED','2015-10-06 16:06:38',0),
2608('2015_10_07_00_characters.sql','E15AB463CEBE321001D7BFDEA4B662FF618728FD','ARCHIVED','2015-10-07 23:32:00',0),
2609('2015_10_12_00_characters.sql','D6F9927BDED72AD0A81D6EC2C6500CBC34A39FA2','ARCHIVED','2015-10-12 15:35:47',0),
2610('2015_10_28_00_characters.sql','622A9CA8FCE690429EBE23BA071A37C7A007BF8B','ARCHIVED','2015-10-19 14:32:22',0),
2611('2015_10_29_00_characters_335.sql','4555A7F35C107E54C13D74D20F141039ED42943E','ARCHIVED','2015-10-29 17:05:43',0),
2612('2015_11_03_00_characters.sql','CC045717B8FDD9733351E52A5302560CD08AAD57','ARCHIVED','2015-10-12 15:23:33',0),
2613('2015_11_07_00_characters.sql','0ACDD35EC9745231BCFA701B78056DEF94D0CC53','ARCHIVED','2016-04-11 00:42:36',94),
2614('2016_02_10_00_characters.sql','F1B4DA202819CABC7319A4470A2D224A34609E97','ARCHIVED','2016-02-10 00:00:00',0),
2615('2016_03_13_2016_01_05_00_characters.sql','0EAD24977F40DE2476B4567DA2B477867CC0DA1A','ARCHIVED','2016-03-13 20:03:56',0),
2616('2016_04_11_00_characters.sql','0ACDD35EC9745231BCFA701B78056DEF94D0CC53','ARCHIVED','2016-04-11 03:18:17',0),
2617('2016_09_13_00_characters.sql','27A04615B11B2CFC3A26778F52F74C071E4F9C54','ARCHIVED','2016-07-06 18:55:18',0),
2618('2016_10_16_00_characters.sql','0ACDD35EC9745231BCFA701B78056DEF94D0CC53','ARCHIVED','2016-10-16 14:02:49',35),
2619('2016_10_30_00_characters.sql','7E2D5B226907B5A9AF320797F46E86DC27B7EC90','ARCHIVED','2016-10-30 00:00:00',0),
2620('2017_04_03_00_characters.sql','CB072C56692C9FBF170C4036F15773DD86D368B5','ARCHIVED','2017-04-03 00:00:00',0),
2621('2017_04_12_00_characters.sql','4FE3C6866A6DCD4926D451F6009464D290C2EF1F','ARCHIVED','2017-04-12 00:00:00',0),
2622('2017_04_12_01_characters.sql','5A8A1215E3A2356722F52CD7A64BBE03D21FBEA3','ARCHIVED','2017-04-12 00:00:00',0),
2623('2017_04_19_00_characters.sql','CE06FA9005C8A8EE4BDD925520278A5D83E87485','ARCHIVED','2017-04-19 00:07:40',25),
2624('2017_10_29_00_characters.sql','8CFC473E7E87E58C317A72016BF69E9050D3BC83','ARCHIVED','2017-04-19 00:07:40',25),
2625('2017_11_27_00_characters.sql','6FF1F84B8985ADFC7FF97F0BF8E53403CF13C320','ARCHIVED','2017-11-27 22:08:42',0),
2626('2018_01_13_00_characters.sql','E3C0DA9995BA71ED5A267294470CD03DC51862DD','ARCHIVED','2018-01-13 00:00:00',0),
2627('2018_02_19_00_characters.sql','FE5C5F9B88F0791549DDE680942493781E2269E6','RELEASED','2018-02-18 19:49:38',0),
2628('2018_04_24_00_characters.sql','77264AB7BEF421C0A4BB81EEAFD0D8C1CBCA840F','RELEASED','2018-04-20 09:38:10',0),
2629('2018_07_09_00_characters.sql','6F3EA22DD5E4CD9F9C60C4332B147E3DBF2E8A44','RELEASED','2018-07-09 18:19:18',0);
2630/*!40000 ALTER TABLE `updates` ENABLE KEYS */;
2631UNLOCK TABLES;
2632
2633--
2634-- Table structure for table `updates_include`
2635--
2636
2637DROP TABLE IF EXISTS `updates_include`;
2638/*!40101 SET @saved_cs_client     = @@character_set_client */;
2639/*!40101 SET character_set_client = utf8 */;
2640CREATE TABLE `updates_include` (
2641  `path` varchar(200) NOT NULL COMMENT 'directory to include. $ means relative to the source directory.',
2642  `state` enum('RELEASED','ARCHIVED') NOT NULL DEFAULT 'RELEASED' COMMENT 'defines if the directory contains released or archived updates.',
2643  PRIMARY KEY (`path`)
2644) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='List of directories where we want to include sql updates.';
2645/*!40101 SET character_set_client = @saved_cs_client */;
2646
2647--
2648-- Dumping data for table `updates_include`
2649--
2650
2651LOCK TABLES `updates_include` WRITE;
2652/*!40000 ALTER TABLE `updates_include` DISABLE KEYS */;
2653INSERT INTO `updates_include` VALUES
2654('$/sql/updates/characters','RELEASED'),
2655('$/sql/custom/characters','RELEASED'),
2656('$/sql/old/3.3.5a/characters','ARCHIVED');
2657/*!40000 ALTER TABLE `updates_include` ENABLE KEYS */;
2658UNLOCK TABLES;
2659
2660--
2661-- Table structure for table `warden_action`
2662--
2663
2664DROP TABLE IF EXISTS `warden_action`;
2665/*!40101 SET @saved_cs_client     = @@character_set_client */;
2666/*!40101 SET character_set_client = utf8 */;
2667CREATE TABLE `warden_action` (
2668  `wardenId` smallint(5) unsigned NOT NULL,
2669  `action` tinyint(3) unsigned DEFAULT NULL,
2670  PRIMARY KEY (`wardenId`)
2671) ENGINE=InnoDB DEFAULT CHARSET=utf8;
2672/*!40101 SET character_set_client = @saved_cs_client */;
2673
2674--
2675-- Dumping data for table `warden_action`
2676--
2677
2678LOCK TABLES `warden_action` WRITE;
2679/*!40000 ALTER TABLE `warden_action` DISABLE KEYS */;
2680/*!40000 ALTER TABLE `warden_action` ENABLE KEYS */;
2681UNLOCK TABLES;
2682
2683--
2684-- Table structure for table `worldstates`
2685--
2686
2687DROP TABLE IF EXISTS `worldstates`;
2688/*!40101 SET @saved_cs_client     = @@character_set_client */;
2689/*!40101 SET character_set_client = utf8 */;
2690CREATE TABLE `worldstates` (
2691  `entry` int(10) unsigned NOT NULL DEFAULT '0',
2692  `value` int(10) unsigned NOT NULL DEFAULT '0',
2693  `comment` tinytext,
2694  PRIMARY KEY (`entry`)
2695) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Variable Saves';
2696/*!40101 SET character_set_client = @saved_cs_client */;
2697
2698--
2699-- Dumping data for table `worldstates`
2700--
2701
2702LOCK TABLES `worldstates` WRITE;
2703/*!40000 ALTER TABLE `worldstates` DISABLE KEYS */;
2704INSERT INTO `worldstates` VALUES
2705(1,0,NULL),
2706(2,0,NULL),
2707(3,0,NULL),
2708(4,0,NULL),
2709(5,0,NULL),
2710(6,0,NULL),
2711(7,0,NULL),
2712(8,0,NULL),
2713(9,0,NULL),
2714(10,0,NULL),
2715(11,0,NULL),
2716(12,0,NULL),
2717(13,0,NULL),
2718(14,1476626581,NULL),
2719(15,1476626581,NULL),
2720(16,0,NULL),
2721(17,0,NULL),
2722(18,1476626581,NULL),
2723(19,0,NULL),
2724(20,0,NULL),
2725(21,0,NULL),
2726(22,0,NULL),
2727(23,0,NULL),
2728(24,0,NULL),
2729(25,0,NULL),
2730(26,0,NULL),
2731(27,1476626581,NULL),
2732(28,0,NULL),
2733(29,0,NULL),
2734(30,0,NULL),
2735(31,0,NULL),
2736(32,0,NULL),
2737(33,0,NULL),
2738(34,1476626581,NULL),
2739(35,0,NULL),
2740(36,0,NULL),
2741(37,0,NULL),
2742(38,0,NULL),
2743(39,0,NULL),
2744(40,0,NULL),
2745(41,0,NULL),
2746(42,0,NULL),
2747(43,0,NULL),
2748(44,0,NULL),
2749(45,0,NULL),
2750(46,0,NULL),
2751(47,0,NULL),
2752(48,0,NULL),
2753(49,0,NULL),
2754(50,0,NULL),
2755(51,0,NULL),
2756(52,0,NULL),
2757(53,0,NULL),
2758(54,0,NULL),
2759(55,0,NULL),
2760(56,0,NULL),
2761(57,0,NULL),
2762(58,0,NULL),
2763(59,0,NULL),
2764(60,1476626581,NULL),
2765(61,0,NULL),
2766(62,1476626581,NULL),
2767(63,0,NULL),
2768(64,0,NULL),
2769(65,0,NULL),
2770(66,0,NULL),
2771(67,0,NULL),
2772(68,0,NULL),
2773(69,0,NULL),
2774(3781,9000000,NULL),
2775(3801,0,NULL),
2776(3802,1,NULL),
2777(20001,0,'NextArenaPointDistributionTime'),
2778(20002,1477230266,'NextWeeklyQuestResetTime'),
2779(20003,1476680400,'NextBGRandomDailyResetTime'),
2780(20004,0,'cleaning_flags'),
2781(20006,1476680400,NULL),
2782(20007,1477954800,NULL);
2783/*!40000 ALTER TABLE `worldstates` ENABLE KEYS */;
2784UNLOCK TABLES;
2785/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
2786
2787/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
2788/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
2789/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
2790/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
2791/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
2792/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
2793/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
2794
2795-- Dump completed on 2018-02-18 19:49:38