2 -- Copyright (C) 2005-2013 MaNGOS <http://getmangos.com/>
4 -- This program is free software; you can redistribute it and/or modify
5 -- it under the terms of the GNU General Public License as published by
6 -- the Free Software Foundation; either version 2 of the License, or
7 -- (at your option) any later version.
9 -- This program is distributed in the hope that it will be useful,
10 -- but WITHOUT ANY WARRANTY; without even the implied warranty of
11 -- MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
12 -- GNU General Public License for more details.
14 -- You should have received a copy of the GNU General Public License
15 -- along with this program; if not, write to the Free Software
16 -- Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA
19 /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
20 /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
21 /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
22 /*!40101 SET NAMES utf8 */;
23 /*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
24 /*!40103 SET TIME_ZONE='+00:00' */;
25 /*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
26 /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
27 /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
28 /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
31 -- Table structure for table `account_data`
34 DROP TABLE IF EXISTS `account_data`;
35 /*!40101 SET @saved_cs_client = @@character_set_client */;
36 /*!40101 SET character_set_client = utf8 */;
37 CREATE TABLE `account_data` (
38 `account` int(11) unsigned NOT NULL DEFAULT '0',
39 `type` int(11) unsigned NOT NULL DEFAULT '0',
40 `time` bigint(11) unsigned NOT NULL DEFAULT '0',
41 `data` longblob NOT NULL,
42 PRIMARY KEY (`account`,`type`)
43 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
44 /*!40101 SET character_set_client = @saved_cs_client */;
47 -- Dumping data for table `account_data`
50 LOCK TABLES `account_data` WRITE;
51 /*!40000 ALTER TABLE `account_data` DISABLE KEYS */;
52 /*!40000 ALTER TABLE `account_data` ENABLE KEYS */;
56 -- Table structure for table `arena_team`
59 DROP TABLE IF EXISTS `arena_team`;
60 /*!40101 SET @saved_cs_client = @@character_set_client */;
61 /*!40101 SET character_set_client = utf8 */;
62 CREATE TABLE `arena_team` (
63 `arenateamid` int(10) unsigned NOT NULL DEFAULT '0',
64 `name` char(255) NOT NULL,
65 `captainguid` int(10) unsigned NOT NULL DEFAULT '0',
66 `type` tinyint(3) unsigned NOT NULL DEFAULT '0',
67 `BackgroundColor` int(10) unsigned NOT NULL DEFAULT '0',
68 `EmblemStyle` int(10) unsigned NOT NULL DEFAULT '0',
69 `EmblemColor` int(10) unsigned NOT NULL DEFAULT '0',
70 `BorderStyle` int(10) unsigned NOT NULL DEFAULT '0',
71 `BorderColor` int(10) unsigned NOT NULL DEFAULT '0',
72 PRIMARY KEY (`arenateamid`)
73 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
74 /*!40101 SET character_set_client = @saved_cs_client */;
77 -- Dumping data for table `arena_team`
80 LOCK TABLES `arena_team` WRITE;
81 /*!40000 ALTER TABLE `arena_team` DISABLE KEYS */;
82 /*!40000 ALTER TABLE `arena_team` ENABLE KEYS */;
86 -- Table structure for table `arena_team_member`
89 DROP TABLE IF EXISTS `arena_team_member`;
90 /*!40101 SET @saved_cs_client = @@character_set_client */;
91 /*!40101 SET character_set_client = utf8 */;
92 CREATE TABLE `arena_team_member` (
93 `arenateamid` int(10) unsigned NOT NULL DEFAULT '0',
94 `guid` int(10) unsigned NOT NULL DEFAULT '0',
95 `played_week` int(10) unsigned NOT NULL DEFAULT '0',
96 `wons_week` int(10) unsigned NOT NULL DEFAULT '0',
97 `played_season` int(10) unsigned NOT NULL DEFAULT '0',
98 `wons_season` int(10) unsigned NOT NULL DEFAULT '0',
99 `personal_rating` int(10) unsigned NOT NULL DEFAULT '0',
100 PRIMARY KEY (`arenateamid`,`guid`)
101 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
102 /*!40101 SET character_set_client = @saved_cs_client */;
105 -- Dumping data for table `arena_team_member`
108 LOCK TABLES `arena_team_member` WRITE;
109 /*!40000 ALTER TABLE `arena_team_member` DISABLE KEYS */;
110 /*!40000 ALTER TABLE `arena_team_member` ENABLE KEYS */;
114 -- Table structure for table `arena_team_stats`
117 DROP TABLE IF EXISTS `arena_team_stats`;
118 /*!40101 SET @saved_cs_client = @@character_set_client */;
119 /*!40101 SET character_set_client = utf8 */;
120 CREATE TABLE `arena_team_stats` (
121 `arenateamid` int(10) unsigned NOT NULL DEFAULT '0',
122 `rating` int(10) unsigned NOT NULL DEFAULT '0',
123 `games_week` int(10) unsigned NOT NULL DEFAULT '0',
124 `wins_week` int(10) unsigned NOT NULL DEFAULT '0',
125 `games_season` int(10) unsigned NOT NULL DEFAULT '0',
126 `wins_season` int(10) unsigned NOT NULL DEFAULT '0',
127 `rank` int(10) unsigned NOT NULL DEFAULT '0',
128 PRIMARY KEY (`arenateamid`)
129 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
130 /*!40101 SET character_set_client = @saved_cs_client */;
133 -- Dumping data for table `arena_team_stats`
136 LOCK TABLES `arena_team_stats` WRITE;
137 /*!40000 ALTER TABLE `arena_team_stats` DISABLE KEYS */;
138 /*!40000 ALTER TABLE `arena_team_stats` ENABLE KEYS */;
142 -- Table structure for table `auction`
145 DROP TABLE IF EXISTS `auction`;
146 /*!40101 SET @saved_cs_client = @@character_set_client */;
147 /*!40101 SET character_set_client = utf8 */;
148 CREATE TABLE `auction` (
149 `id` int(11) unsigned NOT NULL DEFAULT '0',
150 `houseid` int(11) unsigned NOT NULL DEFAULT '0',
151 `itemguid` int(11) unsigned NOT NULL DEFAULT '0',
152 `item_template` int(11) unsigned NOT NULL DEFAULT '0' COMMENT 'Item Identifier',
153 `item_count` int(11) unsigned NOT NULL DEFAULT '0',
154 `item_randompropertyid` int(11) NOT NULL DEFAULT '0',
155 `itemowner` int(11) unsigned NOT NULL DEFAULT '0',
156 `buyoutprice` bigint(40) NOT NULL DEFAULT '0',
157 `time` bigint(40) unsigned NOT NULL DEFAULT '0',
158 `moneyTime` bigint(40) unsigned NOT NULL DEFAULT '0',
159 `buyguid` int(11) unsigned NOT NULL DEFAULT '0',
160 `lastbid` bigint(40) NOT NULL DEFAULT '0',
161 `startbid` bigint(40) NOT NULL DEFAULT '0',
162 `deposit` bigint(40) NOT NULL DEFAULT '0',
164 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
165 /*!40101 SET character_set_client = @saved_cs_client */;
168 -- Dumping data for table `auction`
171 LOCK TABLES `auction` WRITE;
172 /*!40000 ALTER TABLE `auction` DISABLE KEYS */;
173 /*!40000 ALTER TABLE `auction` ENABLE KEYS */;
177 -- Table structure for table `bugreport`
180 DROP TABLE IF EXISTS `bugreport`;
181 /*!40101 SET @saved_cs_client = @@character_set_client */;
182 /*!40101 SET character_set_client = utf8 */;
183 CREATE TABLE `bugreport` (
184 `id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'Identifier',
185 `type` longtext NOT NULL,
186 `content` longtext NOT NULL,
188 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Debug System';
189 /*!40101 SET character_set_client = @saved_cs_client */;
192 -- Dumping data for table `bugreport`
195 LOCK TABLES `bugreport` WRITE;
196 /*!40000 ALTER TABLE `bugreport` DISABLE KEYS */;
197 /*!40000 ALTER TABLE `bugreport` ENABLE KEYS */;
201 -- Table structure for table `character_account_data`
204 DROP TABLE IF EXISTS `character_account_data`;
205 /*!40101 SET @saved_cs_client = @@character_set_client */;
206 /*!40101 SET character_set_client = utf8 */;
207 CREATE TABLE `character_account_data` (
208 `guid` int(11) unsigned NOT NULL DEFAULT '0',
209 `type` int(11) unsigned NOT NULL DEFAULT '0',
210 `time` bigint(11) unsigned NOT NULL DEFAULT '0',
211 `data` longblob NOT NULL,
212 PRIMARY KEY (`guid`,`type`)
213 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
214 /*!40101 SET character_set_client = @saved_cs_client */;
217 -- Dumping data for table `character_account_data`
220 LOCK TABLES `character_account_data` WRITE;
221 /*!40000 ALTER TABLE `character_account_data` DISABLE KEYS */;
222 /*!40000 ALTER TABLE `character_account_data` ENABLE KEYS */;
226 -- Table structure for table `character_achievement`
229 DROP TABLE IF EXISTS `character_achievement`;
230 /*!40101 SET @saved_cs_client = @@character_set_client */;
231 /*!40101 SET character_set_client = utf8 */;
232 CREATE TABLE `character_achievement` (
233 `guid` int(11) unsigned NOT NULL,
234 `achievement` int(11) unsigned NOT NULL,
235 `date` bigint(11) unsigned NOT NULL DEFAULT '0',
236 PRIMARY KEY (`guid`,`achievement`)
237 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
238 /*!40101 SET character_set_client = @saved_cs_client */;
241 -- Dumping data for table `character_achievement`
244 LOCK TABLES `character_achievement` WRITE;
245 /*!40000 ALTER TABLE `character_achievement` DISABLE KEYS */;
246 /*!40000 ALTER TABLE `character_achievement` ENABLE KEYS */;
250 -- Table structure for table `character_achievement_progress`
253 DROP TABLE IF EXISTS `character_achievement_progress`;
254 /*!40101 SET @saved_cs_client = @@character_set_client */;
255 /*!40101 SET character_set_client = utf8 */;
256 CREATE TABLE `character_achievement_progress` (
257 `guid` int(11) unsigned NOT NULL,
258 `criteria` int(11) unsigned NOT NULL,
259 `counter` int(11) unsigned NOT NULL,
260 `date` bigint(11) unsigned NOT NULL DEFAULT '0',
261 PRIMARY KEY (`guid`,`criteria`)
262 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
263 /*!40101 SET character_set_client = @saved_cs_client */;
266 -- Dumping data for table `character_achievement_progress`
269 LOCK TABLES `character_achievement_progress` WRITE;
270 /*!40000 ALTER TABLE `character_achievement_progress` DISABLE KEYS */;
271 /*!40000 ALTER TABLE `character_achievement_progress` ENABLE KEYS */;
275 -- Table structure for table `character_action`
278 DROP TABLE IF EXISTS `character_action`;
279 /*!40101 SET @saved_cs_client = @@character_set_client */;
280 /*!40101 SET character_set_client = utf8 */;
281 CREATE TABLE `character_action` (
282 `guid` int(11) unsigned NOT NULL DEFAULT '0' COMMENT 'Global Unique Identifier',
283 `spec` tinyint(3) unsigned NOT NULL DEFAULT '0',
284 `button` tinyint(3) unsigned NOT NULL DEFAULT '0',
285 `action` int(11) unsigned NOT NULL DEFAULT '0',
286 `type` tinyint(3) unsigned NOT NULL DEFAULT '0',
287 PRIMARY KEY (`guid`,`spec`,`button`)
288 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Player System';
289 /*!40101 SET character_set_client = @saved_cs_client */;
292 -- Dumping data for table `character_action`
295 LOCK TABLES `character_action` WRITE;
296 /*!40000 ALTER TABLE `character_action` DISABLE KEYS */;
297 /*!40000 ALTER TABLE `character_action` ENABLE KEYS */;
301 -- Table structure for table `character_aura`
304 DROP TABLE IF EXISTS `character_aura`;
305 /*!40101 SET @saved_cs_client = @@character_set_client */;
306 /*!40101 SET character_set_client = utf8 */;
307 CREATE TABLE `character_aura` (
308 `guid` int(11) unsigned NOT NULL DEFAULT '0' COMMENT 'Global Unique Identifier',
309 `caster_guid` bigint(20) unsigned NOT NULL DEFAULT '0' COMMENT 'Full Global Unique Identifier',
310 `item_guid` int(11) unsigned NOT NULL DEFAULT '0',
311 `spell` int(11) unsigned NOT NULL DEFAULT '0',
312 `stackcount` int(11) unsigned NOT NULL DEFAULT '1',
313 `remaincharges` int(11) unsigned NOT NULL DEFAULT '0',
314 `basepoints0` int(11) NOT NULL DEFAULT '0',
315 `basepoints1` int(11) NOT NULL DEFAULT '0',
316 `basepoints2` int(11) NOT NULL DEFAULT '0',
317 `periodictime0` int(11) unsigned NOT NULL DEFAULT '0',
318 `periodictime1` int(11) unsigned NOT NULL DEFAULT '0',
319 `periodictime2` int(11) unsigned NOT NULL DEFAULT '0',
320 `maxduration` int(11) NOT NULL DEFAULT '0',
321 `remaintime` int(11) NOT NULL DEFAULT '0',
322 `effIndexMask` int(11) unsigned NOT NULL DEFAULT '0',
323 PRIMARY KEY (`guid`,`caster_guid`,`item_guid`,`spell`)
324 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Player System';
325 /*!40101 SET character_set_client = @saved_cs_client */;
328 -- Dumping data for table `character_aura`
331 LOCK TABLES `character_aura` WRITE;
332 /*!40000 ALTER TABLE `character_aura` DISABLE KEYS */;
333 /*!40000 ALTER TABLE `character_aura` ENABLE KEYS */;
337 -- Table structure for table `character_battleground_data`
340 DROP TABLE IF EXISTS `character_battleground_data`;
341 /*!40101 SET @saved_cs_client = @@character_set_client */;
342 /*!40101 SET character_set_client = utf8 */;
343 CREATE TABLE `character_battleground_data` (
344 `guid` int(11) unsigned NOT NULL DEFAULT '0' COMMENT 'Global Unique Identifier',
345 `instance_id` int(11) unsigned NOT NULL DEFAULT '0',
346 `team` int(11) unsigned NOT NULL DEFAULT '0',
347 `join_x` float NOT NULL DEFAULT '0',
348 `join_y` float NOT NULL DEFAULT '0',
349 `join_z` float NOT NULL DEFAULT '0',
350 `join_o` float NOT NULL DEFAULT '0',
351 `join_map` int(11) NOT NULL DEFAULT '0',
352 `taxi_start` int(11) NOT NULL DEFAULT '0',
353 `taxi_end` int(11) NOT NULL DEFAULT '0',
354 `mount_spell` int(11) NOT NULL DEFAULT '0',
356 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Player System';
357 /*!40101 SET character_set_client = @saved_cs_client */;
360 -- Dumping data for table `character_battleground_data`
363 LOCK TABLES `character_battleground_data` WRITE;
364 /*!40000 ALTER TABLE `character_battleground_data` DISABLE KEYS */;
365 /*!40000 ALTER TABLE `character_battleground_data` ENABLE KEYS */;
369 -- Table structure for table `character_currencies`
372 DROP TABLE IF EXISTS `character_currencies`;
373 /*!40101 SET @saved_cs_client = @@character_set_client */;
374 /*!40101 SET character_set_client = utf8 */;
375 CREATE TABLE `character_currencies` (
376 `guid` int(11) unsigned NOT NULL DEFAULT '0',
377 `id` smallint(5) unsigned NOT NULL DEFAULT '0',
378 `totalCount` int(11) unsigned NOT NULL DEFAULT '0',
379 `weekCount` int(11) unsigned NOT NULL DEFAULT '0',
380 `seasonCount` int(11) unsigned NOT NULL DEFAULT '0',
381 `flags` tinyint(2) unsigned NOT NULL DEFAULT '0',
382 PRIMARY KEY (`guid`,`id`)
383 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
384 /*!40101 SET character_set_client = @saved_cs_client */;
387 -- Dumping data for table `character_currencies`
390 LOCK TABLES `character_currencies` WRITE;
391 /*!40000 ALTER TABLE `character_currencies` DISABLE KEYS */;
392 /*!40000 ALTER TABLE `character_currencies` ENABLE KEYS */;
396 -- Table structure for table `character_db_version`
399 DROP TABLE IF EXISTS `character_db_version`;
400 /*!40101 SET @saved_cs_client = @@character_set_client */;
401 /*!40101 SET character_set_client = utf8 */;
402 CREATE TABLE `character_db_version` (
403 `required_12300_02_characters_mail` bit(1) DEFAULT NULL
404 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Last applied sql update to DB';
405 /*!40101 SET character_set_client = @saved_cs_client */;
408 -- Dumping data for table `character_db_version`
411 LOCK TABLES `character_db_version` WRITE;
412 /*!40000 ALTER TABLE `character_db_version` DISABLE KEYS */;
413 INSERT INTO `character_db_version` (`required_12300_02_characters_mail`) VALUES
415 /*!40000 ALTER TABLE `character_db_version` ENABLE KEYS */;
419 -- Table structure for table `character_declinedname`
422 DROP TABLE IF EXISTS `character_declinedname`;
423 /*!40101 SET @saved_cs_client = @@character_set_client */;
424 /*!40101 SET character_set_client = utf8 */;
425 CREATE TABLE `character_declinedname` (
426 `guid` int(11) unsigned NOT NULL DEFAULT '0' COMMENT 'Global Unique Identifier',
427 `genitive` varchar(15) NOT NULL DEFAULT '',
428 `dative` varchar(15) NOT NULL DEFAULT '',
429 `accusative` varchar(15) NOT NULL DEFAULT '',
430 `instrumental` varchar(15) NOT NULL DEFAULT '',
431 `prepositional` varchar(15) NOT NULL DEFAULT '',
433 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;
434 /*!40101 SET character_set_client = @saved_cs_client */;
437 -- Dumping data for table `character_declinedname`
440 LOCK TABLES `character_declinedname` WRITE;
441 /*!40000 ALTER TABLE `character_declinedname` DISABLE KEYS */;
442 /*!40000 ALTER TABLE `character_declinedname` ENABLE KEYS */;
446 -- Table structure for table `character_equipmentsets`
449 DROP TABLE IF EXISTS `character_equipmentsets`;
450 /*!40101 SET @saved_cs_client = @@character_set_client */;
451 /*!40101 SET character_set_client = utf8 */;
452 CREATE TABLE `character_equipmentsets` (
453 `guid` int(11) NOT NULL DEFAULT '0',
454 `setguid` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
455 `setindex` tinyint(4) NOT NULL DEFAULT '0',
456 `name` varchar(100) NOT NULL,
457 `iconname` varchar(100) NOT NULL,
458 `ignore_mask` int(11) unsigned NOT NULL DEFAULT '0',
459 `item0` int(11) unsigned NOT NULL DEFAULT '0',
460 `item1` int(11) unsigned NOT NULL DEFAULT '0',
461 `item2` int(11) unsigned NOT NULL DEFAULT '0',
462 `item3` int(11) unsigned NOT NULL DEFAULT '0',
463 `item4` int(11) unsigned NOT NULL DEFAULT '0',
464 `item5` int(11) unsigned NOT NULL DEFAULT '0',
465 `item6` int(11) unsigned NOT NULL DEFAULT '0',
466 `item7` int(11) unsigned NOT NULL DEFAULT '0',
467 `item8` int(11) unsigned NOT NULL DEFAULT '0',
468 `item9` int(11) unsigned NOT NULL DEFAULT '0',
469 `item10` int(11) unsigned NOT NULL DEFAULT '0',
470 `item11` int(11) unsigned NOT NULL DEFAULT '0',
471 `item12` int(11) unsigned NOT NULL DEFAULT '0',
472 `item13` int(11) unsigned NOT NULL DEFAULT '0',
473 `item14` int(11) unsigned NOT NULL DEFAULT '0',
474 `item15` int(11) unsigned NOT NULL DEFAULT '0',
475 `item16` int(11) unsigned NOT NULL DEFAULT '0',
476 `item17` int(11) unsigned NOT NULL DEFAULT '0',
477 `item18` int(11) unsigned NOT NULL DEFAULT '0',
478 PRIMARY KEY (`setguid`),
479 UNIQUE KEY `idx_set` (`guid`,`setguid`,`setindex`),
480 KEY `Idx_setindex` (`setindex`)
481 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
482 /*!40101 SET character_set_client = @saved_cs_client */;
485 -- Dumping data for table `character_equipmentsets`
488 LOCK TABLES `character_equipmentsets` WRITE;
489 /*!40000 ALTER TABLE `character_equipmentsets` DISABLE KEYS */;
490 /*!40000 ALTER TABLE `character_equipmentsets` ENABLE KEYS */;
494 -- Table structure for table `character_gifts`
497 DROP TABLE IF EXISTS `character_gifts`;
498 /*!40101 SET @saved_cs_client = @@character_set_client */;
499 /*!40101 SET character_set_client = utf8 */;
500 CREATE TABLE `character_gifts` (
501 `guid` int(20) unsigned NOT NULL DEFAULT '0',
502 `item_guid` int(11) unsigned NOT NULL DEFAULT '0',
503 `entry` int(20) unsigned NOT NULL DEFAULT '0',
504 `flags` int(20) unsigned NOT NULL DEFAULT '0',
505 PRIMARY KEY (`item_guid`),
506 KEY `idx_guid` (`guid`)
507 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
508 /*!40101 SET character_set_client = @saved_cs_client */;
511 -- Dumping data for table `character_gifts`
514 LOCK TABLES `character_gifts` WRITE;
515 /*!40000 ALTER TABLE `character_gifts` DISABLE KEYS */;
516 /*!40000 ALTER TABLE `character_gifts` ENABLE KEYS */;
520 -- Table structure for table `character_glyphs`
523 DROP TABLE IF EXISTS `character_glyphs`;
524 /*!40101 SET @saved_cs_client = @@character_set_client */;
525 /*!40101 SET character_set_client = utf8 */;
526 CREATE TABLE `character_glyphs` (
527 `guid` int(11) unsigned NOT NULL,
528 `spec` tinyint(3) unsigned NOT NULL DEFAULT '0',
529 `slot` tinyint(3) unsigned NOT NULL DEFAULT '0',
530 `glyph` int(11) unsigned NOT NULL DEFAULT '0',
531 PRIMARY KEY (`guid`,`spec`,`slot`)
532 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
533 /*!40101 SET character_set_client = @saved_cs_client */;
536 -- Dumping data for table `character_glyphs`
539 LOCK TABLES `character_glyphs` WRITE;
540 /*!40000 ALTER TABLE `character_glyphs` DISABLE KEYS */;
541 /*!40000 ALTER TABLE `character_glyphs` ENABLE KEYS */;
545 -- Table structure for table `character_homebind`
548 DROP TABLE IF EXISTS `character_homebind`;
549 /*!40101 SET @saved_cs_client = @@character_set_client */;
550 /*!40101 SET character_set_client = utf8 */;
551 CREATE TABLE `character_homebind` (
552 `guid` int(11) unsigned NOT NULL DEFAULT '0' COMMENT 'Global Unique Identifier',
553 `map` int(11) unsigned NOT NULL DEFAULT '0' COMMENT 'Map Identifier',
554 `zone` int(11) unsigned NOT NULL DEFAULT '0' COMMENT 'Zone Identifier',
555 `position_x` float NOT NULL DEFAULT '0',
556 `position_y` float NOT NULL DEFAULT '0',
557 `position_z` float NOT NULL DEFAULT '0',
559 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Player System';
560 /*!40101 SET character_set_client = @saved_cs_client */;
563 -- Dumping data for table `character_homebind`
566 LOCK TABLES `character_homebind` WRITE;
567 /*!40000 ALTER TABLE `character_homebind` DISABLE KEYS */;
568 /*!40000 ALTER TABLE `character_homebind` ENABLE KEYS */;
572 -- Table structure for table `character_instance`
575 DROP TABLE IF EXISTS `character_instance`;
576 /*!40101 SET @saved_cs_client = @@character_set_client */;
577 /*!40101 SET character_set_client = utf8 */;
578 CREATE TABLE `character_instance` (
579 `guid` int(11) unsigned NOT NULL DEFAULT '0',
580 `instance` int(11) unsigned NOT NULL DEFAULT '0',
581 `permanent` tinyint(1) unsigned NOT NULL DEFAULT '0',
582 PRIMARY KEY (`guid`,`instance`),
583 KEY `instance` (`instance`)
584 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
585 /*!40101 SET character_set_client = @saved_cs_client */;
588 -- Dumping data for table `character_instance`
591 LOCK TABLES `character_instance` WRITE;
592 /*!40000 ALTER TABLE `character_instance` DISABLE KEYS */;
593 /*!40000 ALTER TABLE `character_instance` ENABLE KEYS */;
597 -- Table structure for table `character_inventory`
600 DROP TABLE IF EXISTS `character_inventory`;
601 /*!40101 SET @saved_cs_client = @@character_set_client */;
602 /*!40101 SET character_set_client = utf8 */;
603 CREATE TABLE `character_inventory` (
604 `guid` int(11) unsigned NOT NULL DEFAULT '0' COMMENT 'Global Unique Identifier',
605 `bag` int(11) unsigned NOT NULL DEFAULT '0',
606 `slot` tinyint(3) unsigned NOT NULL DEFAULT '0',
607 `item` int(11) unsigned NOT NULL DEFAULT '0' COMMENT 'Item Global Unique Identifier',
608 `item_template` int(11) unsigned NOT NULL DEFAULT '0' COMMENT 'Item Identifier',
609 PRIMARY KEY (`item`),
610 KEY `idx_guid` (`guid`)
611 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Player System';
612 /*!40101 SET character_set_client = @saved_cs_client */;
615 -- Dumping data for table `character_inventory`
618 LOCK TABLES `character_inventory` WRITE;
619 /*!40000 ALTER TABLE `character_inventory` DISABLE KEYS */;
620 /*!40000 ALTER TABLE `character_inventory` ENABLE KEYS */;
624 -- Table structure for table `character_pet`
627 DROP TABLE IF EXISTS `character_pet`;
628 /*!40101 SET @saved_cs_client = @@character_set_client */;
629 /*!40101 SET character_set_client = utf8 */;
630 CREATE TABLE `character_pet` (
631 `id` int(11) unsigned NOT NULL DEFAULT '0',
632 `entry` int(11) unsigned NOT NULL DEFAULT '0',
633 `owner` int(11) unsigned NOT NULL DEFAULT '0',
634 `modelid` int(11) unsigned DEFAULT '0',
635 `CreatedBySpell` int(11) unsigned NOT NULL DEFAULT '0',
636 `PetType` tinyint(3) unsigned NOT NULL DEFAULT '0',
637 `level` int(11) unsigned NOT NULL DEFAULT '1',
638 `exp` int(11) unsigned NOT NULL DEFAULT '0',
639 `Reactstate` tinyint(1) unsigned NOT NULL DEFAULT '0',
640 `name` varchar(100) DEFAULT 'Pet',
641 `renamed` tinyint(1) unsigned NOT NULL DEFAULT '0',
642 `slot` int(11) unsigned NOT NULL DEFAULT '0',
643 `curhealth` int(11) unsigned NOT NULL DEFAULT '1',
644 `curmana` int(11) unsigned NOT NULL DEFAULT '0',
645 `savetime` bigint(20) unsigned NOT NULL DEFAULT '0',
646 `resettalents_cost` int(11) unsigned NOT NULL DEFAULT '0',
647 `resettalents_time` bigint(20) unsigned NOT NULL DEFAULT '0',
650 KEY `owner` (`owner`)
651 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Pet System';
652 /*!40101 SET character_set_client = @saved_cs_client */;
655 -- Dumping data for table `character_pet`
658 LOCK TABLES `character_pet` WRITE;
659 /*!40000 ALTER TABLE `character_pet` DISABLE KEYS */;
660 /*!40000 ALTER TABLE `character_pet` ENABLE KEYS */;
664 -- Table structure for table `character_pet_declinedname`
667 DROP TABLE IF EXISTS `character_pet_declinedname`;
668 /*!40101 SET @saved_cs_client = @@character_set_client */;
669 /*!40101 SET character_set_client = utf8 */;
670 CREATE TABLE `character_pet_declinedname` (
671 `id` int(11) unsigned NOT NULL DEFAULT '0',
672 `owner` int(11) unsigned NOT NULL DEFAULT '0',
673 `genitive` varchar(12) NOT NULL DEFAULT '',
674 `dative` varchar(12) NOT NULL DEFAULT '',
675 `accusative` varchar(12) NOT NULL DEFAULT '',
676 `instrumental` varchar(12) NOT NULL DEFAULT '',
677 `prepositional` varchar(12) NOT NULL DEFAULT '',
679 KEY `owner_key` (`owner`)
680 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;
681 /*!40101 SET character_set_client = @saved_cs_client */;
684 -- Dumping data for table `character_pet_declinedname`
687 LOCK TABLES `character_pet_declinedname` WRITE;
688 /*!40000 ALTER TABLE `character_pet_declinedname` DISABLE KEYS */;
689 /*!40000 ALTER TABLE `character_pet_declinedname` ENABLE KEYS */;
693 -- Table structure for table `character_phase_data`
696 DROP TABLE IF EXISTS `character_phase_data`;
697 /*!40101 SET @saved_cs_client = @@character_set_client */;
698 /*!40101 SET character_set_client = utf8 */;
699 CREATE TABLE `character_phase_data` (
700 `guid` int(11) NOT NULL,
701 `map` smallint(6) NOT NULL,
702 `phase` int(11) NOT NULL DEFAULT '0',
704 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;
705 /*!40101 SET character_set_client = @saved_cs_client */;
708 -- Dumping data for table `character_phase_data`
711 LOCK TABLES `character_phase_data` WRITE;
712 /*!40000 ALTER TABLE `character_phase_data` DISABLE KEYS */;
713 /*!40000 ALTER TABLE `character_phase_data` ENABLE KEYS */;
717 -- Table structure for table `character_queststatus`
720 DROP TABLE IF EXISTS `character_queststatus`;
721 /*!40101 SET @saved_cs_client = @@character_set_client */;
722 /*!40101 SET character_set_client = utf8 */;
723 CREATE TABLE `character_queststatus` (
724 `guid` int(11) unsigned NOT NULL DEFAULT '0' COMMENT 'Global Unique Identifier',
725 `quest` int(11) unsigned NOT NULL DEFAULT '0' COMMENT 'Quest Identifier',
726 `status` int(11) unsigned NOT NULL DEFAULT '0',
727 `rewarded` tinyint(1) unsigned NOT NULL DEFAULT '0',
728 `explored` tinyint(1) unsigned NOT NULL DEFAULT '0',
729 `timer` bigint(20) unsigned NOT NULL DEFAULT '0',
730 `mobcount1` int(11) unsigned NOT NULL DEFAULT '0',
731 `mobcount2` int(11) unsigned NOT NULL DEFAULT '0',
732 `mobcount3` int(11) unsigned NOT NULL DEFAULT '0',
733 `mobcount4` int(11) unsigned NOT NULL DEFAULT '0',
734 `itemcount1` int(11) unsigned NOT NULL DEFAULT '0',
735 `itemcount2` int(11) unsigned NOT NULL DEFAULT '0',
736 `itemcount3` int(11) unsigned NOT NULL DEFAULT '0',
737 `itemcount4` int(11) unsigned NOT NULL DEFAULT '0',
738 `itemcount5` int(11) unsigned NOT NULL DEFAULT '0',
739 `itemcount6` int(11) unsigned NOT NULL DEFAULT '0',
740 PRIMARY KEY (`guid`,`quest`)
741 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Player System';
742 /*!40101 SET character_set_client = @saved_cs_client */;
745 -- Dumping data for table `character_queststatus`
748 LOCK TABLES `character_queststatus` WRITE;
749 /*!40000 ALTER TABLE `character_queststatus` DISABLE KEYS */;
750 /*!40000 ALTER TABLE `character_queststatus` ENABLE KEYS */;
754 -- Table structure for table `character_queststatus_daily`
757 DROP TABLE IF EXISTS `character_queststatus_daily`;
758 /*!40101 SET @saved_cs_client = @@character_set_client */;
759 /*!40101 SET character_set_client = utf8 */;
760 CREATE TABLE `character_queststatus_daily` (
761 `guid` int(11) unsigned NOT NULL DEFAULT '0' COMMENT 'Global Unique Identifier',
762 `quest` int(11) unsigned NOT NULL DEFAULT '0' COMMENT 'Quest Identifier',
763 PRIMARY KEY (`guid`,`quest`),
764 KEY `idx_guid` (`guid`)
765 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Player System';
766 /*!40101 SET character_set_client = @saved_cs_client */;
769 -- Dumping data for table `character_queststatus_daily`
772 LOCK TABLES `character_queststatus_daily` WRITE;
773 /*!40000 ALTER TABLE `character_queststatus_daily` DISABLE KEYS */;
774 /*!40000 ALTER TABLE `character_queststatus_daily` ENABLE KEYS */;
778 -- Table structure for table `character_queststatus_monthly`
781 DROP TABLE IF EXISTS `character_queststatus_monthly`;
782 /*!40101 SET @saved_cs_client = @@character_set_client */;
783 /*!40101 SET character_set_client = utf8 */;
784 CREATE TABLE `character_queststatus_monthly` (
785 `guid` int(11) unsigned NOT NULL DEFAULT '0' COMMENT 'Global Unique Identifier',
786 `quest` int(11) unsigned NOT NULL DEFAULT '0' COMMENT 'Quest Identifier',
787 PRIMARY KEY (`guid`,`quest`),
788 KEY `idx_guid` (`guid`)
789 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Player System';
790 /*!40101 SET character_set_client = @saved_cs_client */;
793 -- Dumping data for table `character_queststatus_monthly`
796 LOCK TABLES `character_queststatus_monthly` WRITE;
797 /*!40000 ALTER TABLE `character_queststatus_monthly` DISABLE KEYS */;
798 /*!40000 ALTER TABLE `character_queststatus_monthly` ENABLE KEYS */;
802 -- Table structure for table `character_queststatus_weekly`
805 DROP TABLE IF EXISTS `character_queststatus_weekly`;
806 /*!40101 SET @saved_cs_client = @@character_set_client */;
807 /*!40101 SET character_set_client = utf8 */;
808 CREATE TABLE `character_queststatus_weekly` (
809 `guid` int(11) unsigned NOT NULL DEFAULT '0' COMMENT 'Global Unique Identifier',
810 `quest` int(11) unsigned NOT NULL DEFAULT '0' COMMENT 'Quest Identifier',
811 PRIMARY KEY (`guid`,`quest`),
812 KEY `idx_guid` (`guid`)
813 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Player System';
814 /*!40101 SET character_set_client = @saved_cs_client */;
817 -- Dumping data for table `character_queststatus_weekly`
820 LOCK TABLES `character_queststatus_weekly` WRITE;
821 /*!40000 ALTER TABLE `character_queststatus_weekly` DISABLE KEYS */;
822 /*!40000 ALTER TABLE `character_queststatus_weekly` ENABLE KEYS */;
826 -- Table structure for table `character_reputation`
829 DROP TABLE IF EXISTS `character_reputation`;
830 /*!40101 SET @saved_cs_client = @@character_set_client */;
831 /*!40101 SET character_set_client = utf8 */;
832 CREATE TABLE `character_reputation` (
833 `guid` int(11) unsigned NOT NULL DEFAULT '0' COMMENT 'Global Unique Identifier',
834 `faction` int(11) unsigned NOT NULL DEFAULT '0',
835 `standing` int(11) NOT NULL DEFAULT '0',
836 `flags` int(11) NOT NULL DEFAULT '0',
837 PRIMARY KEY (`guid`,`faction`)
838 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Player System';
839 /*!40101 SET character_set_client = @saved_cs_client */;
842 -- Dumping data for table `character_reputation`
845 LOCK TABLES `character_reputation` WRITE;
846 /*!40000 ALTER TABLE `character_reputation` DISABLE KEYS */;
847 /*!40000 ALTER TABLE `character_reputation` ENABLE KEYS */;
851 -- Table structure for table `character_skills`
854 DROP TABLE IF EXISTS `character_skills`;
855 /*!40101 SET @saved_cs_client = @@character_set_client */;
856 /*!40101 SET character_set_client = utf8 */;
857 CREATE TABLE `character_skills` (
858 `guid` int(11) unsigned NOT NULL COMMENT 'Global Unique Identifier',
859 `skill` mediumint(9) unsigned NOT NULL,
860 `value` mediumint(9) unsigned NOT NULL,
861 `max` mediumint(9) unsigned NOT NULL,
862 PRIMARY KEY (`guid`,`skill`)
863 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Player System';
864 /*!40101 SET character_set_client = @saved_cs_client */;
867 -- Dumping data for table `character_skills`
870 LOCK TABLES `character_skills` WRITE;
871 /*!40000 ALTER TABLE `character_skills` DISABLE KEYS */;
872 /*!40000 ALTER TABLE `character_skills` ENABLE KEYS */;
876 -- Table structure for table `character_social`
879 DROP TABLE IF EXISTS `character_social`;
880 /*!40101 SET @saved_cs_client = @@character_set_client */;
881 /*!40101 SET character_set_client = utf8 */;
882 CREATE TABLE `character_social` (
883 `guid` int(11) unsigned NOT NULL DEFAULT '0' COMMENT 'Character Global Unique Identifier',
884 `friend` int(11) unsigned NOT NULL DEFAULT '0' COMMENT 'Friend Global Unique Identifier',
885 `flags` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT 'Friend Flags',
886 `note` varchar(48) NOT NULL DEFAULT '' COMMENT 'Friend Note',
887 PRIMARY KEY (`guid`,`friend`,`flags`),
889 KEY `friend` (`friend`),
890 KEY `guid_flags` (`guid`,`flags`),
891 KEY `friend_flags` (`friend`,`flags`)
892 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Player System';
893 /*!40101 SET character_set_client = @saved_cs_client */;
896 -- Dumping data for table `character_social`
899 LOCK TABLES `character_social` WRITE;
900 /*!40000 ALTER TABLE `character_social` DISABLE KEYS */;
901 /*!40000 ALTER TABLE `character_social` ENABLE KEYS */;
905 -- Table structure for table `character_spell`
908 DROP TABLE IF EXISTS `character_spell`;
909 /*!40101 SET @saved_cs_client = @@character_set_client */;
910 /*!40101 SET character_set_client = utf8 */;
911 CREATE TABLE `character_spell` (
912 `guid` int(11) unsigned NOT NULL DEFAULT '0' COMMENT 'Global Unique Identifier',
913 `spell` int(11) unsigned NOT NULL DEFAULT '0' COMMENT 'Spell Identifier',
914 `active` tinyint(3) unsigned NOT NULL DEFAULT '1',
915 `disabled` tinyint(3) unsigned NOT NULL DEFAULT '0',
916 PRIMARY KEY (`guid`,`spell`),
917 KEY `Idx_spell` (`spell`)
918 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Player System';
919 /*!40101 SET character_set_client = @saved_cs_client */;
922 -- Dumping data for table `character_spell`
925 LOCK TABLES `character_spell` WRITE;
926 /*!40000 ALTER TABLE `character_spell` DISABLE KEYS */;
927 /*!40000 ALTER TABLE `character_spell` ENABLE KEYS */;
931 -- Table structure for table `character_spell_cooldown`
934 DROP TABLE IF EXISTS `character_spell_cooldown`;
935 /*!40101 SET @saved_cs_client = @@character_set_client */;
936 /*!40101 SET character_set_client = utf8 */;
937 CREATE TABLE `character_spell_cooldown` (
938 `guid` int(11) unsigned NOT NULL DEFAULT '0' COMMENT 'Global Unique Identifier, Low part',
939 `spell` int(11) unsigned NOT NULL DEFAULT '0' COMMENT 'Spell Identifier',
940 `item` int(11) unsigned NOT NULL DEFAULT '0' COMMENT 'Item Identifier',
941 `time` bigint(20) unsigned NOT NULL DEFAULT '0',
942 PRIMARY KEY (`guid`,`spell`)
943 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
944 /*!40101 SET character_set_client = @saved_cs_client */;
947 -- Dumping data for table `character_spell_cooldown`
950 LOCK TABLES `character_spell_cooldown` WRITE;
951 /*!40000 ALTER TABLE `character_spell_cooldown` DISABLE KEYS */;
952 /*!40000 ALTER TABLE `character_spell_cooldown` ENABLE KEYS */;
956 -- Table structure for table `character_stats`
959 DROP TABLE IF EXISTS `character_stats`;
960 /*!40101 SET @saved_cs_client = @@character_set_client */;
961 /*!40101 SET character_set_client = utf8 */;
962 CREATE TABLE `character_stats` (
963 `guid` int(11) unsigned NOT NULL DEFAULT '0' COMMENT 'Global Unique Identifier, Low part',
964 `maxhealth` int(10) unsigned NOT NULL DEFAULT '0',
965 `maxpower1` int(10) unsigned NOT NULL DEFAULT '0',
966 `maxpower2` int(10) unsigned NOT NULL DEFAULT '0',
967 `maxpower3` int(10) unsigned NOT NULL DEFAULT '0',
968 `maxpower4` int(10) unsigned NOT NULL DEFAULT '0',
969 `maxpower5` int(10) unsigned NOT NULL DEFAULT '0',
970 `strength` int(10) unsigned NOT NULL DEFAULT '0',
971 `agility` int(10) unsigned NOT NULL DEFAULT '0',
972 `stamina` int(10) unsigned NOT NULL DEFAULT '0',
973 `intellect` int(10) unsigned NOT NULL DEFAULT '0',
974 `spirit` int(10) unsigned NOT NULL DEFAULT '0',
975 `armor` int(10) unsigned NOT NULL DEFAULT '0',
976 `resHoly` int(10) unsigned NOT NULL DEFAULT '0',
977 `resFire` int(10) unsigned NOT NULL DEFAULT '0',
978 `resNature` int(10) unsigned NOT NULL DEFAULT '0',
979 `resFrost` int(10) unsigned NOT NULL DEFAULT '0',
980 `resShadow` int(10) unsigned NOT NULL DEFAULT '0',
981 `resArcane` int(10) unsigned NOT NULL DEFAULT '0',
982 `blockPct` float unsigned NOT NULL DEFAULT '0',
983 `dodgePct` float unsigned NOT NULL DEFAULT '0',
984 `parryPct` float unsigned NOT NULL DEFAULT '0',
985 `critPct` float unsigned NOT NULL DEFAULT '0',
986 `rangedCritPct` float unsigned NOT NULL DEFAULT '0',
987 `spellCritPct` float unsigned NOT NULL DEFAULT '0',
988 `attackPower` int(10) unsigned NOT NULL DEFAULT '0',
989 `rangedAttackPower` int(10) unsigned NOT NULL DEFAULT '0',
990 `spellPower` int(10) unsigned NOT NULL DEFAULT '0',
992 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
993 /*!40101 SET character_set_client = @saved_cs_client */;
996 -- Dumping data for table `character_stats`
999 LOCK TABLES `character_stats` WRITE;
1000 /*!40000 ALTER TABLE `character_stats` DISABLE KEYS */;
1001 /*!40000 ALTER TABLE `character_stats` ENABLE KEYS */;
1005 -- Table structure for table `character_talent`
1008 DROP TABLE IF EXISTS `character_talent`;
1009 /*!40101 SET @saved_cs_client = @@character_set_client */;
1010 /*!40101 SET character_set_client = utf8 */;
1011 CREATE TABLE `character_talent` (
1012 `guid` int(11) unsigned NOT NULL,
1013 `talent_id` int(11) unsigned NOT NULL,
1014 `current_rank` tinyint(3) unsigned NOT NULL DEFAULT '0',
1015 `spec` tinyint(3) unsigned NOT NULL DEFAULT '0',
1016 PRIMARY KEY (`guid`,`talent_id`,`spec`),
1017 KEY `guid_key` (`guid`),
1018 KEY `talent_key` (`talent_id`),
1019 KEY `spec_key` (`spec`)
1020 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1021 /*!40101 SET character_set_client = @saved_cs_client */;
1024 -- Dumping data for table `character_talent`
1027 LOCK TABLES `character_talent` WRITE;
1028 /*!40000 ALTER TABLE `character_talent` DISABLE KEYS */;
1029 /*!40000 ALTER TABLE `character_talent` ENABLE KEYS */;
1033 -- Table structure for table `character_ticket`
1036 DROP TABLE IF EXISTS `character_ticket`;
1037 /*!40101 SET @saved_cs_client = @@character_set_client */;
1038 /*!40101 SET character_set_client = utf8 */;
1039 CREATE TABLE `character_ticket` (
1040 `ticket_id` int(11) unsigned NOT NULL AUTO_INCREMENT,
1041 `guid` int(11) unsigned NOT NULL DEFAULT '0',
1043 `response_text` text,
1044 `ticket_lastchange` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
1045 PRIMARY KEY (`ticket_id`)
1046 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Player System';
1047 /*!40101 SET character_set_client = @saved_cs_client */;
1050 -- Dumping data for table `character_ticket`
1053 LOCK TABLES `character_ticket` WRITE;
1054 /*!40000 ALTER TABLE `character_ticket` DISABLE KEYS */;
1055 /*!40000 ALTER TABLE `character_ticket` ENABLE KEYS */;
1059 -- Table structure for table `character_tutorial`
1062 DROP TABLE IF EXISTS `character_tutorial`;
1063 /*!40101 SET @saved_cs_client = @@character_set_client */;
1064 /*!40101 SET character_set_client = utf8 */;
1065 CREATE TABLE `character_tutorial` (
1066 `account` bigint(20) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Account Identifier',
1067 `tut0` int(11) unsigned NOT NULL DEFAULT '0',
1068 `tut1` int(11) unsigned NOT NULL DEFAULT '0',
1069 `tut2` int(11) unsigned NOT NULL DEFAULT '0',
1070 `tut3` int(11) unsigned NOT NULL DEFAULT '0',
1071 `tut4` int(11) unsigned NOT NULL DEFAULT '0',
1072 `tut5` int(11) unsigned NOT NULL DEFAULT '0',
1073 `tut6` int(11) unsigned NOT NULL DEFAULT '0',
1074 `tut7` int(11) unsigned NOT NULL DEFAULT '0',
1075 PRIMARY KEY (`account`)
1076 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Player System';
1077 /*!40101 SET character_set_client = @saved_cs_client */;
1080 -- Dumping data for table `character_tutorial`
1083 LOCK TABLES `character_tutorial` WRITE;
1084 /*!40000 ALTER TABLE `character_tutorial` DISABLE KEYS */;
1085 /*!40000 ALTER TABLE `character_tutorial` ENABLE KEYS */;
1089 -- Table structure for table `characters`
1092 DROP TABLE IF EXISTS `characters`;
1093 /*!40101 SET @saved_cs_client = @@character_set_client */;
1094 /*!40101 SET character_set_client = utf8 */;
1095 CREATE TABLE `characters` (
1096 `guid` int(11) unsigned NOT NULL DEFAULT '0' COMMENT 'Global Unique Identifier',
1097 `account` int(11) unsigned NOT NULL DEFAULT '0' COMMENT 'Account Identifier',
1098 `name` varchar(12) NOT NULL DEFAULT '',
1099 `race` tinyint(3) unsigned NOT NULL DEFAULT '0',
1100 `class` tinyint(3) unsigned NOT NULL DEFAULT '0',
1101 `gender` tinyint(3) unsigned NOT NULL DEFAULT '0',
1102 `level` tinyint(3) unsigned NOT NULL DEFAULT '0',
1103 `xp` int(10) unsigned NOT NULL DEFAULT '0',
1104 `money` bigint(40) unsigned NOT NULL DEFAULT '0',
1105 `playerBytes` int(10) unsigned NOT NULL DEFAULT '0',
1106 `playerBytes2` int(10) unsigned NOT NULL DEFAULT '0',
1107 `playerFlags` int(10) unsigned NOT NULL DEFAULT '0',
1108 `position_x` float NOT NULL DEFAULT '0',
1109 `position_y` float NOT NULL DEFAULT '0',
1110 `position_z` float NOT NULL DEFAULT '0',
1111 `map` int(11) unsigned NOT NULL DEFAULT '0' COMMENT 'Map Identifier',
1112 `dungeon_difficulty` tinyint(1) unsigned NOT NULL DEFAULT '0',
1113 `orientation` float NOT NULL DEFAULT '0',
1114 `taximask` longtext,
1115 `online` tinyint(3) unsigned NOT NULL DEFAULT '0',
1116 `cinematic` tinyint(3) unsigned NOT NULL DEFAULT '0',
1117 `totaltime` int(11) unsigned NOT NULL DEFAULT '0',
1118 `leveltime` int(11) unsigned NOT NULL DEFAULT '0',
1119 `logout_time` bigint(20) unsigned NOT NULL DEFAULT '0',
1120 `is_logout_resting` tinyint(3) unsigned NOT NULL DEFAULT '0',
1121 `rest_bonus` float NOT NULL DEFAULT '0',
1122 `resettalents_cost` int(11) unsigned NOT NULL DEFAULT '0',
1123 `resettalents_time` bigint(20) unsigned NOT NULL DEFAULT '0',
1124 `primary_trees` varchar(10) NOT NULL DEFAULT '0 0 ',
1125 `trans_x` float NOT NULL DEFAULT '0',
1126 `trans_y` float NOT NULL DEFAULT '0',
1127 `trans_z` float NOT NULL DEFAULT '0',
1128 `trans_o` float NOT NULL DEFAULT '0',
1129 `transguid` bigint(20) unsigned NOT NULL DEFAULT '0',
1130 `extra_flags` int(11) unsigned NOT NULL DEFAULT '0',
1131 `stable_slots` tinyint(1) unsigned NOT NULL DEFAULT '0',
1132 `at_login` int(11) unsigned NOT NULL DEFAULT '0',
1133 `zone` int(11) unsigned NOT NULL DEFAULT '0',
1134 `death_expire_time` bigint(20) unsigned NOT NULL DEFAULT '0',
1136 `totalKills` int(10) unsigned NOT NULL DEFAULT '0',
1137 `todayKills` smallint(5) unsigned NOT NULL DEFAULT '0',
1138 `yesterdayKills` smallint(5) unsigned NOT NULL DEFAULT '0',
1139 `chosenTitle` int(10) unsigned NOT NULL DEFAULT '0',
1140 `watchedFaction` int(10) unsigned NOT NULL DEFAULT '0',
1141 `drunk` smallint(5) unsigned NOT NULL DEFAULT '0',
1142 `health` int(10) unsigned NOT NULL DEFAULT '0',
1143 `power1` int(10) unsigned NOT NULL DEFAULT '0',
1144 `power2` int(10) unsigned NOT NULL DEFAULT '0',
1145 `power3` int(10) unsigned NOT NULL DEFAULT '0',
1146 `power4` int(10) unsigned NOT NULL DEFAULT '0',
1147 `power5` int(10) unsigned NOT NULL DEFAULT '0',
1148 `specCount` tinyint(3) unsigned NOT NULL DEFAULT '1',
1149 `activeSpec` tinyint(3) unsigned NOT NULL DEFAULT '0',
1150 `exploredZones` longtext,
1151 `equipmentCache` longtext,
1152 `knownTitles` longtext,
1153 `actionBars` tinyint(3) unsigned NOT NULL DEFAULT '0',
1154 `slot` tinyint(3) unsigned NOT NULL DEFAULT '255',
1155 `deleteInfos_Account` int(11) unsigned DEFAULT NULL,
1156 `deleteInfos_Name` varchar(12) DEFAULT NULL,
1157 `deleteDate` bigint(20) unsigned DEFAULT NULL,
1158 PRIMARY KEY (`guid`),
1159 KEY `idx_account` (`account`),
1160 KEY `idx_online` (`online`),
1161 KEY `idx_name` (`name`)
1162 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Player System';
1163 /*!40101 SET character_set_client = @saved_cs_client */;
1166 -- Dumping data for table `characters`
1169 LOCK TABLES `characters` WRITE;
1170 /*!40000 ALTER TABLE `characters` DISABLE KEYS */;
1171 /*!40000 ALTER TABLE `characters` ENABLE KEYS */;
1175 -- Table structure for table `corpse`
1178 DROP TABLE IF EXISTS `corpse`;
1179 /*!40101 SET @saved_cs_client = @@character_set_client */;
1180 /*!40101 SET character_set_client = utf8 */;
1181 CREATE TABLE `corpse` (
1182 `guid` int(11) unsigned NOT NULL DEFAULT '0' COMMENT 'Global Unique Identifier',
1183 `player` int(11) unsigned NOT NULL DEFAULT '0' COMMENT 'Character Global Unique Identifier',
1184 `position_x` float NOT NULL DEFAULT '0',
1185 `position_y` float NOT NULL DEFAULT '0',
1186 `position_z` float NOT NULL DEFAULT '0',
1187 `orientation` float NOT NULL DEFAULT '0',
1188 `map` int(11) unsigned NOT NULL DEFAULT '0' COMMENT 'Map Identifier',
1189 `phaseMask` smallint(5) unsigned NOT NULL DEFAULT '1',
1190 `time` bigint(20) unsigned NOT NULL DEFAULT '0',
1191 `corpse_type` tinyint(3) unsigned NOT NULL DEFAULT '0',
1192 `instance` int(11) unsigned NOT NULL DEFAULT '0',
1193 PRIMARY KEY (`guid`),
1194 KEY `idx_type` (`corpse_type`),
1195 KEY `instance` (`instance`),
1196 KEY `Idx_player` (`player`),
1197 KEY `Idx_time` (`time`)
1198 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Death System';
1199 /*!40101 SET character_set_client = @saved_cs_client */;
1202 -- Dumping data for table `corpse`
1205 LOCK TABLES `corpse` WRITE;
1206 /*!40000 ALTER TABLE `corpse` DISABLE KEYS */;
1207 /*!40000 ALTER TABLE `corpse` ENABLE KEYS */;
1211 -- Table structure for table `creature_respawn`
1214 DROP TABLE IF EXISTS `creature_respawn`;
1215 /*!40101 SET @saved_cs_client = @@character_set_client */;
1216 /*!40101 SET character_set_client = utf8 */;
1217 CREATE TABLE `creature_respawn` (
1218 `guid` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Global Unique Identifier',
1219 `respawntime` bigint(20) unsigned NOT NULL DEFAULT '0',
1220 `instance` mediumint(8) unsigned NOT NULL DEFAULT '0',
1221 PRIMARY KEY (`guid`,`instance`),
1222 KEY `instance` (`instance`)
1223 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Grid Loading System';
1224 /*!40101 SET character_set_client = @saved_cs_client */;
1227 -- Dumping data for table `creature_respawn`
1230 LOCK TABLES `creature_respawn` WRITE;
1231 /*!40000 ALTER TABLE `creature_respawn` DISABLE KEYS */;
1232 /*!40000 ALTER TABLE `creature_respawn` ENABLE KEYS */;
1236 -- Table structure for table `game_event_status`
1239 DROP TABLE IF EXISTS `game_event_status`;
1240 /*!40101 SET @saved_cs_client = @@character_set_client */;
1241 /*!40101 SET character_set_client = utf8 */;
1242 CREATE TABLE `game_event_status` (
1243 `event` smallint(6) unsigned NOT NULL DEFAULT '0',
1244 PRIMARY KEY (`event`)
1245 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Game event system';
1246 /*!40101 SET character_set_client = @saved_cs_client */;
1249 -- Dumping data for table `game_event_status`
1252 LOCK TABLES `game_event_status` WRITE;
1253 /*!40000 ALTER TABLE `game_event_status` DISABLE KEYS */;
1254 /*!40000 ALTER TABLE `game_event_status` ENABLE KEYS */;
1258 -- Table structure for table `gameobject_respawn`
1261 DROP TABLE IF EXISTS `gameobject_respawn`;
1262 /*!40101 SET @saved_cs_client = @@character_set_client */;
1263 /*!40101 SET character_set_client = utf8 */;
1264 CREATE TABLE `gameobject_respawn` (
1265 `guid` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Global Unique Identifier',
1266 `respawntime` bigint(20) unsigned NOT NULL DEFAULT '0',
1267 `instance` mediumint(8) unsigned NOT NULL DEFAULT '0',
1268 PRIMARY KEY (`guid`,`instance`),
1269 KEY `instance` (`instance`)
1270 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Grid Loading System';
1271 /*!40101 SET character_set_client = @saved_cs_client */;
1274 -- Dumping data for table `gameobject_respawn`
1277 LOCK TABLES `gameobject_respawn` WRITE;
1278 /*!40000 ALTER TABLE `gameobject_respawn` DISABLE KEYS */;
1279 /*!40000 ALTER TABLE `gameobject_respawn` ENABLE KEYS */;
1283 -- Table structure for table `group_instance`
1286 DROP TABLE IF EXISTS `group_instance`;
1287 /*!40101 SET @saved_cs_client = @@character_set_client */;
1288 /*!40101 SET character_set_client = utf8 */;
1289 CREATE TABLE `group_instance` (
1290 `leaderGuid` int(11) unsigned NOT NULL DEFAULT '0',
1291 `instance` int(11) unsigned NOT NULL DEFAULT '0',
1292 `permanent` tinyint(1) unsigned NOT NULL DEFAULT '0',
1293 PRIMARY KEY (`leaderGuid`,`instance`),
1294 KEY `instance` (`instance`)
1295 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1296 /*!40101 SET character_set_client = @saved_cs_client */;
1299 -- Dumping data for table `group_instance`
1302 LOCK TABLES `group_instance` WRITE;
1303 /*!40000 ALTER TABLE `group_instance` DISABLE KEYS */;
1304 /*!40000 ALTER TABLE `group_instance` ENABLE KEYS */;
1308 -- Table structure for table `group_member`
1311 DROP TABLE IF EXISTS `group_member`;
1312 /*!40101 SET @saved_cs_client = @@character_set_client */;
1313 /*!40101 SET character_set_client = utf8 */;
1314 CREATE TABLE `group_member` (
1315 `groupId` int(11) unsigned NOT NULL,
1316 `memberGuid` int(11) unsigned NOT NULL,
1317 `assistant` tinyint(1) unsigned NOT NULL,
1318 `subgroup` smallint(6) unsigned NOT NULL,
1319 PRIMARY KEY (`groupId`,`memberGuid`),
1320 KEY `Idx_memberGuid` (`memberGuid`)
1321 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Groups';
1322 /*!40101 SET character_set_client = @saved_cs_client */;
1325 -- Dumping data for table `group_member`
1328 LOCK TABLES `group_member` WRITE;
1329 /*!40000 ALTER TABLE `group_member` DISABLE KEYS */;
1330 /*!40000 ALTER TABLE `group_member` ENABLE KEYS */;
1334 -- Table structure for table `groups`
1337 DROP TABLE IF EXISTS `groups`;
1338 /*!40101 SET @saved_cs_client = @@character_set_client */;
1339 /*!40101 SET character_set_client = utf8 */;
1340 CREATE TABLE `groups` (
1341 `groupId` int(11) unsigned NOT NULL,
1342 `leaderGuid` int(11) unsigned NOT NULL,
1343 `mainTank` int(11) unsigned NOT NULL,
1344 `mainAssistant` int(11) unsigned NOT NULL,
1345 `lootMethod` tinyint(4) unsigned NOT NULL,
1346 `looterGuid` int(11) unsigned NOT NULL,
1347 `lootThreshold` tinyint(4) unsigned NOT NULL,
1348 `icon1` int(11) unsigned NOT NULL,
1349 `icon2` int(11) unsigned NOT NULL,
1350 `icon3` int(11) unsigned NOT NULL,
1351 `icon4` int(11) unsigned NOT NULL,
1352 `icon5` int(11) unsigned NOT NULL,
1353 `icon6` int(11) unsigned NOT NULL,
1354 `icon7` int(11) unsigned NOT NULL,
1355 `icon8` int(11) unsigned NOT NULL,
1356 `groupType` tinyint(1) unsigned NOT NULL,
1357 `difficulty` tinyint(3) unsigned NOT NULL DEFAULT '0',
1358 `raiddifficulty` int(11) unsigned NOT NULL DEFAULT '0',
1359 PRIMARY KEY (`groupId`),
1360 UNIQUE KEY `leaderGuid` (`leaderGuid`)
1361 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Groups';
1362 /*!40101 SET character_set_client = @saved_cs_client */;
1365 -- Dumping data for table `groups`
1368 LOCK TABLES `groups` WRITE;
1369 /*!40000 ALTER TABLE `groups` DISABLE KEYS */;
1370 /*!40000 ALTER TABLE `groups` ENABLE KEYS */;
1374 -- Table structure for table `guild`
1377 DROP TABLE IF EXISTS `guild`;
1378 /*!40101 SET @saved_cs_client = @@character_set_client */;
1379 /*!40101 SET character_set_client = utf8 */;
1380 CREATE TABLE `guild` (
1381 `guildid` int(6) unsigned NOT NULL DEFAULT '0',
1382 `name` varchar(255) NOT NULL DEFAULT '',
1383 `leaderguid` int(6) unsigned NOT NULL DEFAULT '0',
1384 `EmblemStyle` int(5) NOT NULL DEFAULT '0',
1385 `EmblemColor` int(5) NOT NULL DEFAULT '0',
1386 `BorderStyle` int(5) NOT NULL DEFAULT '0',
1387 `BorderColor` int(5) NOT NULL DEFAULT '0',
1388 `BackgroundColor` int(5) NOT NULL DEFAULT '0',
1389 `info` text NOT NULL,
1390 `motd` varchar(255) NOT NULL DEFAULT '',
1391 `createdate` bigint(20) unsigned NOT NULL DEFAULT '0',
1392 `BankMoney` bigint(20) unsigned NOT NULL DEFAULT '0',
1393 PRIMARY KEY (`guildid`)
1394 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Guild System';
1395 /*!40101 SET character_set_client = @saved_cs_client */;
1398 -- Dumping data for table `guild`
1401 LOCK TABLES `guild` WRITE;
1402 /*!40000 ALTER TABLE `guild` DISABLE KEYS */;
1403 /*!40000 ALTER TABLE `guild` ENABLE KEYS */;
1407 -- Table structure for table `guild_bank_eventlog`
1410 DROP TABLE IF EXISTS `guild_bank_eventlog`;
1411 /*!40101 SET @saved_cs_client = @@character_set_client */;
1412 /*!40101 SET character_set_client = utf8 */;
1413 CREATE TABLE `guild_bank_eventlog` (
1414 `guildid` int(11) unsigned NOT NULL DEFAULT '0' COMMENT 'Guild Identificator',
1415 `LogGuid` int(11) unsigned NOT NULL DEFAULT '0' COMMENT 'Log record identificator - auxiliary column',
1416 `TabId` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT 'Guild bank TabId',
1417 `EventType` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT 'Event type',
1418 `PlayerGuid` int(11) unsigned NOT NULL DEFAULT '0',
1419 `ItemOrMoney` int(11) unsigned NOT NULL DEFAULT '0',
1420 `ItemStackCount` tinyint(3) unsigned NOT NULL DEFAULT '0',
1421 `DestTabId` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT 'Destination Tab Id',
1422 `TimeStamp` bigint(20) unsigned NOT NULL DEFAULT '0' COMMENT 'Event UNIX time',
1423 PRIMARY KEY (`guildid`,`LogGuid`,`TabId`),
1424 KEY `guildid_key` (`guildid`),
1425 KEY `Idx_PlayerGuid` (`PlayerGuid`),
1426 KEY `Idx_LogGuid` (`LogGuid`)
1427 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1428 /*!40101 SET character_set_client = @saved_cs_client */;
1431 -- Dumping data for table `guild_bank_eventlog`
1434 LOCK TABLES `guild_bank_eventlog` WRITE;
1435 /*!40000 ALTER TABLE `guild_bank_eventlog` DISABLE KEYS */;
1436 /*!40000 ALTER TABLE `guild_bank_eventlog` ENABLE KEYS */;
1440 -- Table structure for table `guild_bank_item`
1443 DROP TABLE IF EXISTS `guild_bank_item`;
1444 /*!40101 SET @saved_cs_client = @@character_set_client */;
1445 /*!40101 SET character_set_client = utf8 */;
1446 CREATE TABLE `guild_bank_item` (
1447 `guildid` int(11) unsigned NOT NULL DEFAULT '0',
1448 `TabId` tinyint(1) unsigned NOT NULL DEFAULT '0',
1449 `SlotId` tinyint(3) unsigned NOT NULL DEFAULT '0',
1450 `item_guid` int(11) unsigned NOT NULL DEFAULT '0',
1451 `item_entry` int(11) unsigned NOT NULL DEFAULT '0',
1452 PRIMARY KEY (`guildid`,`TabId`,`SlotId`),
1453 KEY `guildid_key` (`guildid`),
1454 KEY `Idx_item_guid` (`item_guid`)
1455 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1456 /*!40101 SET character_set_client = @saved_cs_client */;
1459 -- Dumping data for table `guild_bank_item`
1462 LOCK TABLES `guild_bank_item` WRITE;
1463 /*!40000 ALTER TABLE `guild_bank_item` DISABLE KEYS */;
1464 /*!40000 ALTER TABLE `guild_bank_item` ENABLE KEYS */;
1468 -- Table structure for table `guild_bank_right`
1471 DROP TABLE IF EXISTS `guild_bank_right`;
1472 /*!40101 SET @saved_cs_client = @@character_set_client */;
1473 /*!40101 SET character_set_client = utf8 */;
1474 CREATE TABLE `guild_bank_right` (
1475 `guildid` int(11) unsigned NOT NULL DEFAULT '0',
1476 `TabId` tinyint(1) unsigned NOT NULL DEFAULT '0',
1477 `rid` int(11) unsigned NOT NULL DEFAULT '0',
1478 `gbright` tinyint(3) unsigned NOT NULL DEFAULT '0',
1479 `SlotPerDay` int(11) unsigned NOT NULL DEFAULT '0',
1480 PRIMARY KEY (`guildid`,`TabId`,`rid`),
1481 KEY `guildid_key` (`guildid`)
1482 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1483 /*!40101 SET character_set_client = @saved_cs_client */;
1486 -- Dumping data for table `guild_bank_right`
1489 LOCK TABLES `guild_bank_right` WRITE;
1490 /*!40000 ALTER TABLE `guild_bank_right` DISABLE KEYS */;
1491 /*!40000 ALTER TABLE `guild_bank_right` ENABLE KEYS */;
1495 -- Table structure for table `guild_bank_tab`
1498 DROP TABLE IF EXISTS `guild_bank_tab`;
1499 /*!40101 SET @saved_cs_client = @@character_set_client */;
1500 /*!40101 SET character_set_client = utf8 */;
1501 CREATE TABLE `guild_bank_tab` (
1502 `guildid` int(11) unsigned NOT NULL DEFAULT '0',
1503 `TabId` tinyint(1) unsigned NOT NULL DEFAULT '0',
1504 `TabName` varchar(100) NOT NULL DEFAULT '',
1505 `TabIcon` varchar(100) NOT NULL DEFAULT '',
1507 PRIMARY KEY (`guildid`,`TabId`),
1508 KEY `guildid_key` (`guildid`)
1509 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1510 /*!40101 SET character_set_client = @saved_cs_client */;
1513 -- Dumping data for table `guild_bank_tab`
1516 LOCK TABLES `guild_bank_tab` WRITE;
1517 /*!40000 ALTER TABLE `guild_bank_tab` DISABLE KEYS */;
1518 /*!40000 ALTER TABLE `guild_bank_tab` ENABLE KEYS */;
1522 -- Table structure for table `guild_eventlog`
1525 DROP TABLE IF EXISTS `guild_eventlog`;
1526 /*!40101 SET @saved_cs_client = @@character_set_client */;
1527 /*!40101 SET character_set_client = utf8 */;
1528 CREATE TABLE `guild_eventlog` (
1529 `guildid` int(11) unsigned NOT NULL COMMENT 'Guild Identificator',
1530 `LogGuid` int(11) unsigned NOT NULL COMMENT 'Log record identificator - auxiliary column',
1531 `EventType` tinyint(1) unsigned NOT NULL COMMENT 'Event type',
1532 `PlayerGuid1` int(11) unsigned NOT NULL COMMENT 'Player 1',
1533 `PlayerGuid2` int(11) unsigned NOT NULL COMMENT 'Player 2',
1534 `NewRank` tinyint(2) unsigned NOT NULL COMMENT 'New rank(in case promotion/demotion)',
1535 `TimeStamp` bigint(20) unsigned NOT NULL COMMENT 'Event UNIX time',
1536 PRIMARY KEY (`guildid`,`LogGuid`),
1537 KEY `Idx_PlayerGuid1` (`PlayerGuid1`),
1538 KEY `Idx_PlayerGuid2` (`PlayerGuid2`),
1539 KEY `Idx_LogGuid` (`LogGuid`)
1540 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Guild Eventlog';
1541 /*!40101 SET character_set_client = @saved_cs_client */;
1544 -- Dumping data for table `guild_eventlog`
1547 LOCK TABLES `guild_eventlog` WRITE;
1548 /*!40000 ALTER TABLE `guild_eventlog` DISABLE KEYS */;
1549 /*!40000 ALTER TABLE `guild_eventlog` ENABLE KEYS */;
1553 -- Table structure for table `guild_member`
1556 DROP TABLE IF EXISTS `guild_member`;
1557 /*!40101 SET @saved_cs_client = @@character_set_client */;
1558 /*!40101 SET character_set_client = utf8 */;
1559 CREATE TABLE `guild_member` (
1560 `guildid` int(6) unsigned NOT NULL DEFAULT '0',
1561 `guid` int(11) unsigned NOT NULL DEFAULT '0',
1562 `rank` tinyint(2) unsigned NOT NULL DEFAULT '0',
1563 `pnote` varchar(255) NOT NULL DEFAULT '',
1564 `offnote` varchar(255) NOT NULL DEFAULT '',
1565 `BankResetTimeMoney` int(11) unsigned NOT NULL DEFAULT '0',
1566 `BankRemMoney` int(11) unsigned NOT NULL DEFAULT '0',
1567 `BankResetTimeTab0` int(11) unsigned NOT NULL DEFAULT '0',
1568 `BankRemSlotsTab0` int(11) unsigned NOT NULL DEFAULT '0',
1569 `BankResetTimeTab1` int(11) unsigned NOT NULL DEFAULT '0',
1570 `BankRemSlotsTab1` int(11) unsigned NOT NULL DEFAULT '0',
1571 `BankResetTimeTab2` int(11) unsigned NOT NULL DEFAULT '0',
1572 `BankRemSlotsTab2` int(11) unsigned NOT NULL DEFAULT '0',
1573 `BankResetTimeTab3` int(11) unsigned NOT NULL DEFAULT '0',
1574 `BankRemSlotsTab3` int(11) unsigned NOT NULL DEFAULT '0',
1575 `BankResetTimeTab4` int(11) unsigned NOT NULL DEFAULT '0',
1576 `BankRemSlotsTab4` int(11) unsigned NOT NULL DEFAULT '0',
1577 `BankResetTimeTab5` int(11) unsigned NOT NULL DEFAULT '0',
1578 `BankRemSlotsTab5` int(11) unsigned NOT NULL DEFAULT '0',
1579 UNIQUE KEY `guid_key` (`guid`),
1580 KEY `guildid_key` (`guildid`),
1581 KEY `guildid_rank_key` (`guildid`,`rank`)
1582 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Guild System';
1583 /*!40101 SET character_set_client = @saved_cs_client */;
1586 -- Dumping data for table `guild_member`
1589 LOCK TABLES `guild_member` WRITE;
1590 /*!40000 ALTER TABLE `guild_member` DISABLE KEYS */;
1591 /*!40000 ALTER TABLE `guild_member` ENABLE KEYS */;
1595 -- Table structure for table `guild_rank`
1598 DROP TABLE IF EXISTS `guild_rank`;
1599 /*!40101 SET @saved_cs_client = @@character_set_client */;
1600 /*!40101 SET character_set_client = utf8 */;
1601 CREATE TABLE `guild_rank` (
1602 `guildid` int(6) unsigned NOT NULL DEFAULT '0',
1603 `rid` int(11) unsigned NOT NULL,
1604 `rname` varchar(255) NOT NULL DEFAULT '',
1605 `rights` int(3) unsigned NOT NULL DEFAULT '0',
1606 `BankMoneyPerDay` int(11) unsigned NOT NULL DEFAULT '0',
1607 PRIMARY KEY (`guildid`,`rid`),
1608 KEY `Idx_rid` (`rid`)
1609 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Guild System';
1610 /*!40101 SET character_set_client = @saved_cs_client */;
1613 -- Dumping data for table `guild_rank`
1616 LOCK TABLES `guild_rank` WRITE;
1617 /*!40000 ALTER TABLE `guild_rank` DISABLE KEYS */;
1618 /*!40000 ALTER TABLE `guild_rank` ENABLE KEYS */;
1622 -- Table structure for table `instance`
1625 DROP TABLE IF EXISTS `instance`;
1626 /*!40101 SET @saved_cs_client = @@character_set_client */;
1627 /*!40101 SET character_set_client = utf8 */;
1628 CREATE TABLE `instance` (
1629 `id` int(11) unsigned NOT NULL DEFAULT '0',
1630 `map` int(11) unsigned NOT NULL DEFAULT '0',
1631 `resettime` bigint(40) unsigned NOT NULL DEFAULT '0',
1632 `difficulty` tinyint(1) unsigned NOT NULL DEFAULT '0',
1633 `encountersMask` int(10) unsigned NOT NULL DEFAULT '0',
1637 KEY `resettime` (`resettime`)
1638 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1639 /*!40101 SET character_set_client = @saved_cs_client */;
1642 -- Dumping data for table `instance`
1645 LOCK TABLES `instance` WRITE;
1646 /*!40000 ALTER TABLE `instance` DISABLE KEYS */;
1647 /*!40000 ALTER TABLE `instance` ENABLE KEYS */;
1651 -- Table structure for table `instance_reset`
1654 DROP TABLE IF EXISTS `instance_reset`;
1655 /*!40101 SET @saved_cs_client = @@character_set_client */;
1656 /*!40101 SET character_set_client = utf8 */;
1657 CREATE TABLE `instance_reset` (
1658 `mapid` int(11) unsigned NOT NULL DEFAULT '0',
1659 `difficulty` tinyint(1) unsigned NOT NULL DEFAULT '0',
1660 `resettime` bigint(40) unsigned NOT NULL DEFAULT '0',
1661 PRIMARY KEY (`mapid`,`difficulty`)
1662 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1663 /*!40101 SET character_set_client = @saved_cs_client */;
1666 -- Dumping data for table `instance_reset`
1669 LOCK TABLES `instance_reset` WRITE;
1670 /*!40000 ALTER TABLE `instance_reset` DISABLE KEYS */;
1671 /*!40000 ALTER TABLE `instance_reset` ENABLE KEYS */;
1675 -- Table structure for table `item_instance`
1678 DROP TABLE IF EXISTS `item_instance`;
1679 /*!40101 SET @saved_cs_client = @@character_set_client */;
1680 /*!40101 SET character_set_client = utf8 */;
1681 CREATE TABLE `item_instance` (
1682 `guid` int(11) unsigned NOT NULL DEFAULT '0',
1683 `owner_guid` int(11) unsigned NOT NULL DEFAULT '0',
1686 PRIMARY KEY (`guid`),
1687 KEY `idx_owner_guid` (`owner_guid`)
1688 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Item System';
1689 /*!40101 SET character_set_client = @saved_cs_client */;
1692 -- Dumping data for table `item_instance`
1695 LOCK TABLES `item_instance` WRITE;
1696 /*!40000 ALTER TABLE `item_instance` DISABLE KEYS */;
1697 /*!40000 ALTER TABLE `item_instance` ENABLE KEYS */;
1701 -- Table structure for table `item_loot`
1704 DROP TABLE IF EXISTS `item_loot`;
1705 /*!40101 SET @saved_cs_client = @@character_set_client */;
1706 /*!40101 SET character_set_client = utf8 */;
1707 CREATE TABLE `item_loot` (
1708 `guid` int(11) unsigned NOT NULL DEFAULT '0',
1709 `owner_guid` int(11) unsigned NOT NULL DEFAULT '0',
1710 `itemid` int(11) unsigned NOT NULL DEFAULT '0',
1711 `amount` int(11) unsigned NOT NULL DEFAULT '0',
1712 `suffix` int(11) unsigned NOT NULL DEFAULT '0',
1713 `property` int(11) NOT NULL DEFAULT '0',
1714 PRIMARY KEY (`guid`,`itemid`),
1715 KEY `idx_owner_guid` (`owner_guid`)
1716 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Item System';
1717 /*!40101 SET character_set_client = @saved_cs_client */;
1720 -- Dumping data for table `item_loot`
1723 LOCK TABLES `item_loot` WRITE;
1724 /*!40000 ALTER TABLE `item_loot` DISABLE KEYS */;
1725 /*!40000 ALTER TABLE `item_loot` ENABLE KEYS */;
1729 -- Table structure for table `mail`
1732 DROP TABLE IF EXISTS `mail`;
1733 /*!40101 SET @saved_cs_client = @@character_set_client */;
1734 /*!40101 SET character_set_client = utf8 */;
1735 CREATE TABLE `mail` (
1736 `id` int(11) unsigned NOT NULL DEFAULT '0' COMMENT 'Identifier',
1737 `messageType` tinyint(3) unsigned NOT NULL DEFAULT '0',
1738 `stationery` tinyint(3) NOT NULL DEFAULT '41',
1739 `mailTemplateId` mediumint(8) unsigned NOT NULL DEFAULT '0',
1740 `sender` int(11) unsigned NOT NULL DEFAULT '0' COMMENT 'Character Global Unique Identifier',
1741 `receiver` int(11) unsigned NOT NULL DEFAULT '0' COMMENT 'Character Global Unique Identifier',
1744 `has_items` tinyint(3) unsigned NOT NULL DEFAULT '0',
1745 `expire_time` bigint(40) unsigned NOT NULL DEFAULT '0',
1746 `deliver_time` bigint(40) unsigned NOT NULL DEFAULT '0',
1747 `money` bigint(40) unsigned NOT NULL DEFAULT '0',
1748 `cod` bigint(40) unsigned NOT NULL DEFAULT '0',
1749 `checked` tinyint(3) unsigned NOT NULL DEFAULT '0',
1751 KEY `idx_receiver` (`receiver`)
1752 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Mail System';
1753 /*!40101 SET character_set_client = @saved_cs_client */;
1756 -- Dumping data for table `mail`
1759 LOCK TABLES `mail` WRITE;
1760 /*!40000 ALTER TABLE `mail` DISABLE KEYS */;
1761 /*!40000 ALTER TABLE `mail` ENABLE KEYS */;
1765 -- Table structure for table `mail_items`
1768 DROP TABLE IF EXISTS `mail_items`;
1769 /*!40101 SET @saved_cs_client = @@character_set_client */;
1770 /*!40101 SET character_set_client = utf8 */;
1771 CREATE TABLE `mail_items` (
1772 `mail_id` int(11) NOT NULL DEFAULT '0',
1773 `item_guid` int(11) NOT NULL DEFAULT '0',
1774 `item_template` int(11) NOT NULL DEFAULT '0',
1775 `receiver` int(11) unsigned NOT NULL DEFAULT '0' COMMENT 'Character Global Unique Identifier',
1776 PRIMARY KEY (`mail_id`,`item_guid`),
1777 KEY `idx_receiver` (`receiver`)
1778 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;
1779 /*!40101 SET character_set_client = @saved_cs_client */;
1782 -- Dumping data for table `mail_items`
1785 LOCK TABLES `mail_items` WRITE;
1786 /*!40000 ALTER TABLE `mail_items` DISABLE KEYS */;
1787 /*!40000 ALTER TABLE `mail_items` ENABLE KEYS */;
1791 -- Table structure for table `pet_aura`
1794 DROP TABLE IF EXISTS `pet_aura`;
1795 /*!40101 SET @saved_cs_client = @@character_set_client */;
1796 /*!40101 SET character_set_client = utf8 */;
1797 CREATE TABLE `pet_aura` (
1798 `guid` int(11) unsigned NOT NULL DEFAULT '0' COMMENT 'Global Unique Identifier',
1799 `caster_guid` bigint(20) unsigned NOT NULL DEFAULT '0' COMMENT 'Full Global Unique Identifier',
1800 `item_guid` int(11) unsigned NOT NULL DEFAULT '0',
1801 `spell` int(11) unsigned NOT NULL DEFAULT '0',
1802 `stackcount` int(11) unsigned NOT NULL DEFAULT '1',
1803 `remaincharges` int(11) unsigned NOT NULL DEFAULT '0',
1804 `basepoints0` int(11) NOT NULL DEFAULT '0',
1805 `basepoints1` int(11) NOT NULL DEFAULT '0',
1806 `basepoints2` int(11) NOT NULL DEFAULT '0',
1807 `periodictime0` int(11) unsigned NOT NULL DEFAULT '0',
1808 `periodictime1` int(11) unsigned NOT NULL DEFAULT '0',
1809 `periodictime2` int(11) unsigned NOT NULL DEFAULT '0',
1810 `maxduration` int(11) NOT NULL DEFAULT '0',
1811 `remaintime` int(11) NOT NULL DEFAULT '0',
1812 `effIndexMask` int(11) unsigned NOT NULL DEFAULT '0',
1813 PRIMARY KEY (`guid`,`caster_guid`,`item_guid`,`spell`)
1814 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Pet System';
1815 /*!40101 SET character_set_client = @saved_cs_client */;
1818 -- Dumping data for table `pet_aura`
1821 LOCK TABLES `pet_aura` WRITE;
1822 /*!40000 ALTER TABLE `pet_aura` DISABLE KEYS */;
1823 /*!40000 ALTER TABLE `pet_aura` ENABLE KEYS */;
1827 -- Table structure for table `pet_spell`
1830 DROP TABLE IF EXISTS `pet_spell`;
1831 /*!40101 SET @saved_cs_client = @@character_set_client */;
1832 /*!40101 SET character_set_client = utf8 */;
1833 CREATE TABLE `pet_spell` (
1834 `guid` int(11) unsigned NOT NULL DEFAULT '0' COMMENT 'Global Unique Identifier',
1835 `spell` int(11) unsigned NOT NULL DEFAULT '0' COMMENT 'Spell Identifier',
1836 `active` int(11) unsigned NOT NULL DEFAULT '0',
1837 PRIMARY KEY (`guid`,`spell`)
1838 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Pet System';
1839 /*!40101 SET character_set_client = @saved_cs_client */;
1842 -- Dumping data for table `pet_spell`
1845 LOCK TABLES `pet_spell` WRITE;
1846 /*!40000 ALTER TABLE `pet_spell` DISABLE KEYS */;
1847 /*!40000 ALTER TABLE `pet_spell` ENABLE KEYS */;
1851 -- Table structure for table `pet_spell_cooldown`
1854 DROP TABLE IF EXISTS `pet_spell_cooldown`;
1855 /*!40101 SET @saved_cs_client = @@character_set_client */;
1856 /*!40101 SET character_set_client = utf8 */;
1857 CREATE TABLE `pet_spell_cooldown` (
1858 `guid` int(11) unsigned NOT NULL DEFAULT '0' COMMENT 'Global Unique Identifier, Low part',
1859 `spell` int(11) unsigned NOT NULL DEFAULT '0' COMMENT 'Spell Identifier',
1860 `time` bigint(20) unsigned NOT NULL DEFAULT '0',
1861 PRIMARY KEY (`guid`,`spell`)
1862 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1863 /*!40101 SET character_set_client = @saved_cs_client */;
1866 -- Dumping data for table `pet_spell_cooldown`
1869 LOCK TABLES `pet_spell_cooldown` WRITE;
1870 /*!40000 ALTER TABLE `pet_spell_cooldown` DISABLE KEYS */;
1871 /*!40000 ALTER TABLE `pet_spell_cooldown` ENABLE KEYS */;
1875 -- Table structure for table `petition`
1878 DROP TABLE IF EXISTS `petition`;
1879 /*!40101 SET @saved_cs_client = @@character_set_client */;
1880 /*!40101 SET character_set_client = utf8 */;
1881 CREATE TABLE `petition` (
1882 `ownerguid` int(10) unsigned NOT NULL,
1883 `petitionguid` int(10) unsigned DEFAULT '0',
1884 `name` varchar(255) NOT NULL DEFAULT '',
1885 PRIMARY KEY (`ownerguid`),
1886 UNIQUE KEY `index_ownerguid_petitionguid` (`ownerguid`,`petitionguid`)
1887 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Guild System';
1888 /*!40101 SET character_set_client = @saved_cs_client */;
1891 -- Dumping data for table `petition`
1894 LOCK TABLES `petition` WRITE;
1895 /*!40000 ALTER TABLE `petition` DISABLE KEYS */;
1896 /*!40000 ALTER TABLE `petition` ENABLE KEYS */;
1900 -- Table structure for table `petition_sign`
1903 DROP TABLE IF EXISTS `petition_sign`;
1904 /*!40101 SET @saved_cs_client = @@character_set_client */;
1905 /*!40101 SET character_set_client = utf8 */;
1906 CREATE TABLE `petition_sign` (
1907 `ownerguid` int(10) unsigned NOT NULL,
1908 `petitionguid` int(11) unsigned NOT NULL DEFAULT '0',
1909 `playerguid` int(11) unsigned NOT NULL DEFAULT '0',
1910 `player_account` int(11) unsigned NOT NULL DEFAULT '0',
1911 PRIMARY KEY (`petitionguid`,`playerguid`),
1912 KEY `Idx_playerguid` (`playerguid`),
1913 KEY `Idx_ownerguid` (`ownerguid`)
1914 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Guild System';
1915 /*!40101 SET character_set_client = @saved_cs_client */;
1918 -- Dumping data for table `petition_sign`
1921 LOCK TABLES `petition_sign` WRITE;
1922 /*!40000 ALTER TABLE `petition_sign` DISABLE KEYS */;
1923 /*!40000 ALTER TABLE `petition_sign` ENABLE KEYS */;
1927 -- Table structure for table `saved_variables`
1930 DROP TABLE IF EXISTS `saved_variables`;
1931 /*!40101 SET @saved_cs_client = @@character_set_client */;
1932 /*!40101 SET character_set_client = utf8 */;
1933 CREATE TABLE `saved_variables` (
1934 `NextCurrenciesResetTime` bigint(40) unsigned NOT NULL DEFAULT '0',
1935 `NextDailyQuestResetTime` bigint(40) unsigned NOT NULL DEFAULT '0',
1936 `NextWeeklyQuestResetTime` bigint(40) unsigned NOT NULL DEFAULT '0',
1937 `NextMonthlyQuestResetTime` bigint(40) unsigned NOT NULL DEFAULT '0',
1938 `cleaning_flags` int(11) unsigned NOT NULL DEFAULT '0'
1939 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Variable Saves';
1940 /*!40101 SET character_set_client = @saved_cs_client */;
1943 -- Dumping data for table `saved_variables`
1946 LOCK TABLES `saved_variables` WRITE;
1947 /*!40000 ALTER TABLE `saved_variables` DISABLE KEYS */;
1948 /*!40000 ALTER TABLE `saved_variables` ENABLE KEYS */;
1952 -- Table structure for table `world`
1955 DROP TABLE IF EXISTS `world`;
1956 /*!40101 SET @saved_cs_client = @@character_set_client */;
1957 /*!40101 SET character_set_client = utf8 */;
1958 CREATE TABLE `world` (
1959 `map` int(11) unsigned NOT NULL DEFAULT '0',
1962 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1963 /*!40101 SET character_set_client = @saved_cs_client */;
1966 -- Dumping data for table `world`
1969 LOCK TABLES `world` WRITE;
1970 /*!40000 ALTER TABLE `world` DISABLE KEYS */;
1971 /*!40000 ALTER TABLE `world` ENABLE KEYS */;
1973 /*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
1975 /*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
1976 /*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
1977 /*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
1978 /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
1979 /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
1980 /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
1981 /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;