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_7207_03_characters_corpse` 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` longtext 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 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
103 -- Dumping data for table `arena_team_member`
106 LOCK TABLES `arena_team_member` WRITE;
107 /*!40000 ALTER TABLE `arena_team_member` DISABLE KEYS */;
108 /*!40000 ALTER TABLE `arena_team_member` ENABLE KEYS */;
112 -- Table structure for table `arena_team_stats`
115 DROP TABLE IF EXISTS `arena_team_stats`;
116 CREATE TABLE `arena_team_stats` (
117 `arenateamid` int(10) unsigned NOT NULL default '0',
118 `rating` int(10) unsigned NOT NULL default '0',
119 `games` int(10) unsigned NOT NULL default '0',
120 `wins` int(10) unsigned NOT NULL default '0',
121 `played` int(10) unsigned NOT NULL default '0',
122 `wins2` int(10) unsigned NOT NULL default '0',
123 `rank` int(10) unsigned NOT NULL default '0',
124 PRIMARY KEY (`arenateamid`)
125 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
128 -- Dumping data for table `arena_team_stats`
131 LOCK TABLES `arena_team_stats` WRITE;
132 /*!40000 ALTER TABLE `arena_team_stats` DISABLE KEYS */;
133 /*!40000 ALTER TABLE `arena_team_stats` ENABLE KEYS */;
137 -- Table structure for table `auctionhouse`
140 DROP TABLE IF EXISTS `auctionhouse`;
141 CREATE TABLE `auctionhouse` (
142 `id` int(11) unsigned NOT NULL default '0',
143 `auctioneerguid` int(11) unsigned NOT NULL default '0',
144 `itemguid` int(11) unsigned NOT NULL default '0',
145 `item_template` int(11) unsigned NOT NULL default '0' COMMENT 'Item Identifier',
146 `itemowner` int(11) unsigned NOT NULL default '0',
147 `buyoutprice` int(11) NOT NULL default '0',
148 `time` bigint(40) NOT NULL default '0',
149 `buyguid` int(11) unsigned NOT NULL default '0',
150 `lastbid` int(11) NOT NULL default '0',
151 `startbid` int(11) NOT NULL default '0',
152 `deposit` int(11) NOT NULL default '0',
153 `location` tinyint(3) unsigned NOT NULL default '3',
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` varchar(255) NOT NULL default '',
175 `content` varchar(255) 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 `position_x` float NOT NULL default '0',
201 `position_y` float NOT NULL default '0',
202 `position_z` float NOT NULL default '0',
203 `map` int(11) unsigned NOT NULL default '0' COMMENT 'Map Identifier',
204 `dungeon_difficulty` tinyint(1) unsigned NOT NULL DEFAULT '0',
205 `orientation` float NOT NULL default '0',
207 `online` tinyint(3) unsigned NOT NULL default '0',
208 `cinematic` tinyint(3) unsigned NOT NULL default '0',
209 `totaltime` int(11) unsigned NOT NULL default '0',
210 `leveltime` int(11) unsigned NOT NULL default '0',
211 `logout_time` bigint(20) unsigned NOT NULL default '0',
212 `is_logout_resting` tinyint(3) unsigned NOT NULL default '0',
213 `rest_bonus` float NOT NULL default '0',
214 `resettalents_cost` int(11) unsigned NOT NULL default '0',
215 `resettalents_time` bigint(20) unsigned NOT NULL default '0',
216 `trans_x` float NOT NULL default '0',
217 `trans_y` float NOT NULL default '0',
218 `trans_z` float NOT NULL default '0',
219 `trans_o` float NOT NULL default '0',
220 `transguid` bigint(20) unsigned NOT NULL default '0',
221 `extra_flags` int(11) unsigned NOT NULL default '0',
222 `stable_slots` tinyint(1) unsigned NOT NULL default '0',
223 `at_login` int(11) unsigned NOT NULL default '0',
224 `zone` int(11) unsigned NOT NULL default '0',
225 `death_expire_time` bigint(20) unsigned NOT NULL default '0',
227 `arena_pending_points` int(10) UNSIGNED NOT NULL default '0',
228 PRIMARY KEY (`guid`),
229 KEY `idx_account` (`account`),
230 KEY `idx_online` (`online`),
231 KEY `idx_name` (`name`)
232 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Player System';
235 -- Dumping data for table `characters`
238 LOCK TABLES `characters` WRITE;
239 /*!40000 ALTER TABLE `characters` DISABLE KEYS */;
240 /*!40000 ALTER TABLE `characters` ENABLE KEYS */;
244 -- Table structure for table `character_achievement`
247 DROP TABLE IF EXISTS `character_achievement`;
248 CREATE TABLE `character_achievement` (
249 `guid` int(11) NOT NULL,
250 `achievement` int(11) NOT NULL,
251 `date` int(11) NOT NULL,
252 PRIMARY KEY (`guid`,`achievement`)
253 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
256 -- Dumping data for table `character_achievement`
259 LOCK TABLES `character_achievement` WRITE;
260 /*!40000 ALTER TABLE `character_achievement` DISABLE KEYS */;
261 /*!40000 ALTER TABLE `character_achievement` ENABLE KEYS */;
265 -- Table structure for table `character_achievement_progress`
268 DROP TABLE IF EXISTS `character_achievement_progress`;
269 CREATE TABLE `character_achievement_progress` (
270 `guid` int(11) NOT NULL,
271 `criteria` int(11) NOT NULL,
272 `counter` int(11) NOT NULL,
273 `date` int(11) NOT NULL,
274 PRIMARY KEY (`guid`,`criteria`)
275 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
278 -- Dumping data for table `character_achievement_progress`
281 LOCK TABLES `character_achievement_progress` WRITE;
282 /*!40000 ALTER TABLE `character_achievement_progress` DISABLE KEYS */;
283 /*!40000 ALTER TABLE `character_achievement_progress` ENABLE KEYS */;
287 -- Table structure for table `character_action`
290 DROP TABLE IF EXISTS `character_action`;
291 CREATE TABLE `character_action` (
292 `guid` int(11) unsigned NOT NULL default '0' COMMENT 'Global Unique Identifier',
293 `button` tinyint(3) unsigned NOT NULL default '0',
294 `action` smallint(5) unsigned NOT NULL default '0',
295 `type` tinyint(3) unsigned NOT NULL default '0',
296 `misc` tinyint(3) unsigned NOT NULL default '0',
297 PRIMARY KEY (`guid`,`button`)
298 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Player System';
301 -- Dumping data for table `character_action`
304 LOCK TABLES `character_action` WRITE;
305 /*!40000 ALTER TABLE `character_action` DISABLE KEYS */;
306 /*!40000 ALTER TABLE `character_action` ENABLE KEYS */;
310 -- Table structure for table `character_aura`
313 DROP TABLE IF EXISTS `character_aura`;
314 CREATE TABLE `character_aura` (
315 `guid` int(11) unsigned NOT NULL default '0' COMMENT 'Global Unique Identifier',
316 `caster_guid` bigint(20) unsigned NOT NULL default '0' COMMENT 'Full Global Unique Identifier',
317 `spell` int(11) unsigned NOT NULL default '0',
318 `effect_index` int(11) unsigned NOT NULL default '0',
319 `stackcount` int(11) NOT NULL default '1',
320 `amount` int(11) NOT NULL default '0',
321 `maxduration` int(11) NOT NULL default '0',
322 `remaintime` int(11) NOT NULL default '0',
323 `remaincharges` int(11) NOT NULL default '0',
324 PRIMARY KEY (`guid`,`spell`,`effect_index`)
325 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Player System';
328 -- Dumping data for table `character_aura`
331 LOCK TABLES `character_aura` WRITE;
332 /*!40000 ALTER TABLE `character_aura` DISABLE KEYS */;
333 /*!40000 ALTER TABLE `character_aura` ENABLE KEYS */;
337 -- Table structure for table `character_declinedname`
340 DROP TABLE IF EXISTS `character_declinedname`;
341 CREATE TABLE `character_declinedname` (
342 `guid` int(11) unsigned NOT NULL default '0' COMMENT 'Global Unique Identifier',
343 `genitive` varchar(15) NOT NULL default '',
344 `dative` varchar(15) NOT NULL default '',
345 `accusative` varchar(15) NOT NULL default '',
346 `instrumental` varchar(15) NOT NULL default '',
347 `prepositional` varchar(15) NOT NULL default '',
349 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;
352 -- Dumping data for table `character_declinedname`
355 LOCK TABLES `character_declinedname` WRITE;
356 /*!40000 ALTER TABLE `character_declinedname` DISABLE KEYS */;
357 /*!40000 ALTER TABLE `character_declinedname` ENABLE KEYS */;
361 -- Table structure for table `character_gifts`
364 DROP TABLE IF EXISTS `character_gifts`;
365 CREATE TABLE `character_gifts` (
366 `guid` int(20) unsigned NOT NULL default '0',
367 `item_guid` int(11) unsigned NOT NULL default '0',
368 `entry` int(20) unsigned NOT NULL default '0',
369 `flags` int(20) unsigned NOT NULL default '0',
370 PRIMARY KEY (`item_guid`),
371 KEY `idx_guid` (`guid`)
372 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
375 -- Dumping data for table `character_gifts`
378 LOCK TABLES `character_gifts` WRITE;
379 /*!40000 ALTER TABLE `character_gifts` DISABLE KEYS */;
380 /*!40000 ALTER TABLE `character_gifts` ENABLE KEYS */;
384 -- Table structure for table `character_homebind`
387 DROP TABLE IF EXISTS `character_homebind`;
388 CREATE TABLE `character_homebind` (
389 `guid` int(11) unsigned NOT NULL default '0' COMMENT 'Global Unique Identifier',
390 `map` int(11) unsigned NOT NULL default '0' COMMENT 'Map Identifier',
391 `zone` int(11) unsigned NOT NULL default '0' COMMENT 'Zone Identifier',
392 `position_x` float NOT NULL default '0',
393 `position_y` float NOT NULL default '0',
394 `position_z` float NOT NULL default '0',
396 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Player System';
399 -- Dumping data for table `character_homebind`
402 LOCK TABLES `character_homebind` WRITE;
403 /*!40000 ALTER TABLE `character_homebind` DISABLE KEYS */;
404 /*!40000 ALTER TABLE `character_homebind` ENABLE KEYS */;
408 -- Table structure for table `character_instance`
411 DROP TABLE IF EXISTS `character_instance`;
412 CREATE TABLE `character_instance` (
413 `guid` int(11) unsigned NOT NULL default '0',
414 `instance` int(11) unsigned NOT NULL default '0',
415 `permanent` tinyint(1) unsigned NOT NULL default '0',
416 PRIMARY KEY (`guid`,`instance`),
417 KEY `instance` (`instance`)
418 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
421 -- Dumping data for table `character_instance`
424 LOCK TABLES `character_instance` WRITE;
425 /*!40000 ALTER TABLE `character_instance` DISABLE KEYS */;
426 /*!40000 ALTER TABLE `character_instance` ENABLE KEYS */;
430 -- Table structure for table `character_inventory`
433 DROP TABLE IF EXISTS `character_inventory`;
434 CREATE TABLE `character_inventory` (
435 `guid` int(11) unsigned NOT NULL default '0' COMMENT 'Global Unique Identifier',
436 `bag` int(11) unsigned NOT NULL default '0',
437 `slot` tinyint(3) unsigned NOT NULL default '0',
438 `item` int(11) unsigned NOT NULL default '0' COMMENT 'Item Global Unique Identifier',
439 `item_template` int(11) unsigned NOT NULL default '0' COMMENT 'Item Identifier',
440 PRIMARY KEY (`item`),
441 KEY `idx_guid` (`guid`)
442 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Player System';
445 -- Dumping data for table `character_inventory`
448 LOCK TABLES `character_inventory` WRITE;
449 /*!40000 ALTER TABLE `character_inventory` DISABLE KEYS */;
450 /*!40000 ALTER TABLE `character_inventory` ENABLE KEYS */;
454 -- Table structure for table `character_pet`
457 DROP TABLE IF EXISTS `character_pet`;
458 CREATE TABLE `character_pet` (
459 `id` int(11) unsigned NOT NULL default '0',
460 `entry` int(11) unsigned NOT NULL default '0',
461 `owner` int(11) unsigned NOT NULL default '0',
462 `modelid` int(11) unsigned default '0',
463 `CreatedBySpell` int(11) unsigned NOT NULL default '0',
464 `PetType` tinyint(3) unsigned NOT NULL default '0',
465 `level` int(11) unsigned NOT NULL default '1',
466 `exp` int(11) unsigned NOT NULL default '0',
467 `Reactstate` tinyint(1) unsigned NOT NULL default '0',
468 `talentpoints` int(11) unsigned NOT NULL default '0',
469 `name` varchar(100) default 'Pet',
470 `renamed` tinyint(1) unsigned NOT NULL default '0',
471 `slot` int(11) unsigned NOT NULL default '0',
472 `curhealth` int(11) unsigned NOT NULL default '1',
473 `curmana` int(11) unsigned NOT NULL default '0',
474 `curhappiness` int(11) unsigned NOT NULL default '0',
475 `savetime` bigint(20) unsigned NOT NULL default '0',
476 `resettalents_cost` int(11) unsigned NOT NULL default '0',
477 `resettalents_time` bigint(20) unsigned NOT NULL default '0',
479 `teachspelldata` longtext,
481 KEY `owner` (`owner`)
482 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Pet System';
485 -- Dumping data for table `character_pet`
488 LOCK TABLES `character_pet` WRITE;
489 /*!40000 ALTER TABLE `character_pet` DISABLE KEYS */;
490 /*!40000 ALTER TABLE `character_pet` ENABLE KEYS */;
494 -- Table structure for table `character_pet_declinedname`
497 DROP TABLE IF EXISTS `character_pet_declinedname`;
498 CREATE TABLE `character_pet_declinedname` (
499 `id` int(11) unsigned NOT NULL default '0',
500 `owner` int(11) unsigned NOT NULL default '0',
501 `genitive` varchar(12) NOT NULL default '',
502 `dative` varchar(12) NOT NULL default '',
503 `accusative` varchar(12) NOT NULL default '',
504 `instrumental` varchar(12) NOT NULL default '',
505 `prepositional` varchar(12) NOT NULL default '',
507 KEY owner_key (`owner`)
508 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;
511 -- Dumping data for table `character_pet_declinedname`
514 LOCK TABLES `character_pet_declinedname` WRITE;
515 /*!40000 ALTER TABLE `character_pet_declinedname` DISABLE KEYS */;
516 /*!40000 ALTER TABLE `character_pet_declinedname` ENABLE KEYS */;
520 -- Table structure for table `character_queststatus`
523 DROP TABLE IF EXISTS `character_queststatus`;
524 CREATE TABLE `character_queststatus` (
525 `guid` int(11) unsigned NOT NULL default '0' COMMENT 'Global Unique Identifier',
526 `quest` int(11) unsigned NOT NULL default '0' COMMENT 'Quest Identifier',
527 `status` int(11) unsigned NOT NULL default '0',
528 `rewarded` tinyint(1) unsigned NOT NULL default '0',
529 `explored` tinyint(1) unsigned NOT NULL default '0',
530 `timer` bigint(20) unsigned NOT NULL default '0',
531 `mobcount1` int(11) unsigned NOT NULL default '0',
532 `mobcount2` int(11) unsigned NOT NULL default '0',
533 `mobcount3` int(11) unsigned NOT NULL default '0',
534 `mobcount4` int(11) unsigned NOT NULL default '0',
535 `itemcount1` int(11) unsigned NOT NULL default '0',
536 `itemcount2` int(11) unsigned NOT NULL default '0',
537 `itemcount3` int(11) unsigned NOT NULL default '0',
538 `itemcount4` int(11) unsigned NOT NULL default '0',
539 PRIMARY KEY (`guid`,`quest`)
540 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Player System';
543 -- Dumping data for table `character_queststatus`
546 LOCK TABLES `character_queststatus` WRITE;
547 /*!40000 ALTER TABLE `character_queststatus` DISABLE KEYS */;
548 /*!40000 ALTER TABLE `character_queststatus` ENABLE KEYS */;
552 -- Table structure for table `character_queststatus_daily`
555 DROP TABLE IF EXISTS `character_queststatus_daily`;
556 CREATE TABLE `character_queststatus_daily` (
557 `guid` int(11) unsigned NOT NULL default '0' COMMENT 'Global Unique Identifier',
558 `quest` int(11) unsigned NOT NULL default '0' COMMENT 'Quest Identifier',
559 `time` bigint(20) unsigned NOT NULL default '0',
560 PRIMARY KEY (`guid`,`quest`),
561 KEY `idx_guid` (`guid`)
562 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Player System';
565 -- Dumping data for table `character_queststatus_daily`
568 LOCK TABLES `character_queststatus_daily` WRITE;
569 /*!40000 ALTER TABLE `character_queststatus_daily` DISABLE KEYS */;
570 /*!40000 ALTER TABLE `character_queststatus_daily` ENABLE KEYS */;
574 -- Table structure for table `character_reputation`
577 DROP TABLE IF EXISTS `character_reputation`;
578 CREATE TABLE `character_reputation` (
579 `guid` int(11) unsigned NOT NULL default '0' COMMENT 'Global Unique Identifier',
580 `faction` int(11) unsigned NOT NULL default '0',
581 `standing` int(11) NOT NULL default '0',
582 `flags` int(11) NOT NULL default '0',
583 PRIMARY KEY (`guid`,`faction`)
584 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Player System';
587 -- Dumping data for table `character_reputation`
590 LOCK TABLES `character_reputation` WRITE;
591 /*!40000 ALTER TABLE `character_reputation` DISABLE KEYS */;
592 /*!40000 ALTER TABLE `character_reputation` ENABLE KEYS */;
596 -- Table structure for table `character_social`
599 DROP TABLE IF EXISTS `character_social`;
600 CREATE TABLE `character_social` (
601 `guid` int(11) unsigned NOT NULL default '0' COMMENT 'Character Global Unique Identifier',
602 `friend` int(11) unsigned NOT NULL default '0' COMMENT 'Friend Global Unique Identifier',
603 `flags` tinyint(1) unsigned NOT NULL default '0' COMMENT 'Friend Flags',
604 `note` varchar(48) NOT NULL DEFAULT '' COMMENT 'Friend Note',
605 PRIMARY KEY (`guid`,`friend`,`flags`),
607 KEY `friend` (`friend`),
608 KEY `guid_flags` (`guid`,`flags`),
609 KEY `friend_flags` (`friend`,`flags`)
610 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Player System';
613 -- Dumping data for table `character_social`
616 LOCK TABLES `character_social` WRITE;
617 /*!40000 ALTER TABLE `character_social` DISABLE KEYS */;
618 /*!40000 ALTER TABLE `character_social` ENABLE KEYS */;
622 -- Table structure for table `character_spell`
625 DROP TABLE IF EXISTS `character_spell`;
626 CREATE TABLE `character_spell` (
627 `guid` int(11) unsigned NOT NULL default '0' COMMENT 'Global Unique Identifier',
628 `spell` int(11) unsigned NOT NULL default '0' COMMENT 'Spell Identifier',
629 `active` tinyint(3) unsigned NOT NULL default '1',
630 `disabled` tinyint(3) unsigned NOT NULL default '0',
631 PRIMARY KEY (`guid`,`spell`)
632 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Player System';
635 -- Dumping data for table `character_spell`
638 LOCK TABLES `character_spell` WRITE;
639 /*!40000 ALTER TABLE `character_spell` DISABLE KEYS */;
640 /*!40000 ALTER TABLE `character_spell` ENABLE KEYS */;
644 -- Table structure for table `character_spell_cooldown`
647 DROP TABLE IF EXISTS `character_spell_cooldown`;
648 CREATE TABLE `character_spell_cooldown` (
649 `guid` int(11) unsigned NOT NULL default '0' COMMENT 'Global Unique Identifier, Low part',
650 `spell` int(11) unsigned NOT NULL default '0' COMMENT 'Spell Identifier',
651 `item` int(11) unsigned NOT NULL default '0' COMMENT 'Item Identifier',
652 `time` bigint(20) unsigned NOT NULL default '0',
653 PRIMARY KEY (`guid`,`spell`)
654 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
657 -- Dumping data for table `character_spell_cooldown`
660 LOCK TABLES `character_spell_cooldown` WRITE;
661 /*!40000 ALTER TABLE `character_spell_cooldown` DISABLE KEYS */;
662 /*!40000 ALTER TABLE `character_spell_cooldown` ENABLE KEYS */;
666 -- Table structure for table `character_ticket`
669 DROP TABLE IF EXISTS `character_ticket`;
670 CREATE TABLE `character_ticket` (
671 `ticket_id` int(11) unsigned NOT NULL auto_increment,
672 `guid` int(11) unsigned NOT NULL default '0',
674 `ticket_lastchange` TIMESTAMP ON UPDATE CURRENT_TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
675 PRIMARY KEY (`ticket_id`)
676 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Player System';
679 -- Dumping data for table `character_ticket`
682 LOCK TABLES `character_ticket` WRITE;
683 /*!40000 ALTER TABLE `character_ticket` DISABLE KEYS */;
684 /*!40000 ALTER TABLE `character_ticket` ENABLE KEYS */;
688 -- Table structure for table `character_tutorial`
691 DROP TABLE IF EXISTS `character_tutorial`;
692 CREATE TABLE `character_tutorial` (
693 `account` bigint(20) unsigned NOT NULL auto_increment COMMENT 'Account Identifier',
694 `realmid` int(11) unsigned NOT NULL default '0' COMMENT 'Realm Identifier',
695 `tut0` int(11) unsigned NOT NULL default '0',
696 `tut1` int(11) unsigned NOT NULL default '0',
697 `tut2` int(11) unsigned NOT NULL default '0',
698 `tut3` int(11) unsigned NOT NULL default '0',
699 `tut4` int(11) unsigned NOT NULL default '0',
700 `tut5` int(11) unsigned NOT NULL default '0',
701 `tut6` int(11) unsigned NOT NULL default '0',
702 `tut7` int(11) unsigned NOT NULL default '0',
703 PRIMARY KEY (`account`,`realmid`),
704 KEY acc_key (`account`)
705 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Player System';
708 -- Dumping data for table `character_tutorial`
711 LOCK TABLES `character_tutorial` WRITE;
712 /*!40000 ALTER TABLE `character_tutorial` DISABLE KEYS */;
713 /*!40000 ALTER TABLE `character_tutorial` ENABLE KEYS */;
717 -- Table structure for table `corpse`
720 DROP TABLE IF EXISTS `corpse`;
721 CREATE TABLE `corpse` (
722 `guid` int(11) unsigned NOT NULL default '0' COMMENT 'Global Unique Identifier',
723 `player` int(11) unsigned NOT NULL default '0' COMMENT 'Character Global Unique Identifier',
724 `position_x` float NOT NULL default '0',
725 `position_y` float NOT NULL default '0',
726 `position_z` float NOT NULL default '0',
727 `orientation` float NOT NULL default '0',
728 `zone` int(11) unsigned NOT NULL default '38' COMMENT 'Zone Identifier',
729 `map` int(11) unsigned NOT NULL default '0' COMMENT 'Map Identifier',
730 `phaseMask` smallint(5) unsigned NOT NULL default '1',
732 `time` bigint(20) unsigned NOT NULL default '0',
733 `corpse_type` tinyint(3) unsigned NOT NULL default '0',
734 `instance` int(11) unsigned NOT NULL default '0',
735 PRIMARY KEY (`guid`),
736 KEY `idx_type` (`corpse_type`),
737 KEY `instance` (`instance`)
738 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Death System';
741 -- Dumping data for table `corpse`
744 LOCK TABLES `corpse` WRITE;
745 /*!40000 ALTER TABLE `corpse` DISABLE KEYS */;
746 /*!40000 ALTER TABLE `corpse` ENABLE KEYS */;
750 -- Table structure for table `groups`
753 DROP TABLE IF EXISTS `groups`;
754 CREATE TABLE `groups` (
755 `leaderGuid` int(11) unsigned NOT NULL,
756 `mainTank` int(11) unsigned NOT NULL,
757 `mainAssistant` int(11) unsigned NOT NULL,
758 `lootMethod` tinyint(4) unsigned NOT NULL,
759 `looterGuid` int(11) unsigned NOT NULL,
760 `lootThreshold` tinyint(4) unsigned NOT NULL,
761 `icon1` int(11) unsigned NOT NULL,
762 `icon2` int(11) unsigned NOT NULL,
763 `icon3` int(11) unsigned NOT NULL,
764 `icon4` int(11) unsigned NOT NULL,
765 `icon5` int(11) unsigned NOT NULL,
766 `icon6` int(11) unsigned NOT NULL,
767 `icon7` int(11) unsigned NOT NULL,
768 `icon8` int(11) unsigned NOT NULL,
769 `isRaid` tinyint(1) unsigned NOT NULL,
770 `difficulty` tinyint(3) unsigned NOT NULL default '0',
771 PRIMARY KEY (`leaderGuid`)
772 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Groups';
775 -- Dumping data for table `groups`
778 LOCK TABLES `groups` WRITE;
779 /*!40000 ALTER TABLE `groups` DISABLE KEYS */;
780 /*!40000 ALTER TABLE `groups` ENABLE KEYS */;
783 -- ----------------------------
784 -- Table structure for group_instance
785 -- ----------------------------
786 DROP TABLE IF EXISTS `group_instance`;
787 CREATE TABLE `group_instance` (
788 `leaderGuid` int(11) unsigned NOT NULL default '0',
789 `instance` int(11) unsigned NOT NULL default '0',
790 `permanent` tinyint(1) unsigned NOT NULL default '0',
791 PRIMARY KEY (`leaderGuid`,`instance`),
792 KEY `instance` (`instance`)
793 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
796 -- Dumping data for table `group_instance`
799 LOCK TABLES `group_instance` WRITE;
800 /*!40000 ALTER TABLE `group_instance` DISABLE KEYS */;
801 /*!40000 ALTER TABLE `group_instance` ENABLE KEYS */;
805 -- Table structure for table `group_member`
808 DROP TABLE IF EXISTS `group_member`;
809 CREATE TABLE `group_member` (
810 `leaderGuid` int(11) unsigned NOT NULL,
811 `memberGuid` int(11) unsigned NOT NULL,
812 `assistant` tinyint(1) unsigned NOT NULL,
813 `subgroup` smallint(6) unsigned NOT NULL,
814 PRIMARY KEY (`leaderGuid`,`memberGuid`)
815 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Groups';
818 -- Dumping data for table `group_member`
821 LOCK TABLES `group_member` WRITE;
822 /*!40000 ALTER TABLE `group_member` DISABLE KEYS */;
823 /*!40000 ALTER TABLE `group_member` ENABLE KEYS */;
827 -- Table structure for table `guild`
830 DROP TABLE IF EXISTS `guild`;
831 CREATE TABLE `guild` (
832 `guildid` int(6) unsigned NOT NULL default '0',
833 `name` varchar(255) NOT NULL default '',
834 `leaderguid` int(6) unsigned NOT NULL default '0',
835 `EmblemStyle` int(5) NOT NULL default '0',
836 `EmblemColor` int(5) NOT NULL default '0',
837 `BorderStyle` int(5) NOT NULL default '0',
838 `BorderColor` int(5) NOT NULL default '0',
839 `BackgroundColor` int(5) NOT NULL default '0',
840 `info` text NOT NULL,
841 `motd` varchar(255) NOT NULL default '',
842 `createdate` datetime default NULL,
843 `BankMoney` bigint(20) NOT NULL default '0',
844 PRIMARY KEY (`guildid`)
845 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Guild System';
848 -- Dumping data for table `guild`
851 LOCK TABLES `guild` WRITE;
852 /*!40000 ALTER TABLE `guild` DISABLE KEYS */;
853 /*!40000 ALTER TABLE `guild` ENABLE KEYS */;
857 -- Table structure for table `guild_bank_eventlog`
860 DROP TABLE IF EXISTS `guild_bank_eventlog`;
861 CREATE TABLE `guild_bank_eventlog` (
862 `guildid` int(11) unsigned NOT NULL default '0',
863 `LogGuid` int(11) unsigned NOT NULL default '0',
864 `LogEntry` tinyint(1) unsigned NOT NULL default '0',
865 `TabId` tinyint(1) unsigned NOT NULL default '0',
866 `PlayerGuid` int(11) unsigned NOT NULL default '0',
867 `ItemOrMoney` int(11) unsigned NOT NULL default '0',
868 `ItemStackCount` tinyint(3) unsigned NOT NULL default '0',
869 `DestTabId` tinyint(1) unsigned NOT NULL default '0',
870 `TimeStamp` bigint(20) unsigned NOT NULL default '0',
871 PRIMARY KEY (`guildid`,`LogGuid`),
872 KEY `guildid_key` (`guildid`)
873 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
876 -- Dumping data for table `guild_bank_eventlog`
879 LOCK TABLES `guild_bank_eventlog` WRITE;
880 /*!40000 ALTER TABLE `guild_bank_eventlog` DISABLE KEYS */;
881 /*!40000 ALTER TABLE `guild_bank_eventlog` ENABLE KEYS */;
885 -- Table structure for table `guild_bank_item`
888 DROP TABLE IF EXISTS `guild_bank_item`;
889 CREATE TABLE `guild_bank_item` (
890 `guildid` int(11) unsigned NOT NULL default '0',
891 `TabId` tinyint(1) unsigned NOT NULL default '0',
892 `SlotId` tinyint(3) unsigned NOT NULL default '0',
893 `item_guid` int(11) unsigned NOT NULL default '0',
894 `item_entry` int(11) unsigned NOT NULL default '0',
895 PRIMARY KEY (`guildid`,`tabid`,`slotid`),
896 KEY `guildid_key` (`guildid`)
897 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
900 -- Dumping data for table `guild_bank_item`
903 LOCK TABLES `guild_bank_item` WRITE;
904 /*!40000 ALTER TABLE `guild_bank_item` DISABLE KEYS */;
905 /*!40000 ALTER TABLE `guild_bank_item` ENABLE KEYS */;
909 -- Table structure for table `guild_bank_right`
912 DROP TABLE IF EXISTS `guild_bank_right`;
913 CREATE TABLE `guild_bank_right` (
914 `guildid` int(11) unsigned NOT NULL default '0',
915 `TabId` tinyint(1) unsigned NOT NULL default '0',
916 `rid` int(11) unsigned NOT NULL default '0',
917 `gbright` tinyint(3) unsigned NOT NULL default '0',
918 `SlotPerDay` int(11) unsigned NOT NULL default '0',
919 PRIMARY KEY (`guildid`,`TabId`,`rid`),
920 KEY `guildid_key` (`guildid`)
921 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
924 -- Dumping data for table `guild_bank_right`
927 LOCK TABLES `guild_bank_right` WRITE;
928 /*!40000 ALTER TABLE `guild_bank_right` DISABLE KEYS */;
929 /*!40000 ALTER TABLE `guild_bank_right` ENABLE KEYS */;
933 -- Table structure for table `guild_bank_tab`
936 DROP TABLE IF EXISTS `guild_bank_tab`;
937 CREATE TABLE `guild_bank_tab` (
938 `guildid` int(11) unsigned NOT NULL default '0',
939 `TabId` tinyint(1) unsigned NOT NULL default '0',
940 `TabName` varchar(100) NOT NULL default '',
941 `TabIcon` varchar(100) NOT NULL default '',
943 PRIMARY KEY (`guildid`,`TabId`),
944 KEY `guildid_key` (`guildid`)
945 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
948 -- Dumping data for table `guild_bank_tab`
951 LOCK TABLES `guild_bank_tab` WRITE;
952 /*!40000 ALTER TABLE `guild_bank_tab` DISABLE KEYS */;
953 /*!40000 ALTER TABLE `guild_bank_tab` ENABLE KEYS */;
957 -- Table structure for table `guild_eventlog`
960 DROP TABLE IF EXISTS `guild_eventlog`;
961 CREATE TABLE `guild_eventlog` (
962 `guildid` int(11) NOT NULL COMMENT 'Guild Identificator',
963 `LogGuid` int(11) NOT NULL COMMENT 'Log entry identificator',
964 `EventType` tinyint(1) NOT NULL COMMENT 'Event type',
965 `PlayerGuid1` int(11) NOT NULL COMMENT 'Player 1',
966 `PlayerGuid2` int(11) NOT NULL COMMENT 'Player 2',
967 `NewRank` tinyint(2) NOT NULL COMMENT 'New rank(in case promotion/demotion)',
968 `TimeStamp` bigint(20) NOT NULL COMMENT 'Event UNIX time'
969 ) ENGINE = InnoDB DEFAULT CHARSET = latin1 COMMENT 'Guild Eventlog';
972 -- Dumping data for table `guild_eventlog`
975 LOCK TABLES `guild_eventlog` WRITE;
976 /*!40000 ALTER TABLE `guild_eventlog` DISABLE KEYS */;
977 /*!40000 ALTER TABLE `guild_eventlog` ENABLE KEYS */;
981 -- Table structure for table `guild_member`
984 DROP TABLE IF EXISTS `guild_member`;
985 CREATE TABLE `guild_member` (
986 `guildid` int(6) unsigned NOT NULL default '0',
987 `guid` int(11) unsigned NOT NULL default '0',
988 `rank` tinyint(2) unsigned NOT NULL default '0',
989 `pnote` varchar(255) NOT NULL default '',
990 `offnote` varchar(255) NOT NULL default '',
991 `BankResetTimeMoney` int(11) unsigned NOT NULL default '0',
992 `BankRemMoney` int(11) unsigned NOT NULL default '0',
993 `BankResetTimeTab0` int(11) unsigned NOT NULL default '0',
994 `BankRemSlotsTab0` int(11) unsigned NOT NULL default '0',
995 `BankResetTimeTab1` int(11) unsigned NOT NULL default '0',
996 `BankRemSlotsTab1` int(11) unsigned NOT NULL default '0',
997 `BankResetTimeTab2` int(11) unsigned NOT NULL default '0',
998 `BankRemSlotsTab2` int(11) unsigned NOT NULL default '0',
999 `BankResetTimeTab3` int(11) unsigned NOT NULL default '0',
1000 `BankRemSlotsTab3` int(11) unsigned NOT NULL default '0',
1001 `BankResetTimeTab4` int(11) unsigned NOT NULL default '0',
1002 `BankRemSlotsTab4` int(11) unsigned NOT NULL default '0',
1003 `BankResetTimeTab5` int(11) unsigned NOT NULL default '0',
1004 `BankRemSlotsTab5` int(11) unsigned NOT NULL default '0',
1005 KEY `guildid_key` (`guildid`),
1006 KEY `guildid_rank_key` (`guildid`,`rank`),
1007 UNIQUE KEY `guid_key` (`guid`)
1008 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Guild System';
1011 -- Dumping data for table `guild_member`
1014 LOCK TABLES `guild_member` WRITE;
1015 /*!40000 ALTER TABLE `guild_member` DISABLE KEYS */;
1016 /*!40000 ALTER TABLE `guild_member` ENABLE KEYS */;
1020 -- Table structure for table `guild_rank`
1023 DROP TABLE IF EXISTS `guild_rank`;
1024 CREATE TABLE `guild_rank` (
1025 `guildid` int(6) unsigned NOT NULL default '0',
1026 `rid` int(11) unsigned NOT NULL,
1027 `rname` varchar(255) NOT NULL default '',
1028 `rights` int(3) unsigned NOT NULL default '0',
1029 `BankMoneyPerDay` int(11) unsigned NOT NULL default '0',
1030 PRIMARY KEY (`guildid`,`rid`)
1031 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Guild System';
1034 -- Dumping data for table `guild_rank`
1037 LOCK TABLES `guild_rank` WRITE;
1038 /*!40000 ALTER TABLE `guild_rank` DISABLE KEYS */;
1039 /*!40000 ALTER TABLE `guild_rank` ENABLE KEYS */;
1043 -- Table structure for table `instance`
1046 DROP TABLE IF EXISTS `instance`;
1047 CREATE TABLE `instance` (
1048 `id` int(11) unsigned NOT NULL default '0',
1049 `map` int(11) unsigned NOT NULL default '0',
1050 `resettime` bigint(40) NOT NULL default '0',
1051 `difficulty` tinyint(1) unsigned NOT NULL default '0',
1055 KEY `resettime` (`resettime`)
1056 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1059 -- Dumping data for table `instance`
1062 LOCK TABLES `instance` WRITE;
1063 /*!40000 ALTER TABLE `instance` DISABLE KEYS */;
1064 /*!40000 ALTER TABLE `instance` ENABLE KEYS */;
1067 -- ----------------------------
1068 -- Table structure for instance_reset
1069 -- ----------------------------
1070 DROP TABLE IF EXISTS `instance_reset`;
1071 CREATE TABLE `instance_reset` (
1072 `mapid` int(11) unsigned NOT NULL default '0',
1073 `resettime` bigint(40) NOT NULL default '0',
1074 PRIMARY KEY (`mapid`)
1075 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1078 -- Dumping data for table `instance_reset`
1081 LOCK TABLES `instance_reset` WRITE;
1082 /*!40000 ALTER TABLE `instance_reset` DISABLE KEYS */;
1083 /*!40000 ALTER TABLE `instance_reset` ENABLE KEYS */;
1087 -- Table structure for table `item_instance`
1090 DROP TABLE IF EXISTS `item_instance`;
1091 CREATE TABLE `item_instance` (
1092 `guid` int(11) unsigned NOT NULL default '0',
1093 `owner_guid` int(11) unsigned NOT NULL default '0',
1095 PRIMARY KEY (`guid`),
1096 KEY `idx_owner_guid` (`owner_guid`)
1097 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Item System';
1100 -- Dumping data for table `item_instance`
1103 LOCK TABLES `item_instance` WRITE;
1104 /*!40000 ALTER TABLE `item_instance` DISABLE KEYS */;
1105 /*!40000 ALTER TABLE `item_instance` ENABLE KEYS */;
1109 -- Table structure for table `item_text`
1112 DROP TABLE IF EXISTS `item_text`;
1113 CREATE TABLE `item_text` (
1114 `id` int(11) unsigned NOT NULL default '0',
1117 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Item System';
1120 -- Dumping data for table `item_text`
1123 LOCK TABLES `item_text` WRITE;
1124 /*!40000 ALTER TABLE `item_text` DISABLE KEYS */;
1125 /*!40000 ALTER TABLE `item_text` ENABLE KEYS */;
1129 -- Table structure for table `mail`
1132 DROP TABLE IF EXISTS `mail`;
1133 CREATE TABLE `mail` (
1134 `id` int(11) unsigned NOT NULL default '0' COMMENT 'Identifier',
1135 `messageType` tinyint(3) unsigned NOT NULL default '0',
1136 `stationery` tinyint(3) NOT NULL default '41',
1137 `mailTemplateId` mediumint(8) unsigned NOT NULL default '0',
1138 `sender` int(11) unsigned NOT NULL default '0' COMMENT 'Character Global Unique Identifier',
1139 `receiver` int(11) unsigned NOT NULL default '0' COMMENT 'Character Global Unique Identifier',
1141 `itemTextId` int(11) unsigned NOT NULL default '0',
1142 `has_items` tinyint(3) unsigned NOT NULL default '0',
1143 `expire_time` bigint(40) NOT NULL default '0',
1144 `deliver_time` bigint(40) NOT NULL default '0',
1145 `money` int(11) unsigned NOT NULL default '0',
1146 `cod` int(11) unsigned NOT NULL default '0',
1147 `checked` tinyint(3) unsigned NOT NULL default '0',
1149 KEY `idx_receiver` (`receiver`)
1150 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Mail System';
1153 -- Dumping data for table `mail`
1156 LOCK TABLES `mail` WRITE;
1157 /*!40000 ALTER TABLE `mail` DISABLE KEYS */;
1158 /*!40000 ALTER TABLE `mail` ENABLE KEYS */;
1162 -- Table structure for table `mail_items`
1165 DROP TABLE IF EXISTS `mail_items`;
1166 CREATE TABLE `mail_items` (
1167 `mail_id` int(11) NOT NULL default '0',
1168 `item_guid` int(11) NOT NULL default '0',
1169 `item_template` int(11) NOT NULL default '0',
1170 `receiver` int(11) unsigned NOT NULL default '0' COMMENT 'Character Global Unique Identifier',
1171 PRIMARY KEY (`mail_id`,`item_guid`),
1172 KEY `idx_receiver` (`receiver`)
1173 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;
1176 -- Dumping data for table `mail_items`
1179 LOCK TABLES `mail_items` WRITE;
1180 /*!40000 ALTER TABLE `mail_items` DISABLE KEYS */;
1181 /*!40000 ALTER TABLE `mail_items` ENABLE KEYS */;
1185 -- Table structure for table `pet_aura`
1188 DROP TABLE IF EXISTS `pet_aura`;
1189 CREATE TABLE `pet_aura` (
1190 `guid` int(11) unsigned NOT NULL default '0' COMMENT 'Global Unique Identifier',
1191 `caster_guid` bigint(20) unsigned NOT NULL default '0' COMMENT 'Full Global Unique Identifier',
1192 `spell` int(11) unsigned NOT NULL default '0',
1193 `effect_index` int(11) unsigned NOT NULL default '0',
1194 `stackcount` int(11) NOT NULL default '1',
1195 `amount` int(11) NOT NULL default '0',
1196 `maxduration` int(11) NOT NULL default '0',
1197 `remaintime` int(11) NOT NULL default '0',
1198 `remaincharges` int(11) NOT NULL default '0',
1199 PRIMARY KEY (`guid`,`spell`,`effect_index`)
1200 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Pet System';
1203 -- Dumping data for table `pet_aura`
1206 LOCK TABLES `pet_aura` WRITE;
1207 /*!40000 ALTER TABLE `pet_aura` DISABLE KEYS */;
1208 /*!40000 ALTER TABLE `pet_aura` ENABLE KEYS */;
1212 -- Table structure for table `pet_spell`
1215 DROP TABLE IF EXISTS `pet_spell`;
1216 CREATE TABLE `pet_spell` (
1217 `guid` int(11) unsigned NOT NULL default '0' COMMENT 'Global Unique Identifier',
1218 `spell` int(11) unsigned NOT NULL default '0' COMMENT 'Spell Identifier',
1219 `active` int(11) unsigned NOT NULL default '0',
1220 PRIMARY KEY (`guid`,`spell`)
1221 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Pet System';
1224 -- Dumping data for table `pet_spell`
1227 LOCK TABLES `pet_spell` WRITE;
1228 /*!40000 ALTER TABLE `pet_spell` DISABLE KEYS */;
1229 /*!40000 ALTER TABLE `pet_spell` ENABLE KEYS */;
1233 -- Table structure for table `pet_spell_cooldown`
1236 DROP TABLE IF EXISTS `pet_spell_cooldown`;
1237 CREATE TABLE `pet_spell_cooldown` (
1238 `guid` int(11) unsigned NOT NULL default '0' COMMENT 'Global Unique Identifier, Low part',
1239 `spell` int(11) unsigned NOT NULL default '0' COMMENT 'Spell Identifier',
1240 `time` bigint(20) unsigned NOT NULL default '0',
1241 PRIMARY KEY (`guid`,`spell`)
1242 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1245 -- Dumping data for table `pet_spell_cooldown`
1248 LOCK TABLES `pet_spell_cooldown` WRITE;
1249 /*!40000 ALTER TABLE `pet_spell_cooldown` DISABLE KEYS */;
1250 /*!40000 ALTER TABLE `pet_spell_cooldown` ENABLE KEYS */;
1254 -- Table structure for table `petition`
1257 DROP TABLE IF EXISTS `petition`;
1258 CREATE TABLE `petition` (
1259 `ownerguid` int(10) unsigned NOT NULL,
1260 `petitionguid` int(10) unsigned default '0',
1261 `name` varchar(255) NOT NULL default '',
1262 `type` int(10) unsigned NOT NULL default '0',
1263 PRIMARY KEY (`ownerguid`,`type`),
1264 UNIQUE KEY `index_ownerguid_petitionguid` (`ownerguid`,`petitionguid`)
1265 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Guild System';
1268 -- Dumping data for table `petition`
1271 LOCK TABLES `petition` WRITE;
1272 /*!40000 ALTER TABLE `petition` DISABLE KEYS */;
1273 /*!40000 ALTER TABLE `petition` ENABLE KEYS */;
1277 -- Table structure for table `petition_sign`
1280 DROP TABLE IF EXISTS `petition_sign`;
1281 CREATE TABLE `petition_sign` (
1282 `ownerguid` int(10) unsigned NOT NULL,
1283 `petitionguid` int(11) unsigned NOT NULL default '0',
1284 `playerguid` int(11) unsigned NOT NULL default '0',
1285 `player_account` int(11) unsigned NOT NULL default '0',
1286 `type` int(10) unsigned NOT NULL default '0',
1287 PRIMARY KEY (`petitionguid`,`playerguid`)
1288 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Guild System';
1291 -- Dumping data for table `petition_sign`
1294 LOCK TABLES `petition_sign` WRITE;
1295 /*!40000 ALTER TABLE `petition_sign` DISABLE KEYS */;
1296 /*!40000 ALTER TABLE `petition_sign` ENABLE KEYS */;
1298 /*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
1301 -- Table structure for table `saved_variables`
1304 DROP TABLE IF EXISTS `saved_variables`;
1305 CREATE TABLE `saved_variables` (
1306 `NextArenaPointDistributionTime` bigint(40) UNSIGNED NOT NULL DEFAULT '0'
1307 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Variable Saves';
1310 -- Dumping data for table `saved_variables`
1313 LOCK TABLES `saved_variables` WRITE;
1314 /*!40000 ALTER TABLE `saved_variables` DISABLE KEYS */;
1315 /*!40000 ALTER TABLE `saved_variables` ENABLE KEYS */;
1317 /*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
1320 /*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
1321 /*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
1322 /*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
1323 /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
1324 /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
1325 /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
1326 /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
1328 -- Dump completed on 2008-01-10 11:37:06