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_9359_01_characters_characters` 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',
197 `name` varchar(12) NOT NULL default '',
198 `race` tinyint(3) unsigned NOT NULL default '0',
199 `class` tinyint(3) unsigned NOT NULL default '0',
200 `gender` TINYINT UNSIGNED NOT NULL default '0',
201 `level` TINYINT UNSIGNED NOT NULL default '0',
202 `xp` INT UNSIGNED NOT NULL default '0',
203 `money` INT UNSIGNED NOT NULL default '0',
204 `playerBytes` INT UNSIGNED NOT NULL default '0',
205 `playerBytes2` INT UNSIGNED NOT NULL default '0',
206 `playerFlags` INT UNSIGNED NOT NULL default '0',
207 `position_x` float NOT NULL default '0',
208 `position_y` float NOT NULL default '0',
209 `position_z` float NOT NULL default '0',
210 `map` int(11) unsigned NOT NULL default '0' COMMENT 'Map Identifier',
211 `dungeon_difficulty` tinyint(1) unsigned NOT NULL DEFAULT '0',
212 `orientation` float NOT NULL default '0',
214 `online` tinyint(3) unsigned NOT NULL default '0',
215 `cinematic` tinyint(3) unsigned NOT NULL default '0',
216 `totaltime` int(11) unsigned NOT NULL default '0',
217 `leveltime` int(11) unsigned NOT NULL default '0',
218 `logout_time` bigint(20) unsigned NOT NULL default '0',
219 `is_logout_resting` tinyint(3) unsigned NOT NULL default '0',
220 `rest_bonus` float NOT NULL default '0',
221 `resettalents_cost` int(11) unsigned NOT NULL default '0',
222 `resettalents_time` bigint(20) unsigned NOT NULL default '0',
223 `trans_x` float NOT NULL default '0',
224 `trans_y` float NOT NULL default '0',
225 `trans_z` float NOT NULL default '0',
226 `trans_o` float NOT NULL default '0',
227 `transguid` bigint(20) unsigned NOT NULL default '0',
228 `extra_flags` int(11) unsigned NOT NULL default '0',
229 `stable_slots` tinyint(1) unsigned NOT NULL default '0',
230 `at_login` int(11) unsigned NOT NULL default '0',
231 `zone` int(11) unsigned NOT NULL default '0',
232 `death_expire_time` bigint(20) unsigned NOT NULL default '0',
234 `arenaPoints` int(10) UNSIGNED NOT NULL default '0',
235 `totalHonorPoints` int(10) UNSIGNED NOT NULL default '0',
236 `todayHonorPoints` int(10) UNSIGNED NOT NULL default '0',
237 `yesterdayHonorPoints` int(10) UNSIGNED NOT NULL default '0',
238 `totalKills` int(10) UNSIGNED NOT NULL default '0',
239 `todayKills` smallint(5) UNSIGNED NOT NULL default '0',
240 `yesterdayKills` smallint(5) UNSIGNED NOT NULL default '0',
241 `chosenTitle` int(10) UNSIGNED NOT NULL default '0',
242 `knownCurrencies` bigint(20) UNSIGNED NOT NULL default '0',
243 `watchedFaction` int(10) UNSIGNED NOT NULL default '0',
244 `drunk` smallint(5) UNSIGNED NOT NULL default '0',
245 `health` int(10) UNSIGNED NOT NULL default '0',
246 `power1` int(10) UNSIGNED NOT NULL default '0',
247 `power2` int(10) UNSIGNED NOT NULL default '0',
248 `power3` int(10) UNSIGNED NOT NULL default '0',
249 `power4` int(10) UNSIGNED NOT NULL default '0',
250 `power5` int(10) UNSIGNED NOT NULL default '0',
251 `power6` int(10) UNSIGNED NOT NULL default '0',
252 `power7` int(10) UNSIGNED NOT NULL default '0',
253 `specCount` tinyint(3) UNSIGNED NOT NULL default '1',
254 `activeSpec` tinyint(3) UNSIGNED NOT NULL default '0',
255 PRIMARY KEY (`guid`),
256 KEY `idx_account` (`account`),
257 KEY `idx_online` (`online`),
258 KEY `idx_name` (`name`)
259 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Player System';
262 -- Dumping data for table `characters`
265 LOCK TABLES `characters` WRITE;
266 /*!40000 ALTER TABLE `characters` DISABLE KEYS */;
267 /*!40000 ALTER TABLE `characters` ENABLE KEYS */;
271 -- Table structure for table `character_account_data`
274 DROP TABLE IF EXISTS `character_account_data`;
275 CREATE TABLE `character_account_data` (
276 `guid` int(11) unsigned NOT NULL default '0',
277 `type` int(11) unsigned NOT NULL default '0',
278 `time` bigint(11) unsigned NOT NULL default '0',
279 `data` longblob NOT NULL,
280 PRIMARY KEY (`guid`,`type`)
281 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
284 -- Dumping data for table `character_account_data`
287 LOCK TABLES `character_account_data` WRITE;
288 /*!40000 ALTER TABLE `character_account_data` DISABLE KEYS */;
289 /*!40000 ALTER TABLE `character_account_data` ENABLE KEYS */;
293 -- Table structure for table `character_achievement`
296 DROP TABLE IF EXISTS `character_achievement`;
297 CREATE TABLE `character_achievement` (
298 `guid` int(11) unsigned NOT NULL,
299 `achievement` int(11) unsigned NOT NULL,
300 `date` bigint(11) unsigned NOT NULL default '0',
301 PRIMARY KEY (`guid`,`achievement`)
302 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
305 -- Dumping data for table `character_achievement`
308 LOCK TABLES `character_achievement` WRITE;
309 /*!40000 ALTER TABLE `character_achievement` DISABLE KEYS */;
310 /*!40000 ALTER TABLE `character_achievement` ENABLE KEYS */;
314 -- Table structure for table `character_achievement_progress`
317 DROP TABLE IF EXISTS `character_achievement_progress`;
318 CREATE TABLE `character_achievement_progress` (
319 `guid` int(11) unsigned NOT NULL,
320 `criteria` int(11) unsigned NOT NULL,
321 `counter` int(11) unsigned NOT NULL,
322 `date` bigint(11) unsigned NOT NULL default '0',
323 PRIMARY KEY (`guid`,`criteria`)
324 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
327 -- Dumping data for table `character_achievement_progress`
330 LOCK TABLES `character_achievement_progress` WRITE;
331 /*!40000 ALTER TABLE `character_achievement_progress` DISABLE KEYS */;
332 /*!40000 ALTER TABLE `character_achievement_progress` ENABLE KEYS */;
336 -- Table structure for table `character_action`
339 DROP TABLE IF EXISTS `character_action`;
340 CREATE TABLE `character_action` (
341 `guid` int(11) unsigned NOT NULL default '0' COMMENT 'Global Unique Identifier',
342 `spec` tinyint(3) unsigned NOT NULL default '0',
343 `button` tinyint(3) unsigned NOT NULL default '0',
344 `action` int(11) unsigned NOT NULL default '0',
345 `type` tinyint(3) unsigned NOT NULL default '0',
346 PRIMARY KEY (`guid`,`spec`,`button`)
347 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Player System';
350 -- Dumping data for table `character_action`
353 LOCK TABLES `character_action` WRITE;
354 /*!40000 ALTER TABLE `character_action` DISABLE KEYS */;
355 /*!40000 ALTER TABLE `character_action` ENABLE KEYS */;
359 -- Table structure for table `character_aura`
362 DROP TABLE IF EXISTS `character_aura`;
363 CREATE TABLE `character_aura` (
364 `guid` int(11) unsigned NOT NULL default '0' COMMENT 'Global Unique Identifier',
365 `caster_guid` bigint(20) unsigned NOT NULL default '0' COMMENT 'Full Global Unique Identifier',
366 `spell` int(11) unsigned NOT NULL default '0',
367 `effect_index` int(11) unsigned NOT NULL default '0',
368 `stackcount` int(11) NOT NULL default '1',
369 `amount` int(11) NOT NULL default '0',
370 `maxduration` int(11) NOT NULL default '0',
371 `remaintime` int(11) NOT NULL default '0',
372 `remaincharges` int(11) NOT NULL default '0',
373 PRIMARY KEY (`guid`,`spell`,`effect_index`)
374 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Player System';
377 -- Dumping data for table `character_aura`
380 LOCK TABLES `character_aura` WRITE;
381 /*!40000 ALTER TABLE `character_aura` DISABLE KEYS */;
382 /*!40000 ALTER TABLE `character_aura` ENABLE KEYS */;
386 -- Table structure for table `character_battleground_data`
389 DROP TABLE IF EXISTS `character_battleground_data`;
390 CREATE TABLE `character_battleground_data` (
391 `guid` int(11) unsigned NOT NULL default '0' COMMENT 'Global Unique Identifier',
392 `instance_id` int(11) unsigned NOT NULL default '0',
393 `team` int(11) unsigned NOT NULL default '0',
394 `join_x` float NOT NULL default '0',
395 `join_y` float NOT NULL default '0',
396 `join_z` float NOT NULL default '0',
397 `join_o` float NOT NULL default '0',
398 `join_map` int(11) NOT NULL default '0',
399 `taxi_start` int(11) NOT NULL default '0',
400 `taxi_end` int(11) NOT NULL default '0',
401 `mount_spell` int(11) NOT NULL default '0',
403 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Player System';
406 -- Dumping data for table `character_battleground_data`
409 LOCK TABLES `character_battleground_data` WRITE;
410 /*!40000 ALTER TABLE `character_battleground_data` DISABLE KEYS */;
411 /*!40000 ALTER TABLE `character_battleground_data` ENABLE KEYS */;
415 -- Table structure for table `character_declinedname`
418 DROP TABLE IF EXISTS `character_declinedname`;
419 CREATE TABLE `character_declinedname` (
420 `guid` int(11) unsigned NOT NULL default '0' COMMENT 'Global Unique Identifier',
421 `genitive` varchar(15) NOT NULL default '',
422 `dative` varchar(15) NOT NULL default '',
423 `accusative` varchar(15) NOT NULL default '',
424 `instrumental` varchar(15) NOT NULL default '',
425 `prepositional` varchar(15) NOT NULL default '',
427 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;
430 -- Dumping data for table `character_declinedname`
433 LOCK TABLES `character_declinedname` WRITE;
434 /*!40000 ALTER TABLE `character_declinedname` DISABLE KEYS */;
435 /*!40000 ALTER TABLE `character_declinedname` ENABLE KEYS */;
439 -- Table structure for table `character_equipmentsets`
442 DROP TABLE IF EXISTS `character_equipmentsets`;
443 CREATE TABLE `character_equipmentsets` (
444 `guid` int(11) NOT NULL default '0',
445 `setguid` bigint(20) NOT NULL auto_increment,
446 `setindex` tinyint(4) NOT NULL default '0',
447 `name` varchar(100) NOT NULL,
448 `iconname` varchar(100) NOT NULL,
449 `item0` int(11) NOT NULL default '0',
450 `item1` int(11) NOT NULL default '0',
451 `item2` int(11) NOT NULL default '0',
452 `item3` int(11) NOT NULL default '0',
453 `item4` int(11) NOT NULL default '0',
454 `item5` int(11) NOT NULL default '0',
455 `item6` int(11) NOT NULL default '0',
456 `item7` int(11) NOT NULL default '0',
457 `item8` int(11) NOT NULL default '0',
458 `item9` int(11) NOT NULL default '0',
459 `item10` int(11) NOT NULL default '0',
460 `item11` int(11) NOT NULL default '0',
461 `item12` int(11) NOT NULL default '0',
462 `item13` int(11) NOT NULL default '0',
463 `item14` int(11) NOT NULL default '0',
464 `item15` int(11) NOT NULL default '0',
465 `item16` int(11) NOT NULL default '0',
466 `item17` int(11) NOT NULL default '0',
467 `item18` int(11) NOT NULL default '0',
468 PRIMARY KEY (`setguid`),
469 UNIQUE KEY `idx_set` (`guid`,`setguid`,`setindex`)
470 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
473 -- Dumping data for table `character_equipmentsets`
476 LOCK TABLES `character_equipmentsets` WRITE;
477 /*!40000 ALTER TABLE `character_equipmentsets` DISABLE KEYS */;
478 /*!40000 ALTER TABLE `character_equipmentsets` ENABLE KEYS */;
482 -- Table structure for table `character_gifts`
485 DROP TABLE IF EXISTS `character_gifts`;
486 CREATE TABLE `character_gifts` (
487 `guid` int(20) unsigned NOT NULL default '0',
488 `item_guid` int(11) unsigned NOT NULL default '0',
489 `entry` int(20) unsigned NOT NULL default '0',
490 `flags` int(20) unsigned NOT NULL default '0',
491 PRIMARY KEY (`item_guid`),
492 KEY `idx_guid` (`guid`)
493 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
496 -- Dumping data for table `character_gifts`
499 LOCK TABLES `character_gifts` WRITE;
500 /*!40000 ALTER TABLE `character_gifts` DISABLE KEYS */;
501 /*!40000 ALTER TABLE `character_gifts` ENABLE KEYS */;
505 -- Table structure for table `character_glyphs`
508 DROP TABLE IF EXISTS `character_glyphs`;
509 CREATE TABLE `character_glyphs` (
510 `guid` int(11) unsigned NOT NULL,
511 `spec` tinyint(3) unsigned NOT NULL DEFAULT '0',
512 `slot` tinyint(3) unsigned NOT NULL DEFAULT '0',
513 `glyph` int(11) unsigned NOT NULL DEFAULT '0',
514 PRIMARY KEY (`guid`,`spec`,`slot`)
515 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
518 -- Dumping data for table `character_glyphs`
521 LOCK TABLES `character_glyphs` WRITE;
522 /*!40000 ALTER TABLE `character_glyphs` DISABLE KEYS */;
523 /*!40000 ALTER TABLE `character_glyphs` ENABLE KEYS */;
527 -- Table structure for table `character_homebind`
530 DROP TABLE IF EXISTS `character_homebind`;
531 CREATE TABLE `character_homebind` (
532 `guid` int(11) unsigned NOT NULL default '0' COMMENT 'Global Unique Identifier',
533 `map` int(11) unsigned NOT NULL default '0' COMMENT 'Map Identifier',
534 `zone` int(11) unsigned NOT NULL default '0' COMMENT 'Zone Identifier',
535 `position_x` float NOT NULL default '0',
536 `position_y` float NOT NULL default '0',
537 `position_z` float NOT NULL default '0',
539 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Player System';
542 -- Dumping data for table `character_homebind`
545 LOCK TABLES `character_homebind` WRITE;
546 /*!40000 ALTER TABLE `character_homebind` DISABLE KEYS */;
547 /*!40000 ALTER TABLE `character_homebind` ENABLE KEYS */;
551 -- Table structure for table `character_instance`
554 DROP TABLE IF EXISTS `character_instance`;
555 CREATE TABLE `character_instance` (
556 `guid` int(11) unsigned NOT NULL default '0',
557 `instance` int(11) unsigned NOT NULL default '0',
558 `permanent` tinyint(1) unsigned NOT NULL default '0',
559 PRIMARY KEY (`guid`,`instance`),
560 KEY `instance` (`instance`)
561 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
564 -- Dumping data for table `character_instance`
567 LOCK TABLES `character_instance` WRITE;
568 /*!40000 ALTER TABLE `character_instance` DISABLE KEYS */;
569 /*!40000 ALTER TABLE `character_instance` ENABLE KEYS */;
573 -- Table structure for table `character_inventory`
576 DROP TABLE IF EXISTS `character_inventory`;
577 CREATE TABLE `character_inventory` (
578 `guid` int(11) unsigned NOT NULL default '0' COMMENT 'Global Unique Identifier',
579 `bag` int(11) unsigned NOT NULL default '0',
580 `slot` tinyint(3) unsigned NOT NULL default '0',
581 `item` int(11) unsigned NOT NULL default '0' COMMENT 'Item Global Unique Identifier',
582 `item_template` int(11) unsigned NOT NULL default '0' COMMENT 'Item Identifier',
583 PRIMARY KEY (`item`),
584 KEY `idx_guid` (`guid`)
585 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Player System';
588 -- Dumping data for table `character_inventory`
591 LOCK TABLES `character_inventory` WRITE;
592 /*!40000 ALTER TABLE `character_inventory` DISABLE KEYS */;
593 /*!40000 ALTER TABLE `character_inventory` ENABLE KEYS */;
597 -- Table structure for table `character_pet`
600 DROP TABLE IF EXISTS `character_pet`;
601 CREATE TABLE `character_pet` (
602 `id` int(11) unsigned NOT NULL default '0',
603 `entry` int(11) unsigned NOT NULL default '0',
604 `owner` int(11) unsigned NOT NULL default '0',
605 `modelid` int(11) unsigned default '0',
606 `CreatedBySpell` int(11) unsigned NOT NULL default '0',
607 `PetType` tinyint(3) unsigned NOT NULL default '0',
608 `level` int(11) unsigned NOT NULL default '1',
609 `exp` int(11) unsigned NOT NULL default '0',
610 `Reactstate` tinyint(1) unsigned NOT NULL default '0',
611 `name` varchar(100) default 'Pet',
612 `renamed` tinyint(1) unsigned NOT NULL default '0',
613 `slot` int(11) unsigned NOT NULL default '0',
614 `curhealth` int(11) unsigned NOT NULL default '1',
615 `curmana` int(11) unsigned NOT NULL default '0',
616 `curhappiness` int(11) unsigned NOT NULL default '0',
617 `savetime` bigint(20) unsigned NOT NULL default '0',
618 `resettalents_cost` int(11) unsigned NOT NULL default '0',
619 `resettalents_time` bigint(20) unsigned NOT NULL default '0',
622 KEY `owner` (`owner`)
623 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Pet System';
626 -- Dumping data for table `character_pet`
629 LOCK TABLES `character_pet` WRITE;
630 /*!40000 ALTER TABLE `character_pet` DISABLE KEYS */;
631 /*!40000 ALTER TABLE `character_pet` ENABLE KEYS */;
635 -- Table structure for table `character_pet_declinedname`
638 DROP TABLE IF EXISTS `character_pet_declinedname`;
639 CREATE TABLE `character_pet_declinedname` (
640 `id` int(11) unsigned NOT NULL default '0',
641 `owner` int(11) unsigned NOT NULL default '0',
642 `genitive` varchar(12) NOT NULL default '',
643 `dative` varchar(12) NOT NULL default '',
644 `accusative` varchar(12) NOT NULL default '',
645 `instrumental` varchar(12) NOT NULL default '',
646 `prepositional` varchar(12) NOT NULL default '',
648 KEY owner_key (`owner`)
649 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;
652 -- Dumping data for table `character_pet_declinedname`
655 LOCK TABLES `character_pet_declinedname` WRITE;
656 /*!40000 ALTER TABLE `character_pet_declinedname` DISABLE KEYS */;
657 /*!40000 ALTER TABLE `character_pet_declinedname` ENABLE KEYS */;
661 -- Table structure for table `character_queststatus`
664 DROP TABLE IF EXISTS `character_queststatus`;
665 CREATE TABLE `character_queststatus` (
666 `guid` int(11) unsigned NOT NULL default '0' COMMENT 'Global Unique Identifier',
667 `quest` int(11) unsigned NOT NULL default '0' COMMENT 'Quest Identifier',
668 `status` int(11) unsigned NOT NULL default '0',
669 `rewarded` tinyint(1) unsigned NOT NULL default '0',
670 `explored` tinyint(1) unsigned NOT NULL default '0',
671 `timer` bigint(20) unsigned NOT NULL default '0',
672 `mobcount1` int(11) unsigned NOT NULL default '0',
673 `mobcount2` int(11) unsigned NOT NULL default '0',
674 `mobcount3` int(11) unsigned NOT NULL default '0',
675 `mobcount4` int(11) unsigned NOT NULL default '0',
676 `itemcount1` int(11) unsigned NOT NULL default '0',
677 `itemcount2` int(11) unsigned NOT NULL default '0',
678 `itemcount3` int(11) unsigned NOT NULL default '0',
679 `itemcount4` int(11) unsigned NOT NULL default '0',
680 PRIMARY KEY (`guid`,`quest`)
681 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Player System';
684 -- Dumping data for table `character_queststatus`
687 LOCK TABLES `character_queststatus` WRITE;
688 /*!40000 ALTER TABLE `character_queststatus` DISABLE KEYS */;
689 /*!40000 ALTER TABLE `character_queststatus` ENABLE KEYS */;
693 -- Table structure for table `character_queststatus_daily`
696 DROP TABLE IF EXISTS `character_queststatus_daily`;
697 CREATE TABLE `character_queststatus_daily` (
698 `guid` int(11) unsigned NOT NULL default '0' COMMENT 'Global Unique Identifier',
699 `quest` int(11) unsigned NOT NULL default '0' COMMENT 'Quest Identifier',
700 `time` bigint(20) unsigned NOT NULL default '0',
701 PRIMARY KEY (`guid`,`quest`),
702 KEY `idx_guid` (`guid`)
703 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Player System';
706 -- Dumping data for table `character_queststatus_daily`
709 LOCK TABLES `character_queststatus_daily` WRITE;
710 /*!40000 ALTER TABLE `character_queststatus_daily` DISABLE KEYS */;
711 /*!40000 ALTER TABLE `character_queststatus_daily` ENABLE KEYS */;
715 -- Table structure for table `character_reputation`
718 DROP TABLE IF EXISTS `character_reputation`;
719 CREATE TABLE `character_reputation` (
720 `guid` int(11) unsigned NOT NULL default '0' COMMENT 'Global Unique Identifier',
721 `faction` int(11) unsigned NOT NULL default '0',
722 `standing` int(11) NOT NULL default '0',
723 `flags` int(11) NOT NULL default '0',
724 PRIMARY KEY (`guid`,`faction`)
725 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Player System';
728 -- Dumping data for table `character_reputation`
731 LOCK TABLES `character_reputation` WRITE;
732 /*!40000 ALTER TABLE `character_reputation` DISABLE KEYS */;
733 /*!40000 ALTER TABLE `character_reputation` ENABLE KEYS */;
737 -- Table structure for table `character_skills`
740 DROP TABLE IF EXISTS `character_skills`;
741 CREATE TABLE `character_skills` (
742 `guid` int(11) unsigned NOT NULL COMMENT 'Global Unique Identifier',
743 `skill` mediumint(9) unsigned NOT NULL,
744 `value` mediumint(9) unsigned NOT NULL,
745 `max` mediumint(9) unsigned NOT NULL,
746 PRIMARY KEY (`guid`,`skill`)
747 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Player System';
750 -- Dumping data for table `character_skills`
753 LOCK TABLES `character_skills` WRITE;
754 /*!40000 ALTER TABLE `character_skills` DISABLE KEYS */;
755 /*!40000 ALTER TABLE `character_skills` ENABLE KEYS */;
759 -- Table structure for table `character_social`
762 DROP TABLE IF EXISTS `character_social`;
763 CREATE TABLE `character_social` (
764 `guid` int(11) unsigned NOT NULL default '0' COMMENT 'Character Global Unique Identifier',
765 `friend` int(11) unsigned NOT NULL default '0' COMMENT 'Friend Global Unique Identifier',
766 `flags` tinyint(1) unsigned NOT NULL default '0' COMMENT 'Friend Flags',
767 `note` varchar(48) NOT NULL DEFAULT '' COMMENT 'Friend Note',
768 PRIMARY KEY (`guid`,`friend`,`flags`),
770 KEY `friend` (`friend`),
771 KEY `guid_flags` (`guid`,`flags`),
772 KEY `friend_flags` (`friend`,`flags`)
773 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Player System';
776 -- Dumping data for table `character_social`
779 LOCK TABLES `character_social` WRITE;
780 /*!40000 ALTER TABLE `character_social` DISABLE KEYS */;
781 /*!40000 ALTER TABLE `character_social` ENABLE KEYS */;
785 -- Table structure for table `character_spell`
788 DROP TABLE IF EXISTS `character_spell`;
789 CREATE TABLE `character_spell` (
790 `guid` int(11) unsigned NOT NULL default '0' COMMENT 'Global Unique Identifier',
791 `spell` int(11) unsigned NOT NULL default '0' COMMENT 'Spell Identifier',
792 `active` tinyint(3) unsigned NOT NULL default '1',
793 `disabled` tinyint(3) unsigned NOT NULL default '0',
794 PRIMARY KEY (`guid`,`spell`)
795 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Player System';
798 -- Dumping data for table `character_spell`
801 LOCK TABLES `character_spell` WRITE;
802 /*!40000 ALTER TABLE `character_spell` DISABLE KEYS */;
803 /*!40000 ALTER TABLE `character_spell` ENABLE KEYS */;
807 -- Table structure for table `character_spell_cooldown`
810 DROP TABLE IF EXISTS `character_spell_cooldown`;
811 CREATE TABLE `character_spell_cooldown` (
812 `guid` int(11) unsigned NOT NULL default '0' COMMENT 'Global Unique Identifier, Low part',
813 `spell` int(11) unsigned NOT NULL default '0' COMMENT 'Spell Identifier',
814 `item` int(11) unsigned NOT NULL default '0' COMMENT 'Item Identifier',
815 `time` bigint(20) unsigned NOT NULL default '0',
816 PRIMARY KEY (`guid`,`spell`)
817 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
820 -- Dumping data for table `character_spell_cooldown`
823 LOCK TABLES `character_spell_cooldown` WRITE;
824 /*!40000 ALTER TABLE `character_spell_cooldown` DISABLE KEYS */;
825 /*!40000 ALTER TABLE `character_spell_cooldown` ENABLE KEYS */;
829 -- Table structure for table `character_ticket`
832 DROP TABLE IF EXISTS `character_ticket`;
833 CREATE TABLE `character_ticket` (
834 `ticket_id` int(11) unsigned NOT NULL auto_increment,
835 `guid` int(11) unsigned NOT NULL default '0',
837 `response_text` text,
838 `ticket_lastchange` TIMESTAMP ON UPDATE CURRENT_TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
839 PRIMARY KEY (`ticket_id`)
840 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Player System';
843 -- Dumping data for table `character_ticket`
846 LOCK TABLES `character_ticket` WRITE;
847 /*!40000 ALTER TABLE `character_ticket` DISABLE KEYS */;
848 /*!40000 ALTER TABLE `character_ticket` ENABLE KEYS */;
852 -- Table structure for table `character_tutorial`
855 DROP TABLE IF EXISTS `character_tutorial`;
856 CREATE TABLE `character_tutorial` (
857 `account` bigint(20) unsigned NOT NULL auto_increment COMMENT 'Account Identifier',
858 `realmid` int(11) unsigned NOT NULL default '0' COMMENT 'Realm Identifier',
859 `tut0` int(11) unsigned NOT NULL default '0',
860 `tut1` int(11) unsigned NOT NULL default '0',
861 `tut2` int(11) unsigned NOT NULL default '0',
862 `tut3` int(11) unsigned NOT NULL default '0',
863 `tut4` int(11) unsigned NOT NULL default '0',
864 `tut5` int(11) unsigned NOT NULL default '0',
865 `tut6` int(11) unsigned NOT NULL default '0',
866 `tut7` int(11) unsigned NOT NULL default '0',
867 PRIMARY KEY (`account`,`realmid`),
868 KEY acc_key (`account`)
869 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Player System';
872 -- Dumping data for table `character_tutorial`
875 LOCK TABLES `character_tutorial` WRITE;
876 /*!40000 ALTER TABLE `character_tutorial` DISABLE KEYS */;
877 /*!40000 ALTER TABLE `character_tutorial` ENABLE KEYS */;
881 -- Table structure for table `corpse`
884 DROP TABLE IF EXISTS `corpse`;
885 CREATE TABLE `corpse` (
886 `guid` int(11) unsigned NOT NULL default '0' COMMENT 'Global Unique Identifier',
887 `player` int(11) unsigned NOT NULL default '0' COMMENT 'Character Global Unique Identifier',
888 `position_x` float NOT NULL default '0',
889 `position_y` float NOT NULL default '0',
890 `position_z` float NOT NULL default '0',
891 `orientation` float NOT NULL default '0',
892 `zone` int(11) unsigned NOT NULL default '38' COMMENT 'Zone Identifier',
893 `map` int(11) unsigned NOT NULL default '0' COMMENT 'Map Identifier',
894 `phaseMask` smallint(5) unsigned NOT NULL default '1',
896 `time` bigint(20) unsigned NOT NULL default '0',
897 `corpse_type` tinyint(3) unsigned NOT NULL default '0',
898 `instance` int(11) unsigned NOT NULL default '0',
899 PRIMARY KEY (`guid`),
900 KEY `idx_type` (`corpse_type`),
901 KEY `instance` (`instance`)
902 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Death System';
905 -- Dumping data for table `corpse`
908 LOCK TABLES `corpse` WRITE;
909 /*!40000 ALTER TABLE `corpse` DISABLE KEYS */;
910 /*!40000 ALTER TABLE `corpse` ENABLE KEYS */;
914 -- Table structure for table `groups`
917 DROP TABLE IF EXISTS `groups`;
918 CREATE TABLE `groups` (
919 `groupId` int(11) unsigned NOT NULL,
920 `leaderGuid` int(11) unsigned NOT NULL,
921 `mainTank` int(11) unsigned NOT NULL,
922 `mainAssistant` int(11) unsigned NOT NULL,
923 `lootMethod` tinyint(4) unsigned NOT NULL,
924 `looterGuid` int(11) unsigned NOT NULL,
925 `lootThreshold` tinyint(4) unsigned NOT NULL,
926 `icon1` int(11) unsigned NOT NULL,
927 `icon2` int(11) unsigned NOT NULL,
928 `icon3` int(11) unsigned NOT NULL,
929 `icon4` int(11) unsigned NOT NULL,
930 `icon5` int(11) unsigned NOT NULL,
931 `icon6` int(11) unsigned NOT NULL,
932 `icon7` int(11) unsigned NOT NULL,
933 `icon8` int(11) unsigned NOT NULL,
934 `isRaid` tinyint(1) unsigned NOT NULL,
935 `difficulty` tinyint(3) unsigned NOT NULL default '0',
936 `raiddifficulty` int(11) UNSIGNED NOT NULL default '0',
937 PRIMARY KEY (`groupId`),
938 UNIQUE KEY (`leaderGuid`)
939 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Groups';
942 -- Dumping data for table `groups`
945 LOCK TABLES `groups` WRITE;
946 /*!40000 ALTER TABLE `groups` DISABLE KEYS */;
947 /*!40000 ALTER TABLE `groups` ENABLE KEYS */;
950 -- ----------------------------
951 -- Table structure for group_instance
952 -- ----------------------------
953 DROP TABLE IF EXISTS `group_instance`;
954 CREATE TABLE `group_instance` (
955 `leaderGuid` int(11) unsigned NOT NULL default '0',
956 `instance` int(11) unsigned NOT NULL default '0',
957 `permanent` tinyint(1) unsigned NOT NULL default '0',
958 PRIMARY KEY (`leaderGuid`,`instance`),
959 KEY `instance` (`instance`)
960 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
963 -- Dumping data for table `group_instance`
966 LOCK TABLES `group_instance` WRITE;
967 /*!40000 ALTER TABLE `group_instance` DISABLE KEYS */;
968 /*!40000 ALTER TABLE `group_instance` ENABLE KEYS */;
972 -- Table structure for table `group_member`
975 DROP TABLE IF EXISTS `group_member`;
976 CREATE TABLE `group_member` (
977 `groupId` int(11) unsigned NOT NULL,
978 `memberGuid` int(11) unsigned NOT NULL,
979 `assistant` tinyint(1) unsigned NOT NULL,
980 `subgroup` smallint(6) unsigned NOT NULL,
981 PRIMARY KEY (`groupId`,`memberGuid`)
982 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Groups';
985 -- Dumping data for table `group_member`
988 LOCK TABLES `group_member` WRITE;
989 /*!40000 ALTER TABLE `group_member` DISABLE KEYS */;
990 /*!40000 ALTER TABLE `group_member` ENABLE KEYS */;
994 -- Table structure for table `guild`
997 DROP TABLE IF EXISTS `guild`;
998 CREATE TABLE `guild` (
999 `guildid` int(6) unsigned NOT NULL default '0',
1000 `name` varchar(255) NOT NULL default '',
1001 `leaderguid` int(6) unsigned NOT NULL default '0',
1002 `EmblemStyle` int(5) NOT NULL default '0',
1003 `EmblemColor` int(5) NOT NULL default '0',
1004 `BorderStyle` int(5) NOT NULL default '0',
1005 `BorderColor` int(5) NOT NULL default '0',
1006 `BackgroundColor` int(5) NOT NULL default '0',
1007 `info` text NOT NULL,
1008 `motd` varchar(255) NOT NULL default '',
1009 `createdate` bigint(20) NOT NULL default '0',
1010 `BankMoney` bigint(20) NOT NULL default '0',
1011 PRIMARY KEY (`guildid`)
1012 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Guild System';
1015 -- Dumping data for table `guild`
1018 LOCK TABLES `guild` WRITE;
1019 /*!40000 ALTER TABLE `guild` DISABLE KEYS */;
1020 /*!40000 ALTER TABLE `guild` ENABLE KEYS */;
1024 -- Table structure for table `guild_bank_eventlog`
1027 DROP TABLE IF EXISTS `guild_bank_eventlog`;
1028 CREATE TABLE `guild_bank_eventlog` (
1029 `guildid` int(11) unsigned NOT NULL default '0' COMMENT 'Guild Identificator',
1030 `LogGuid` int(11) unsigned NOT NULL default '0' COMMENT 'Log record identificator - auxiliary column',
1031 `TabId` tinyint(3) unsigned NOT NULL default '0' COMMENT 'Guild bank TabId',
1032 `EventType` tinyint(3) unsigned NOT NULL default '0' COMMENT 'Event type',
1033 `PlayerGuid` int(11) unsigned NOT NULL default '0',
1034 `ItemOrMoney` int(11) unsigned NOT NULL default '0',
1035 `ItemStackCount` tinyint(3) unsigned NOT NULL default '0',
1036 `DestTabId` tinyint(1) unsigned NOT NULL default '0' COMMENT 'Destination Tab Id',
1037 `TimeStamp` bigint(20) unsigned NOT NULL default '0' COMMENT 'Event UNIX time',
1038 PRIMARY KEY (`guildid`,`LogGuid`,`TabId`),
1039 KEY `guildid_key` (`guildid`)
1040 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1043 -- Dumping data for table `guild_bank_eventlog`
1046 LOCK TABLES `guild_bank_eventlog` WRITE;
1047 /*!40000 ALTER TABLE `guild_bank_eventlog` DISABLE KEYS */;
1048 /*!40000 ALTER TABLE `guild_bank_eventlog` ENABLE KEYS */;
1052 -- Table structure for table `guild_bank_item`
1055 DROP TABLE IF EXISTS `guild_bank_item`;
1056 CREATE TABLE `guild_bank_item` (
1057 `guildid` int(11) unsigned NOT NULL default '0',
1058 `TabId` tinyint(1) unsigned NOT NULL default '0',
1059 `SlotId` tinyint(3) unsigned NOT NULL default '0',
1060 `item_guid` int(11) unsigned NOT NULL default '0',
1061 `item_entry` int(11) unsigned NOT NULL default '0',
1062 PRIMARY KEY (`guildid`,`tabid`,`slotid`),
1063 KEY `guildid_key` (`guildid`)
1064 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1067 -- Dumping data for table `guild_bank_item`
1070 LOCK TABLES `guild_bank_item` WRITE;
1071 /*!40000 ALTER TABLE `guild_bank_item` DISABLE KEYS */;
1072 /*!40000 ALTER TABLE `guild_bank_item` ENABLE KEYS */;
1076 -- Table structure for table `guild_bank_right`
1079 DROP TABLE IF EXISTS `guild_bank_right`;
1080 CREATE TABLE `guild_bank_right` (
1081 `guildid` int(11) unsigned NOT NULL default '0',
1082 `TabId` tinyint(1) unsigned NOT NULL default '0',
1083 `rid` int(11) unsigned NOT NULL default '0',
1084 `gbright` tinyint(3) unsigned NOT NULL default '0',
1085 `SlotPerDay` int(11) unsigned NOT NULL default '0',
1086 PRIMARY KEY (`guildid`,`TabId`,`rid`),
1087 KEY `guildid_key` (`guildid`)
1088 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1091 -- Dumping data for table `guild_bank_right`
1094 LOCK TABLES `guild_bank_right` WRITE;
1095 /*!40000 ALTER TABLE `guild_bank_right` DISABLE KEYS */;
1096 /*!40000 ALTER TABLE `guild_bank_right` ENABLE KEYS */;
1100 -- Table structure for table `guild_bank_tab`
1103 DROP TABLE IF EXISTS `guild_bank_tab`;
1104 CREATE TABLE `guild_bank_tab` (
1105 `guildid` int(11) unsigned NOT NULL default '0',
1106 `TabId` tinyint(1) unsigned NOT NULL default '0',
1107 `TabName` varchar(100) NOT NULL default '',
1108 `TabIcon` varchar(100) NOT NULL default '',
1110 PRIMARY KEY (`guildid`,`TabId`),
1111 KEY `guildid_key` (`guildid`)
1112 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1115 -- Dumping data for table `guild_bank_tab`
1118 LOCK TABLES `guild_bank_tab` WRITE;
1119 /*!40000 ALTER TABLE `guild_bank_tab` DISABLE KEYS */;
1120 /*!40000 ALTER TABLE `guild_bank_tab` ENABLE KEYS */;
1124 -- Table structure for table `guild_eventlog`
1127 DROP TABLE IF EXISTS `guild_eventlog`;
1128 CREATE TABLE `guild_eventlog` (
1129 `guildid` int(11) NOT NULL COMMENT 'Guild Identificator',
1130 `LogGuid` int(11) NOT NULL COMMENT 'Log record identificator - auxiliary column',
1131 `EventType` tinyint(1) NOT NULL COMMENT 'Event type',
1132 `PlayerGuid1` int(11) NOT NULL COMMENT 'Player 1',
1133 `PlayerGuid2` int(11) NOT NULL COMMENT 'Player 2',
1134 `NewRank` tinyint(2) NOT NULL COMMENT 'New rank(in case promotion/demotion)',
1135 `TimeStamp` bigint(20) NOT NULL COMMENT 'Event UNIX time',
1136 PRIMARY KEY (`guildid`, `LogGuid`)
1137 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT 'Guild Eventlog';
1140 -- Dumping data for table `guild_eventlog`
1143 LOCK TABLES `guild_eventlog` WRITE;
1144 /*!40000 ALTER TABLE `guild_eventlog` DISABLE KEYS */;
1145 /*!40000 ALTER TABLE `guild_eventlog` ENABLE KEYS */;
1149 -- Table structure for table `guild_member`
1152 DROP TABLE IF EXISTS `guild_member`;
1153 CREATE TABLE `guild_member` (
1154 `guildid` int(6) unsigned NOT NULL default '0',
1155 `guid` int(11) unsigned NOT NULL default '0',
1156 `rank` tinyint(2) unsigned NOT NULL default '0',
1157 `pnote` varchar(255) NOT NULL default '',
1158 `offnote` varchar(255) NOT NULL default '',
1159 `BankResetTimeMoney` int(11) unsigned NOT NULL default '0',
1160 `BankRemMoney` int(11) unsigned NOT NULL default '0',
1161 `BankResetTimeTab0` int(11) unsigned NOT NULL default '0',
1162 `BankRemSlotsTab0` int(11) unsigned NOT NULL default '0',
1163 `BankResetTimeTab1` int(11) unsigned NOT NULL default '0',
1164 `BankRemSlotsTab1` int(11) unsigned NOT NULL default '0',
1165 `BankResetTimeTab2` int(11) unsigned NOT NULL default '0',
1166 `BankRemSlotsTab2` int(11) unsigned NOT NULL default '0',
1167 `BankResetTimeTab3` int(11) unsigned NOT NULL default '0',
1168 `BankRemSlotsTab3` int(11) unsigned NOT NULL default '0',
1169 `BankResetTimeTab4` int(11) unsigned NOT NULL default '0',
1170 `BankRemSlotsTab4` int(11) unsigned NOT NULL default '0',
1171 `BankResetTimeTab5` int(11) unsigned NOT NULL default '0',
1172 `BankRemSlotsTab5` int(11) unsigned NOT NULL default '0',
1173 KEY `guildid_key` (`guildid`),
1174 KEY `guildid_rank_key` (`guildid`,`rank`),
1175 UNIQUE KEY `guid_key` (`guid`)
1176 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Guild System';
1179 -- Dumping data for table `guild_member`
1182 LOCK TABLES `guild_member` WRITE;
1183 /*!40000 ALTER TABLE `guild_member` DISABLE KEYS */;
1184 /*!40000 ALTER TABLE `guild_member` ENABLE KEYS */;
1188 -- Table structure for table `guild_rank`
1191 DROP TABLE IF EXISTS `guild_rank`;
1192 CREATE TABLE `guild_rank` (
1193 `guildid` int(6) unsigned NOT NULL default '0',
1194 `rid` int(11) unsigned NOT NULL,
1195 `rname` varchar(255) NOT NULL default '',
1196 `rights` int(3) unsigned NOT NULL default '0',
1197 `BankMoneyPerDay` int(11) unsigned NOT NULL default '0',
1198 PRIMARY KEY (`guildid`,`rid`)
1199 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Guild System';
1202 -- Dumping data for table `guild_rank`
1205 LOCK TABLES `guild_rank` WRITE;
1206 /*!40000 ALTER TABLE `guild_rank` DISABLE KEYS */;
1207 /*!40000 ALTER TABLE `guild_rank` ENABLE KEYS */;
1211 -- Table structure for table `instance`
1214 DROP TABLE IF EXISTS `instance`;
1215 CREATE TABLE `instance` (
1216 `id` int(11) unsigned NOT NULL default '0',
1217 `map` int(11) unsigned NOT NULL default '0',
1218 `resettime` bigint(40) NOT NULL default '0',
1219 `difficulty` tinyint(1) unsigned NOT NULL default '0',
1223 KEY `resettime` (`resettime`)
1224 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1227 -- Dumping data for table `instance`
1230 LOCK TABLES `instance` WRITE;
1231 /*!40000 ALTER TABLE `instance` DISABLE KEYS */;
1232 /*!40000 ALTER TABLE `instance` ENABLE KEYS */;
1235 -- ----------------------------
1236 -- Table structure for instance_reset
1237 -- ----------------------------
1238 DROP TABLE IF EXISTS `instance_reset`;
1239 CREATE TABLE `instance_reset` (
1240 `mapid` int(11) unsigned NOT NULL default '0',
1241 `difficulty` tinyint(1) unsigned NOT NULL default '0',
1242 `resettime` bigint(40) NOT NULL default '0',
1243 PRIMARY KEY (`mapid`,`difficulty`)
1244 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1247 -- Dumping data for table `instance_reset`
1250 LOCK TABLES `instance_reset` WRITE;
1251 /*!40000 ALTER TABLE `instance_reset` DISABLE KEYS */;
1252 /*!40000 ALTER TABLE `instance_reset` ENABLE KEYS */;
1256 -- Table structure for table `item_instance`
1259 DROP TABLE IF EXISTS `item_instance`;
1260 CREATE TABLE `item_instance` (
1261 `guid` int(11) unsigned NOT NULL default '0',
1262 `owner_guid` int(11) unsigned NOT NULL default '0',
1264 PRIMARY KEY (`guid`),
1265 KEY `idx_owner_guid` (`owner_guid`)
1266 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Item System';
1269 -- Dumping data for table `item_instance`
1272 LOCK TABLES `item_instance` WRITE;
1273 /*!40000 ALTER TABLE `item_instance` DISABLE KEYS */;
1274 /*!40000 ALTER TABLE `item_instance` ENABLE KEYS */;
1278 -- Table structure for table `item_text`
1281 DROP TABLE IF EXISTS `item_text`;
1282 CREATE TABLE `item_text` (
1283 `id` int(11) unsigned NOT NULL default '0',
1286 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Item System';
1289 -- Dumping data for table `item_text`
1292 LOCK TABLES `item_text` WRITE;
1293 /*!40000 ALTER TABLE `item_text` DISABLE KEYS */;
1294 /*!40000 ALTER TABLE `item_text` ENABLE KEYS */;
1298 -- Table structure for table `mail`
1301 DROP TABLE IF EXISTS `mail`;
1302 CREATE TABLE `mail` (
1303 `id` int(11) unsigned NOT NULL default '0' COMMENT 'Identifier',
1304 `messageType` tinyint(3) unsigned NOT NULL default '0',
1305 `stationery` tinyint(3) NOT NULL default '41',
1306 `mailTemplateId` mediumint(8) unsigned NOT NULL default '0',
1307 `sender` int(11) unsigned NOT NULL default '0' COMMENT 'Character Global Unique Identifier',
1308 `receiver` int(11) unsigned NOT NULL default '0' COMMENT 'Character Global Unique Identifier',
1310 `itemTextId` int(11) unsigned NOT NULL default '0',
1311 `has_items` tinyint(3) unsigned NOT NULL default '0',
1312 `expire_time` bigint(40) NOT NULL default '0',
1313 `deliver_time` bigint(40) NOT NULL default '0',
1314 `money` int(11) unsigned NOT NULL default '0',
1315 `cod` int(11) unsigned NOT NULL default '0',
1316 `checked` tinyint(3) unsigned NOT NULL default '0',
1318 KEY `idx_receiver` (`receiver`)
1319 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Mail System';
1322 -- Dumping data for table `mail`
1325 LOCK TABLES `mail` WRITE;
1326 /*!40000 ALTER TABLE `mail` DISABLE KEYS */;
1327 /*!40000 ALTER TABLE `mail` ENABLE KEYS */;
1331 -- Table structure for table `mail_items`
1334 DROP TABLE IF EXISTS `mail_items`;
1335 CREATE TABLE `mail_items` (
1336 `mail_id` int(11) NOT NULL default '0',
1337 `item_guid` int(11) NOT NULL default '0',
1338 `item_template` int(11) NOT NULL default '0',
1339 `receiver` int(11) unsigned NOT NULL default '0' COMMENT 'Character Global Unique Identifier',
1340 PRIMARY KEY (`mail_id`,`item_guid`),
1341 KEY `idx_receiver` (`receiver`)
1342 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;
1345 -- Dumping data for table `mail_items`
1348 LOCK TABLES `mail_items` WRITE;
1349 /*!40000 ALTER TABLE `mail_items` DISABLE KEYS */;
1350 /*!40000 ALTER TABLE `mail_items` ENABLE KEYS */;
1354 -- Table structure for table `pet_aura`
1357 DROP TABLE IF EXISTS `pet_aura`;
1358 CREATE TABLE `pet_aura` (
1359 `guid` int(11) unsigned NOT NULL default '0' COMMENT 'Global Unique Identifier',
1360 `caster_guid` bigint(20) unsigned NOT NULL default '0' COMMENT 'Full Global Unique Identifier',
1361 `spell` int(11) unsigned NOT NULL default '0',
1362 `effect_index` int(11) unsigned NOT NULL default '0',
1363 `stackcount` int(11) NOT NULL default '1',
1364 `amount` int(11) NOT NULL default '0',
1365 `maxduration` int(11) NOT NULL default '0',
1366 `remaintime` int(11) NOT NULL default '0',
1367 `remaincharges` int(11) NOT NULL default '0',
1368 PRIMARY KEY (`guid`,`spell`,`effect_index`)
1369 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Pet System';
1372 -- Dumping data for table `pet_aura`
1375 LOCK TABLES `pet_aura` WRITE;
1376 /*!40000 ALTER TABLE `pet_aura` DISABLE KEYS */;
1377 /*!40000 ALTER TABLE `pet_aura` ENABLE KEYS */;
1381 -- Table structure for table `pet_spell`
1384 DROP TABLE IF EXISTS `pet_spell`;
1385 CREATE TABLE `pet_spell` (
1386 `guid` int(11) unsigned NOT NULL default '0' COMMENT 'Global Unique Identifier',
1387 `spell` int(11) unsigned NOT NULL default '0' COMMENT 'Spell Identifier',
1388 `active` int(11) unsigned NOT NULL default '0',
1389 PRIMARY KEY (`guid`,`spell`)
1390 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Pet System';
1393 -- Dumping data for table `pet_spell`
1396 LOCK TABLES `pet_spell` WRITE;
1397 /*!40000 ALTER TABLE `pet_spell` DISABLE KEYS */;
1398 /*!40000 ALTER TABLE `pet_spell` ENABLE KEYS */;
1402 -- Table structure for table `pet_spell_cooldown`
1405 DROP TABLE IF EXISTS `pet_spell_cooldown`;
1406 CREATE TABLE `pet_spell_cooldown` (
1407 `guid` int(11) unsigned NOT NULL default '0' COMMENT 'Global Unique Identifier, Low part',
1408 `spell` int(11) unsigned NOT NULL default '0' COMMENT 'Spell Identifier',
1409 `time` bigint(20) unsigned NOT NULL default '0',
1410 PRIMARY KEY (`guid`,`spell`)
1411 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1414 -- Dumping data for table `pet_spell_cooldown`
1417 LOCK TABLES `pet_spell_cooldown` WRITE;
1418 /*!40000 ALTER TABLE `pet_spell_cooldown` DISABLE KEYS */;
1419 /*!40000 ALTER TABLE `pet_spell_cooldown` ENABLE KEYS */;
1423 -- Table structure for table `petition`
1426 DROP TABLE IF EXISTS `petition`;
1427 CREATE TABLE `petition` (
1428 `ownerguid` int(10) unsigned NOT NULL,
1429 `petitionguid` int(10) unsigned default '0',
1430 `name` varchar(255) NOT NULL default '',
1431 `type` int(10) unsigned NOT NULL default '0',
1432 PRIMARY KEY (`ownerguid`,`type`),
1433 UNIQUE KEY `index_ownerguid_petitionguid` (`ownerguid`,`petitionguid`)
1434 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Guild System';
1437 -- Dumping data for table `petition`
1440 LOCK TABLES `petition` WRITE;
1441 /*!40000 ALTER TABLE `petition` DISABLE KEYS */;
1442 /*!40000 ALTER TABLE `petition` ENABLE KEYS */;
1446 -- Table structure for table `petition_sign`
1449 DROP TABLE IF EXISTS `petition_sign`;
1450 CREATE TABLE `petition_sign` (
1451 `ownerguid` int(10) unsigned NOT NULL,
1452 `petitionguid` int(11) unsigned NOT NULL default '0',
1453 `playerguid` int(11) unsigned NOT NULL default '0',
1454 `player_account` int(11) unsigned NOT NULL default '0',
1455 `type` int(10) unsigned NOT NULL default '0',
1456 PRIMARY KEY (`petitionguid`,`playerguid`)
1457 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Guild System';
1460 -- Dumping data for table `petition_sign`
1463 LOCK TABLES `petition_sign` WRITE;
1464 /*!40000 ALTER TABLE `petition_sign` DISABLE KEYS */;
1465 /*!40000 ALTER TABLE `petition_sign` ENABLE KEYS */;
1467 /*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
1470 -- Table structure for table `saved_variables`
1473 DROP TABLE IF EXISTS `saved_variables`;
1474 CREATE TABLE `saved_variables` (
1475 `NextArenaPointDistributionTime` bigint(40) UNSIGNED NOT NULL DEFAULT '0'
1476 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Variable Saves';
1479 -- Dumping data for table `saved_variables`
1482 LOCK TABLES `saved_variables` WRITE;
1483 /*!40000 ALTER TABLE `saved_variables` DISABLE KEYS */;
1484 /*!40000 ALTER TABLE `saved_variables` ENABLE KEYS */;
1486 /*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
1489 /*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
1490 /*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
1491 /*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
1492 /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
1493 /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
1494 /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
1495 /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
1497 -- Dump completed on 2008-01-10 11:37:06