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_7267_01_characters_auctionhouse` 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',
154 UNIQUE KEY `item_guid` (`itemguid`)
155 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
158 -- Dumping data for table `auctionhouse`
161 LOCK TABLES `auctionhouse` WRITE;
162 /*!40000 ALTER TABLE `auctionhouse` DISABLE KEYS */;
163 /*!40000 ALTER TABLE `auctionhouse` ENABLE KEYS */;
167 -- Table structure for table `bugreport`
170 DROP TABLE IF EXISTS `bugreport`;
171 CREATE TABLE `bugreport` (
172 `id` int(11) NOT NULL auto_increment COMMENT 'Identifier',
173 `type` varchar(255) NOT NULL default '',
174 `content` varchar(255) NOT NULL default '',
176 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Debug System';
179 -- Dumping data for table `bugreport`
182 LOCK TABLES `bugreport` WRITE;
183 /*!40000 ALTER TABLE `bugreport` DISABLE KEYS */;
184 /*!40000 ALTER TABLE `bugreport` ENABLE KEYS */;
188 -- Table structure for table `characters`
191 DROP TABLE IF EXISTS `characters`;
192 CREATE TABLE `characters` (
193 `guid` int(11) unsigned NOT NULL default '0' COMMENT 'Global Unique Identifier',
194 `account` int(11) unsigned NOT NULL default '0' COMMENT 'Account Identifier',
196 `name` varchar(12) NOT NULL default '',
197 `race` tinyint(3) unsigned NOT NULL default '0',
198 `class` tinyint(3) unsigned NOT NULL default '0',
199 `position_x` float NOT NULL default '0',
200 `position_y` float NOT NULL default '0',
201 `position_z` float NOT NULL default '0',
202 `map` int(11) unsigned NOT NULL default '0' COMMENT 'Map Identifier',
203 `dungeon_difficulty` tinyint(1) unsigned NOT NULL DEFAULT '0',
204 `orientation` float NOT NULL default '0',
206 `online` tinyint(3) unsigned NOT NULL default '0',
207 `cinematic` tinyint(3) unsigned NOT NULL default '0',
208 `totaltime` int(11) unsigned NOT NULL default '0',
209 `leveltime` int(11) unsigned NOT NULL default '0',
210 `logout_time` bigint(20) unsigned NOT NULL default '0',
211 `is_logout_resting` tinyint(3) unsigned NOT NULL default '0',
212 `rest_bonus` float NOT NULL default '0',
213 `resettalents_cost` int(11) unsigned NOT NULL default '0',
214 `resettalents_time` bigint(20) unsigned NOT NULL default '0',
215 `trans_x` float NOT NULL default '0',
216 `trans_y` float NOT NULL default '0',
217 `trans_z` float NOT NULL default '0',
218 `trans_o` float NOT NULL default '0',
219 `transguid` bigint(20) unsigned NOT NULL default '0',
220 `extra_flags` int(11) unsigned NOT NULL default '0',
221 `stable_slots` tinyint(1) unsigned NOT NULL default '0',
222 `at_login` int(11) unsigned NOT NULL default '0',
223 `zone` int(11) unsigned NOT NULL default '0',
224 `death_expire_time` bigint(20) unsigned NOT NULL default '0',
226 `arena_pending_points` int(10) UNSIGNED NOT NULL default '0',
227 `bgid` int(10) unsigned NOT NULL default '0',
228 `bgteam` int(10) unsigned NOT NULL default '0',
229 `bgmap` int(10) unsigned NOT NULL default '0',
230 `bgx` float NOT NULL default '0',
231 `bgy` float NOT NULL default '0',
232 `bgz` float NOT NULL default '0',
233 `bgo` float NOT NULL default '0',
234 PRIMARY KEY (`guid`),
235 KEY `idx_account` (`account`),
236 KEY `idx_online` (`online`),
237 KEY `idx_name` (`name`)
238 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Player System';
241 -- Dumping data for table `characters`
244 LOCK TABLES `characters` WRITE;
245 /*!40000 ALTER TABLE `characters` DISABLE KEYS */;
246 /*!40000 ALTER TABLE `characters` ENABLE KEYS */;
250 -- Table structure for table `character_achievement`
253 DROP TABLE IF EXISTS `character_achievement`;
254 CREATE TABLE `character_achievement` (
255 `guid` int(11) NOT NULL,
256 `achievement` int(11) NOT NULL,
257 `date` int(11) NOT NULL,
258 PRIMARY KEY (`guid`,`achievement`)
259 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
262 -- Dumping data for table `character_achievement`
265 LOCK TABLES `character_achievement` WRITE;
266 /*!40000 ALTER TABLE `character_achievement` DISABLE KEYS */;
267 /*!40000 ALTER TABLE `character_achievement` ENABLE KEYS */;
271 -- Table structure for table `character_achievement_progress`
274 DROP TABLE IF EXISTS `character_achievement_progress`;
275 CREATE TABLE `character_achievement_progress` (
276 `guid` int(11) NOT NULL,
277 `criteria` int(11) NOT NULL,
278 `counter` int(11) NOT NULL,
279 `date` int(11) NOT NULL,
280 PRIMARY KEY (`guid`,`criteria`)
281 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
284 -- Dumping data for table `character_achievement_progress`
287 LOCK TABLES `character_achievement_progress` WRITE;
288 /*!40000 ALTER TABLE `character_achievement_progress` DISABLE KEYS */;
289 /*!40000 ALTER TABLE `character_achievement_progress` ENABLE KEYS */;
293 -- Table structure for table `character_action`
296 DROP TABLE IF EXISTS `character_action`;
297 CREATE TABLE `character_action` (
298 `guid` int(11) unsigned NOT NULL default '0' COMMENT 'Global Unique Identifier',
299 `button` tinyint(3) unsigned NOT NULL default '0',
300 `action` smallint(5) unsigned NOT NULL default '0',
301 `type` tinyint(3) unsigned NOT NULL default '0',
302 `misc` tinyint(3) unsigned NOT NULL default '0',
303 PRIMARY KEY (`guid`,`button`)
304 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Player System';
307 -- Dumping data for table `character_action`
310 LOCK TABLES `character_action` WRITE;
311 /*!40000 ALTER TABLE `character_action` DISABLE KEYS */;
312 /*!40000 ALTER TABLE `character_action` ENABLE KEYS */;
316 -- Table structure for table `character_aura`
319 DROP TABLE IF EXISTS `character_aura`;
320 CREATE TABLE `character_aura` (
321 `guid` int(11) unsigned NOT NULL default '0' COMMENT 'Global Unique Identifier',
322 `caster_guid` bigint(20) unsigned NOT NULL default '0' COMMENT 'Full Global Unique Identifier',
323 `spell` int(11) unsigned NOT NULL default '0',
324 `effect_index` int(11) unsigned NOT NULL default '0',
325 `stackcount` int(11) NOT NULL default '1',
326 `amount` int(11) NOT NULL default '0',
327 `maxduration` int(11) NOT NULL default '0',
328 `remaintime` int(11) NOT NULL default '0',
329 `remaincharges` int(11) NOT NULL default '0',
330 PRIMARY KEY (`guid`,`spell`,`effect_index`)
331 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Player System';
334 -- Dumping data for table `character_aura`
337 LOCK TABLES `character_aura` WRITE;
338 /*!40000 ALTER TABLE `character_aura` DISABLE KEYS */;
339 /*!40000 ALTER TABLE `character_aura` ENABLE KEYS */;
343 -- Table structure for table `character_declinedname`
346 DROP TABLE IF EXISTS `character_declinedname`;
347 CREATE TABLE `character_declinedname` (
348 `guid` int(11) unsigned NOT NULL default '0' COMMENT 'Global Unique Identifier',
349 `genitive` varchar(15) NOT NULL default '',
350 `dative` varchar(15) NOT NULL default '',
351 `accusative` varchar(15) NOT NULL default '',
352 `instrumental` varchar(15) NOT NULL default '',
353 `prepositional` varchar(15) NOT NULL default '',
355 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;
358 -- Dumping data for table `character_declinedname`
361 LOCK TABLES `character_declinedname` WRITE;
362 /*!40000 ALTER TABLE `character_declinedname` DISABLE KEYS */;
363 /*!40000 ALTER TABLE `character_declinedname` ENABLE KEYS */;
367 -- Table structure for table `character_gifts`
370 DROP TABLE IF EXISTS `character_gifts`;
371 CREATE TABLE `character_gifts` (
372 `guid` int(20) unsigned NOT NULL default '0',
373 `item_guid` int(11) unsigned NOT NULL default '0',
374 `entry` int(20) unsigned NOT NULL default '0',
375 `flags` int(20) unsigned NOT NULL default '0',
376 PRIMARY KEY (`item_guid`),
377 KEY `idx_guid` (`guid`)
378 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
381 -- Dumping data for table `character_gifts`
384 LOCK TABLES `character_gifts` WRITE;
385 /*!40000 ALTER TABLE `character_gifts` DISABLE KEYS */;
386 /*!40000 ALTER TABLE `character_gifts` ENABLE KEYS */;
390 -- Table structure for table `character_homebind`
393 DROP TABLE IF EXISTS `character_homebind`;
394 CREATE TABLE `character_homebind` (
395 `guid` int(11) unsigned NOT NULL default '0' COMMENT 'Global Unique Identifier',
396 `map` int(11) unsigned NOT NULL default '0' COMMENT 'Map Identifier',
397 `zone` int(11) unsigned NOT NULL default '0' COMMENT 'Zone Identifier',
398 `position_x` float NOT NULL default '0',
399 `position_y` float NOT NULL default '0',
400 `position_z` float NOT NULL default '0',
402 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Player System';
405 -- Dumping data for table `character_homebind`
408 LOCK TABLES `character_homebind` WRITE;
409 /*!40000 ALTER TABLE `character_homebind` DISABLE KEYS */;
410 /*!40000 ALTER TABLE `character_homebind` ENABLE KEYS */;
414 -- Table structure for table `character_instance`
417 DROP TABLE IF EXISTS `character_instance`;
418 CREATE TABLE `character_instance` (
419 `guid` int(11) unsigned NOT NULL default '0',
420 `instance` int(11) unsigned NOT NULL default '0',
421 `permanent` tinyint(1) unsigned NOT NULL default '0',
422 PRIMARY KEY (`guid`,`instance`),
423 KEY `instance` (`instance`)
424 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
427 -- Dumping data for table `character_instance`
430 LOCK TABLES `character_instance` WRITE;
431 /*!40000 ALTER TABLE `character_instance` DISABLE KEYS */;
432 /*!40000 ALTER TABLE `character_instance` ENABLE KEYS */;
436 -- Table structure for table `character_inventory`
439 DROP TABLE IF EXISTS `character_inventory`;
440 CREATE TABLE `character_inventory` (
441 `guid` int(11) unsigned NOT NULL default '0' COMMENT 'Global Unique Identifier',
442 `bag` int(11) unsigned NOT NULL default '0',
443 `slot` tinyint(3) unsigned NOT NULL default '0',
444 `item` int(11) unsigned NOT NULL default '0' COMMENT 'Item Global Unique Identifier',
445 `item_template` int(11) unsigned NOT NULL default '0' COMMENT 'Item Identifier',
446 PRIMARY KEY (`item`),
447 KEY `idx_guid` (`guid`)
448 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Player System';
451 -- Dumping data for table `character_inventory`
454 LOCK TABLES `character_inventory` WRITE;
455 /*!40000 ALTER TABLE `character_inventory` DISABLE KEYS */;
456 /*!40000 ALTER TABLE `character_inventory` ENABLE KEYS */;
460 -- Table structure for table `character_pet`
463 DROP TABLE IF EXISTS `character_pet`;
464 CREATE TABLE `character_pet` (
465 `id` int(11) unsigned NOT NULL default '0',
466 `entry` int(11) unsigned NOT NULL default '0',
467 `owner` int(11) unsigned NOT NULL default '0',
468 `modelid` int(11) unsigned default '0',
469 `CreatedBySpell` int(11) unsigned NOT NULL default '0',
470 `PetType` tinyint(3) unsigned NOT NULL default '0',
471 `level` int(11) unsigned NOT NULL default '1',
472 `exp` int(11) unsigned NOT NULL default '0',
473 `Reactstate` tinyint(1) unsigned NOT NULL default '0',
474 `talentpoints` int(11) 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',
485 `teachspelldata` longtext,
487 KEY `owner` (`owner`)
488 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Pet System';
491 -- Dumping data for table `character_pet`
494 LOCK TABLES `character_pet` WRITE;
495 /*!40000 ALTER TABLE `character_pet` DISABLE KEYS */;
496 /*!40000 ALTER TABLE `character_pet` ENABLE KEYS */;
500 -- Table structure for table `character_pet_declinedname`
503 DROP TABLE IF EXISTS `character_pet_declinedname`;
504 CREATE TABLE `character_pet_declinedname` (
505 `id` int(11) unsigned NOT NULL default '0',
506 `owner` int(11) unsigned NOT NULL default '0',
507 `genitive` varchar(12) NOT NULL default '',
508 `dative` varchar(12) NOT NULL default '',
509 `accusative` varchar(12) NOT NULL default '',
510 `instrumental` varchar(12) NOT NULL default '',
511 `prepositional` varchar(12) NOT NULL default '',
513 KEY owner_key (`owner`)
514 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;
517 -- Dumping data for table `character_pet_declinedname`
520 LOCK TABLES `character_pet_declinedname` WRITE;
521 /*!40000 ALTER TABLE `character_pet_declinedname` DISABLE KEYS */;
522 /*!40000 ALTER TABLE `character_pet_declinedname` ENABLE KEYS */;
526 -- Table structure for table `character_queststatus`
529 DROP TABLE IF EXISTS `character_queststatus`;
530 CREATE TABLE `character_queststatus` (
531 `guid` int(11) unsigned NOT NULL default '0' COMMENT 'Global Unique Identifier',
532 `quest` int(11) unsigned NOT NULL default '0' COMMENT 'Quest Identifier',
533 `status` int(11) unsigned NOT NULL default '0',
534 `rewarded` tinyint(1) unsigned NOT NULL default '0',
535 `explored` tinyint(1) unsigned NOT NULL default '0',
536 `timer` bigint(20) unsigned NOT NULL default '0',
537 `mobcount1` int(11) unsigned NOT NULL default '0',
538 `mobcount2` int(11) unsigned NOT NULL default '0',
539 `mobcount3` int(11) unsigned NOT NULL default '0',
540 `mobcount4` int(11) unsigned NOT NULL default '0',
541 `itemcount1` int(11) unsigned NOT NULL default '0',
542 `itemcount2` int(11) unsigned NOT NULL default '0',
543 `itemcount3` int(11) unsigned NOT NULL default '0',
544 `itemcount4` int(11) unsigned NOT NULL default '0',
545 PRIMARY KEY (`guid`,`quest`)
546 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Player System';
549 -- Dumping data for table `character_queststatus`
552 LOCK TABLES `character_queststatus` WRITE;
553 /*!40000 ALTER TABLE `character_queststatus` DISABLE KEYS */;
554 /*!40000 ALTER TABLE `character_queststatus` ENABLE KEYS */;
558 -- Table structure for table `character_queststatus_daily`
561 DROP TABLE IF EXISTS `character_queststatus_daily`;
562 CREATE TABLE `character_queststatus_daily` (
563 `guid` int(11) unsigned NOT NULL default '0' COMMENT 'Global Unique Identifier',
564 `quest` int(11) unsigned NOT NULL default '0' COMMENT 'Quest Identifier',
565 `time` bigint(20) unsigned NOT NULL default '0',
566 PRIMARY KEY (`guid`,`quest`),
567 KEY `idx_guid` (`guid`)
568 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Player System';
571 -- Dumping data for table `character_queststatus_daily`
574 LOCK TABLES `character_queststatus_daily` WRITE;
575 /*!40000 ALTER TABLE `character_queststatus_daily` DISABLE KEYS */;
576 /*!40000 ALTER TABLE `character_queststatus_daily` ENABLE KEYS */;
580 -- Table structure for table `character_reputation`
583 DROP TABLE IF EXISTS `character_reputation`;
584 CREATE TABLE `character_reputation` (
585 `guid` int(11) unsigned NOT NULL default '0' COMMENT 'Global Unique Identifier',
586 `faction` int(11) unsigned NOT NULL default '0',
587 `standing` int(11) NOT NULL default '0',
588 `flags` int(11) NOT NULL default '0',
589 PRIMARY KEY (`guid`,`faction`)
590 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Player System';
593 -- Dumping data for table `character_reputation`
596 LOCK TABLES `character_reputation` WRITE;
597 /*!40000 ALTER TABLE `character_reputation` DISABLE KEYS */;
598 /*!40000 ALTER TABLE `character_reputation` ENABLE KEYS */;
602 -- Table structure for table `character_social`
605 DROP TABLE IF EXISTS `character_social`;
606 CREATE TABLE `character_social` (
607 `guid` int(11) unsigned NOT NULL default '0' COMMENT 'Character Global Unique Identifier',
608 `friend` int(11) unsigned NOT NULL default '0' COMMENT 'Friend Global Unique Identifier',
609 `flags` tinyint(1) unsigned NOT NULL default '0' COMMENT 'Friend Flags',
610 `note` varchar(48) NOT NULL DEFAULT '' COMMENT 'Friend Note',
611 PRIMARY KEY (`guid`,`friend`,`flags`),
613 KEY `friend` (`friend`),
614 KEY `guid_flags` (`guid`,`flags`),
615 KEY `friend_flags` (`friend`,`flags`)
616 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Player System';
619 -- Dumping data for table `character_social`
622 LOCK TABLES `character_social` WRITE;
623 /*!40000 ALTER TABLE `character_social` DISABLE KEYS */;
624 /*!40000 ALTER TABLE `character_social` ENABLE KEYS */;
628 -- Table structure for table `character_spell`
631 DROP TABLE IF EXISTS `character_spell`;
632 CREATE TABLE `character_spell` (
633 `guid` int(11) unsigned NOT NULL default '0' COMMENT 'Global Unique Identifier',
634 `spell` int(11) unsigned NOT NULL default '0' COMMENT 'Spell Identifier',
635 `active` tinyint(3) unsigned NOT NULL default '1',
636 `disabled` tinyint(3) unsigned NOT NULL default '0',
637 PRIMARY KEY (`guid`,`spell`)
638 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Player System';
641 -- Dumping data for table `character_spell`
644 LOCK TABLES `character_spell` WRITE;
645 /*!40000 ALTER TABLE `character_spell` DISABLE KEYS */;
646 /*!40000 ALTER TABLE `character_spell` ENABLE KEYS */;
650 -- Table structure for table `character_spell_cooldown`
653 DROP TABLE IF EXISTS `character_spell_cooldown`;
654 CREATE TABLE `character_spell_cooldown` (
655 `guid` int(11) unsigned NOT NULL default '0' COMMENT 'Global Unique Identifier, Low part',
656 `spell` int(11) unsigned NOT NULL default '0' COMMENT 'Spell Identifier',
657 `item` int(11) unsigned NOT NULL default '0' COMMENT 'Item Identifier',
658 `time` bigint(20) unsigned NOT NULL default '0',
659 PRIMARY KEY (`guid`,`spell`)
660 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
663 -- Dumping data for table `character_spell_cooldown`
666 LOCK TABLES `character_spell_cooldown` WRITE;
667 /*!40000 ALTER TABLE `character_spell_cooldown` DISABLE KEYS */;
668 /*!40000 ALTER TABLE `character_spell_cooldown` ENABLE KEYS */;
672 -- Table structure for table `character_ticket`
675 DROP TABLE IF EXISTS `character_ticket`;
676 CREATE TABLE `character_ticket` (
677 `ticket_id` int(11) unsigned NOT NULL auto_increment,
678 `guid` int(11) unsigned NOT NULL default '0',
680 `ticket_lastchange` TIMESTAMP ON UPDATE CURRENT_TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
681 PRIMARY KEY (`ticket_id`)
682 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Player System';
685 -- Dumping data for table `character_ticket`
688 LOCK TABLES `character_ticket` WRITE;
689 /*!40000 ALTER TABLE `character_ticket` DISABLE KEYS */;
690 /*!40000 ALTER TABLE `character_ticket` ENABLE KEYS */;
694 -- Table structure for table `character_tutorial`
697 DROP TABLE IF EXISTS `character_tutorial`;
698 CREATE TABLE `character_tutorial` (
699 `account` bigint(20) unsigned NOT NULL auto_increment COMMENT 'Account Identifier',
700 `realmid` int(11) unsigned NOT NULL default '0' COMMENT 'Realm Identifier',
701 `tut0` int(11) unsigned NOT NULL default '0',
702 `tut1` int(11) unsigned NOT NULL default '0',
703 `tut2` int(11) unsigned NOT NULL default '0',
704 `tut3` int(11) unsigned NOT NULL default '0',
705 `tut4` int(11) unsigned NOT NULL default '0',
706 `tut5` int(11) unsigned NOT NULL default '0',
707 `tut6` int(11) unsigned NOT NULL default '0',
708 `tut7` int(11) unsigned NOT NULL default '0',
709 PRIMARY KEY (`account`,`realmid`),
710 KEY acc_key (`account`)
711 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Player System';
714 -- Dumping data for table `character_tutorial`
717 LOCK TABLES `character_tutorial` WRITE;
718 /*!40000 ALTER TABLE `character_tutorial` DISABLE KEYS */;
719 /*!40000 ALTER TABLE `character_tutorial` ENABLE KEYS */;
723 -- Table structure for table `corpse`
726 DROP TABLE IF EXISTS `corpse`;
727 CREATE TABLE `corpse` (
728 `guid` int(11) unsigned NOT NULL default '0' COMMENT 'Global Unique Identifier',
729 `player` int(11) unsigned NOT NULL default '0' COMMENT 'Character Global Unique Identifier',
730 `position_x` float NOT NULL default '0',
731 `position_y` float NOT NULL default '0',
732 `position_z` float NOT NULL default '0',
733 `orientation` float NOT NULL default '0',
734 `zone` int(11) unsigned NOT NULL default '38' COMMENT 'Zone Identifier',
735 `map` int(11) unsigned NOT NULL default '0' COMMENT 'Map Identifier',
736 `phaseMask` smallint(5) unsigned NOT NULL default '1',
738 `time` bigint(20) unsigned NOT NULL default '0',
739 `corpse_type` tinyint(3) unsigned NOT NULL default '0',
740 `instance` int(11) unsigned NOT NULL default '0',
741 PRIMARY KEY (`guid`),
742 KEY `idx_type` (`corpse_type`),
743 KEY `instance` (`instance`)
744 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Death System';
747 -- Dumping data for table `corpse`
750 LOCK TABLES `corpse` WRITE;
751 /*!40000 ALTER TABLE `corpse` DISABLE KEYS */;
752 /*!40000 ALTER TABLE `corpse` ENABLE KEYS */;
756 -- Table structure for table `groups`
759 DROP TABLE IF EXISTS `groups`;
760 CREATE TABLE `groups` (
761 `leaderGuid` int(11) unsigned NOT NULL,
762 `mainTank` int(11) unsigned NOT NULL,
763 `mainAssistant` int(11) unsigned NOT NULL,
764 `lootMethod` tinyint(4) unsigned NOT NULL,
765 `looterGuid` int(11) unsigned NOT NULL,
766 `lootThreshold` tinyint(4) unsigned NOT NULL,
767 `icon1` int(11) unsigned NOT NULL,
768 `icon2` int(11) unsigned NOT NULL,
769 `icon3` int(11) unsigned NOT NULL,
770 `icon4` int(11) unsigned NOT NULL,
771 `icon5` int(11) unsigned NOT NULL,
772 `icon6` int(11) unsigned NOT NULL,
773 `icon7` int(11) unsigned NOT NULL,
774 `icon8` int(11) unsigned NOT NULL,
775 `isRaid` tinyint(1) unsigned NOT NULL,
776 `difficulty` tinyint(3) unsigned NOT NULL default '0',
777 PRIMARY KEY (`leaderGuid`)
778 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Groups';
781 -- Dumping data for table `groups`
784 LOCK TABLES `groups` WRITE;
785 /*!40000 ALTER TABLE `groups` DISABLE KEYS */;
786 /*!40000 ALTER TABLE `groups` ENABLE KEYS */;
789 -- ----------------------------
790 -- Table structure for group_instance
791 -- ----------------------------
792 DROP TABLE IF EXISTS `group_instance`;
793 CREATE TABLE `group_instance` (
794 `leaderGuid` int(11) unsigned NOT NULL default '0',
795 `instance` int(11) unsigned NOT NULL default '0',
796 `permanent` tinyint(1) unsigned NOT NULL default '0',
797 PRIMARY KEY (`leaderGuid`,`instance`),
798 KEY `instance` (`instance`)
799 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
802 -- Dumping data for table `group_instance`
805 LOCK TABLES `group_instance` WRITE;
806 /*!40000 ALTER TABLE `group_instance` DISABLE KEYS */;
807 /*!40000 ALTER TABLE `group_instance` ENABLE KEYS */;
811 -- Table structure for table `group_member`
814 DROP TABLE IF EXISTS `group_member`;
815 CREATE TABLE `group_member` (
816 `leaderGuid` int(11) unsigned NOT NULL,
817 `memberGuid` int(11) unsigned NOT NULL,
818 `assistant` tinyint(1) unsigned NOT NULL,
819 `subgroup` smallint(6) unsigned NOT NULL,
820 PRIMARY KEY (`leaderGuid`,`memberGuid`)
821 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Groups';
824 -- Dumping data for table `group_member`
827 LOCK TABLES `group_member` WRITE;
828 /*!40000 ALTER TABLE `group_member` DISABLE KEYS */;
829 /*!40000 ALTER TABLE `group_member` ENABLE KEYS */;
833 -- Table structure for table `guild`
836 DROP TABLE IF EXISTS `guild`;
837 CREATE TABLE `guild` (
838 `guildid` int(6) unsigned NOT NULL default '0',
839 `name` varchar(255) NOT NULL default '',
840 `leaderguid` int(6) unsigned NOT NULL default '0',
841 `EmblemStyle` int(5) NOT NULL default '0',
842 `EmblemColor` int(5) NOT NULL default '0',
843 `BorderStyle` int(5) NOT NULL default '0',
844 `BorderColor` int(5) NOT NULL default '0',
845 `BackgroundColor` int(5) NOT NULL default '0',
846 `info` text NOT NULL,
847 `motd` varchar(255) NOT NULL default '',
848 `createdate` datetime default NULL,
849 `BankMoney` bigint(20) NOT NULL default '0',
850 PRIMARY KEY (`guildid`)
851 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Guild System';
854 -- Dumping data for table `guild`
857 LOCK TABLES `guild` WRITE;
858 /*!40000 ALTER TABLE `guild` DISABLE KEYS */;
859 /*!40000 ALTER TABLE `guild` ENABLE KEYS */;
863 -- Table structure for table `guild_bank_eventlog`
866 DROP TABLE IF EXISTS `guild_bank_eventlog`;
867 CREATE TABLE `guild_bank_eventlog` (
868 `guildid` int(11) unsigned NOT NULL default '0',
869 `LogGuid` int(11) unsigned NOT NULL default '0',
870 `LogEntry` tinyint(1) unsigned NOT NULL default '0',
871 `TabId` tinyint(1) unsigned NOT NULL default '0',
872 `PlayerGuid` int(11) unsigned NOT NULL default '0',
873 `ItemOrMoney` int(11) unsigned NOT NULL default '0',
874 `ItemStackCount` tinyint(3) unsigned NOT NULL default '0',
875 `DestTabId` tinyint(1) unsigned NOT NULL default '0',
876 `TimeStamp` bigint(20) unsigned NOT NULL default '0',
877 PRIMARY KEY (`guildid`,`LogGuid`),
878 KEY `guildid_key` (`guildid`)
879 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
882 -- Dumping data for table `guild_bank_eventlog`
885 LOCK TABLES `guild_bank_eventlog` WRITE;
886 /*!40000 ALTER TABLE `guild_bank_eventlog` DISABLE KEYS */;
887 /*!40000 ALTER TABLE `guild_bank_eventlog` ENABLE KEYS */;
891 -- Table structure for table `guild_bank_item`
894 DROP TABLE IF EXISTS `guild_bank_item`;
895 CREATE TABLE `guild_bank_item` (
896 `guildid` int(11) unsigned NOT NULL default '0',
897 `TabId` tinyint(1) unsigned NOT NULL default '0',
898 `SlotId` tinyint(3) unsigned NOT NULL default '0',
899 `item_guid` int(11) unsigned NOT NULL default '0',
900 `item_entry` int(11) unsigned NOT NULL default '0',
901 PRIMARY KEY (`guildid`,`tabid`,`slotid`),
902 KEY `guildid_key` (`guildid`)
903 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
906 -- Dumping data for table `guild_bank_item`
909 LOCK TABLES `guild_bank_item` WRITE;
910 /*!40000 ALTER TABLE `guild_bank_item` DISABLE KEYS */;
911 /*!40000 ALTER TABLE `guild_bank_item` ENABLE KEYS */;
915 -- Table structure for table `guild_bank_right`
918 DROP TABLE IF EXISTS `guild_bank_right`;
919 CREATE TABLE `guild_bank_right` (
920 `guildid` int(11) unsigned NOT NULL default '0',
921 `TabId` tinyint(1) unsigned NOT NULL default '0',
922 `rid` int(11) unsigned NOT NULL default '0',
923 `gbright` tinyint(3) unsigned NOT NULL default '0',
924 `SlotPerDay` int(11) unsigned NOT NULL default '0',
925 PRIMARY KEY (`guildid`,`TabId`,`rid`),
926 KEY `guildid_key` (`guildid`)
927 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
930 -- Dumping data for table `guild_bank_right`
933 LOCK TABLES `guild_bank_right` WRITE;
934 /*!40000 ALTER TABLE `guild_bank_right` DISABLE KEYS */;
935 /*!40000 ALTER TABLE `guild_bank_right` ENABLE KEYS */;
939 -- Table structure for table `guild_bank_tab`
942 DROP TABLE IF EXISTS `guild_bank_tab`;
943 CREATE TABLE `guild_bank_tab` (
944 `guildid` int(11) unsigned NOT NULL default '0',
945 `TabId` tinyint(1) unsigned NOT NULL default '0',
946 `TabName` varchar(100) NOT NULL default '',
947 `TabIcon` varchar(100) NOT NULL default '',
949 PRIMARY KEY (`guildid`,`TabId`),
950 KEY `guildid_key` (`guildid`)
951 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
954 -- Dumping data for table `guild_bank_tab`
957 LOCK TABLES `guild_bank_tab` WRITE;
958 /*!40000 ALTER TABLE `guild_bank_tab` DISABLE KEYS */;
959 /*!40000 ALTER TABLE `guild_bank_tab` ENABLE KEYS */;
963 -- Table structure for table `guild_eventlog`
966 DROP TABLE IF EXISTS `guild_eventlog`;
967 CREATE TABLE `guild_eventlog` (
968 `guildid` int(11) NOT NULL COMMENT 'Guild Identificator',
969 `LogGuid` int(11) NOT NULL COMMENT 'Log entry identificator',
970 `EventType` tinyint(1) NOT NULL COMMENT 'Event type',
971 `PlayerGuid1` int(11) NOT NULL COMMENT 'Player 1',
972 `PlayerGuid2` int(11) NOT NULL COMMENT 'Player 2',
973 `NewRank` tinyint(2) NOT NULL COMMENT 'New rank(in case promotion/demotion)',
974 `TimeStamp` bigint(20) NOT NULL COMMENT 'Event UNIX time'
975 ) ENGINE = InnoDB DEFAULT CHARSET = latin1 COMMENT 'Guild Eventlog';
978 -- Dumping data for table `guild_eventlog`
981 LOCK TABLES `guild_eventlog` WRITE;
982 /*!40000 ALTER TABLE `guild_eventlog` DISABLE KEYS */;
983 /*!40000 ALTER TABLE `guild_eventlog` ENABLE KEYS */;
987 -- Table structure for table `guild_member`
990 DROP TABLE IF EXISTS `guild_member`;
991 CREATE TABLE `guild_member` (
992 `guildid` int(6) unsigned NOT NULL default '0',
993 `guid` int(11) unsigned NOT NULL default '0',
994 `rank` tinyint(2) unsigned NOT NULL default '0',
995 `pnote` varchar(255) NOT NULL default '',
996 `offnote` varchar(255) NOT NULL default '',
997 `BankResetTimeMoney` int(11) unsigned NOT NULL default '0',
998 `BankRemMoney` int(11) unsigned NOT NULL default '0',
999 `BankResetTimeTab0` int(11) unsigned NOT NULL default '0',
1000 `BankRemSlotsTab0` int(11) unsigned NOT NULL default '0',
1001 `BankResetTimeTab1` int(11) unsigned NOT NULL default '0',
1002 `BankRemSlotsTab1` int(11) unsigned NOT NULL default '0',
1003 `BankResetTimeTab2` int(11) unsigned NOT NULL default '0',
1004 `BankRemSlotsTab2` int(11) unsigned NOT NULL default '0',
1005 `BankResetTimeTab3` int(11) unsigned NOT NULL default '0',
1006 `BankRemSlotsTab3` int(11) unsigned NOT NULL default '0',
1007 `BankResetTimeTab4` int(11) unsigned NOT NULL default '0',
1008 `BankRemSlotsTab4` int(11) unsigned NOT NULL default '0',
1009 `BankResetTimeTab5` int(11) unsigned NOT NULL default '0',
1010 `BankRemSlotsTab5` int(11) unsigned NOT NULL default '0',
1011 KEY `guildid_key` (`guildid`),
1012 KEY `guildid_rank_key` (`guildid`,`rank`),
1013 UNIQUE KEY `guid_key` (`guid`)
1014 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Guild System';
1017 -- Dumping data for table `guild_member`
1020 LOCK TABLES `guild_member` WRITE;
1021 /*!40000 ALTER TABLE `guild_member` DISABLE KEYS */;
1022 /*!40000 ALTER TABLE `guild_member` ENABLE KEYS */;
1026 -- Table structure for table `guild_rank`
1029 DROP TABLE IF EXISTS `guild_rank`;
1030 CREATE TABLE `guild_rank` (
1031 `guildid` int(6) unsigned NOT NULL default '0',
1032 `rid` int(11) unsigned NOT NULL,
1033 `rname` varchar(255) NOT NULL default '',
1034 `rights` int(3) unsigned NOT NULL default '0',
1035 `BankMoneyPerDay` int(11) unsigned NOT NULL default '0',
1036 PRIMARY KEY (`guildid`,`rid`)
1037 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Guild System';
1040 -- Dumping data for table `guild_rank`
1043 LOCK TABLES `guild_rank` WRITE;
1044 /*!40000 ALTER TABLE `guild_rank` DISABLE KEYS */;
1045 /*!40000 ALTER TABLE `guild_rank` ENABLE KEYS */;
1049 -- Table structure for table `instance`
1052 DROP TABLE IF EXISTS `instance`;
1053 CREATE TABLE `instance` (
1054 `id` int(11) unsigned NOT NULL default '0',
1055 `map` int(11) unsigned NOT NULL default '0',
1056 `resettime` bigint(40) NOT NULL default '0',
1057 `difficulty` tinyint(1) unsigned NOT NULL default '0',
1061 KEY `resettime` (`resettime`)
1062 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1065 -- Dumping data for table `instance`
1068 LOCK TABLES `instance` WRITE;
1069 /*!40000 ALTER TABLE `instance` DISABLE KEYS */;
1070 /*!40000 ALTER TABLE `instance` ENABLE KEYS */;
1073 -- ----------------------------
1074 -- Table structure for instance_reset
1075 -- ----------------------------
1076 DROP TABLE IF EXISTS `instance_reset`;
1077 CREATE TABLE `instance_reset` (
1078 `mapid` int(11) unsigned NOT NULL default '0',
1079 `resettime` bigint(40) NOT NULL default '0',
1080 PRIMARY KEY (`mapid`)
1081 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1084 -- Dumping data for table `instance_reset`
1087 LOCK TABLES `instance_reset` WRITE;
1088 /*!40000 ALTER TABLE `instance_reset` DISABLE KEYS */;
1089 /*!40000 ALTER TABLE `instance_reset` ENABLE KEYS */;
1093 -- Table structure for table `item_instance`
1096 DROP TABLE IF EXISTS `item_instance`;
1097 CREATE TABLE `item_instance` (
1098 `guid` int(11) unsigned NOT NULL default '0',
1099 `owner_guid` int(11) unsigned NOT NULL default '0',
1101 PRIMARY KEY (`guid`),
1102 KEY `idx_owner_guid` (`owner_guid`)
1103 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Item System';
1106 -- Dumping data for table `item_instance`
1109 LOCK TABLES `item_instance` WRITE;
1110 /*!40000 ALTER TABLE `item_instance` DISABLE KEYS */;
1111 /*!40000 ALTER TABLE `item_instance` ENABLE KEYS */;
1115 -- Table structure for table `item_text`
1118 DROP TABLE IF EXISTS `item_text`;
1119 CREATE TABLE `item_text` (
1120 `id` int(11) unsigned NOT NULL default '0',
1123 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Item System';
1126 -- Dumping data for table `item_text`
1129 LOCK TABLES `item_text` WRITE;
1130 /*!40000 ALTER TABLE `item_text` DISABLE KEYS */;
1131 /*!40000 ALTER TABLE `item_text` ENABLE KEYS */;
1135 -- Table structure for table `mail`
1138 DROP TABLE IF EXISTS `mail`;
1139 CREATE TABLE `mail` (
1140 `id` int(11) unsigned NOT NULL default '0' COMMENT 'Identifier',
1141 `messageType` tinyint(3) unsigned NOT NULL default '0',
1142 `stationery` tinyint(3) NOT NULL default '41',
1143 `mailTemplateId` mediumint(8) unsigned NOT NULL default '0',
1144 `sender` int(11) unsigned NOT NULL default '0' COMMENT 'Character Global Unique Identifier',
1145 `receiver` int(11) unsigned NOT NULL default '0' COMMENT 'Character Global Unique Identifier',
1147 `itemTextId` int(11) unsigned NOT NULL default '0',
1148 `has_items` tinyint(3) unsigned NOT NULL default '0',
1149 `expire_time` bigint(40) NOT NULL default '0',
1150 `deliver_time` bigint(40) NOT NULL default '0',
1151 `money` int(11) unsigned NOT NULL default '0',
1152 `cod` int(11) unsigned NOT NULL default '0',
1153 `checked` tinyint(3) unsigned NOT NULL default '0',
1155 KEY `idx_receiver` (`receiver`)
1156 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Mail System';
1159 -- Dumping data for table `mail`
1162 LOCK TABLES `mail` WRITE;
1163 /*!40000 ALTER TABLE `mail` DISABLE KEYS */;
1164 /*!40000 ALTER TABLE `mail` ENABLE KEYS */;
1168 -- Table structure for table `mail_items`
1171 DROP TABLE IF EXISTS `mail_items`;
1172 CREATE TABLE `mail_items` (
1173 `mail_id` int(11) NOT NULL default '0',
1174 `item_guid` int(11) NOT NULL default '0',
1175 `item_template` int(11) NOT NULL default '0',
1176 `receiver` int(11) unsigned NOT NULL default '0' COMMENT 'Character Global Unique Identifier',
1177 PRIMARY KEY (`mail_id`,`item_guid`),
1178 KEY `idx_receiver` (`receiver`)
1179 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;
1182 -- Dumping data for table `mail_items`
1185 LOCK TABLES `mail_items` WRITE;
1186 /*!40000 ALTER TABLE `mail_items` DISABLE KEYS */;
1187 /*!40000 ALTER TABLE `mail_items` ENABLE KEYS */;
1191 -- Table structure for table `pet_aura`
1194 DROP TABLE IF EXISTS `pet_aura`;
1195 CREATE TABLE `pet_aura` (
1196 `guid` int(11) unsigned NOT NULL default '0' COMMENT 'Global Unique Identifier',
1197 `caster_guid` bigint(20) unsigned NOT NULL default '0' COMMENT 'Full Global Unique Identifier',
1198 `spell` int(11) unsigned NOT NULL default '0',
1199 `effect_index` int(11) unsigned NOT NULL default '0',
1200 `stackcount` int(11) NOT NULL default '1',
1201 `amount` int(11) NOT NULL default '0',
1202 `maxduration` int(11) NOT NULL default '0',
1203 `remaintime` int(11) NOT NULL default '0',
1204 `remaincharges` int(11) NOT NULL default '0',
1205 PRIMARY KEY (`guid`,`spell`,`effect_index`)
1206 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Pet System';
1209 -- Dumping data for table `pet_aura`
1212 LOCK TABLES `pet_aura` WRITE;
1213 /*!40000 ALTER TABLE `pet_aura` DISABLE KEYS */;
1214 /*!40000 ALTER TABLE `pet_aura` ENABLE KEYS */;
1218 -- Table structure for table `pet_spell`
1221 DROP TABLE IF EXISTS `pet_spell`;
1222 CREATE TABLE `pet_spell` (
1223 `guid` int(11) unsigned NOT NULL default '0' COMMENT 'Global Unique Identifier',
1224 `spell` int(11) unsigned NOT NULL default '0' COMMENT 'Spell Identifier',
1225 `active` int(11) unsigned NOT NULL default '0',
1226 PRIMARY KEY (`guid`,`spell`)
1227 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Pet System';
1230 -- Dumping data for table `pet_spell`
1233 LOCK TABLES `pet_spell` WRITE;
1234 /*!40000 ALTER TABLE `pet_spell` DISABLE KEYS */;
1235 /*!40000 ALTER TABLE `pet_spell` ENABLE KEYS */;
1239 -- Table structure for table `pet_spell_cooldown`
1242 DROP TABLE IF EXISTS `pet_spell_cooldown`;
1243 CREATE TABLE `pet_spell_cooldown` (
1244 `guid` int(11) unsigned NOT NULL default '0' COMMENT 'Global Unique Identifier, Low part',
1245 `spell` int(11) unsigned NOT NULL default '0' COMMENT 'Spell Identifier',
1246 `time` bigint(20) unsigned NOT NULL default '0',
1247 PRIMARY KEY (`guid`,`spell`)
1248 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1251 -- Dumping data for table `pet_spell_cooldown`
1254 LOCK TABLES `pet_spell_cooldown` WRITE;
1255 /*!40000 ALTER TABLE `pet_spell_cooldown` DISABLE KEYS */;
1256 /*!40000 ALTER TABLE `pet_spell_cooldown` ENABLE KEYS */;
1260 -- Table structure for table `petition`
1263 DROP TABLE IF EXISTS `petition`;
1264 CREATE TABLE `petition` (
1265 `ownerguid` int(10) unsigned NOT NULL,
1266 `petitionguid` int(10) unsigned default '0',
1267 `name` varchar(255) NOT NULL default '',
1268 `type` int(10) unsigned NOT NULL default '0',
1269 PRIMARY KEY (`ownerguid`,`type`),
1270 UNIQUE KEY `index_ownerguid_petitionguid` (`ownerguid`,`petitionguid`)
1271 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Guild System';
1274 -- Dumping data for table `petition`
1277 LOCK TABLES `petition` WRITE;
1278 /*!40000 ALTER TABLE `petition` DISABLE KEYS */;
1279 /*!40000 ALTER TABLE `petition` ENABLE KEYS */;
1283 -- Table structure for table `petition_sign`
1286 DROP TABLE IF EXISTS `petition_sign`;
1287 CREATE TABLE `petition_sign` (
1288 `ownerguid` int(10) unsigned NOT NULL,
1289 `petitionguid` int(11) unsigned NOT NULL default '0',
1290 `playerguid` int(11) unsigned NOT NULL default '0',
1291 `player_account` int(11) unsigned NOT NULL default '0',
1292 `type` int(10) unsigned NOT NULL default '0',
1293 PRIMARY KEY (`petitionguid`,`playerguid`)
1294 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Guild System';
1297 -- Dumping data for table `petition_sign`
1300 LOCK TABLES `petition_sign` WRITE;
1301 /*!40000 ALTER TABLE `petition_sign` DISABLE KEYS */;
1302 /*!40000 ALTER TABLE `petition_sign` ENABLE KEYS */;
1304 /*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
1307 -- Table structure for table `saved_variables`
1310 DROP TABLE IF EXISTS `saved_variables`;
1311 CREATE TABLE `saved_variables` (
1312 `NextArenaPointDistributionTime` bigint(40) UNSIGNED NOT NULL DEFAULT '0'
1313 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Variable Saves';
1316 -- Dumping data for table `saved_variables`
1319 LOCK TABLES `saved_variables` WRITE;
1320 /*!40000 ALTER TABLE `saved_variables` DISABLE KEYS */;
1321 /*!40000 ALTER TABLE `saved_variables` ENABLE KEYS */;
1323 /*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
1326 /*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
1327 /*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
1328 /*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
1329 /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
1330 /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
1331 /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
1332 /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
1334 -- Dump completed on 2008-01-10 11:37:06