1 CREATE DATABASE `characters` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;
2 GRANT ALL PRIVILEGES ON `characters` . * TO 'mangos'@'localhost' WITH GRANT OPTION;
4 DROP TABLE IF EXISTS `characters`.`arena_team`;
5 CREATE TABLE `characters`.`arena_team` (
6 `arenateamid` int(10) unsigned NOT NULL default '0',
7 `name` char(255) NOT NULL,
8 `captainguid` int(10) unsigned NOT NULL default '0',
9 `type` tinyint(3) unsigned NOT NULL default '0',
10 `EmblemStyle` int(10) unsigned NOT NULL default '0',
11 `EmblemColor` int(10) unsigned NOT NULL default '0',
12 `BorderStyle` int(10) unsigned NOT NULL default '0',
13 `BorderColor` int(10) unsigned NOT NULL default '0',
14 `BackgroundColor` int(10) unsigned NOT NULL default '0',
15 PRIMARY KEY (`arenateamid`)
16 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
19 -- Dumping data for table `arena_team`
22 /*!40000 ALTER TABLE `arena_team` DISABLE KEYS */;
23 /*!40000 ALTER TABLE `arena_team` ENABLE KEYS */;
27 -- Definition of table `arena_team_member`
30 DROP TABLE IF EXISTS `characters`.`arena_team_member`;
31 CREATE TABLE `characters`.`arena_team_member` (
32 `arenateamid` int(10) unsigned NOT NULL default '0',
33 `guid` int(10) unsigned NOT NULL default '0',
34 `played_week` int(10) unsigned NOT NULL default '0',
35 `wons_week` int(10) unsigned NOT NULL default '0',
36 `played_season` int(10) unsigned NOT NULL default '0',
37 `wons_season` int(10) unsigned NOT NULL default '0'
38 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
41 -- Dumping data for table `arena_team_member`
44 /*!40000 ALTER TABLE `arena_team_member` DISABLE KEYS */;
45 /*!40000 ALTER TABLE `arena_team_member` ENABLE KEYS */;
49 -- Definition of table `arena_team_stats`
52 DROP TABLE IF EXISTS `characters`.`arena_team_stats`;
53 CREATE TABLE `characters`.`arena_team_stats` (
54 `arenateamid` int(10) unsigned NOT NULL default '0',
55 `rating` int(10) unsigned NOT NULL default '0',
56 `games` int(10) unsigned NOT NULL default '0',
57 `wins` int(10) unsigned NOT NULL default '0',
58 `played` int(10) unsigned NOT NULL default '0',
59 `wins2` int(10) unsigned NOT NULL default '0',
60 `rank` int(10) unsigned NOT NULL default '0',
61 PRIMARY KEY (`arenateamid`)
62 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
65 -- Dumping data for table `arena_team_stats`
68 /*!40000 ALTER TABLE `arena_team_stats` DISABLE KEYS */;
69 /*!40000 ALTER TABLE `arena_team_stats` ENABLE KEYS */;
73 -- Definition of table `auctionhouse`
76 DROP TABLE IF EXISTS `characters`.`auctionhouse`;
77 CREATE TABLE `characters`.`auctionhouse` (
78 `id` int(11) unsigned NOT NULL default '0',
79 `auctioneerguid` int(11) unsigned NOT NULL default '0',
80 `itemguid` int(11) unsigned NOT NULL default '0',
81 `item_template` int(11) unsigned NOT NULL default '0' COMMENT 'Item Identifier',
82 `itemowner` int(11) unsigned NOT NULL default '0',
83 `buyoutprice` int(11) NOT NULL default '0',
84 `time` bigint(40) NOT NULL default '0',
85 `buyguid` int(11) unsigned NOT NULL default '0',
86 `lastbid` int(11) NOT NULL default '0',
87 `startbid` int(11) NOT NULL default '0',
88 `deposit` int(11) NOT NULL default '0',
89 `location` tinyint(3) unsigned NOT NULL default '3',
91 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
94 -- Dumping data for table `auctionhouse`
97 /*!40000 ALTER TABLE `auctionhouse` DISABLE KEYS */;
98 /*!40000 ALTER TABLE `auctionhouse` ENABLE KEYS */;
102 -- Definition of table `bugreport`
105 DROP TABLE IF EXISTS `characters`.`bugreport`;
106 CREATE TABLE `characters`.`bugreport` (
107 `id` int(11) NOT NULL auto_increment COMMENT 'Identifier',
108 `type` varchar(255) NOT NULL default '',
109 `content` varchar(255) NOT NULL default '',
111 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Debug System';
114 -- Dumping data for table `bugreport`
117 /*!40000 ALTER TABLE `bugreport` DISABLE KEYS */;
118 /*!40000 ALTER TABLE `bugreport` ENABLE KEYS */;
122 -- Definition of table `character`
125 DROP TABLE IF EXISTS `characters`.`character`;
126 CREATE TABLE `characters`.`character` (
127 `guid` int(11) unsigned NOT NULL default '0' COMMENT 'Global Unique Identifier',
128 `account` int(11) unsigned NOT NULL default '0' COMMENT 'Account Identifier',
130 `name` varchar(12) NOT NULL default '',
131 `race` tinyint(3) unsigned NOT NULL default '0',
132 `class` tinyint(3) unsigned NOT NULL default '0',
133 `position_x` float NOT NULL default '0',
134 `position_y` float NOT NULL default '0',
135 `position_z` float NOT NULL default '0',
136 `map` int(11) unsigned NOT NULL default '0' COMMENT 'Map Identifier',
137 `orientation` float NOT NULL default '0',
139 `online` tinyint(3) unsigned NOT NULL default '0',
140 `cinematic` tinyint(3) unsigned NOT NULL default '0',
141 `totaltime` int(11) unsigned NOT NULL default '0',
142 `leveltime` int(11) unsigned NOT NULL default '0',
143 `logout_time` int(11) unsigned NOT NULL default '0',
144 `is_logout_resting` tinyint(3) unsigned NOT NULL default '0',
145 `rest_bonus` float NOT NULL default '0',
146 `resettalents_cost` int(11) unsigned NOT NULL default '0',
147 `resettalents_time` bigint(20) unsigned NOT NULL default '0',
148 `trans_x` float NOT NULL default '0',
149 `trans_y` float NOT NULL default '0',
150 `trans_z` float NOT NULL default '0',
151 `trans_o` float NOT NULL default '0',
152 `transguid` bigint(20) unsigned NOT NULL default '0',
153 `gmstate` tinyint(3) unsigned NOT NULL default '0',
154 `stable_slots` tinyint(1) unsigned NOT NULL default '0',
155 `at_login` int(11) unsigned NOT NULL default '0',
156 `zone` int(11) unsigned NOT NULL default '0',
157 `last_honor_date` int(11) unsigned NOT NULL default '0',
158 `pending_honor` float NOT NULL default '0',
159 `pending_kills` int(11) NOT NULL default '0',
160 `last_kill_date` int(11) unsigned NOT NULL default '0',
161 PRIMARY KEY (`guid`),
162 KEY `idx_account` (`account`),
163 KEY `idx_online` (`online`)
164 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Player System';
167 -- Dumping data for table `character`
170 /*!40000 ALTER TABLE `character` DISABLE KEYS */;
171 /*!40000 ALTER TABLE `character` ENABLE KEYS */;
175 -- Definition of table `character_action`
178 DROP TABLE IF EXISTS `characters`.`character_action`;
179 CREATE TABLE `characters`.`character_action` (
180 `guid` int(11) unsigned NOT NULL default '0' COMMENT 'Global Unique Identifier',
181 `button` tinyint(3) unsigned NOT NULL default '0',
182 `action` smallint(5) unsigned NOT NULL default '0',
183 `type` tinyint(3) unsigned NOT NULL default '0',
184 `misc` tinyint(3) unsigned NOT NULL default '0',
185 PRIMARY KEY (`guid`,`button`)
186 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Player System';
189 -- Dumping data for table `character_action`
192 /*!40000 ALTER TABLE `character_action` DISABLE KEYS */;
193 /*!40000 ALTER TABLE `character_action` ENABLE KEYS */;
197 -- Definition of table `character_aura`
200 DROP TABLE IF EXISTS `characters`.`character_aura`;
201 CREATE TABLE `characters`.`character_aura` (
202 `guid` int(11) unsigned NOT NULL default '0' COMMENT 'Global Unique Identifier',
203 `caster_guid` bigint(20) unsigned NOT NULL default '0' COMMENT 'Full Global Unique Identifier',
204 `spell` int(11) unsigned NOT NULL default '0',
205 `effect_index` int(11) unsigned NOT NULL default '0',
206 `amount` int(11) NOT NULL default '0',
207 `maxduration` int(11) NOT NULL default '0',
208 `remaintime` int(11) NOT NULL default '0',
209 `remaincharges` int(11) NOT NULL default '0',
210 PRIMARY KEY (`guid`,`spell`,`effect_index`)
211 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Player System';
214 -- Dumping data for table `character_aura`
217 /*!40000 ALTER TABLE `character_aura` DISABLE KEYS */;
218 /*!40000 ALTER TABLE `character_aura` ENABLE KEYS */;
222 -- Definition of table `character_gifts`
225 DROP TABLE IF EXISTS `characters`.`character_gifts`;
226 CREATE TABLE `characters`.`character_gifts` (
227 `guid` int(20) unsigned NOT NULL default '0',
228 `item_guid` int(11) unsigned NOT NULL default '0',
229 `entry` int(20) unsigned NOT NULL default '0',
230 `flags` int(20) unsigned NOT NULL default '0',
231 PRIMARY KEY (`item_guid`),
232 KEY `idx_guid` (`guid`)
233 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
236 -- Dumping data for table `character_gifts`
239 /*!40000 ALTER TABLE `character_gifts` DISABLE KEYS */;
240 /*!40000 ALTER TABLE `character_gifts` ENABLE KEYS */;
244 -- Definition of table `character_homebind`
247 DROP TABLE IF EXISTS `characters`.`character_homebind`;
248 CREATE TABLE `characters`.`character_homebind` (
249 `guid` int(11) unsigned NOT NULL default '0' COMMENT 'Global Unique Identifier',
250 `map` int(11) unsigned NOT NULL default '0' COMMENT 'Map Identifier',
251 `zone` int(11) unsigned NOT NULL default '0' COMMENT 'Zone Identifier',
252 `position_x` float NOT NULL default '0',
253 `position_y` float NOT NULL default '0',
254 `position_z` float NOT NULL default '0',
256 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Player System';
259 -- Dumping data for table `character_homebind`
262 /*!40000 ALTER TABLE `character_homebind` DISABLE KEYS */;
263 /*!40000 ALTER TABLE `character_homebind` ENABLE KEYS */;
267 -- Definition of table `character_instance`
270 DROP TABLE IF EXISTS `characters`.`character_instance`;
271 CREATE TABLE `characters`.`character_instance` (
272 `guid` int(11) unsigned NOT NULL default '0',
273 `map` int(11) unsigned NOT NULL default '0',
274 `instance` bigint(40) NOT NULL default '0',
275 `leader` int(11) unsigned NOT NULL default '0',
276 PRIMARY KEY (`guid`,`map`),
277 KEY `instance` (`instance`),
278 KEY `leader` (`leader`)
279 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
282 -- Dumping data for table `character_instance`
285 /*!40000 ALTER TABLE `character_instance` DISABLE KEYS */;
286 /*!40000 ALTER TABLE `character_instance` ENABLE KEYS */;
290 -- Definition of table `character_inventory`
293 DROP TABLE IF EXISTS `characters`.`character_inventory`;
294 CREATE TABLE `characters`.`character_inventory` (
295 `guid` int(11) unsigned NOT NULL default '0' COMMENT 'Global Unique Identifier',
296 `bag` int(11) unsigned NOT NULL default '0',
297 `slot` tinyint(3) unsigned NOT NULL default '0',
298 `item` int(11) unsigned NOT NULL default '0' COMMENT 'Item Global Unique Identifier',
299 `item_template` int(11) unsigned NOT NULL default '0' COMMENT 'Item Identifier',
300 PRIMARY KEY (`item`),
301 KEY `idx_guid` (`guid`)
302 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Player System';
305 -- Dumping data for table `character_inventory`
308 /*!40000 ALTER TABLE `character_inventory` DISABLE KEYS */;
309 /*!40000 ALTER TABLE `character_inventory` ENABLE KEYS */;
313 -- Definition of table `character_kill`
316 DROP TABLE IF EXISTS `characters`.`character_kill`;
317 CREATE TABLE `characters`.`character_kill` (
318 `guid` int(11) unsigned NOT NULL default '0',
319 `victim_guid` int(11) unsigned NOT NULL default '0',
320 `count` tinyint(3) unsigned NOT NULL default '0',
321 PRIMARY KEY (`guid`,`victim_guid`)
322 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Kills Yesterday';
325 -- Dumping data for table `character_kill`
328 /*!40000 ALTER TABLE `character_kill` DISABLE KEYS */;
329 /*!40000 ALTER TABLE `character_kill` ENABLE KEYS */;
333 -- Definition of table `character_pet`
336 DROP TABLE IF EXISTS `characters`.`character_pet`;
337 CREATE TABLE `characters`.`character_pet` (
338 `id` int(11) unsigned NOT NULL default '0',
339 `entry` int(11) unsigned NOT NULL default '0',
340 `owner` int(11) unsigned NOT NULL default '0',
341 `modelid` int(11) unsigned default '0',
342 `CreatedBySpell` int(11) unsigned NOT NULL default '0',
343 `PetType` tinyint(3) unsigned NOT NULL default '0',
344 `level` int(11) unsigned NOT NULL default '1',
345 `exp` int(11) unsigned NOT NULL default '0',
346 `nextlvlexp` int(11) unsigned NOT NULL default '100',
347 `Reactstate` tinyint(1) unsigned NOT NULL default '0',
348 `Commandstate` tinyint(1) unsigned NOT NULL default '1',
349 `loyaltypoints` int(11) NOT NULL default '0',
350 `loyalty` int(11) unsigned NOT NULL default '0',
351 `trainpoint` int(11) NOT NULL default '0',
352 `name` varchar(100) default 'Pet',
353 `renamed` tinyint(1) unsigned NOT NULL default '0',
354 `slot` int(11) unsigned NOT NULL default '0',
355 `curhealth` int(11) unsigned NOT NULL default '1',
356 `curmana` int(11) unsigned NOT NULL default '0',
357 `curhappiness` int(11) unsigned NOT NULL default '0',
358 `savetime` bigint(20) unsigned NOT NULL default '0',
359 `resettalents_cost` int(11) unsigned NOT NULL default '0',
360 `resettalents_time` bigint(20) unsigned NOT NULL default '0',
362 `TeachSpelldata` longtext,
364 KEY `owner` (`owner`)
365 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Pet System';
368 -- Dumping data for table `character_pet`
371 /*!40000 ALTER TABLE `character_pet` DISABLE KEYS */;
372 /*!40000 ALTER TABLE `character_pet` ENABLE KEYS */;
376 -- Definition of table `character_queststatus`
379 DROP TABLE IF EXISTS `characters`.`character_queststatus`;
380 CREATE TABLE `characters`.`character_queststatus` (
381 `guid` int(11) unsigned NOT NULL default '0' COMMENT 'Global Unique Identifier',
382 `quest` int(11) unsigned NOT NULL default '0' COMMENT 'Quest Identifier',
383 `status` int(11) unsigned NOT NULL default '0',
384 `rewarded` tinyint(1) unsigned NOT NULL default '0',
385 `explored` tinyint(1) unsigned NOT NULL default '0',
386 `timer` bigint(20) unsigned NOT NULL default '0',
387 `mobcount1` int(11) unsigned NOT NULL default '0',
388 `mobcount2` int(11) unsigned NOT NULL default '0',
389 `mobcount3` int(11) unsigned NOT NULL default '0',
390 `mobcount4` int(11) unsigned NOT NULL default '0',
391 `itemcount1` int(11) unsigned NOT NULL default '0',
392 `itemcount2` int(11) unsigned NOT NULL default '0',
393 `itemcount3` int(11) unsigned NOT NULL default '0',
394 `itemcount4` int(11) unsigned NOT NULL default '0',
395 PRIMARY KEY (`guid`,`quest`)
396 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Player System';
399 -- Dumping data for table `character_queststatus`
402 /*!40000 ALTER TABLE `character_queststatus` DISABLE KEYS */;
403 /*!40000 ALTER TABLE `character_queststatus` ENABLE KEYS */;
407 -- Definition of table `character_queststatus_daily`
410 DROP TABLE IF EXISTS `characters`.`character_queststatus_daily`;
411 CREATE TABLE `characters`.`character_queststatus_daily` (
412 `guid` int(11) unsigned NOT NULL default '0' COMMENT 'Global Unique Identifier',
413 `quest` int(11) unsigned NOT NULL default '0' COMMENT 'Quest Identifier',
414 `time` bigint(20) unsigned NOT NULL default '0',
415 PRIMARY KEY (`guid`,`quest`),
416 KEY `idx_guid` (`guid`)
417 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Player System';
420 -- Dumping data for table `character_queststatus_daily`
423 /*!40000 ALTER TABLE `character_queststatus_daily` DISABLE KEYS */;
424 /*!40000 ALTER TABLE `character_queststatus_daily` ENABLE KEYS */;
428 -- Definition of table `character_reputation`
431 DROP TABLE IF EXISTS `characters`.`character_reputation`;
432 CREATE TABLE `characters`.`character_reputation` (
433 `guid` int(11) unsigned NOT NULL default '0' COMMENT 'Global Unique Identifier',
434 `faction` int(11) unsigned NOT NULL default '0',
435 `standing` int(11) NOT NULL default '0',
436 `flags` int(11) NOT NULL default '0',
437 PRIMARY KEY (`guid`,`faction`)
438 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Player System';
441 -- Dumping data for table `character_reputation`
444 /*!40000 ALTER TABLE `character_reputation` DISABLE KEYS */;
445 /*!40000 ALTER TABLE `character_reputation` ENABLE KEYS */;
449 -- Definition of table `character_social`
452 DROP TABLE IF EXISTS `characters`.`character_social`;
453 CREATE TABLE `characters`.`character_social` (
454 `guid` int(11) unsigned NOT NULL default '0' COMMENT 'Global Unique Identifier',
455 `name` varchar(21) NOT NULL default '',
456 `friend` int(11) unsigned NOT NULL default '0' COMMENT 'Character Global Unique Identifier',
457 `flags` varchar(21) NOT NULL default '',
458 PRIMARY KEY (`guid`,`friend`,`flags`)
459 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Player System';
462 -- Dumping data for table `character_social`
465 /*!40000 ALTER TABLE `character_social` DISABLE KEYS */;
466 /*!40000 ALTER TABLE `character_social` ENABLE KEYS */;
470 -- Definition of table `character_spell`
473 DROP TABLE IF EXISTS `characters`.`character_spell`;
474 CREATE TABLE `characters`.`character_spell` (
475 `guid` int(11) unsigned NOT NULL default '0' COMMENT 'Global Unique Identifier',
476 `spell` int(11) unsigned NOT NULL default '0' COMMENT 'Spell Identifier',
477 `slot` int(11) unsigned NOT NULL default '0',
478 `active` tinyint(3) unsigned NOT NULL default '1',
479 PRIMARY KEY (`guid`,`spell`)
480 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Player System';
483 -- Dumping data for table `character_spell`
486 /*!40000 ALTER TABLE `character_spell` DISABLE KEYS */;
487 /*!40000 ALTER TABLE `character_spell` ENABLE KEYS */;
491 -- Definition of table `character_spell_cooldown`
494 DROP TABLE IF EXISTS `characters`.`character_spell_cooldown`;
495 CREATE TABLE `characters`.`character_spell_cooldown` (
496 `guid` int(11) unsigned NOT NULL default '0' COMMENT 'Global Unique Identifier, Low part',
497 `spell` int(11) unsigned NOT NULL default '0' COMMENT 'Spell Identifier',
498 `item` int(11) unsigned NOT NULL default '0' COMMENT 'Item Identifier',
499 `time` bigint(20) unsigned NOT NULL default '0',
500 PRIMARY KEY (`guid`,`spell`)
501 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
504 -- Dumping data for table `character_spell_cooldown`
507 /*!40000 ALTER TABLE `character_spell_cooldown` DISABLE KEYS */;
508 /*!40000 ALTER TABLE `character_spell_cooldown` ENABLE KEYS */;
512 -- Definition of table `character_ticket`
515 DROP TABLE IF EXISTS `characters`.`character_ticket`;
516 CREATE TABLE `characters`.`character_ticket` (
517 `ticket_id` int(11) unsigned NOT NULL auto_increment,
518 `guid` int(11) unsigned NOT NULL default '0',
520 `ticket_category` int(1) NOT NULL default '0',
521 PRIMARY KEY (`ticket_id`)
522 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Player System';
525 -- Dumping data for table `character_ticket`
528 /*!40000 ALTER TABLE `character_ticket` DISABLE KEYS */;
529 /*!40000 ALTER TABLE `character_ticket` ENABLE KEYS */;
533 -- Definition of table `character_tutorial`
536 DROP TABLE IF EXISTS `characters`.`character_tutorial`;
537 CREATE TABLE `characters`.`character_tutorial` (
538 `guid` int(11) unsigned NOT NULL default '0' COMMENT 'Global Unique Identifier',
539 `tut0` int(11) unsigned NOT NULL default '0',
540 `tut1` int(11) unsigned NOT NULL default '0',
541 `tut2` int(11) unsigned NOT NULL default '0',
542 `tut3` int(11) unsigned NOT NULL default '0',
543 `tut4` int(11) unsigned NOT NULL default '0',
544 `tut5` int(11) unsigned NOT NULL default '0',
545 `tut6` int(11) unsigned NOT NULL default '0',
546 `tut7` int(11) unsigned NOT NULL default '0',
548 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Player System';
551 -- Dumping data for table `character_tutorial`
554 /*!40000 ALTER TABLE `character_tutorial` DISABLE KEYS */;
555 /*!40000 ALTER TABLE `character_tutorial` ENABLE KEYS */;
559 -- Definition of table `corpse`
562 DROP TABLE IF EXISTS `characters`.`corpse`;
563 CREATE TABLE `characters`.`corpse` (
564 `guid` int(11) unsigned NOT NULL default '0' COMMENT 'Global Unique Identifier',
565 `player` int(11) unsigned NOT NULL default '0' COMMENT 'Character Global Unique Identifier',
566 `position_x` float NOT NULL default '0',
567 `position_y` float NOT NULL default '0',
568 `position_z` float NOT NULL default '0',
569 `orientation` float NOT NULL default '0',
570 `zone` int(11) unsigned NOT NULL default '38' COMMENT 'Zone Identifier',
571 `map` int(11) unsigned NOT NULL default '0' COMMENT 'Map Identifier',
573 `time` timestamp NOT NULL default '0000-00-00 00:00:00',
574 `bones_flag` tinyint(3) NOT NULL default '0',
575 `instance` int(11) unsigned NOT NULL default '0',
576 PRIMARY KEY (`guid`),
577 KEY `idx_bones_flag` (`bones_flag`),
578 KEY `instance` (`instance`)
579 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Death System';
582 -- Dumping data for table `corpse`
585 /*!40000 ALTER TABLE `corpse` DISABLE KEYS */;
586 /*!40000 ALTER TABLE `corpse` ENABLE KEYS */;
590 -- Definition of table `group`
593 DROP TABLE IF EXISTS `characters`.`group`;
594 CREATE TABLE `characters`.`group` (
595 `leaderGuid` int(11) unsigned NOT NULL,
596 `mainTank` int(11) unsigned NOT NULL,
597 `mainAssistant` int(11) unsigned NOT NULL,
598 `lootMethod` tinyint(4) unsigned NOT NULL,
599 `looterGuid` int(11) unsigned NOT NULL,
600 `lootThreshold` tinyint(4) unsigned NOT NULL,
601 `icon1` int(11) unsigned NOT NULL,
602 `icon2` int(11) unsigned NOT NULL,
603 `icon3` int(11) unsigned NOT NULL,
604 `icon4` int(11) unsigned NOT NULL,
605 `icon5` int(11) unsigned NOT NULL,
606 `icon6` int(11) unsigned NOT NULL,
607 `icon7` int(11) unsigned NOT NULL,
608 `icon8` int(11) unsigned NOT NULL,
609 `isRaid` tinyint(1) unsigned NOT NULL,
610 PRIMARY KEY (`leaderGuid`)
611 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Groups';
614 -- Dumping data for table `group`
617 /*!40000 ALTER TABLE `group` DISABLE KEYS */;
618 /*!40000 ALTER TABLE `group` ENABLE KEYS */;
622 -- Definition of table `group_member`
625 DROP TABLE IF EXISTS `characters`.`group_member`;
626 CREATE TABLE `characters`.`group_member` (
627 `leaderGuid` int(11) unsigned NOT NULL,
628 `memberGuid` int(11) unsigned NOT NULL,
629 `assistant` tinyint(1) unsigned NOT NULL,
630 `subgroup` smallint(6) unsigned NOT NULL,
631 PRIMARY KEY (`leaderGuid`,`memberGuid`)
632 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Groups';
635 -- Dumping data for table `group_member`
638 /*!40000 ALTER TABLE `group_member` DISABLE KEYS */;
639 /*!40000 ALTER TABLE `group_member` ENABLE KEYS */;
643 -- Definition of table `guild`
646 DROP TABLE IF EXISTS `characters`.`guild`;
647 CREATE TABLE `characters`.`guild` (
648 `guildid` int(6) unsigned NOT NULL default '0',
649 `name` varchar(255) NOT NULL default '',
650 `leaderguid` int(6) unsigned NOT NULL default '0',
651 `EmblemStyle` int(5) NOT NULL default '0',
652 `EmblemColor` int(5) NOT NULL default '0',
653 `BorderStyle` int(5) NOT NULL default '0',
654 `BorderColor` int(5) NOT NULL default '0',
655 `BackgroundColor` int(5) NOT NULL default '0',
656 `info` text NOT NULL,
657 `MOTD` varchar(255) NOT NULL default '',
658 `createdate` datetime default NULL,
659 PRIMARY KEY (`guildid`)
660 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Guild System';
663 -- Dumping data for table `guild`
666 /*!40000 ALTER TABLE `guild` DISABLE KEYS */;
667 /*!40000 ALTER TABLE `guild` ENABLE KEYS */;
671 -- Definition of table `guild_member`
674 DROP TABLE IF EXISTS `characters`.`guild_member`;
675 CREATE TABLE `characters`.`guild_member` (
676 `guildid` int(6) unsigned NOT NULL default '0',
677 `guid` int(11) unsigned NOT NULL default '0',
678 `rank` tinyint(2) unsigned NOT NULL default '0',
679 `Pnote` varchar(255) NOT NULL default '',
680 `OFFnote` varchar(255) NOT NULL default ''
681 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Guild System';
684 -- Dumping data for table `guild_member`
687 /*!40000 ALTER TABLE `guild_member` DISABLE KEYS */;
688 /*!40000 ALTER TABLE `guild_member` ENABLE KEYS */;
692 -- Definition of table `guild_rank`
695 DROP TABLE IF EXISTS `characters`.`guild_rank`;
696 CREATE TABLE `characters`.`guild_rank` (
697 `guildid` int(6) unsigned NOT NULL default '0',
698 `rid` int(11) unsigned NOT NULL,
699 `rname` varchar(255) NOT NULL default '',
700 `rights` int(3) unsigned NOT NULL default '0',
701 PRIMARY KEY (`guildid`,`rid`)
702 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Guild System';
705 -- Dumping data for table `guild_rank`
708 /*!40000 ALTER TABLE `guild_rank` DISABLE KEYS */;
709 /*!40000 ALTER TABLE `guild_rank` ENABLE KEYS */;
713 -- Definition of table `instance`
716 DROP TABLE IF EXISTS `characters`.`instance`;
717 CREATE TABLE `characters`.`instance` (
718 `id` int(11) unsigned NOT NULL default '0',
719 `map` int(11) unsigned NOT NULL default '0',
720 `resettime` bigint(40) NOT NULL default '0',
724 KEY `resettime` (`resettime`)
725 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
728 -- Dumping data for table `instance`
731 /*!40000 ALTER TABLE `instance` DISABLE KEYS */;
732 /*!40000 ALTER TABLE `instance` ENABLE KEYS */;
736 -- Definition of table `item_instance`
739 DROP TABLE IF EXISTS `characters`.`item_instance`;
740 CREATE TABLE `characters`.`item_instance` (
741 `guid` int(11) unsigned NOT NULL default '0',
742 `owner_guid` int(11) unsigned NOT NULL default '0',
744 PRIMARY KEY (`guid`),
745 KEY `idx_owner_guid` (`owner_guid`)
746 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Item System';
749 -- Dumping data for table `item_instance`
752 /*!40000 ALTER TABLE `item_instance` DISABLE KEYS */;
753 /*!40000 ALTER TABLE `item_instance` ENABLE KEYS */;
757 -- Definition of table `item_text`
760 DROP TABLE IF EXISTS `characters`.`item_text`;
761 CREATE TABLE `characters`.`item_text` (
762 `id` int(11) unsigned NOT NULL default '0',
765 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Item System';
768 -- Dumping data for table `item_text`
771 /*!40000 ALTER TABLE `item_text` DISABLE KEYS */;
772 /*!40000 ALTER TABLE `item_text` ENABLE KEYS */;
776 -- Definition of table `mail`
779 DROP TABLE IF EXISTS `characters`.`mail`;
780 CREATE TABLE `characters`.`mail` (
781 `id` int(11) unsigned NOT NULL default '0' COMMENT 'Identifier',
782 `messageType` tinyint(3) unsigned NOT NULL default '0',
783 `sender` int(11) unsigned NOT NULL default '0' COMMENT 'Character Global Unique Identifier',
784 `receiver` int(11) unsigned NOT NULL default '0' COMMENT 'Character Global Unique Identifier',
786 `itemTextId` int(11) unsigned NOT NULL default '0',
787 `item_guid` int(11) unsigned NOT NULL default '0' COMMENT 'Mail Item Global Unique Identifier',
788 `item_template` int(11) unsigned NOT NULL default '0' COMMENT 'Item Identifier',
789 `expire_time` bigint(40) NOT NULL default '0',
790 `deliver_time` bigint(40) NOT NULL default '0',
791 `money` int(11) unsigned NOT NULL default '0',
792 `cod` int(11) unsigned NOT NULL default '0',
793 `checked` tinyint(3) unsigned NOT NULL default '0',
795 KEY `idx_receiver` (`receiver`)
796 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Mail System';
799 -- Dumping data for table `mail`
802 /*!40000 ALTER TABLE `mail` DISABLE KEYS */;
803 /*!40000 ALTER TABLE `mail` ENABLE KEYS */;
807 -- Definition of table `pet_aura`
810 DROP TABLE IF EXISTS `characters`.`pet_aura`;
811 CREATE TABLE `characters`.`pet_aura` (
812 `guid` int(11) unsigned NOT NULL default '0' COMMENT 'Global Unique Identifier',
813 `caster_guid` bigint(20) unsigned NOT NULL default '0' COMMENT 'Full Global Unique Identifier',
814 `spell` int(11) unsigned NOT NULL default '0',
815 `effect_index` int(11) unsigned NOT NULL default '0',
816 `amount` int(11) NOT NULL default '0',
817 `maxduration` int(11) NOT NULL default '0',
818 `remaintime` int(11) NOT NULL default '0',
819 `remaincharges` int(11) NOT NULL default '0',
820 PRIMARY KEY (`guid`,`spell`,`effect_index`)
821 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Pet System';
824 -- Dumping data for table `pet_aura`
827 /*!40000 ALTER TABLE `pet_aura` DISABLE KEYS */;
828 /*!40000 ALTER TABLE `pet_aura` ENABLE KEYS */;
832 -- Definition of table `pet_spell`
835 DROP TABLE IF EXISTS `characters`.`pet_spell`;
836 CREATE TABLE `characters`.`pet_spell` (
837 `guid` int(11) unsigned NOT NULL default '0' COMMENT 'Global Unique Identifier',
838 `spell` int(11) unsigned NOT NULL default '0' COMMENT 'Spell Identifier',
839 `slot` int(11) unsigned NOT NULL default '0',
840 `active` int(11) unsigned NOT NULL default '0',
841 PRIMARY KEY (`guid`,`spell`)
842 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Pet System';
845 -- Dumping data for table `pet_spell`
848 /*!40000 ALTER TABLE `pet_spell` DISABLE KEYS */;
849 /*!40000 ALTER TABLE `pet_spell` ENABLE KEYS */;
853 -- Definition of table `pet_spell_cooldown`
856 DROP TABLE IF EXISTS `characters`.`pet_spell_cooldown`;
857 CREATE TABLE `characters`.`pet_spell_cooldown` (
858 `guid` int(11) unsigned NOT NULL default '0' COMMENT 'Global Unique Identifier, Low part',
859 `spell` int(11) unsigned NOT NULL default '0' COMMENT 'Spell Identifier',
860 `time` bigint(20) unsigned NOT NULL default '0',
861 PRIMARY KEY (`guid`,`spell`)
862 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
865 -- Dumping data for table `pet_spell_cooldown`
868 /*!40000 ALTER TABLE `pet_spell_cooldown` DISABLE KEYS */;
869 /*!40000 ALTER TABLE `pet_spell_cooldown` ENABLE KEYS */;
873 -- Definition of table `petition`
876 DROP TABLE IF EXISTS `characters`.`petition`;
877 CREATE TABLE `characters`.`petition` (
878 `ownerguid` int(10) unsigned NOT NULL,
879 `petitionguid` int(10) unsigned default '0',
880 `name` varchar(255) NOT NULL default '',
881 `type` int(10) unsigned NOT NULL default '0',
882 PRIMARY KEY (`ownerguid`),
883 UNIQUE KEY `index_ownerguid_petitionguid` (`ownerguid`,`petitionguid`)
884 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Guild System';
887 -- Dumping data for table `petition`
890 /*!40000 ALTER TABLE `petition` DISABLE KEYS */;
891 /*!40000 ALTER TABLE `petition` ENABLE KEYS */;
895 -- Definition of table `petition_sign`
898 DROP TABLE IF EXISTS `characters`.`petition_sign`;
899 CREATE TABLE `characters`.`petition_sign` (
900 `ownerguid` int(10) unsigned NOT NULL,
901 `petitionguid` int(11) unsigned NOT NULL default '0',
902 `playerguid` int(11) unsigned NOT NULL default '0',
903 `player_account` int(11) unsigned NOT NULL default '0',
904 PRIMARY KEY (`petitionguid`,`playerguid`)
905 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Guild System';
908 INSERT INTO `characters`.`arena_team` SELECT * FROM `arena_team`;
909 INSERT INTO `characters`.`arena_team_member` SELECT * FROM `arena_team_member`;
910 INSERT INTO `characters`.`arena_team_stats` SELECT * FROM `arena_team_stats`;
911 INSERT INTO `characters`.`auctionhouse` SELECT * FROM `auctionhouse`;
912 INSERT INTO `characters`.`bugreport` SELECT * FROM `bugreport`;
913 INSERT INTO `characters`.`character` SELECT * FROM `character`;
914 INSERT INTO `characters`.`character_action` SELECT * FROM `character_action`;
915 INSERT INTO `characters`.`character_aura` SELECT * FROM `character_aura`;
916 INSERT INTO `characters`.`character_gifts` SELECT * FROM `character_gifts`;
917 INSERT INTO `characters`.`character_homebind` SELECT * FROM `character_homebind`;
918 INSERT INTO `characters`.`character_instance` SELECT * FROM `character_instance`;
919 INSERT INTO `characters`.`character_inventory` SELECT * FROM `character_inventory`;
920 INSERT INTO `characters`.`character_kill` SELECT * FROM `character_kill`;
921 INSERT INTO `characters`.`character_pet` SELECT * FROM `character_pet`;
922 INSERT INTO `characters`.`character_queststatus` SELECT * FROM `character_queststatus`;
923 INSERT INTO `characters`.`character_queststatus_daily` SELECT * FROM `character_queststatus_daily`;
924 INSERT INTO `characters`.`character_reputation` SELECT * FROM `character_reputation`;
925 INSERT INTO `characters`.`character_social` SELECT * FROM `character_social`;
926 INSERT INTO `characters`.`character_spell` SELECT * FROM `character_spell`;
927 INSERT INTO `characters`.`character_spell_cooldown` SELECT * FROM `character_spell_cooldown`;
928 INSERT INTO `characters`.`character_ticket` SELECT * FROM `character_ticket`;
929 INSERT INTO `characters`.`character_tutorial` SELECT * FROM `character_tutorial`;
930 INSERT INTO `characters`.`corpse` SELECT * FROM `corpse`;
931 INSERT INTO `characters`.`group` SELECT * FROM `group`;
932 INSERT INTO `characters`.`group_member` SELECT * FROM `group_member`;
933 INSERT INTO `characters`.`guild` SELECT * FROM `guild`;
934 INSERT INTO `characters`.`guild_member` SELECT * FROM `guild_member`;
935 INSERT INTO `characters`.`guild_rank` SELECT * FROM `guild_rank`;
936 INSERT INTO `characters`.`instance` SELECT * FROM `instance`;
937 INSERT INTO `characters`.`item_instance` SELECT * FROM `item_instance`;
938 INSERT INTO `characters`.`item_text` SELECT * FROM `item_text`;
939 INSERT INTO `characters`.`mail` SELECT * FROM `mail`;
940 INSERT INTO `characters`.`pet_aura` SELECT * FROM `pet_aura`;
941 INSERT INTO `characters`.`pet_spell` SELECT * FROM `pet_spell`;
942 INSERT INTO `characters`.`pet_spell_cooldown` SELECT * FROM `pet_spell_cooldown`;
943 INSERT INTO `characters`.`petition` SELECT * FROM `petition`;
944 INSERT INTO `characters`.`petition_sign` SELECT * FROM `petition_sign`;
946 DROP TABLE `arena_team`;
947 DROP TABLE `arena_team_member`;
948 DROP TABLE `arena_team_stats`;
949 DROP TABLE `auctionhouse`;
950 DROP TABLE `bugreport`;
951 DROP TABLE `character`;
952 DROP TABLE `character_action`;
953 DROP TABLE `character_aura`;
954 DROP TABLE `character_gifts`;
955 DROP TABLE `character_homebind`;
956 DROP TABLE `character_instance`;
957 DROP TABLE `character_inventory`;
958 DROP TABLE `character_kill`;
959 DROP TABLE `character_pet`;
960 DROP TABLE `character_queststatus`;
961 DROP TABLE `character_queststatus_daily`;
962 DROP TABLE `character_reputation`;
963 DROP TABLE `character_social`;
964 DROP TABLE `character_spell`;
965 DROP TABLE `character_spell_cooldown`;
966 DROP TABLE `character_ticket`;
967 DROP TABLE `character_tutorial`;
970 DROP TABLE `group_member`;
972 DROP TABLE `guild_member`;
973 DROP TABLE `guild_rank`;
974 DROP TABLE `instance`;
975 DROP TABLE `item_instance`;
976 DROP TABLE `item_text`;
978 DROP TABLE `pet_aura`;
979 DROP TABLE `pet_spell`;
980 DROP TABLE `pet_spell_cooldown`;
981 DROP TABLE `petition`;
982 DROP TABLE `petition_sign`;