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_7932_01_characters_character_pet` 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 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` 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 `bgid` int(10) unsigned NOT NULL default '0',
229 `bgteam` int(10) unsigned NOT NULL default '0',
230 `bgmap` int(10) unsigned NOT NULL default '0',
231 `bgx` float NOT NULL default '0',
232 `bgy` float NOT NULL default '0',
233 `bgz` float NOT NULL default '0',
234 `bgo` float NOT NULL default '0',
235 PRIMARY KEY (`guid`),
236 KEY `idx_account` (`account`),
237 KEY `idx_online` (`online`),
238 KEY `idx_name` (`name`)
239 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Player System';
242 -- Dumping data for table `characters`
245 LOCK TABLES `characters` WRITE;
246 /*!40000 ALTER TABLE `characters` DISABLE KEYS */;
247 /*!40000 ALTER TABLE `characters` ENABLE KEYS */;
251 -- Table structure for table `character_achievement`
254 DROP TABLE IF EXISTS `character_achievement`;
255 CREATE TABLE `character_achievement` (
256 `guid` int(11) unsigned NOT NULL,
257 `achievement` int(11) unsigned NOT NULL,
258 `date` bigint(11) unsigned NOT NULL default '0',
259 PRIMARY KEY (`guid`,`achievement`)
260 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
263 -- Dumping data for table `character_achievement`
266 LOCK TABLES `character_achievement` WRITE;
267 /*!40000 ALTER TABLE `character_achievement` DISABLE KEYS */;
268 /*!40000 ALTER TABLE `character_achievement` ENABLE KEYS */;
272 -- Table structure for table `character_achievement_progress`
275 DROP TABLE IF EXISTS `character_achievement_progress`;
276 CREATE TABLE `character_achievement_progress` (
277 `guid` int(11) unsigned NOT NULL,
278 `criteria` int(11) unsigned NOT NULL,
279 `counter` int(11) unsigned NOT NULL,
280 `date` bigint(11) unsigned NOT NULL default '0',
281 PRIMARY KEY (`guid`,`criteria`)
282 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
285 -- Dumping data for table `character_achievement_progress`
288 LOCK TABLES `character_achievement_progress` WRITE;
289 /*!40000 ALTER TABLE `character_achievement_progress` DISABLE KEYS */;
290 /*!40000 ALTER TABLE `character_achievement_progress` ENABLE KEYS */;
294 -- Table structure for table `character_action`
297 DROP TABLE IF EXISTS `character_action`;
298 CREATE TABLE `character_action` (
299 `guid` int(11) unsigned NOT NULL default '0' COMMENT 'Global Unique Identifier',
300 `button` tinyint(3) unsigned NOT NULL default '0',
301 `action` smallint(5) unsigned NOT NULL default '0',
302 `type` tinyint(3) unsigned NOT NULL default '0',
303 `misc` tinyint(3) unsigned NOT NULL default '0',
304 PRIMARY KEY (`guid`,`button`)
305 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Player System';
308 -- Dumping data for table `character_action`
311 LOCK TABLES `character_action` WRITE;
312 /*!40000 ALTER TABLE `character_action` DISABLE KEYS */;
313 /*!40000 ALTER TABLE `character_action` ENABLE KEYS */;
317 -- Table structure for table `character_aura`
320 DROP TABLE IF EXISTS `character_aura`;
321 CREATE TABLE `character_aura` (
322 `guid` int(11) unsigned NOT NULL default '0' COMMENT 'Global Unique Identifier',
323 `caster_guid` bigint(20) unsigned NOT NULL default '0' COMMENT 'Full Global Unique Identifier',
324 `spell` int(11) unsigned NOT NULL default '0',
325 `effect_index` int(11) unsigned NOT NULL default '0',
326 `stackcount` int(11) NOT NULL default '1',
327 `amount` int(11) NOT NULL default '0',
328 `maxduration` int(11) NOT NULL default '0',
329 `remaintime` int(11) NOT NULL default '0',
330 `remaincharges` int(11) NOT NULL default '0',
331 PRIMARY KEY (`guid`,`spell`,`effect_index`)
332 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Player System';
335 -- Dumping data for table `character_aura`
338 LOCK TABLES `character_aura` WRITE;
339 /*!40000 ALTER TABLE `character_aura` DISABLE KEYS */;
340 /*!40000 ALTER TABLE `character_aura` ENABLE KEYS */;
344 -- Table structure for table `character_declinedname`
347 DROP TABLE IF EXISTS `character_declinedname`;
348 CREATE TABLE `character_declinedname` (
349 `guid` int(11) unsigned NOT NULL default '0' COMMENT 'Global Unique Identifier',
350 `genitive` varchar(15) NOT NULL default '',
351 `dative` varchar(15) NOT NULL default '',
352 `accusative` varchar(15) NOT NULL default '',
353 `instrumental` varchar(15) NOT NULL default '',
354 `prepositional` varchar(15) NOT NULL default '',
356 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;
359 -- Dumping data for table `character_declinedname`
362 LOCK TABLES `character_declinedname` WRITE;
363 /*!40000 ALTER TABLE `character_declinedname` DISABLE KEYS */;
364 /*!40000 ALTER TABLE `character_declinedname` ENABLE KEYS */;
368 -- Table structure for table `character_gifts`
371 DROP TABLE IF EXISTS `character_gifts`;
372 CREATE TABLE `character_gifts` (
373 `guid` int(20) unsigned NOT NULL default '0',
374 `item_guid` int(11) unsigned NOT NULL default '0',
375 `entry` int(20) unsigned NOT NULL default '0',
376 `flags` int(20) unsigned NOT NULL default '0',
377 PRIMARY KEY (`item_guid`),
378 KEY `idx_guid` (`guid`)
379 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
382 -- Dumping data for table `character_gifts`
385 LOCK TABLES `character_gifts` WRITE;
386 /*!40000 ALTER TABLE `character_gifts` DISABLE KEYS */;
387 /*!40000 ALTER TABLE `character_gifts` ENABLE KEYS */;
391 -- Table structure for table `character_homebind`
394 DROP TABLE IF EXISTS `character_homebind`;
395 CREATE TABLE `character_homebind` (
396 `guid` int(11) unsigned NOT NULL default '0' COMMENT 'Global Unique Identifier',
397 `map` int(11) unsigned NOT NULL default '0' COMMENT 'Map Identifier',
398 `zone` int(11) unsigned NOT NULL default '0' COMMENT 'Zone Identifier',
399 `position_x` float NOT NULL default '0',
400 `position_y` float NOT NULL default '0',
401 `position_z` float NOT NULL default '0',
403 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Player System';
406 -- Dumping data for table `character_homebind`
409 LOCK TABLES `character_homebind` WRITE;
410 /*!40000 ALTER TABLE `character_homebind` DISABLE KEYS */;
411 /*!40000 ALTER TABLE `character_homebind` ENABLE KEYS */;
415 -- Table structure for table `character_instance`
418 DROP TABLE IF EXISTS `character_instance`;
419 CREATE TABLE `character_instance` (
420 `guid` int(11) unsigned NOT NULL default '0',
421 `instance` int(11) unsigned NOT NULL default '0',
422 `permanent` tinyint(1) unsigned NOT NULL default '0',
423 PRIMARY KEY (`guid`,`instance`),
424 KEY `instance` (`instance`)
425 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
428 -- Dumping data for table `character_instance`
431 LOCK TABLES `character_instance` WRITE;
432 /*!40000 ALTER TABLE `character_instance` DISABLE KEYS */;
433 /*!40000 ALTER TABLE `character_instance` ENABLE KEYS */;
437 -- Table structure for table `character_inventory`
440 DROP TABLE IF EXISTS `character_inventory`;
441 CREATE TABLE `character_inventory` (
442 `guid` int(11) unsigned NOT NULL default '0' COMMENT 'Global Unique Identifier',
443 `bag` int(11) unsigned NOT NULL default '0',
444 `slot` tinyint(3) unsigned NOT NULL default '0',
445 `item` int(11) unsigned NOT NULL default '0' COMMENT 'Item Global Unique Identifier',
446 `item_template` int(11) unsigned NOT NULL default '0' COMMENT 'Item Identifier',
447 PRIMARY KEY (`item`),
448 KEY `idx_guid` (`guid`)
449 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Player System';
452 -- Dumping data for table `character_inventory`
455 LOCK TABLES `character_inventory` WRITE;
456 /*!40000 ALTER TABLE `character_inventory` DISABLE KEYS */;
457 /*!40000 ALTER TABLE `character_inventory` ENABLE KEYS */;
461 -- Table structure for table `character_pet`
464 DROP TABLE IF EXISTS `character_pet`;
465 CREATE TABLE `character_pet` (
466 `id` int(11) unsigned NOT NULL default '0',
467 `entry` int(11) unsigned NOT NULL default '0',
468 `owner` int(11) unsigned NOT NULL default '0',
469 `modelid` int(11) unsigned default '0',
470 `CreatedBySpell` int(11) unsigned NOT NULL default '0',
471 `PetType` tinyint(3) unsigned NOT NULL default '0',
472 `level` int(11) unsigned NOT NULL default '1',
473 `exp` int(11) unsigned NOT NULL default '0',
474 `Reactstate` tinyint(1) unsigned NOT NULL default '0',
475 `name` varchar(100) default 'Pet',
476 `renamed` tinyint(1) unsigned NOT NULL default '0',
477 `slot` int(11) unsigned NOT NULL default '0',
478 `curhealth` int(11) unsigned NOT NULL default '1',
479 `curmana` int(11) unsigned NOT NULL default '0',
480 `curhappiness` int(11) unsigned NOT NULL default '0',
481 `savetime` bigint(20) unsigned NOT NULL default '0',
482 `resettalents_cost` int(11) unsigned NOT NULL default '0',
483 `resettalents_time` bigint(20) unsigned NOT NULL default '0',
486 KEY `owner` (`owner`)
487 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Pet System';
490 -- Dumping data for table `character_pet`
493 LOCK TABLES `character_pet` WRITE;
494 /*!40000 ALTER TABLE `character_pet` DISABLE KEYS */;
495 /*!40000 ALTER TABLE `character_pet` ENABLE KEYS */;
499 -- Table structure for table `character_pet_declinedname`
502 DROP TABLE IF EXISTS `character_pet_declinedname`;
503 CREATE TABLE `character_pet_declinedname` (
504 `id` int(11) unsigned NOT NULL default '0',
505 `owner` int(11) unsigned NOT NULL default '0',
506 `genitive` varchar(12) NOT NULL default '',
507 `dative` varchar(12) NOT NULL default '',
508 `accusative` varchar(12) NOT NULL default '',
509 `instrumental` varchar(12) NOT NULL default '',
510 `prepositional` varchar(12) NOT NULL default '',
512 KEY owner_key (`owner`)
513 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;
516 -- Dumping data for table `character_pet_declinedname`
519 LOCK TABLES `character_pet_declinedname` WRITE;
520 /*!40000 ALTER TABLE `character_pet_declinedname` DISABLE KEYS */;
521 /*!40000 ALTER TABLE `character_pet_declinedname` ENABLE KEYS */;
525 -- Table structure for table `character_queststatus`
528 DROP TABLE IF EXISTS `character_queststatus`;
529 CREATE TABLE `character_queststatus` (
530 `guid` int(11) unsigned NOT NULL default '0' COMMENT 'Global Unique Identifier',
531 `quest` int(11) unsigned NOT NULL default '0' COMMENT 'Quest Identifier',
532 `status` int(11) unsigned NOT NULL default '0',
533 `rewarded` tinyint(1) unsigned NOT NULL default '0',
534 `explored` tinyint(1) unsigned NOT NULL default '0',
535 `timer` bigint(20) unsigned NOT NULL default '0',
536 `mobcount1` int(11) unsigned NOT NULL default '0',
537 `mobcount2` int(11) unsigned NOT NULL default '0',
538 `mobcount3` int(11) unsigned NOT NULL default '0',
539 `mobcount4` int(11) unsigned NOT NULL default '0',
540 `itemcount1` int(11) unsigned NOT NULL default '0',
541 `itemcount2` int(11) unsigned NOT NULL default '0',
542 `itemcount3` int(11) unsigned NOT NULL default '0',
543 `itemcount4` int(11) unsigned NOT NULL default '0',
544 PRIMARY KEY (`guid`,`quest`)
545 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Player System';
548 -- Dumping data for table `character_queststatus`
551 LOCK TABLES `character_queststatus` WRITE;
552 /*!40000 ALTER TABLE `character_queststatus` DISABLE KEYS */;
553 /*!40000 ALTER TABLE `character_queststatus` ENABLE KEYS */;
557 -- Table structure for table `character_queststatus_daily`
560 DROP TABLE IF EXISTS `character_queststatus_daily`;
561 CREATE TABLE `character_queststatus_daily` (
562 `guid` int(11) unsigned NOT NULL default '0' COMMENT 'Global Unique Identifier',
563 `quest` int(11) unsigned NOT NULL default '0' COMMENT 'Quest Identifier',
564 `time` bigint(20) unsigned NOT NULL default '0',
565 PRIMARY KEY (`guid`,`quest`),
566 KEY `idx_guid` (`guid`)
567 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Player System';
570 -- Dumping data for table `character_queststatus_daily`
573 LOCK TABLES `character_queststatus_daily` WRITE;
574 /*!40000 ALTER TABLE `character_queststatus_daily` DISABLE KEYS */;
575 /*!40000 ALTER TABLE `character_queststatus_daily` ENABLE KEYS */;
579 -- Table structure for table `character_reputation`
582 DROP TABLE IF EXISTS `character_reputation`;
583 CREATE TABLE `character_reputation` (
584 `guid` int(11) unsigned NOT NULL default '0' COMMENT 'Global Unique Identifier',
585 `faction` int(11) unsigned NOT NULL default '0',
586 `standing` int(11) NOT NULL default '0',
587 `flags` int(11) NOT NULL default '0',
588 PRIMARY KEY (`guid`,`faction`)
589 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Player System';
592 -- Dumping data for table `character_reputation`
595 LOCK TABLES `character_reputation` WRITE;
596 /*!40000 ALTER TABLE `character_reputation` DISABLE KEYS */;
597 /*!40000 ALTER TABLE `character_reputation` ENABLE KEYS */;
601 -- Table structure for table `character_social`
604 DROP TABLE IF EXISTS `character_social`;
605 CREATE TABLE `character_social` (
606 `guid` int(11) unsigned NOT NULL default '0' COMMENT 'Character Global Unique Identifier',
607 `friend` int(11) unsigned NOT NULL default '0' COMMENT 'Friend Global Unique Identifier',
608 `flags` tinyint(1) unsigned NOT NULL default '0' COMMENT 'Friend Flags',
609 `note` varchar(48) NOT NULL DEFAULT '' COMMENT 'Friend Note',
610 PRIMARY KEY (`guid`,`friend`,`flags`),
612 KEY `friend` (`friend`),
613 KEY `guid_flags` (`guid`,`flags`),
614 KEY `friend_flags` (`friend`,`flags`)
615 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Player System';
618 -- Dumping data for table `character_social`
621 LOCK TABLES `character_social` WRITE;
622 /*!40000 ALTER TABLE `character_social` DISABLE KEYS */;
623 /*!40000 ALTER TABLE `character_social` ENABLE KEYS */;
627 -- Table structure for table `character_spell`
630 DROP TABLE IF EXISTS `character_spell`;
631 CREATE TABLE `character_spell` (
632 `guid` int(11) unsigned NOT NULL default '0' COMMENT 'Global Unique Identifier',
633 `spell` int(11) unsigned NOT NULL default '0' COMMENT 'Spell Identifier',
634 `active` tinyint(3) unsigned NOT NULL default '1',
635 `disabled` tinyint(3) unsigned NOT NULL default '0',
636 PRIMARY KEY (`guid`,`spell`)
637 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Player System';
640 -- Dumping data for table `character_spell`
643 LOCK TABLES `character_spell` WRITE;
644 /*!40000 ALTER TABLE `character_spell` DISABLE KEYS */;
645 /*!40000 ALTER TABLE `character_spell` ENABLE KEYS */;
649 -- Table structure for table `character_spell_cooldown`
652 DROP TABLE IF EXISTS `character_spell_cooldown`;
653 CREATE TABLE `character_spell_cooldown` (
654 `guid` int(11) unsigned NOT NULL default '0' COMMENT 'Global Unique Identifier, Low part',
655 `spell` int(11) unsigned NOT NULL default '0' COMMENT 'Spell Identifier',
656 `item` int(11) unsigned NOT NULL default '0' COMMENT 'Item Identifier',
657 `time` bigint(20) unsigned NOT NULL default '0',
658 PRIMARY KEY (`guid`,`spell`)
659 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
662 -- Dumping data for table `character_spell_cooldown`
665 LOCK TABLES `character_spell_cooldown` WRITE;
666 /*!40000 ALTER TABLE `character_spell_cooldown` DISABLE KEYS */;
667 /*!40000 ALTER TABLE `character_spell_cooldown` ENABLE KEYS */;
671 -- Table structure for table `character_ticket`
674 DROP TABLE IF EXISTS `character_ticket`;
675 CREATE TABLE `character_ticket` (
676 `ticket_id` int(11) unsigned NOT NULL auto_increment,
677 `guid` int(11) unsigned NOT NULL default '0',
679 `ticket_lastchange` TIMESTAMP ON UPDATE CURRENT_TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
680 PRIMARY KEY (`ticket_id`)
681 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Player System';
684 -- Dumping data for table `character_ticket`
687 LOCK TABLES `character_ticket` WRITE;
688 /*!40000 ALTER TABLE `character_ticket` DISABLE KEYS */;
689 /*!40000 ALTER TABLE `character_ticket` ENABLE KEYS */;
693 -- Table structure for table `character_tutorial`
696 DROP TABLE IF EXISTS `character_tutorial`;
697 CREATE TABLE `character_tutorial` (
698 `account` bigint(20) unsigned NOT NULL auto_increment COMMENT 'Account Identifier',
699 `realmid` int(11) unsigned NOT NULL default '0' COMMENT 'Realm Identifier',
700 `tut0` int(11) unsigned NOT NULL default '0',
701 `tut1` int(11) unsigned NOT NULL default '0',
702 `tut2` int(11) unsigned NOT NULL default '0',
703 `tut3` int(11) unsigned NOT NULL default '0',
704 `tut4` int(11) unsigned NOT NULL default '0',
705 `tut5` int(11) unsigned NOT NULL default '0',
706 `tut6` int(11) unsigned NOT NULL default '0',
707 `tut7` int(11) unsigned NOT NULL default '0',
708 PRIMARY KEY (`account`,`realmid`),
709 KEY acc_key (`account`)
710 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Player System';
713 -- Dumping data for table `character_tutorial`
716 LOCK TABLES `character_tutorial` WRITE;
717 /*!40000 ALTER TABLE `character_tutorial` DISABLE KEYS */;
718 /*!40000 ALTER TABLE `character_tutorial` ENABLE KEYS */;
722 -- Table structure for table `corpse`
725 DROP TABLE IF EXISTS `corpse`;
726 CREATE TABLE `corpse` (
727 `guid` int(11) unsigned NOT NULL default '0' COMMENT 'Global Unique Identifier',
728 `player` int(11) unsigned NOT NULL default '0' COMMENT 'Character Global Unique Identifier',
729 `position_x` float NOT NULL default '0',
730 `position_y` float NOT NULL default '0',
731 `position_z` float NOT NULL default '0',
732 `orientation` float NOT NULL default '0',
733 `zone` int(11) unsigned NOT NULL default '38' COMMENT 'Zone Identifier',
734 `map` int(11) unsigned NOT NULL default '0' COMMENT 'Map Identifier',
735 `phaseMask` smallint(5) unsigned NOT NULL default '1',
737 `time` bigint(20) unsigned NOT NULL default '0',
738 `corpse_type` tinyint(3) unsigned NOT NULL default '0',
739 `instance` int(11) unsigned NOT NULL default '0',
740 PRIMARY KEY (`guid`),
741 KEY `idx_type` (`corpse_type`),
742 KEY `instance` (`instance`)
743 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Death System';
746 -- Dumping data for table `corpse`
749 LOCK TABLES `corpse` WRITE;
750 /*!40000 ALTER TABLE `corpse` DISABLE KEYS */;
751 /*!40000 ALTER TABLE `corpse` ENABLE KEYS */;
755 -- Table structure for table `groups`
758 DROP TABLE IF EXISTS `groups`;
759 CREATE TABLE `groups` (
760 `leaderGuid` int(11) unsigned NOT NULL,
761 `mainTank` int(11) unsigned NOT NULL,
762 `mainAssistant` int(11) unsigned NOT NULL,
763 `lootMethod` tinyint(4) unsigned NOT NULL,
764 `looterGuid` int(11) unsigned NOT NULL,
765 `lootThreshold` tinyint(4) unsigned NOT NULL,
766 `icon1` int(11) unsigned NOT NULL,
767 `icon2` int(11) unsigned NOT NULL,
768 `icon3` int(11) unsigned NOT NULL,
769 `icon4` int(11) unsigned NOT NULL,
770 `icon5` int(11) unsigned NOT NULL,
771 `icon6` int(11) unsigned NOT NULL,
772 `icon7` int(11) unsigned NOT NULL,
773 `icon8` int(11) unsigned NOT NULL,
774 `isRaid` tinyint(1) unsigned NOT NULL,
775 `difficulty` tinyint(3) unsigned NOT NULL default '0',
776 PRIMARY KEY (`leaderGuid`)
777 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Groups';
780 -- Dumping data for table `groups`
783 LOCK TABLES `groups` WRITE;
784 /*!40000 ALTER TABLE `groups` DISABLE KEYS */;
785 /*!40000 ALTER TABLE `groups` ENABLE KEYS */;
788 -- ----------------------------
789 -- Table structure for group_instance
790 -- ----------------------------
791 DROP TABLE IF EXISTS `group_instance`;
792 CREATE TABLE `group_instance` (
793 `leaderGuid` int(11) unsigned NOT NULL default '0',
794 `instance` int(11) unsigned NOT NULL default '0',
795 `permanent` tinyint(1) unsigned NOT NULL default '0',
796 PRIMARY KEY (`leaderGuid`,`instance`),
797 KEY `instance` (`instance`)
798 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
801 -- Dumping data for table `group_instance`
804 LOCK TABLES `group_instance` WRITE;
805 /*!40000 ALTER TABLE `group_instance` DISABLE KEYS */;
806 /*!40000 ALTER TABLE `group_instance` ENABLE KEYS */;
810 -- Table structure for table `group_member`
813 DROP TABLE IF EXISTS `group_member`;
814 CREATE TABLE `group_member` (
815 `leaderGuid` int(11) unsigned NOT NULL,
816 `memberGuid` int(11) unsigned NOT NULL,
817 `assistant` tinyint(1) unsigned NOT NULL,
818 `subgroup` smallint(6) unsigned NOT NULL,
819 PRIMARY KEY (`leaderGuid`,`memberGuid`)
820 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Groups';
823 -- Dumping data for table `group_member`
826 LOCK TABLES `group_member` WRITE;
827 /*!40000 ALTER TABLE `group_member` DISABLE KEYS */;
828 /*!40000 ALTER TABLE `group_member` ENABLE KEYS */;
832 -- Table structure for table `guild`
835 DROP TABLE IF EXISTS `guild`;
836 CREATE TABLE `guild` (
837 `guildid` int(6) unsigned NOT NULL default '0',
838 `name` varchar(255) NOT NULL default '',
839 `leaderguid` int(6) unsigned NOT NULL default '0',
840 `EmblemStyle` int(5) NOT NULL default '0',
841 `EmblemColor` int(5) NOT NULL default '0',
842 `BorderStyle` int(5) NOT NULL default '0',
843 `BorderColor` int(5) NOT NULL default '0',
844 `BackgroundColor` int(5) NOT NULL default '0',
845 `info` text NOT NULL,
846 `motd` varchar(255) NOT NULL default '',
847 `createdate` datetime default NULL,
848 `BankMoney` bigint(20) NOT NULL default '0',
849 PRIMARY KEY (`guildid`)
850 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Guild System';
853 -- Dumping data for table `guild`
856 LOCK TABLES `guild` WRITE;
857 /*!40000 ALTER TABLE `guild` DISABLE KEYS */;
858 /*!40000 ALTER TABLE `guild` ENABLE KEYS */;
862 -- Table structure for table `guild_bank_eventlog`
865 DROP TABLE IF EXISTS `guild_bank_eventlog`;
866 CREATE TABLE `guild_bank_eventlog` (
867 `guildid` int(11) unsigned NOT NULL default '0',
868 `LogGuid` int(11) unsigned NOT NULL default '0',
869 `LogEntry` tinyint(1) unsigned NOT NULL default '0',
870 `TabId` tinyint(1) unsigned NOT NULL default '0',
871 `PlayerGuid` int(11) unsigned NOT NULL default '0',
872 `ItemOrMoney` int(11) unsigned NOT NULL default '0',
873 `ItemStackCount` tinyint(3) unsigned NOT NULL default '0',
874 `DestTabId` tinyint(1) unsigned NOT NULL default '0',
875 `TimeStamp` bigint(20) unsigned NOT NULL default '0',
876 PRIMARY KEY (`guildid`,`LogGuid`),
877 KEY `guildid_key` (`guildid`)
878 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
881 -- Dumping data for table `guild_bank_eventlog`
884 LOCK TABLES `guild_bank_eventlog` WRITE;
885 /*!40000 ALTER TABLE `guild_bank_eventlog` DISABLE KEYS */;
886 /*!40000 ALTER TABLE `guild_bank_eventlog` ENABLE KEYS */;
890 -- Table structure for table `guild_bank_item`
893 DROP TABLE IF EXISTS `guild_bank_item`;
894 CREATE TABLE `guild_bank_item` (
895 `guildid` int(11) unsigned NOT NULL default '0',
896 `TabId` tinyint(1) unsigned NOT NULL default '0',
897 `SlotId` tinyint(3) unsigned NOT NULL default '0',
898 `item_guid` int(11) unsigned NOT NULL default '0',
899 `item_entry` int(11) unsigned NOT NULL default '0',
900 PRIMARY KEY (`guildid`,`tabid`,`slotid`),
901 KEY `guildid_key` (`guildid`)
902 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
905 -- Dumping data for table `guild_bank_item`
908 LOCK TABLES `guild_bank_item` WRITE;
909 /*!40000 ALTER TABLE `guild_bank_item` DISABLE KEYS */;
910 /*!40000 ALTER TABLE `guild_bank_item` ENABLE KEYS */;
914 -- Table structure for table `guild_bank_right`
917 DROP TABLE IF EXISTS `guild_bank_right`;
918 CREATE TABLE `guild_bank_right` (
919 `guildid` int(11) unsigned NOT NULL default '0',
920 `TabId` tinyint(1) unsigned NOT NULL default '0',
921 `rid` int(11) unsigned NOT NULL default '0',
922 `gbright` tinyint(3) unsigned NOT NULL default '0',
923 `SlotPerDay` int(11) unsigned NOT NULL default '0',
924 PRIMARY KEY (`guildid`,`TabId`,`rid`),
925 KEY `guildid_key` (`guildid`)
926 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
929 -- Dumping data for table `guild_bank_right`
932 LOCK TABLES `guild_bank_right` WRITE;
933 /*!40000 ALTER TABLE `guild_bank_right` DISABLE KEYS */;
934 /*!40000 ALTER TABLE `guild_bank_right` ENABLE KEYS */;
938 -- Table structure for table `guild_bank_tab`
941 DROP TABLE IF EXISTS `guild_bank_tab`;
942 CREATE TABLE `guild_bank_tab` (
943 `guildid` int(11) unsigned NOT NULL default '0',
944 `TabId` tinyint(1) unsigned NOT NULL default '0',
945 `TabName` varchar(100) NOT NULL default '',
946 `TabIcon` varchar(100) NOT NULL default '',
948 PRIMARY KEY (`guildid`,`TabId`),
949 KEY `guildid_key` (`guildid`)
950 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
953 -- Dumping data for table `guild_bank_tab`
956 LOCK TABLES `guild_bank_tab` WRITE;
957 /*!40000 ALTER TABLE `guild_bank_tab` DISABLE KEYS */;
958 /*!40000 ALTER TABLE `guild_bank_tab` ENABLE KEYS */;
962 -- Table structure for table `guild_eventlog`
965 DROP TABLE IF EXISTS `guild_eventlog`;
966 CREATE TABLE `guild_eventlog` (
967 `guildid` int(11) NOT NULL COMMENT 'Guild Identificator',
968 `LogGuid` int(11) NOT NULL COMMENT 'Log entry identificator',
969 `EventType` tinyint(1) NOT NULL COMMENT 'Event type',
970 `PlayerGuid1` int(11) NOT NULL COMMENT 'Player 1',
971 `PlayerGuid2` int(11) NOT NULL COMMENT 'Player 2',
972 `NewRank` tinyint(2) NOT NULL COMMENT 'New rank(in case promotion/demotion)',
973 `TimeStamp` bigint(20) NOT NULL COMMENT 'Event UNIX time'
974 ) ENGINE = InnoDB DEFAULT CHARSET = latin1 COMMENT 'Guild Eventlog';
977 -- Dumping data for table `guild_eventlog`
980 LOCK TABLES `guild_eventlog` WRITE;
981 /*!40000 ALTER TABLE `guild_eventlog` DISABLE KEYS */;
982 /*!40000 ALTER TABLE `guild_eventlog` ENABLE KEYS */;
986 -- Table structure for table `guild_member`
989 DROP TABLE IF EXISTS `guild_member`;
990 CREATE TABLE `guild_member` (
991 `guildid` int(6) unsigned NOT NULL default '0',
992 `guid` int(11) unsigned NOT NULL default '0',
993 `rank` tinyint(2) unsigned NOT NULL default '0',
994 `pnote` varchar(255) NOT NULL default '',
995 `offnote` varchar(255) NOT NULL default '',
996 `BankResetTimeMoney` int(11) unsigned NOT NULL default '0',
997 `BankRemMoney` int(11) unsigned NOT NULL default '0',
998 `BankResetTimeTab0` int(11) unsigned NOT NULL default '0',
999 `BankRemSlotsTab0` int(11) unsigned NOT NULL default '0',
1000 `BankResetTimeTab1` int(11) unsigned NOT NULL default '0',
1001 `BankRemSlotsTab1` int(11) unsigned NOT NULL default '0',
1002 `BankResetTimeTab2` int(11) unsigned NOT NULL default '0',
1003 `BankRemSlotsTab2` int(11) unsigned NOT NULL default '0',
1004 `BankResetTimeTab3` int(11) unsigned NOT NULL default '0',
1005 `BankRemSlotsTab3` int(11) unsigned NOT NULL default '0',
1006 `BankResetTimeTab4` int(11) unsigned NOT NULL default '0',
1007 `BankRemSlotsTab4` int(11) unsigned NOT NULL default '0',
1008 `BankResetTimeTab5` int(11) unsigned NOT NULL default '0',
1009 `BankRemSlotsTab5` int(11) unsigned NOT NULL default '0',
1010 KEY `guildid_key` (`guildid`),
1011 KEY `guildid_rank_key` (`guildid`,`rank`),
1012 UNIQUE KEY `guid_key` (`guid`)
1013 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Guild System';
1016 -- Dumping data for table `guild_member`
1019 LOCK TABLES `guild_member` WRITE;
1020 /*!40000 ALTER TABLE `guild_member` DISABLE KEYS */;
1021 /*!40000 ALTER TABLE `guild_member` ENABLE KEYS */;
1025 -- Table structure for table `guild_rank`
1028 DROP TABLE IF EXISTS `guild_rank`;
1029 CREATE TABLE `guild_rank` (
1030 `guildid` int(6) unsigned NOT NULL default '0',
1031 `rid` int(11) unsigned NOT NULL,
1032 `rname` varchar(255) NOT NULL default '',
1033 `rights` int(3) unsigned NOT NULL default '0',
1034 `BankMoneyPerDay` int(11) unsigned NOT NULL default '0',
1035 PRIMARY KEY (`guildid`,`rid`)
1036 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Guild System';
1039 -- Dumping data for table `guild_rank`
1042 LOCK TABLES `guild_rank` WRITE;
1043 /*!40000 ALTER TABLE `guild_rank` DISABLE KEYS */;
1044 /*!40000 ALTER TABLE `guild_rank` ENABLE KEYS */;
1048 -- Table structure for table `instance`
1051 DROP TABLE IF EXISTS `instance`;
1052 CREATE TABLE `instance` (
1053 `id` int(11) unsigned NOT NULL default '0',
1054 `map` int(11) unsigned NOT NULL default '0',
1055 `resettime` bigint(40) NOT NULL default '0',
1056 `difficulty` tinyint(1) unsigned NOT NULL default '0',
1060 KEY `resettime` (`resettime`)
1061 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1064 -- Dumping data for table `instance`
1067 LOCK TABLES `instance` WRITE;
1068 /*!40000 ALTER TABLE `instance` DISABLE KEYS */;
1069 /*!40000 ALTER TABLE `instance` ENABLE KEYS */;
1072 -- ----------------------------
1073 -- Table structure for instance_reset
1074 -- ----------------------------
1075 DROP TABLE IF EXISTS `instance_reset`;
1076 CREATE TABLE `instance_reset` (
1077 `mapid` int(11) unsigned NOT NULL default '0',
1078 `resettime` bigint(40) NOT NULL default '0',
1079 PRIMARY KEY (`mapid`)
1080 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1083 -- Dumping data for table `instance_reset`
1086 LOCK TABLES `instance_reset` WRITE;
1087 /*!40000 ALTER TABLE `instance_reset` DISABLE KEYS */;
1088 /*!40000 ALTER TABLE `instance_reset` ENABLE KEYS */;
1092 -- Table structure for table `item_instance`
1095 DROP TABLE IF EXISTS `item_instance`;
1096 CREATE TABLE `item_instance` (
1097 `guid` int(11) unsigned NOT NULL default '0',
1098 `owner_guid` int(11) unsigned NOT NULL default '0',
1100 PRIMARY KEY (`guid`),
1101 KEY `idx_owner_guid` (`owner_guid`)
1102 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Item System';
1105 -- Dumping data for table `item_instance`
1108 LOCK TABLES `item_instance` WRITE;
1109 /*!40000 ALTER TABLE `item_instance` DISABLE KEYS */;
1110 /*!40000 ALTER TABLE `item_instance` ENABLE KEYS */;
1114 -- Table structure for table `item_text`
1117 DROP TABLE IF EXISTS `item_text`;
1118 CREATE TABLE `item_text` (
1119 `id` int(11) unsigned NOT NULL default '0',
1122 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Item System';
1125 -- Dumping data for table `item_text`
1128 LOCK TABLES `item_text` WRITE;
1129 /*!40000 ALTER TABLE `item_text` DISABLE KEYS */;
1130 /*!40000 ALTER TABLE `item_text` ENABLE KEYS */;
1134 -- Table structure for table `mail`
1137 DROP TABLE IF EXISTS `mail`;
1138 CREATE TABLE `mail` (
1139 `id` int(11) unsigned NOT NULL default '0' COMMENT 'Identifier',
1140 `messageType` tinyint(3) unsigned NOT NULL default '0',
1141 `stationery` tinyint(3) NOT NULL default '41',
1142 `mailTemplateId` mediumint(8) unsigned NOT NULL default '0',
1143 `sender` int(11) unsigned NOT NULL default '0' COMMENT 'Character Global Unique Identifier',
1144 `receiver` int(11) unsigned NOT NULL default '0' COMMENT 'Character Global Unique Identifier',
1146 `itemTextId` int(11) unsigned NOT NULL default '0',
1147 `has_items` tinyint(3) unsigned NOT NULL default '0',
1148 `expire_time` bigint(40) NOT NULL default '0',
1149 `deliver_time` bigint(40) NOT NULL default '0',
1150 `money` int(11) unsigned NOT NULL default '0',
1151 `cod` int(11) unsigned NOT NULL default '0',
1152 `checked` tinyint(3) unsigned NOT NULL default '0',
1154 KEY `idx_receiver` (`receiver`)
1155 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Mail System';
1158 -- Dumping data for table `mail`
1161 LOCK TABLES `mail` WRITE;
1162 /*!40000 ALTER TABLE `mail` DISABLE KEYS */;
1163 /*!40000 ALTER TABLE `mail` ENABLE KEYS */;
1167 -- Table structure for table `mail_items`
1170 DROP TABLE IF EXISTS `mail_items`;
1171 CREATE TABLE `mail_items` (
1172 `mail_id` int(11) NOT NULL default '0',
1173 `item_guid` int(11) NOT NULL default '0',
1174 `item_template` int(11) NOT NULL default '0',
1175 `receiver` int(11) unsigned NOT NULL default '0' COMMENT 'Character Global Unique Identifier',
1176 PRIMARY KEY (`mail_id`,`item_guid`),
1177 KEY `idx_receiver` (`receiver`)
1178 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;
1181 -- Dumping data for table `mail_items`
1184 LOCK TABLES `mail_items` WRITE;
1185 /*!40000 ALTER TABLE `mail_items` DISABLE KEYS */;
1186 /*!40000 ALTER TABLE `mail_items` ENABLE KEYS */;
1190 -- Table structure for table `pet_aura`
1193 DROP TABLE IF EXISTS `pet_aura`;
1194 CREATE TABLE `pet_aura` (
1195 `guid` int(11) unsigned NOT NULL default '0' COMMENT 'Global Unique Identifier',
1196 `caster_guid` bigint(20) unsigned NOT NULL default '0' COMMENT 'Full Global Unique Identifier',
1197 `spell` int(11) unsigned NOT NULL default '0',
1198 `effect_index` int(11) unsigned NOT NULL default '0',
1199 `stackcount` int(11) NOT NULL default '1',
1200 `amount` int(11) NOT NULL default '0',
1201 `maxduration` int(11) NOT NULL default '0',
1202 `remaintime` int(11) NOT NULL default '0',
1203 `remaincharges` int(11) NOT NULL default '0',
1204 PRIMARY KEY (`guid`,`spell`,`effect_index`)
1205 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Pet System';
1208 -- Dumping data for table `pet_aura`
1211 LOCK TABLES `pet_aura` WRITE;
1212 /*!40000 ALTER TABLE `pet_aura` DISABLE KEYS */;
1213 /*!40000 ALTER TABLE `pet_aura` ENABLE KEYS */;
1217 -- Table structure for table `pet_spell`
1220 DROP TABLE IF EXISTS `pet_spell`;
1221 CREATE TABLE `pet_spell` (
1222 `guid` int(11) unsigned NOT NULL default '0' COMMENT 'Global Unique Identifier',
1223 `spell` int(11) unsigned NOT NULL default '0' COMMENT 'Spell Identifier',
1224 `active` int(11) unsigned NOT NULL default '0',
1225 PRIMARY KEY (`guid`,`spell`)
1226 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Pet System';
1229 -- Dumping data for table `pet_spell`
1232 LOCK TABLES `pet_spell` WRITE;
1233 /*!40000 ALTER TABLE `pet_spell` DISABLE KEYS */;
1234 /*!40000 ALTER TABLE `pet_spell` ENABLE KEYS */;
1238 -- Table structure for table `pet_spell_cooldown`
1241 DROP TABLE IF EXISTS `pet_spell_cooldown`;
1242 CREATE TABLE `pet_spell_cooldown` (
1243 `guid` int(11) unsigned NOT NULL default '0' COMMENT 'Global Unique Identifier, Low part',
1244 `spell` int(11) unsigned NOT NULL default '0' COMMENT 'Spell Identifier',
1245 `time` bigint(20) unsigned NOT NULL default '0',
1246 PRIMARY KEY (`guid`,`spell`)
1247 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1250 -- Dumping data for table `pet_spell_cooldown`
1253 LOCK TABLES `pet_spell_cooldown` WRITE;
1254 /*!40000 ALTER TABLE `pet_spell_cooldown` DISABLE KEYS */;
1255 /*!40000 ALTER TABLE `pet_spell_cooldown` ENABLE KEYS */;
1259 -- Table structure for table `petition`
1262 DROP TABLE IF EXISTS `petition`;
1263 CREATE TABLE `petition` (
1264 `ownerguid` int(10) unsigned NOT NULL,
1265 `petitionguid` int(10) unsigned default '0',
1266 `name` varchar(255) NOT NULL default '',
1267 `type` int(10) unsigned NOT NULL default '0',
1268 PRIMARY KEY (`ownerguid`,`type`),
1269 UNIQUE KEY `index_ownerguid_petitionguid` (`ownerguid`,`petitionguid`)
1270 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Guild System';
1273 -- Dumping data for table `petition`
1276 LOCK TABLES `petition` WRITE;
1277 /*!40000 ALTER TABLE `petition` DISABLE KEYS */;
1278 /*!40000 ALTER TABLE `petition` ENABLE KEYS */;
1282 -- Table structure for table `petition_sign`
1285 DROP TABLE IF EXISTS `petition_sign`;
1286 CREATE TABLE `petition_sign` (
1287 `ownerguid` int(10) unsigned NOT NULL,
1288 `petitionguid` int(11) unsigned NOT NULL default '0',
1289 `playerguid` int(11) unsigned NOT NULL default '0',
1290 `player_account` int(11) unsigned NOT NULL default '0',
1291 `type` int(10) unsigned NOT NULL default '0',
1292 PRIMARY KEY (`petitionguid`,`playerguid`)
1293 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Guild System';
1296 -- Dumping data for table `petition_sign`
1299 LOCK TABLES `petition_sign` WRITE;
1300 /*!40000 ALTER TABLE `petition_sign` DISABLE KEYS */;
1301 /*!40000 ALTER TABLE `petition_sign` ENABLE KEYS */;
1303 /*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
1306 -- Table structure for table `saved_variables`
1309 DROP TABLE IF EXISTS `saved_variables`;
1310 CREATE TABLE `saved_variables` (
1311 `NextArenaPointDistributionTime` bigint(40) UNSIGNED NOT NULL DEFAULT '0'
1312 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Variable Saves';
1315 -- Dumping data for table `saved_variables`
1318 LOCK TABLES `saved_variables` WRITE;
1319 /*!40000 ALTER TABLE `saved_variables` DISABLE KEYS */;
1320 /*!40000 ALTER TABLE `saved_variables` ENABLE KEYS */;
1322 /*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
1325 /*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
1326 /*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
1327 /*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
1328 /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
1329 /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
1330 /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
1331 /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
1333 -- Dump completed on 2008-01-10 11:37:06