3 -- Host: localhost Database: characters
4 -- ------------------------------------------------------
5 -- Server version 5.0.45-Debian_1ubuntu3.1-log
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 */;
19 -- Table structure for table `character_db_version`
22 DROP TABLE IF EXISTS `character_db_version`;
23 CREATE TABLE `character_db_version` (
24 `required_9849_01_characters_saved_variables` bit(1) default NULL
25 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Last applied sql update to DB';
28 -- Dumping data for table `character_db_version`
31 LOCK TABLES `character_db_version` WRITE;
32 /*!40000 ALTER TABLE `character_db_version` DISABLE KEYS */;
33 INSERT INTO `character_db_version` VALUES
35 /*!40000 ALTER TABLE `character_db_version` ENABLE KEYS */;
39 -- Table structure for table `account_data`
42 DROP TABLE IF EXISTS `account_data`;
43 CREATE TABLE `account_data` (
44 `account` int(11) unsigned NOT NULL default '0',
45 `type` int(11) unsigned NOT NULL default '0',
46 `time` bigint(11) unsigned NOT NULL default '0',
47 `data` longblob NOT NULL,
48 PRIMARY KEY (`account`,`type`)
49 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
52 -- Dumping data for table `account_data`
55 LOCK TABLES `account_data` WRITE;
56 /*!40000 ALTER TABLE `account_data` DISABLE KEYS */;
57 /*!40000 ALTER TABLE `account_data` ENABLE KEYS */;
61 -- Table structure for table `arena_team`
64 DROP TABLE IF EXISTS `arena_team`;
65 CREATE TABLE `arena_team` (
66 `arenateamid` int(10) unsigned NOT NULL default '0',
67 `name` char(255) NOT NULL,
68 `captainguid` int(10) unsigned NOT NULL default '0',
69 `type` tinyint(3) unsigned NOT NULL default '0',
70 `BackgroundColor` int(10) unsigned NOT NULL default '0',
71 `EmblemStyle` int(10) unsigned NOT NULL default '0',
72 `EmblemColor` int(10) unsigned NOT NULL default '0',
73 `BorderStyle` int(10) unsigned NOT NULL default '0',
74 `BorderColor` int(10) unsigned NOT NULL default '0',
75 PRIMARY KEY (`arenateamid`)
76 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
79 -- Dumping data for table `arena_team`
82 LOCK TABLES `arena_team` WRITE;
83 /*!40000 ALTER TABLE `arena_team` DISABLE KEYS */;
84 /*!40000 ALTER TABLE `arena_team` ENABLE KEYS */;
88 -- Table structure for table `arena_team_member`
91 DROP TABLE IF EXISTS `arena_team_member`;
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;
104 -- Dumping data for table `arena_team_member`
107 LOCK TABLES `arena_team_member` WRITE;
108 /*!40000 ALTER TABLE `arena_team_member` DISABLE KEYS */;
109 /*!40000 ALTER TABLE `arena_team_member` ENABLE KEYS */;
113 -- Table structure for table `arena_team_stats`
116 DROP TABLE IF EXISTS `arena_team_stats`;
117 CREATE TABLE `arena_team_stats` (
118 `arenateamid` int(10) unsigned NOT NULL default '0',
119 `rating` int(10) unsigned NOT NULL default '0',
120 `games` int(10) unsigned NOT NULL default '0',
121 `wins` int(10) unsigned NOT NULL default '0',
122 `played` int(10) unsigned NOT NULL default '0',
123 `wins2` int(10) unsigned NOT NULL default '0',
124 `rank` int(10) unsigned NOT NULL default '0',
125 PRIMARY KEY (`arenateamid`)
126 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
129 -- Dumping data for table `arena_team_stats`
132 LOCK TABLES `arena_team_stats` WRITE;
133 /*!40000 ALTER TABLE `arena_team_stats` DISABLE KEYS */;
134 /*!40000 ALTER TABLE `arena_team_stats` ENABLE KEYS */;
138 -- Table structure for table `auctionhouse`
141 DROP TABLE IF EXISTS `auctionhouse`;
142 CREATE TABLE `auctionhouse` (
143 `id` int(11) unsigned NOT NULL default '0',
144 `auctioneerguid` int(11) unsigned NOT NULL default '0',
145 `itemguid` int(11) unsigned NOT NULL default '0',
146 `item_template` int(11) unsigned NOT NULL default '0' COMMENT 'Item Identifier',
147 `itemowner` int(11) unsigned NOT NULL default '0',
148 `buyoutprice` int(11) NOT NULL default '0',
149 `time` bigint(40) NOT NULL default '0',
150 `buyguid` int(11) unsigned NOT NULL default '0',
151 `lastbid` int(11) NOT NULL default '0',
152 `startbid` int(11) NOT NULL default '0',
153 `deposit` int(11) NOT NULL default '0',
155 UNIQUE KEY `item_guid` (`itemguid`)
156 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
159 -- Dumping data for table `auctionhouse`
162 LOCK TABLES `auctionhouse` WRITE;
163 /*!40000 ALTER TABLE `auctionhouse` DISABLE KEYS */;
164 /*!40000 ALTER TABLE `auctionhouse` ENABLE KEYS */;
168 -- Table structure for table `bugreport`
171 DROP TABLE IF EXISTS `bugreport`;
172 CREATE TABLE `bugreport` (
173 `id` int(11) NOT NULL auto_increment COMMENT 'Identifier',
174 `type` longtext NOT NULL default '',
175 `content` longtext NOT NULL default '',
177 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Debug System';
180 -- Dumping data for table `bugreport`
183 LOCK TABLES `bugreport` WRITE;
184 /*!40000 ALTER TABLE `bugreport` DISABLE KEYS */;
185 /*!40000 ALTER TABLE `bugreport` ENABLE KEYS */;
189 -- Table structure for table `characters`
192 DROP TABLE IF EXISTS `characters`;
193 CREATE TABLE `characters` (
194 `guid` int(11) unsigned NOT NULL default '0' COMMENT 'Global Unique Identifier',
195 `account` int(11) unsigned NOT NULL default '0' COMMENT 'Account Identifier',
196 `name` varchar(12) NOT NULL default '',
197 `race` tinyint(3) unsigned NOT NULL default '0',
198 `class` tinyint(3) unsigned NOT NULL default '0',
199 `gender` TINYINT UNSIGNED NOT NULL default '0',
200 `level` TINYINT UNSIGNED NOT NULL default '0',
201 `xp` INT UNSIGNED NOT NULL default '0',
202 `money` INT UNSIGNED NOT NULL default '0',
203 `playerBytes` INT UNSIGNED NOT NULL default '0',
204 `playerBytes2` INT UNSIGNED NOT NULL default '0',
205 `playerFlags` INT UNSIGNED NOT NULL default '0',
206 `position_x` float NOT NULL default '0',
207 `position_y` float NOT NULL default '0',
208 `position_z` float NOT NULL default '0',
209 `map` int(11) unsigned NOT NULL default '0' COMMENT 'Map Identifier',
210 `dungeon_difficulty` tinyint(1) unsigned NOT NULL DEFAULT '0',
211 `orientation` float NOT NULL default '0',
213 `online` tinyint(3) unsigned NOT NULL default '0',
214 `cinematic` tinyint(3) unsigned NOT NULL default '0',
215 `totaltime` int(11) unsigned NOT NULL default '0',
216 `leveltime` int(11) unsigned NOT NULL default '0',
217 `logout_time` bigint(20) unsigned NOT NULL default '0',
218 `is_logout_resting` tinyint(3) unsigned NOT NULL default '0',
219 `rest_bonus` float NOT NULL default '0',
220 `resettalents_cost` int(11) unsigned NOT NULL default '0',
221 `resettalents_time` bigint(20) unsigned NOT NULL default '0',
222 `trans_x` float NOT NULL default '0',
223 `trans_y` float NOT NULL default '0',
224 `trans_z` float NOT NULL default '0',
225 `trans_o` float NOT NULL default '0',
226 `transguid` bigint(20) unsigned NOT NULL default '0',
227 `extra_flags` int(11) unsigned NOT NULL default '0',
228 `stable_slots` tinyint(1) unsigned NOT NULL default '0',
229 `at_login` int(11) unsigned NOT NULL default '0',
230 `zone` int(11) unsigned NOT NULL default '0',
231 `death_expire_time` bigint(20) unsigned NOT NULL default '0',
233 `arenaPoints` int(10) UNSIGNED NOT NULL default '0',
234 `totalHonorPoints` int(10) UNSIGNED NOT NULL default '0',
235 `todayHonorPoints` int(10) UNSIGNED NOT NULL default '0',
236 `yesterdayHonorPoints` int(10) UNSIGNED NOT NULL default '0',
237 `totalKills` int(10) UNSIGNED NOT NULL default '0',
238 `todayKills` smallint(5) UNSIGNED NOT NULL default '0',
239 `yesterdayKills` smallint(5) UNSIGNED NOT NULL default '0',
240 `chosenTitle` int(10) UNSIGNED NOT NULL default '0',
241 `knownCurrencies` bigint(20) UNSIGNED NOT NULL default '0',
242 `watchedFaction` int(10) UNSIGNED NOT NULL default '0',
243 `drunk` smallint(5) UNSIGNED NOT NULL default '0',
244 `health` int(10) UNSIGNED NOT NULL default '0',
245 `power1` int(10) UNSIGNED NOT NULL default '0',
246 `power2` int(10) UNSIGNED NOT NULL default '0',
247 `power3` int(10) UNSIGNED NOT NULL default '0',
248 `power4` int(10) UNSIGNED NOT NULL default '0',
249 `power5` int(10) UNSIGNED NOT NULL default '0',
250 `power6` int(10) UNSIGNED NOT NULL default '0',
251 `power7` int(10) UNSIGNED NOT NULL default '0',
252 `specCount` tinyint(3) UNSIGNED NOT NULL default '1',
253 `activeSpec` tinyint(3) UNSIGNED NOT NULL default '0',
254 `exploredZones` longtext,
255 `equipmentCache` longtext,
256 `ammoId` int(10) UNSIGNED NOT NULL default '0',
257 `knownTitles` longtext,
258 `actionBars` tinyint(3) UNSIGNED NOT NULL default '0',
259 `deleteInfos_Account` int(11) UNSIGNED default NULL,
260 `deleteInfos_Name` varchar(12) default NULL,
261 `deleteDate` bigint(20) default NULL,
262 PRIMARY KEY (`guid`),
263 KEY `idx_account` (`account`),
264 KEY `idx_online` (`online`),
265 KEY `idx_name` (`name`)
266 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Player System';
269 -- Dumping data for table `characters`
272 LOCK TABLES `characters` WRITE;
273 /*!40000 ALTER TABLE `characters` DISABLE KEYS */;
274 /*!40000 ALTER TABLE `characters` ENABLE KEYS */;
278 -- Table structure for table `character_account_data`
281 DROP TABLE IF EXISTS `character_account_data`;
282 CREATE TABLE `character_account_data` (
283 `guid` int(11) unsigned NOT NULL default '0',
284 `type` int(11) unsigned NOT NULL default '0',
285 `time` bigint(11) unsigned NOT NULL default '0',
286 `data` longblob NOT NULL,
287 PRIMARY KEY (`guid`,`type`)
288 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
291 -- Dumping data for table `character_account_data`
294 LOCK TABLES `character_account_data` WRITE;
295 /*!40000 ALTER TABLE `character_account_data` DISABLE KEYS */;
296 /*!40000 ALTER TABLE `character_account_data` ENABLE KEYS */;
300 -- Table structure for table `character_achievement`
303 DROP TABLE IF EXISTS `character_achievement`;
304 CREATE TABLE `character_achievement` (
305 `guid` int(11) unsigned NOT NULL,
306 `achievement` int(11) unsigned NOT NULL,
307 `date` bigint(11) unsigned NOT NULL default '0',
308 PRIMARY KEY (`guid`,`achievement`)
309 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
312 -- Dumping data for table `character_achievement`
315 LOCK TABLES `character_achievement` WRITE;
316 /*!40000 ALTER TABLE `character_achievement` DISABLE KEYS */;
317 /*!40000 ALTER TABLE `character_achievement` ENABLE KEYS */;
321 -- Table structure for table `character_achievement_progress`
324 DROP TABLE IF EXISTS `character_achievement_progress`;
325 CREATE TABLE `character_achievement_progress` (
326 `guid` int(11) unsigned NOT NULL,
327 `criteria` int(11) unsigned NOT NULL,
328 `counter` int(11) unsigned NOT NULL,
329 `date` bigint(11) unsigned NOT NULL default '0',
330 PRIMARY KEY (`guid`,`criteria`)
331 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
334 -- Dumping data for table `character_achievement_progress`
337 LOCK TABLES `character_achievement_progress` WRITE;
338 /*!40000 ALTER TABLE `character_achievement_progress` DISABLE KEYS */;
339 /*!40000 ALTER TABLE `character_achievement_progress` ENABLE KEYS */;
343 -- Table structure for table `character_action`
346 DROP TABLE IF EXISTS `character_action`;
347 CREATE TABLE `character_action` (
348 `guid` int(11) unsigned NOT NULL default '0' COMMENT 'Global Unique Identifier',
349 `spec` tinyint(3) unsigned NOT NULL default '0',
350 `button` tinyint(3) unsigned NOT NULL default '0',
351 `action` int(11) unsigned NOT NULL default '0',
352 `type` tinyint(3) unsigned NOT NULL default '0',
353 PRIMARY KEY (`guid`,`spec`,`button`)
354 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Player System';
357 -- Dumping data for table `character_action`
360 LOCK TABLES `character_action` WRITE;
361 /*!40000 ALTER TABLE `character_action` DISABLE KEYS */;
362 /*!40000 ALTER TABLE `character_action` ENABLE KEYS */;
366 -- Table structure for table `character_aura`
369 DROP TABLE IF EXISTS `character_aura`;
370 CREATE TABLE `character_aura` (
371 `guid` int(11) unsigned NOT NULL default '0' COMMENT 'Global Unique Identifier',
372 `caster_guid` bigint(20) unsigned NOT NULL default '0' COMMENT 'Full Global Unique Identifier',
373 `spell` int(11) unsigned NOT NULL default '0',
374 `effect_index` int(11) unsigned NOT NULL default '0',
375 `stackcount` int(11) NOT NULL default '1',
376 `amount` int(11) NOT NULL default '0',
377 `maxduration` int(11) NOT NULL default '0',
378 `remaintime` int(11) NOT NULL default '0',
379 `remaincharges` int(11) NOT NULL default '0',
380 PRIMARY KEY (`guid`,`spell`,`effect_index`)
381 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Player System';
384 -- Dumping data for table `character_aura`
387 LOCK TABLES `character_aura` WRITE;
388 /*!40000 ALTER TABLE `character_aura` DISABLE KEYS */;
389 /*!40000 ALTER TABLE `character_aura` ENABLE KEYS */;
393 -- Table structure for table `character_battleground_data`
396 DROP TABLE IF EXISTS `character_battleground_data`;
397 CREATE TABLE `character_battleground_data` (
398 `guid` int(11) unsigned NOT NULL default '0' COMMENT 'Global Unique Identifier',
399 `instance_id` int(11) unsigned NOT NULL default '0',
400 `team` int(11) unsigned NOT NULL default '0',
401 `join_x` float NOT NULL default '0',
402 `join_y` float NOT NULL default '0',
403 `join_z` float NOT NULL default '0',
404 `join_o` float NOT NULL default '0',
405 `join_map` int(11) NOT NULL default '0',
406 `taxi_start` int(11) NOT NULL default '0',
407 `taxi_end` int(11) NOT NULL default '0',
408 `mount_spell` int(11) NOT NULL default '0',
410 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Player System';
413 -- Dumping data for table `character_battleground_data`
416 LOCK TABLES `character_battleground_data` WRITE;
417 /*!40000 ALTER TABLE `character_battleground_data` DISABLE KEYS */;
418 /*!40000 ALTER TABLE `character_battleground_data` ENABLE KEYS */;
422 -- Table structure for table `character_declinedname`
425 DROP TABLE IF EXISTS `character_declinedname`;
426 CREATE TABLE `character_declinedname` (
427 `guid` int(11) unsigned NOT NULL default '0' COMMENT 'Global Unique Identifier',
428 `genitive` varchar(15) NOT NULL default '',
429 `dative` varchar(15) NOT NULL default '',
430 `accusative` varchar(15) NOT NULL default '',
431 `instrumental` varchar(15) NOT NULL default '',
432 `prepositional` varchar(15) NOT NULL default '',
434 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;
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 CREATE TABLE `character_equipmentsets` (
451 `guid` int(11) NOT NULL default '0',
452 `setguid` bigint(20) NOT NULL auto_increment,
453 `setindex` tinyint(4) NOT NULL default '0',
454 `name` varchar(100) NOT NULL,
455 `iconname` varchar(100) NOT NULL,
456 `item0` int(11) NOT NULL default '0',
457 `item1` int(11) NOT NULL default '0',
458 `item2` int(11) NOT NULL default '0',
459 `item3` int(11) NOT NULL default '0',
460 `item4` int(11) NOT NULL default '0',
461 `item5` int(11) NOT NULL default '0',
462 `item6` int(11) NOT NULL default '0',
463 `item7` int(11) NOT NULL default '0',
464 `item8` int(11) NOT NULL default '0',
465 `item9` int(11) NOT NULL default '0',
466 `item10` int(11) NOT NULL default '0',
467 `item11` int(11) NOT NULL default '0',
468 `item12` int(11) NOT NULL default '0',
469 `item13` int(11) NOT NULL default '0',
470 `item14` int(11) NOT NULL default '0',
471 `item15` int(11) NOT NULL default '0',
472 `item16` int(11) NOT NULL default '0',
473 `item17` int(11) NOT NULL default '0',
474 `item18` int(11) NOT NULL default '0',
475 PRIMARY KEY (`setguid`),
476 UNIQUE KEY `idx_set` (`guid`,`setguid`,`setindex`),
477 INDEX `Idx_setindex` (`setindex`)
478 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
481 -- Dumping data for table `character_equipmentsets`
484 LOCK TABLES `character_equipmentsets` WRITE;
485 /*!40000 ALTER TABLE `character_equipmentsets` DISABLE KEYS */;
486 /*!40000 ALTER TABLE `character_equipmentsets` ENABLE KEYS */;
490 -- Table structure for table `character_gifts`
493 DROP TABLE IF EXISTS `character_gifts`;
494 CREATE TABLE `character_gifts` (
495 `guid` int(20) unsigned NOT NULL default '0',
496 `item_guid` int(11) unsigned NOT NULL default '0',
497 `entry` int(20) unsigned NOT NULL default '0',
498 `flags` int(20) unsigned NOT NULL default '0',
499 PRIMARY KEY (`item_guid`),
500 KEY `idx_guid` (`guid`)
501 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
504 -- Dumping data for table `character_gifts`
507 LOCK TABLES `character_gifts` WRITE;
508 /*!40000 ALTER TABLE `character_gifts` DISABLE KEYS */;
509 /*!40000 ALTER TABLE `character_gifts` ENABLE KEYS */;
513 -- Table structure for table `character_glyphs`
516 DROP TABLE IF EXISTS `character_glyphs`;
517 CREATE TABLE `character_glyphs` (
518 `guid` int(11) unsigned NOT NULL,
519 `spec` tinyint(3) unsigned NOT NULL DEFAULT '0',
520 `slot` tinyint(3) unsigned NOT NULL DEFAULT '0',
521 `glyph` int(11) unsigned NOT NULL DEFAULT '0',
522 PRIMARY KEY (`guid`,`spec`,`slot`)
523 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
526 -- Dumping data for table `character_glyphs`
529 LOCK TABLES `character_glyphs` WRITE;
530 /*!40000 ALTER TABLE `character_glyphs` DISABLE KEYS */;
531 /*!40000 ALTER TABLE `character_glyphs` ENABLE KEYS */;
535 -- Table structure for table `character_homebind`
538 DROP TABLE IF EXISTS `character_homebind`;
539 CREATE TABLE `character_homebind` (
540 `guid` int(11) unsigned NOT NULL default '0' COMMENT 'Global Unique Identifier',
541 `map` int(11) unsigned NOT NULL default '0' COMMENT 'Map Identifier',
542 `zone` int(11) unsigned NOT NULL default '0' COMMENT 'Zone Identifier',
543 `position_x` float NOT NULL default '0',
544 `position_y` float NOT NULL default '0',
545 `position_z` float NOT NULL default '0',
547 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Player System';
550 -- Dumping data for table `character_homebind`
553 LOCK TABLES `character_homebind` WRITE;
554 /*!40000 ALTER TABLE `character_homebind` DISABLE KEYS */;
555 /*!40000 ALTER TABLE `character_homebind` ENABLE KEYS */;
559 -- Table structure for table `character_instance`
562 DROP TABLE IF EXISTS `character_instance`;
563 CREATE TABLE `character_instance` (
564 `guid` int(11) unsigned NOT NULL default '0',
565 `instance` int(11) unsigned NOT NULL default '0',
566 `permanent` tinyint(1) unsigned NOT NULL default '0',
567 PRIMARY KEY (`guid`,`instance`),
568 KEY `instance` (`instance`)
569 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
572 -- Dumping data for table `character_instance`
575 LOCK TABLES `character_instance` WRITE;
576 /*!40000 ALTER TABLE `character_instance` DISABLE KEYS */;
577 /*!40000 ALTER TABLE `character_instance` ENABLE KEYS */;
581 -- Table structure for table `character_inventory`
584 DROP TABLE IF EXISTS `character_inventory`;
585 CREATE TABLE `character_inventory` (
586 `guid` int(11) unsigned NOT NULL default '0' COMMENT 'Global Unique Identifier',
587 `bag` int(11) unsigned NOT NULL default '0',
588 `slot` tinyint(3) unsigned NOT NULL default '0',
589 `item` int(11) unsigned NOT NULL default '0' COMMENT 'Item Global Unique Identifier',
590 `item_template` int(11) unsigned NOT NULL default '0' COMMENT 'Item Identifier',
591 PRIMARY KEY (`item`),
592 KEY `idx_guid` (`guid`)
593 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Player System';
596 -- Dumping data for table `character_inventory`
599 LOCK TABLES `character_inventory` WRITE;
600 /*!40000 ALTER TABLE `character_inventory` DISABLE KEYS */;
601 /*!40000 ALTER TABLE `character_inventory` ENABLE KEYS */;
605 -- Table structure for table `character_pet`
608 DROP TABLE IF EXISTS `character_pet`;
609 CREATE TABLE `character_pet` (
610 `id` int(11) unsigned NOT NULL default '0',
611 `entry` int(11) unsigned NOT NULL default '0',
612 `owner` int(11) unsigned NOT NULL default '0',
613 `modelid` int(11) unsigned default '0',
614 `CreatedBySpell` int(11) unsigned NOT NULL default '0',
615 `PetType` tinyint(3) unsigned NOT NULL default '0',
616 `level` int(11) unsigned NOT NULL default '1',
617 `exp` int(11) unsigned NOT NULL default '0',
618 `Reactstate` tinyint(1) unsigned NOT NULL default '0',
619 `name` varchar(100) default 'Pet',
620 `renamed` tinyint(1) unsigned NOT NULL default '0',
621 `slot` int(11) unsigned NOT NULL default '0',
622 `curhealth` int(11) unsigned NOT NULL default '1',
623 `curmana` int(11) unsigned NOT NULL default '0',
624 `curhappiness` int(11) unsigned NOT NULL default '0',
625 `savetime` bigint(20) unsigned NOT NULL default '0',
626 `resettalents_cost` int(11) unsigned NOT NULL default '0',
627 `resettalents_time` bigint(20) unsigned NOT NULL default '0',
630 KEY `owner` (`owner`)
631 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Pet System';
634 -- Dumping data for table `character_pet`
637 LOCK TABLES `character_pet` WRITE;
638 /*!40000 ALTER TABLE `character_pet` DISABLE KEYS */;
639 /*!40000 ALTER TABLE `character_pet` ENABLE KEYS */;
643 -- Table structure for table `character_pet_declinedname`
646 DROP TABLE IF EXISTS `character_pet_declinedname`;
647 CREATE TABLE `character_pet_declinedname` (
648 `id` int(11) unsigned NOT NULL default '0',
649 `owner` int(11) unsigned NOT NULL default '0',
650 `genitive` varchar(12) NOT NULL default '',
651 `dative` varchar(12) NOT NULL default '',
652 `accusative` varchar(12) NOT NULL default '',
653 `instrumental` varchar(12) NOT NULL default '',
654 `prepositional` varchar(12) NOT NULL default '',
656 KEY owner_key (`owner`)
657 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;
660 -- Dumping data for table `character_pet_declinedname`
663 LOCK TABLES `character_pet_declinedname` WRITE;
664 /*!40000 ALTER TABLE `character_pet_declinedname` DISABLE KEYS */;
665 /*!40000 ALTER TABLE `character_pet_declinedname` ENABLE KEYS */;
669 -- Table structure for table `character_queststatus`
672 DROP TABLE IF EXISTS `character_queststatus`;
673 CREATE TABLE `character_queststatus` (
674 `guid` int(11) unsigned NOT NULL default '0' COMMENT 'Global Unique Identifier',
675 `quest` int(11) unsigned NOT NULL default '0' COMMENT 'Quest Identifier',
676 `status` int(11) unsigned NOT NULL default '0',
677 `rewarded` tinyint(1) unsigned NOT NULL default '0',
678 `explored` tinyint(1) unsigned NOT NULL default '0',
679 `timer` bigint(20) unsigned NOT NULL default '0',
680 `mobcount1` int(11) unsigned NOT NULL default '0',
681 `mobcount2` int(11) unsigned NOT NULL default '0',
682 `mobcount3` int(11) unsigned NOT NULL default '0',
683 `mobcount4` int(11) unsigned NOT NULL default '0',
684 `itemcount1` int(11) unsigned NOT NULL default '0',
685 `itemcount2` int(11) unsigned NOT NULL default '0',
686 `itemcount3` int(11) unsigned NOT NULL default '0',
687 `itemcount4` int(11) unsigned NOT NULL default '0',
688 PRIMARY KEY (`guid`,`quest`)
689 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Player System';
692 -- Dumping data for table `character_queststatus`
695 LOCK TABLES `character_queststatus` WRITE;
696 /*!40000 ALTER TABLE `character_queststatus` DISABLE KEYS */;
697 /*!40000 ALTER TABLE `character_queststatus` ENABLE KEYS */;
701 -- Table structure for table `character_queststatus_daily`
704 DROP TABLE IF EXISTS `character_queststatus_daily`;
705 CREATE TABLE `character_queststatus_daily` (
706 `guid` int(11) unsigned NOT NULL default '0' COMMENT 'Global Unique Identifier',
707 `quest` int(11) unsigned NOT NULL default '0' COMMENT 'Quest Identifier',
708 PRIMARY KEY (`guid`,`quest`),
709 KEY `idx_guid` (`guid`)
710 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Player System';
713 -- Dumping data for table `character_queststatus_daily`
716 LOCK TABLES `character_queststatus_daily` WRITE;
717 /*!40000 ALTER TABLE `character_queststatus_daily` DISABLE KEYS */;
718 /*!40000 ALTER TABLE `character_queststatus_daily` ENABLE KEYS */;
722 -- Table structure for table `character_queststatus_weekly`
725 DROP TABLE IF EXISTS `character_queststatus_weekly`;
726 CREATE TABLE `character_queststatus_weekly` (
727 `guid` int(11) unsigned NOT NULL default '0' COMMENT 'Global Unique Identifier',
728 `quest` int(11) unsigned NOT NULL default '0' COMMENT 'Quest Identifier',
729 PRIMARY KEY (`guid`,`quest`),
730 KEY `idx_guid` (`guid`)
731 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Player System';
734 -- Dumping data for table `character_queststatus_weekly`
737 LOCK TABLES `character_queststatus_weekly` WRITE;
738 /*!40000 ALTER TABLE `character_queststatus_weekly` DISABLE KEYS */;
739 /*!40000 ALTER TABLE `character_queststatus_weekly` ENABLE KEYS */;
743 -- Table structure for table `character_reputation`
746 DROP TABLE IF EXISTS `character_reputation`;
747 CREATE TABLE `character_reputation` (
748 `guid` int(11) unsigned NOT NULL default '0' COMMENT 'Global Unique Identifier',
749 `faction` int(11) unsigned NOT NULL default '0',
750 `standing` int(11) NOT NULL default '0',
751 `flags` int(11) NOT NULL default '0',
752 PRIMARY KEY (`guid`,`faction`)
753 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Player System';
756 -- Dumping data for table `character_reputation`
759 LOCK TABLES `character_reputation` WRITE;
760 /*!40000 ALTER TABLE `character_reputation` DISABLE KEYS */;
761 /*!40000 ALTER TABLE `character_reputation` ENABLE KEYS */;
765 -- Table structure for table `character_skills`
768 DROP TABLE IF EXISTS `character_skills`;
769 CREATE TABLE `character_skills` (
770 `guid` int(11) unsigned NOT NULL COMMENT 'Global Unique Identifier',
771 `skill` mediumint(9) unsigned NOT NULL,
772 `value` mediumint(9) unsigned NOT NULL,
773 `max` mediumint(9) unsigned NOT NULL,
774 PRIMARY KEY (`guid`,`skill`)
775 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Player System';
778 -- Dumping data for table `character_skills`
781 LOCK TABLES `character_skills` WRITE;
782 /*!40000 ALTER TABLE `character_skills` DISABLE KEYS */;
783 /*!40000 ALTER TABLE `character_skills` ENABLE KEYS */;
787 -- Table structure for table `character_social`
790 DROP TABLE IF EXISTS `character_social`;
791 CREATE TABLE `character_social` (
792 `guid` int(11) unsigned NOT NULL default '0' COMMENT 'Character Global Unique Identifier',
793 `friend` int(11) unsigned NOT NULL default '0' COMMENT 'Friend Global Unique Identifier',
794 `flags` tinyint(1) unsigned NOT NULL default '0' COMMENT 'Friend Flags',
795 `note` varchar(48) NOT NULL DEFAULT '' COMMENT 'Friend Note',
796 PRIMARY KEY (`guid`,`friend`,`flags`),
798 KEY `friend` (`friend`),
799 KEY `guid_flags` (`guid`,`flags`),
800 KEY `friend_flags` (`friend`,`flags`)
801 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Player System';
804 -- Dumping data for table `character_social`
807 LOCK TABLES `character_social` WRITE;
808 /*!40000 ALTER TABLE `character_social` DISABLE KEYS */;
809 /*!40000 ALTER TABLE `character_social` ENABLE KEYS */;
813 -- Table structure for table `character_spell`
816 DROP TABLE IF EXISTS `character_spell`;
817 CREATE TABLE `character_spell` (
818 `guid` int(11) unsigned NOT NULL default '0' COMMENT 'Global Unique Identifier',
819 `spell` int(11) unsigned NOT NULL default '0' COMMENT 'Spell Identifier',
820 `active` tinyint(3) unsigned NOT NULL default '1',
821 `disabled` tinyint(3) unsigned NOT NULL default '0',
822 PRIMARY KEY (`guid`,`spell`),
823 KEY `Idx_spell` (`spell`)
824 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Player System';
827 -- Dumping data for table `character_spell`
830 LOCK TABLES `character_spell` WRITE;
831 /*!40000 ALTER TABLE `character_spell` DISABLE KEYS */;
832 /*!40000 ALTER TABLE `character_spell` ENABLE KEYS */;
836 -- Table structure for table `character_spell_cooldown`
839 DROP TABLE IF EXISTS `character_spell_cooldown`;
840 CREATE TABLE `character_spell_cooldown` (
841 `guid` int(11) unsigned NOT NULL default '0' COMMENT 'Global Unique Identifier, Low part',
842 `spell` int(11) unsigned NOT NULL default '0' COMMENT 'Spell Identifier',
843 `item` int(11) unsigned NOT NULL default '0' COMMENT 'Item Identifier',
844 `time` bigint(20) unsigned NOT NULL default '0',
845 PRIMARY KEY (`guid`,`spell`)
846 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
849 -- Dumping data for table `character_spell_cooldown`
852 LOCK TABLES `character_spell_cooldown` WRITE;
853 /*!40000 ALTER TABLE `character_spell_cooldown` DISABLE KEYS */;
854 /*!40000 ALTER TABLE `character_spell_cooldown` ENABLE KEYS */;
858 -- Table structure for table `character_stats`
861 DROP TABLE IF EXISTS `character_stats`;
862 CREATE TABLE `character_stats` (
863 `guid` int(11) unsigned NOT NULL default '0' COMMENT 'Global Unique Identifier, Low part',
864 `maxhealth` int(10) UNSIGNED NOT NULL default '0',
865 `maxpower1` int(10) UNSIGNED NOT NULL default '0',
866 `maxpower2` int(10) UNSIGNED NOT NULL default '0',
867 `maxpower3` int(10) UNSIGNED NOT NULL default '0',
868 `maxpower4` int(10) UNSIGNED NOT NULL default '0',
869 `maxpower5` int(10) UNSIGNED NOT NULL default '0',
870 `maxpower6` int(10) UNSIGNED NOT NULL default '0',
871 `maxpower7` int(10) UNSIGNED NOT NULL default '0',
872 `strength` int(10) UNSIGNED NOT NULL default '0',
873 `agility` int(10) UNSIGNED NOT NULL default '0',
874 `stamina` int(10) UNSIGNED NOT NULL default '0',
875 `intellect` int(10) UNSIGNED NOT NULL default '0',
876 `spirit` int(10) UNSIGNED NOT NULL default '0',
877 `armor` int(10) UNSIGNED NOT NULL default '0',
878 `resHoly` int(10) UNSIGNED NOT NULL default '0',
879 `resFire` int(10) UNSIGNED NOT NULL default '0',
880 `resNature` int(10) UNSIGNED NOT NULL default '0',
881 `resFrost` int(10) UNSIGNED NOT NULL default '0',
882 `resShadow` int(10) UNSIGNED NOT NULL default '0',
883 `resArcane` int(10) UNSIGNED NOT NULL default '0',
884 `blockPct` float UNSIGNED NOT NULL default '0',
885 `dodgePct` float UNSIGNED NOT NULL default '0',
886 `parryPct` float UNSIGNED NOT NULL default '0',
887 `critPct` float UNSIGNED NOT NULL default '0',
888 `rangedCritPct` float UNSIGNED NOT NULL default '0',
889 `spellCritPct` float UNSIGNED NOT NULL default '0',
890 `attackPower` int(10) UNSIGNED NOT NULL default '0',
891 `rangedAttackPower` int(10) UNSIGNED NOT NULL default '0',
892 `spellPower` int(10) UNSIGNED NOT NULL default '0',
894 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
897 -- Dumping data for table `character_stats`
900 LOCK TABLES `character_stats` WRITE;
901 /*!40000 ALTER TABLE `character_stats` DISABLE KEYS */;
902 /*!40000 ALTER TABLE `character_stats` ENABLE KEYS */;
906 -- Table structure for table `character_talent`
909 DROP TABLE IF EXISTS `character_talent`;
910 CREATE TABLE `character_talent` (
911 `guid` int(11) unsigned NOT NULL,
912 `talent_id` int(11) unsigned NOT NULL,
913 `current_rank` tinyint(3) unsigned NOT NULL DEFAULT '0',
914 `spec` tinyint(3) unsigned NOT NULL DEFAULT '0',
915 PRIMARY KEY (`guid`,`talent_id`,`spec`),
916 KEY guid_key (`guid`),
917 KEY talent_key (`talent_id`),
918 KEY spec_key (`spec`)
919 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
922 -- Dumping data for table `character_talent`
925 LOCK TABLES `character_talent` WRITE;
926 /*!40000 ALTER TABLE `character_talent` DISABLE KEYS */;
927 /*!40000 ALTER TABLE `character_talent` ENABLE KEYS */;
931 -- Table structure for table `character_ticket`
934 DROP TABLE IF EXISTS `character_ticket`;
935 CREATE TABLE `character_ticket` (
936 `ticket_id` int(11) unsigned NOT NULL auto_increment,
937 `guid` int(11) unsigned NOT NULL default '0',
939 `response_text` text,
940 `ticket_lastchange` TIMESTAMP ON UPDATE CURRENT_TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
941 PRIMARY KEY (`ticket_id`)
942 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Player System';
945 -- Dumping data for table `character_ticket`
948 LOCK TABLES `character_ticket` WRITE;
949 /*!40000 ALTER TABLE `character_ticket` DISABLE KEYS */;
950 /*!40000 ALTER TABLE `character_ticket` ENABLE KEYS */;
954 -- Table structure for table `character_tutorial`
957 DROP TABLE IF EXISTS `character_tutorial`;
958 CREATE TABLE `character_tutorial` (
959 `account` bigint(20) unsigned NOT NULL auto_increment COMMENT 'Account Identifier',
960 `realmid` int(11) unsigned NOT NULL default '0' COMMENT 'Realm Identifier',
961 `tut0` int(11) unsigned NOT NULL default '0',
962 `tut1` int(11) unsigned NOT NULL default '0',
963 `tut2` int(11) unsigned NOT NULL default '0',
964 `tut3` int(11) unsigned NOT NULL default '0',
965 `tut4` int(11) unsigned NOT NULL default '0',
966 `tut5` int(11) unsigned NOT NULL default '0',
967 `tut6` int(11) unsigned NOT NULL default '0',
968 `tut7` int(11) unsigned NOT NULL default '0',
969 PRIMARY KEY (`account`,`realmid`),
970 KEY acc_key (`account`)
971 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Player System';
974 -- Dumping data for table `character_tutorial`
977 LOCK TABLES `character_tutorial` WRITE;
978 /*!40000 ALTER TABLE `character_tutorial` DISABLE KEYS */;
979 /*!40000 ALTER TABLE `character_tutorial` ENABLE KEYS */;
983 -- Table structure for table `corpse`
986 DROP TABLE IF EXISTS `corpse`;
987 CREATE TABLE `corpse` (
988 `guid` int(11) unsigned NOT NULL default '0' COMMENT 'Global Unique Identifier',
989 `player` int(11) unsigned NOT NULL default '0' COMMENT 'Character Global Unique Identifier',
990 `position_x` float NOT NULL default '0',
991 `position_y` float NOT NULL default '0',
992 `position_z` float NOT NULL default '0',
993 `orientation` float NOT NULL default '0',
994 `map` int(11) unsigned NOT NULL default '0' COMMENT 'Map Identifier',
995 `phaseMask` smallint(5) unsigned NOT NULL default '1',
996 `time` bigint(20) unsigned NOT NULL default '0',
997 `corpse_type` tinyint(3) unsigned NOT NULL default '0',
998 `instance` int(11) unsigned NOT NULL default '0',
999 PRIMARY KEY (`guid`),
1000 KEY `idx_type` (`corpse_type`),
1001 KEY `instance` (`instance`),
1002 INDEX `Idx_player`(`player`),
1003 INDEX `Idx_time`(`time`)
1004 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Death System';
1007 -- Dumping data for table `corpse`
1010 LOCK TABLES `corpse` WRITE;
1011 /*!40000 ALTER TABLE `corpse` DISABLE KEYS */;
1012 /*!40000 ALTER TABLE `corpse` ENABLE KEYS */;
1016 -- Table structure for table `groups`
1019 DROP TABLE IF EXISTS `groups`;
1020 CREATE TABLE `groups` (
1021 `groupId` int(11) unsigned NOT NULL,
1022 `leaderGuid` int(11) unsigned NOT NULL,
1023 `mainTank` int(11) unsigned NOT NULL,
1024 `mainAssistant` int(11) unsigned NOT NULL,
1025 `lootMethod` tinyint(4) unsigned NOT NULL,
1026 `looterGuid` int(11) unsigned NOT NULL,
1027 `lootThreshold` tinyint(4) unsigned NOT NULL,
1028 `icon1` int(11) unsigned NOT NULL,
1029 `icon2` int(11) unsigned NOT NULL,
1030 `icon3` int(11) unsigned NOT NULL,
1031 `icon4` int(11) unsigned NOT NULL,
1032 `icon5` int(11) unsigned NOT NULL,
1033 `icon6` int(11) unsigned NOT NULL,
1034 `icon7` int(11) unsigned NOT NULL,
1035 `icon8` int(11) unsigned NOT NULL,
1036 `isRaid` tinyint(1) unsigned NOT NULL,
1037 `difficulty` tinyint(3) unsigned NOT NULL default '0',
1038 `raiddifficulty` int(11) UNSIGNED NOT NULL default '0',
1039 PRIMARY KEY (`groupId`),
1040 UNIQUE KEY (`leaderGuid`)
1041 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Groups';
1044 -- Dumping data for table `groups`
1047 LOCK TABLES `groups` WRITE;
1048 /*!40000 ALTER TABLE `groups` DISABLE KEYS */;
1049 /*!40000 ALTER TABLE `groups` ENABLE KEYS */;
1052 -- ----------------------------
1053 -- Table structure for group_instance
1054 -- ----------------------------
1055 DROP TABLE IF EXISTS `group_instance`;
1056 CREATE TABLE `group_instance` (
1057 `leaderGuid` int(11) unsigned NOT NULL default '0',
1058 `instance` int(11) unsigned NOT NULL default '0',
1059 `permanent` tinyint(1) unsigned NOT NULL default '0',
1060 PRIMARY KEY (`leaderGuid`,`instance`),
1061 KEY `instance` (`instance`)
1062 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1065 -- Dumping data for table `group_instance`
1068 LOCK TABLES `group_instance` WRITE;
1069 /*!40000 ALTER TABLE `group_instance` DISABLE KEYS */;
1070 /*!40000 ALTER TABLE `group_instance` ENABLE KEYS */;
1074 -- Table structure for table `group_member`
1077 DROP TABLE IF EXISTS `group_member`;
1078 CREATE TABLE `group_member` (
1079 `groupId` int(11) unsigned NOT NULL,
1080 `memberGuid` int(11) unsigned NOT NULL,
1081 `assistant` tinyint(1) unsigned NOT NULL,
1082 `subgroup` smallint(6) unsigned NOT NULL,
1083 PRIMARY KEY (`groupId`,`memberGuid`),
1084 INDEX `Idx_memberGuid`(`memberGuid`)
1085 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Groups';
1088 -- Dumping data for table `group_member`
1091 LOCK TABLES `group_member` WRITE;
1092 /*!40000 ALTER TABLE `group_member` DISABLE KEYS */;
1093 /*!40000 ALTER TABLE `group_member` ENABLE KEYS */;
1097 -- Table structure for table `guild`
1100 DROP TABLE IF EXISTS `guild`;
1101 CREATE TABLE `guild` (
1102 `guildid` int(6) unsigned NOT NULL default '0',
1103 `name` varchar(255) NOT NULL default '',
1104 `leaderguid` int(6) unsigned NOT NULL default '0',
1105 `EmblemStyle` int(5) NOT NULL default '0',
1106 `EmblemColor` int(5) NOT NULL default '0',
1107 `BorderStyle` int(5) NOT NULL default '0',
1108 `BorderColor` int(5) NOT NULL default '0',
1109 `BackgroundColor` int(5) NOT NULL default '0',
1110 `info` text NOT NULL,
1111 `motd` varchar(255) NOT NULL default '',
1112 `createdate` bigint(20) NOT NULL default '0',
1113 `BankMoney` bigint(20) NOT NULL default '0',
1114 PRIMARY KEY (`guildid`)
1115 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Guild System';
1118 -- Dumping data for table `guild`
1121 LOCK TABLES `guild` WRITE;
1122 /*!40000 ALTER TABLE `guild` DISABLE KEYS */;
1123 /*!40000 ALTER TABLE `guild` ENABLE KEYS */;
1127 -- Table structure for table `guild_bank_eventlog`
1130 DROP TABLE IF EXISTS `guild_bank_eventlog`;
1131 CREATE TABLE `guild_bank_eventlog` (
1132 `guildid` int(11) unsigned NOT NULL default '0' COMMENT 'Guild Identificator',
1133 `LogGuid` int(11) unsigned NOT NULL default '0' COMMENT 'Log record identificator - auxiliary column',
1134 `TabId` tinyint(3) unsigned NOT NULL default '0' COMMENT 'Guild bank TabId',
1135 `EventType` tinyint(3) unsigned NOT NULL default '0' COMMENT 'Event type',
1136 `PlayerGuid` int(11) unsigned NOT NULL default '0',
1137 `ItemOrMoney` int(11) unsigned NOT NULL default '0',
1138 `ItemStackCount` tinyint(3) unsigned NOT NULL default '0',
1139 `DestTabId` tinyint(1) unsigned NOT NULL default '0' COMMENT 'Destination Tab Id',
1140 `TimeStamp` bigint(20) unsigned NOT NULL default '0' COMMENT 'Event UNIX time',
1141 PRIMARY KEY (`guildid`,`LogGuid`,`TabId`),
1142 KEY `guildid_key` (`guildid`),
1143 INDEX `Idx_PlayerGuid`(`PlayerGuid`),
1144 INDEX `Idx_LogGuid`(`LogGuid`)
1145 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1148 -- Dumping data for table `guild_bank_eventlog`
1151 LOCK TABLES `guild_bank_eventlog` WRITE;
1152 /*!40000 ALTER TABLE `guild_bank_eventlog` DISABLE KEYS */;
1153 /*!40000 ALTER TABLE `guild_bank_eventlog` ENABLE KEYS */;
1157 -- Table structure for table `guild_bank_item`
1160 DROP TABLE IF EXISTS `guild_bank_item`;
1161 CREATE TABLE `guild_bank_item` (
1162 `guildid` int(11) unsigned NOT NULL default '0',
1163 `TabId` tinyint(1) unsigned NOT NULL default '0',
1164 `SlotId` tinyint(3) unsigned NOT NULL default '0',
1165 `item_guid` int(11) unsigned NOT NULL default '0',
1166 `item_entry` int(11) unsigned NOT NULL default '0',
1167 PRIMARY KEY (`guildid`,`tabid`,`slotid`),
1168 KEY `guildid_key` (`guildid`),
1169 INDEX `Idx_item_guid`(`item_guid`)
1170 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1173 -- Dumping data for table `guild_bank_item`
1176 LOCK TABLES `guild_bank_item` WRITE;
1177 /*!40000 ALTER TABLE `guild_bank_item` DISABLE KEYS */;
1178 /*!40000 ALTER TABLE `guild_bank_item` ENABLE KEYS */;
1182 -- Table structure for table `guild_bank_right`
1185 DROP TABLE IF EXISTS `guild_bank_right`;
1186 CREATE TABLE `guild_bank_right` (
1187 `guildid` int(11) unsigned NOT NULL default '0',
1188 `TabId` tinyint(1) unsigned NOT NULL default '0',
1189 `rid` int(11) unsigned NOT NULL default '0',
1190 `gbright` tinyint(3) unsigned NOT NULL default '0',
1191 `SlotPerDay` int(11) unsigned NOT NULL default '0',
1192 PRIMARY KEY (`guildid`,`TabId`,`rid`),
1193 KEY `guildid_key` (`guildid`)
1194 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1197 -- Dumping data for table `guild_bank_right`
1200 LOCK TABLES `guild_bank_right` WRITE;
1201 /*!40000 ALTER TABLE `guild_bank_right` DISABLE KEYS */;
1202 /*!40000 ALTER TABLE `guild_bank_right` ENABLE KEYS */;
1206 -- Table structure for table `guild_bank_tab`
1209 DROP TABLE IF EXISTS `guild_bank_tab`;
1210 CREATE TABLE `guild_bank_tab` (
1211 `guildid` int(11) unsigned NOT NULL default '0',
1212 `TabId` tinyint(1) unsigned NOT NULL default '0',
1213 `TabName` varchar(100) NOT NULL default '',
1214 `TabIcon` varchar(100) NOT NULL default '',
1216 PRIMARY KEY (`guildid`,`TabId`),
1217 KEY `guildid_key` (`guildid`)
1218 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1221 -- Dumping data for table `guild_bank_tab`
1224 LOCK TABLES `guild_bank_tab` WRITE;
1225 /*!40000 ALTER TABLE `guild_bank_tab` DISABLE KEYS */;
1226 /*!40000 ALTER TABLE `guild_bank_tab` ENABLE KEYS */;
1230 -- Table structure for table `guild_eventlog`
1233 DROP TABLE IF EXISTS `guild_eventlog`;
1234 CREATE TABLE `guild_eventlog` (
1235 `guildid` int(11) NOT NULL COMMENT 'Guild Identificator',
1236 `LogGuid` int(11) NOT NULL COMMENT 'Log record identificator - auxiliary column',
1237 `EventType` tinyint(1) NOT NULL COMMENT 'Event type',
1238 `PlayerGuid1` int(11) NOT NULL COMMENT 'Player 1',
1239 `PlayerGuid2` int(11) NOT NULL COMMENT 'Player 2',
1240 `NewRank` tinyint(2) NOT NULL COMMENT 'New rank(in case promotion/demotion)',
1241 `TimeStamp` bigint(20) NOT NULL COMMENT 'Event UNIX time',
1242 PRIMARY KEY (`guildid`, `LogGuid`),
1243 INDEX `Idx_PlayerGuid1`(`PlayerGuid1`),
1244 INDEX `Idx_PlayerGuid2`(`PlayerGuid2`),
1245 INDEX `Idx_LogGuid`(`LogGuid`)
1246 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT 'Guild Eventlog';
1249 -- Dumping data for table `guild_eventlog`
1252 LOCK TABLES `guild_eventlog` WRITE;
1253 /*!40000 ALTER TABLE `guild_eventlog` DISABLE KEYS */;
1254 /*!40000 ALTER TABLE `guild_eventlog` ENABLE KEYS */;
1258 -- Table structure for table `guild_member`
1261 DROP TABLE IF EXISTS `guild_member`;
1262 CREATE TABLE `guild_member` (
1263 `guildid` int(6) unsigned NOT NULL default '0',
1264 `guid` int(11) unsigned NOT NULL default '0',
1265 `rank` tinyint(2) unsigned NOT NULL default '0',
1266 `pnote` varchar(255) NOT NULL default '',
1267 `offnote` varchar(255) NOT NULL default '',
1268 `BankResetTimeMoney` int(11) unsigned NOT NULL default '0',
1269 `BankRemMoney` int(11) unsigned NOT NULL default '0',
1270 `BankResetTimeTab0` int(11) unsigned NOT NULL default '0',
1271 `BankRemSlotsTab0` int(11) unsigned NOT NULL default '0',
1272 `BankResetTimeTab1` int(11) unsigned NOT NULL default '0',
1273 `BankRemSlotsTab1` int(11) unsigned NOT NULL default '0',
1274 `BankResetTimeTab2` int(11) unsigned NOT NULL default '0',
1275 `BankRemSlotsTab2` int(11) unsigned NOT NULL default '0',
1276 `BankResetTimeTab3` int(11) unsigned NOT NULL default '0',
1277 `BankRemSlotsTab3` int(11) unsigned NOT NULL default '0',
1278 `BankResetTimeTab4` int(11) unsigned NOT NULL default '0',
1279 `BankRemSlotsTab4` int(11) unsigned NOT NULL default '0',
1280 `BankResetTimeTab5` int(11) unsigned NOT NULL default '0',
1281 `BankRemSlotsTab5` int(11) unsigned NOT NULL default '0',
1282 KEY `guildid_key` (`guildid`),
1283 KEY `guildid_rank_key` (`guildid`,`rank`),
1284 UNIQUE KEY `guid_key` (`guid`)
1285 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Guild System';
1288 -- Dumping data for table `guild_member`
1291 LOCK TABLES `guild_member` WRITE;
1292 /*!40000 ALTER TABLE `guild_member` DISABLE KEYS */;
1293 /*!40000 ALTER TABLE `guild_member` ENABLE KEYS */;
1297 -- Table structure for table `guild_rank`
1300 DROP TABLE IF EXISTS `guild_rank`;
1301 CREATE TABLE `guild_rank` (
1302 `guildid` int(6) unsigned NOT NULL default '0',
1303 `rid` int(11) unsigned NOT NULL,
1304 `rname` varchar(255) NOT NULL default '',
1305 `rights` int(3) unsigned NOT NULL default '0',
1306 `BankMoneyPerDay` int(11) unsigned NOT NULL default '0',
1307 PRIMARY KEY (`guildid`,`rid`),
1308 INDEX `Idx_rid`(`rid`)
1309 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Guild System';
1312 -- Dumping data for table `guild_rank`
1315 LOCK TABLES `guild_rank` WRITE;
1316 /*!40000 ALTER TABLE `guild_rank` DISABLE KEYS */;
1317 /*!40000 ALTER TABLE `guild_rank` ENABLE KEYS */;
1321 -- Table structure for table `instance`
1324 DROP TABLE IF EXISTS `instance`;
1325 CREATE TABLE `instance` (
1326 `id` int(11) unsigned NOT NULL default '0',
1327 `map` int(11) unsigned NOT NULL default '0',
1328 `resettime` bigint(40) NOT NULL default '0',
1329 `difficulty` tinyint(1) unsigned NOT NULL default '0',
1333 KEY `resettime` (`resettime`)
1334 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1337 -- Dumping data for table `instance`
1340 LOCK TABLES `instance` WRITE;
1341 /*!40000 ALTER TABLE `instance` DISABLE KEYS */;
1342 /*!40000 ALTER TABLE `instance` ENABLE KEYS */;
1345 -- ----------------------------
1346 -- Table structure for instance_reset
1347 -- ----------------------------
1348 DROP TABLE IF EXISTS `instance_reset`;
1349 CREATE TABLE `instance_reset` (
1350 `mapid` int(11) unsigned NOT NULL default '0',
1351 `difficulty` tinyint(1) unsigned NOT NULL default '0',
1352 `resettime` bigint(40) NOT NULL default '0',
1353 PRIMARY KEY (`mapid`,`difficulty`)
1354 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1357 -- Dumping data for table `instance_reset`
1360 LOCK TABLES `instance_reset` WRITE;
1361 /*!40000 ALTER TABLE `instance_reset` DISABLE KEYS */;
1362 /*!40000 ALTER TABLE `instance_reset` ENABLE KEYS */;
1366 -- Table structure for table `item_instance`
1369 DROP TABLE IF EXISTS `item_instance`;
1370 CREATE TABLE `item_instance` (
1371 `guid` int(11) unsigned NOT NULL default '0',
1372 `owner_guid` int(11) unsigned NOT NULL default '0',
1375 PRIMARY KEY (`guid`),
1376 KEY `idx_owner_guid` (`owner_guid`)
1377 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Item System';
1380 -- Dumping data for table `item_instance`
1383 LOCK TABLES `item_instance` WRITE;
1384 /*!40000 ALTER TABLE `item_instance` DISABLE KEYS */;
1385 /*!40000 ALTER TABLE `item_instance` ENABLE KEYS */;
1389 -- Table structure for table `mail`
1392 DROP TABLE IF EXISTS `mail`;
1393 CREATE TABLE `mail` (
1394 `id` int(11) unsigned NOT NULL default '0' COMMENT 'Identifier',
1395 `messageType` tinyint(3) unsigned NOT NULL default '0',
1396 `stationery` tinyint(3) NOT NULL default '41',
1397 `mailTemplateId` mediumint(8) unsigned NOT NULL default '0',
1398 `sender` int(11) unsigned NOT NULL default '0' COMMENT 'Character Global Unique Identifier',
1399 `receiver` int(11) unsigned NOT NULL default '0' COMMENT 'Character Global Unique Identifier',
1402 `has_items` tinyint(3) unsigned NOT NULL default '0',
1403 `expire_time` bigint(40) NOT NULL default '0',
1404 `deliver_time` bigint(40) NOT NULL default '0',
1405 `money` int(11) unsigned NOT NULL default '0',
1406 `cod` int(11) unsigned NOT NULL default '0',
1407 `checked` tinyint(3) unsigned NOT NULL default '0',
1409 KEY `idx_receiver` (`receiver`)
1410 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Mail System';
1413 -- Dumping data for table `mail`
1416 LOCK TABLES `mail` WRITE;
1417 /*!40000 ALTER TABLE `mail` DISABLE KEYS */;
1418 /*!40000 ALTER TABLE `mail` ENABLE KEYS */;
1422 -- Table structure for table `mail_items`
1425 DROP TABLE IF EXISTS `mail_items`;
1426 CREATE TABLE `mail_items` (
1427 `mail_id` int(11) NOT NULL default '0',
1428 `item_guid` int(11) NOT NULL default '0',
1429 `item_template` int(11) NOT NULL default '0',
1430 `receiver` int(11) unsigned NOT NULL default '0' COMMENT 'Character Global Unique Identifier',
1431 PRIMARY KEY (`mail_id`,`item_guid`),
1432 KEY `idx_receiver` (`receiver`)
1433 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;
1436 -- Dumping data for table `mail_items`
1439 LOCK TABLES `mail_items` WRITE;
1440 /*!40000 ALTER TABLE `mail_items` DISABLE KEYS */;
1441 /*!40000 ALTER TABLE `mail_items` ENABLE KEYS */;
1445 -- Table structure for table `pet_aura`
1448 DROP TABLE IF EXISTS `pet_aura`;
1449 CREATE TABLE `pet_aura` (
1450 `guid` int(11) unsigned NOT NULL default '0' COMMENT 'Global Unique Identifier',
1451 `caster_guid` bigint(20) unsigned NOT NULL default '0' COMMENT 'Full Global Unique Identifier',
1452 `spell` int(11) unsigned NOT NULL default '0',
1453 `effect_index` int(11) unsigned NOT NULL default '0',
1454 `stackcount` int(11) NOT NULL default '1',
1455 `amount` int(11) NOT NULL default '0',
1456 `maxduration` int(11) NOT NULL default '0',
1457 `remaintime` int(11) NOT NULL default '0',
1458 `remaincharges` int(11) NOT NULL default '0',
1459 PRIMARY KEY (`guid`,`spell`,`effect_index`)
1460 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Pet System';
1463 -- Dumping data for table `pet_aura`
1466 LOCK TABLES `pet_aura` WRITE;
1467 /*!40000 ALTER TABLE `pet_aura` DISABLE KEYS */;
1468 /*!40000 ALTER TABLE `pet_aura` ENABLE KEYS */;
1472 -- Table structure for table `pet_spell`
1475 DROP TABLE IF EXISTS `pet_spell`;
1476 CREATE TABLE `pet_spell` (
1477 `guid` int(11) unsigned NOT NULL default '0' COMMENT 'Global Unique Identifier',
1478 `spell` int(11) unsigned NOT NULL default '0' COMMENT 'Spell Identifier',
1479 `active` int(11) unsigned NOT NULL default '0',
1480 PRIMARY KEY (`guid`,`spell`)
1481 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Pet System';
1484 -- Dumping data for table `pet_spell`
1487 LOCK TABLES `pet_spell` WRITE;
1488 /*!40000 ALTER TABLE `pet_spell` DISABLE KEYS */;
1489 /*!40000 ALTER TABLE `pet_spell` ENABLE KEYS */;
1493 -- Table structure for table `pet_spell_cooldown`
1496 DROP TABLE IF EXISTS `pet_spell_cooldown`;
1497 CREATE TABLE `pet_spell_cooldown` (
1498 `guid` int(11) unsigned NOT NULL default '0' COMMENT 'Global Unique Identifier, Low part',
1499 `spell` int(11) unsigned NOT NULL default '0' COMMENT 'Spell Identifier',
1500 `time` bigint(20) unsigned NOT NULL default '0',
1501 PRIMARY KEY (`guid`,`spell`)
1502 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1505 -- Dumping data for table `pet_spell_cooldown`
1508 LOCK TABLES `pet_spell_cooldown` WRITE;
1509 /*!40000 ALTER TABLE `pet_spell_cooldown` DISABLE KEYS */;
1510 /*!40000 ALTER TABLE `pet_spell_cooldown` ENABLE KEYS */;
1514 -- Table structure for table `petition`
1517 DROP TABLE IF EXISTS `petition`;
1518 CREATE TABLE `petition` (
1519 `ownerguid` int(10) unsigned NOT NULL,
1520 `petitionguid` int(10) unsigned default '0',
1521 `name` varchar(255) NOT NULL default '',
1522 `type` int(10) unsigned NOT NULL default '0',
1523 PRIMARY KEY (`ownerguid`,`type`),
1524 UNIQUE KEY `index_ownerguid_petitionguid` (`ownerguid`,`petitionguid`)
1525 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Guild System';
1528 -- Dumping data for table `petition`
1531 LOCK TABLES `petition` WRITE;
1532 /*!40000 ALTER TABLE `petition` DISABLE KEYS */;
1533 /*!40000 ALTER TABLE `petition` ENABLE KEYS */;
1537 -- Table structure for table `petition_sign`
1540 DROP TABLE IF EXISTS `petition_sign`;
1541 CREATE TABLE `petition_sign` (
1542 `ownerguid` int(10) unsigned NOT NULL,
1543 `petitionguid` int(11) unsigned NOT NULL default '0',
1544 `playerguid` int(11) unsigned NOT NULL default '0',
1545 `player_account` int(11) unsigned NOT NULL default '0',
1546 `type` int(10) unsigned NOT NULL default '0',
1547 PRIMARY KEY (`petitionguid`,`playerguid`),
1548 INDEX `Idx_playerguid`(`playerguid`),
1549 INDEX `Idx_ownerguid`(`ownerguid`)
1550 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Guild System';
1553 -- Dumping data for table `petition_sign`
1556 LOCK TABLES `petition_sign` WRITE;
1557 /*!40000 ALTER TABLE `petition_sign` DISABLE KEYS */;
1558 /*!40000 ALTER TABLE `petition_sign` ENABLE KEYS */;
1560 /*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
1563 -- Table structure for table `saved_variables`
1566 DROP TABLE IF EXISTS `saved_variables`;
1567 CREATE TABLE `saved_variables` (
1568 `NextArenaPointDistributionTime` bigint(40) UNSIGNED NOT NULL DEFAULT '0',
1569 `NextDailyQuestResetTime` bigint(40) unsigned NOT NULL default '0',
1570 `NextWeeklyQuestResetTime` bigint(40) unsigned NOT NULL default '0',
1571 `cleaning_flags` int(11) unsigned NOT NULL default '0'
1572 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Variable Saves';
1575 -- Dumping data for table `saved_variables`
1578 LOCK TABLES `saved_variables` WRITE;
1579 /*!40000 ALTER TABLE `saved_variables` DISABLE KEYS */;
1580 /*!40000 ALTER TABLE `saved_variables` ENABLE KEYS */;
1582 /*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
1585 /*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
1586 /*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
1587 /*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
1588 /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
1589 /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
1590 /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
1591 /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
1593 -- Dump completed on 2008-01-10 11:37:06