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_2008_12_03_01_character_guild_member` 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 `arena_team`
42 DROP TABLE IF EXISTS `arena_team`;
43 CREATE TABLE `arena_team` (
44 `arenateamid` int(10) unsigned NOT NULL default '0',
45 `name` char(255) NOT NULL,
46 `captainguid` int(10) unsigned NOT NULL default '0',
47 `type` tinyint(3) unsigned NOT NULL default '0',
48 `BackgroundColor` int(10) unsigned NOT NULL default '0',
49 `EmblemStyle` int(10) unsigned NOT NULL default '0',
50 `EmblemColor` int(10) unsigned NOT NULL default '0',
51 `BorderStyle` int(10) unsigned NOT NULL default '0',
52 `BorderColor` int(10) unsigned NOT NULL default '0',
53 PRIMARY KEY (`arenateamid`)
54 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
57 -- Dumping data for table `arena_team`
60 LOCK TABLES `arena_team` WRITE;
61 /*!40000 ALTER TABLE `arena_team` DISABLE KEYS */;
62 /*!40000 ALTER TABLE `arena_team` ENABLE KEYS */;
66 -- Table structure for table `arena_team_member`
69 DROP TABLE IF EXISTS `arena_team_member`;
70 CREATE TABLE `arena_team_member` (
71 `arenateamid` int(10) unsigned NOT NULL default '0',
72 `guid` int(10) unsigned NOT NULL default '0',
73 `played_week` int(10) unsigned NOT NULL default '0',
74 `wons_week` int(10) unsigned NOT NULL default '0',
75 `played_season` int(10) unsigned NOT NULL default '0',
76 `wons_season` int(10) unsigned NOT NULL default '0'
77 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
80 -- Dumping data for table `arena_team_member`
83 LOCK TABLES `arena_team_member` WRITE;
84 /*!40000 ALTER TABLE `arena_team_member` DISABLE KEYS */;
85 /*!40000 ALTER TABLE `arena_team_member` ENABLE KEYS */;
89 -- Table structure for table `arena_team_stats`
92 DROP TABLE IF EXISTS `arena_team_stats`;
93 CREATE TABLE `arena_team_stats` (
94 `arenateamid` int(10) unsigned NOT NULL default '0',
95 `rating` int(10) unsigned NOT NULL default '0',
96 `games` int(10) unsigned NOT NULL default '0',
97 `wins` int(10) unsigned NOT NULL default '0',
98 `played` int(10) unsigned NOT NULL default '0',
99 `wins2` int(10) unsigned NOT NULL default '0',
100 `rank` int(10) unsigned NOT NULL default '0',
101 PRIMARY KEY (`arenateamid`)
102 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
105 -- Dumping data for table `arena_team_stats`
108 LOCK TABLES `arena_team_stats` WRITE;
109 /*!40000 ALTER TABLE `arena_team_stats` DISABLE KEYS */;
110 /*!40000 ALTER TABLE `arena_team_stats` ENABLE KEYS */;
114 -- Table structure for table `auctionhouse`
117 DROP TABLE IF EXISTS `auctionhouse`;
118 CREATE TABLE `auctionhouse` (
119 `id` int(11) unsigned NOT NULL default '0',
120 `auctioneerguid` int(11) unsigned NOT NULL default '0',
121 `itemguid` int(11) unsigned NOT NULL default '0',
122 `item_template` int(11) unsigned NOT NULL default '0' COMMENT 'Item Identifier',
123 `itemowner` int(11) unsigned NOT NULL default '0',
124 `buyoutprice` int(11) NOT NULL default '0',
125 `time` bigint(40) NOT NULL default '0',
126 `buyguid` int(11) unsigned NOT NULL default '0',
127 `lastbid` int(11) NOT NULL default '0',
128 `startbid` int(11) NOT NULL default '0',
129 `deposit` int(11) NOT NULL default '0',
130 `location` tinyint(3) unsigned NOT NULL default '3',
132 UNIQUE KEY `item_guid` (`itemguid`)
133 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
136 -- Dumping data for table `auctionhouse`
139 LOCK TABLES `auctionhouse` WRITE;
140 /*!40000 ALTER TABLE `auctionhouse` DISABLE KEYS */;
141 /*!40000 ALTER TABLE `auctionhouse` ENABLE KEYS */;
145 -- Table structure for table `bugreport`
148 DROP TABLE IF EXISTS `bugreport`;
149 CREATE TABLE `bugreport` (
150 `id` int(11) NOT NULL auto_increment COMMENT 'Identifier',
151 `type` varchar(255) NOT NULL default '',
152 `content` varchar(255) NOT NULL default '',
154 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Debug System';
157 -- Dumping data for table `bugreport`
160 LOCK TABLES `bugreport` WRITE;
161 /*!40000 ALTER TABLE `bugreport` DISABLE KEYS */;
162 /*!40000 ALTER TABLE `bugreport` ENABLE KEYS */;
166 -- Table structure for table `characters`
169 DROP TABLE IF EXISTS `characters`;
170 CREATE TABLE `characters` (
171 `guid` int(11) unsigned NOT NULL default '0' COMMENT 'Global Unique Identifier',
172 `account` int(11) unsigned NOT NULL default '0' COMMENT 'Account Identifier',
174 `name` varchar(12) NOT NULL default '',
175 `race` tinyint(3) unsigned NOT NULL default '0',
176 `class` tinyint(3) unsigned NOT NULL default '0',
177 `position_x` float NOT NULL default '0',
178 `position_y` float NOT NULL default '0',
179 `position_z` float NOT NULL default '0',
180 `map` int(11) unsigned NOT NULL default '0' COMMENT 'Map Identifier',
181 `dungeon_difficulty` tinyint(1) unsigned NOT NULL DEFAULT '0',
182 `orientation` float NOT NULL default '0',
184 `online` tinyint(3) unsigned NOT NULL default '0',
185 `cinematic` tinyint(3) unsigned NOT NULL default '0',
186 `totaltime` int(11) unsigned NOT NULL default '0',
187 `leveltime` int(11) unsigned NOT NULL default '0',
188 `logout_time` bigint(20) unsigned NOT NULL default '0',
189 `is_logout_resting` tinyint(3) unsigned NOT NULL default '0',
190 `rest_bonus` float NOT NULL default '0',
191 `resettalents_cost` int(11) unsigned NOT NULL default '0',
192 `resettalents_time` bigint(20) unsigned NOT NULL default '0',
193 `trans_x` float NOT NULL default '0',
194 `trans_y` float NOT NULL default '0',
195 `trans_z` float NOT NULL default '0',
196 `trans_o` float NOT NULL default '0',
197 `transguid` bigint(20) unsigned NOT NULL default '0',
198 `extra_flags` int(11) unsigned NOT NULL default '0',
199 `stable_slots` tinyint(1) unsigned NOT NULL default '0',
200 `at_login` int(11) unsigned NOT NULL default '0',
201 `zone` int(11) unsigned NOT NULL default '0',
202 `death_expire_time` bigint(20) unsigned NOT NULL default '0',
204 PRIMARY KEY (`guid`),
205 KEY `idx_account` (`account`),
206 KEY `idx_online` (`online`),
207 KEY `idx_name` (`name`)
208 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Player System';
211 -- Dumping data for table `characters`
214 LOCK TABLES `characters` WRITE;
215 /*!40000 ALTER TABLE `characters` DISABLE KEYS */;
216 /*!40000 ALTER TABLE `characters` ENABLE KEYS */;
220 -- Table structure for table `character_action`
223 DROP TABLE IF EXISTS `character_action`;
224 CREATE TABLE `character_action` (
225 `guid` int(11) unsigned NOT NULL default '0' COMMENT 'Global Unique Identifier',
226 `button` tinyint(3) unsigned NOT NULL default '0',
227 `action` smallint(5) unsigned NOT NULL default '0',
228 `type` tinyint(3) unsigned NOT NULL default '0',
229 `misc` tinyint(3) unsigned NOT NULL default '0',
230 PRIMARY KEY (`guid`,`button`)
231 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Player System';
234 -- Dumping data for table `character_action`
237 LOCK TABLES `character_action` WRITE;
238 /*!40000 ALTER TABLE `character_action` DISABLE KEYS */;
239 /*!40000 ALTER TABLE `character_action` ENABLE KEYS */;
243 -- Table structure for table `character_aura`
246 DROP TABLE IF EXISTS `character_aura`;
247 CREATE TABLE `character_aura` (
248 `guid` int(11) unsigned NOT NULL default '0' COMMENT 'Global Unique Identifier',
249 `caster_guid` bigint(20) unsigned NOT NULL default '0' COMMENT 'Full Global Unique Identifier',
250 `spell` int(11) unsigned NOT NULL default '0',
251 `effect_index` int(11) unsigned NOT NULL default '0',
252 `stackcount` int(11) NOT NULL default '1',
253 `amount` int(11) NOT NULL default '0',
254 `maxduration` int(11) NOT NULL default '0',
255 `remaintime` int(11) NOT NULL default '0',
256 `remaincharges` int(11) NOT NULL default '0',
257 PRIMARY KEY (`guid`,`spell`,`effect_index`)
258 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Player System';
261 -- Dumping data for table `character_aura`
264 LOCK TABLES `character_aura` WRITE;
265 /*!40000 ALTER TABLE `character_aura` DISABLE KEYS */;
266 /*!40000 ALTER TABLE `character_aura` ENABLE KEYS */;
270 -- Table structure for table `character_declinedname`
273 DROP TABLE IF EXISTS `character_declinedname`;
274 CREATE TABLE `character_declinedname` (
275 `guid` int(11) unsigned NOT NULL default '0' COMMENT 'Global Unique Identifier',
276 `genitive` varchar(15) NOT NULL default '',
277 `dative` varchar(15) NOT NULL default '',
278 `accusative` varchar(15) NOT NULL default '',
279 `instrumental` varchar(15) NOT NULL default '',
280 `prepositional` varchar(15) NOT NULL default '',
282 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;
285 -- Dumping data for table `character_declinedname`
288 LOCK TABLES `character_declinedname` WRITE;
289 /*!40000 ALTER TABLE `character_declinedname` DISABLE KEYS */;
290 /*!40000 ALTER TABLE `character_declinedname` ENABLE KEYS */;
294 -- Table structure for table `character_gifts`
297 DROP TABLE IF EXISTS `character_gifts`;
298 CREATE TABLE `character_gifts` (
299 `guid` int(20) unsigned NOT NULL default '0',
300 `item_guid` int(11) unsigned NOT NULL default '0',
301 `entry` int(20) unsigned NOT NULL default '0',
302 `flags` int(20) unsigned NOT NULL default '0',
303 PRIMARY KEY (`item_guid`),
304 KEY `idx_guid` (`guid`)
305 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
308 -- Dumping data for table `character_gifts`
311 LOCK TABLES `character_gifts` WRITE;
312 /*!40000 ALTER TABLE `character_gifts` DISABLE KEYS */;
313 /*!40000 ALTER TABLE `character_gifts` ENABLE KEYS */;
317 -- Table structure for table `character_homebind`
320 DROP TABLE IF EXISTS `character_homebind`;
321 CREATE TABLE `character_homebind` (
322 `guid` int(11) unsigned NOT NULL default '0' COMMENT 'Global Unique Identifier',
323 `map` int(11) unsigned NOT NULL default '0' COMMENT 'Map Identifier',
324 `zone` int(11) unsigned NOT NULL default '0' COMMENT 'Zone Identifier',
325 `position_x` float NOT NULL default '0',
326 `position_y` float NOT NULL default '0',
327 `position_z` float NOT NULL default '0',
329 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Player System';
332 -- Dumping data for table `character_homebind`
335 LOCK TABLES `character_homebind` WRITE;
336 /*!40000 ALTER TABLE `character_homebind` DISABLE KEYS */;
337 /*!40000 ALTER TABLE `character_homebind` ENABLE KEYS */;
341 -- Table structure for table `character_instance`
344 DROP TABLE IF EXISTS `character_instance`;
345 CREATE TABLE `character_instance` (
346 `guid` int(11) unsigned NOT NULL default '0',
347 `instance` int(11) unsigned NOT NULL default '0',
348 `permanent` tinyint(1) unsigned NOT NULL default '0',
349 PRIMARY KEY (`guid`,`instance`),
350 KEY `instance` (`instance`)
351 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
354 -- Dumping data for table `character_instance`
357 LOCK TABLES `character_instance` WRITE;
358 /*!40000 ALTER TABLE `character_instance` DISABLE KEYS */;
359 /*!40000 ALTER TABLE `character_instance` ENABLE KEYS */;
363 -- Table structure for table `character_inventory`
366 DROP TABLE IF EXISTS `character_inventory`;
367 CREATE TABLE `character_inventory` (
368 `guid` int(11) unsigned NOT NULL default '0' COMMENT 'Global Unique Identifier',
369 `bag` int(11) unsigned NOT NULL default '0',
370 `slot` tinyint(3) unsigned NOT NULL default '0',
371 `item` int(11) unsigned NOT NULL default '0' COMMENT 'Item Global Unique Identifier',
372 `item_template` int(11) unsigned NOT NULL default '0' COMMENT 'Item Identifier',
373 PRIMARY KEY (`item`),
374 KEY `idx_guid` (`guid`)
375 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Player System';
378 -- Dumping data for table `character_inventory`
381 LOCK TABLES `character_inventory` WRITE;
382 /*!40000 ALTER TABLE `character_inventory` DISABLE KEYS */;
383 /*!40000 ALTER TABLE `character_inventory` ENABLE KEYS */;
387 -- Table structure for table `character_pet`
390 DROP TABLE IF EXISTS `character_pet`;
391 CREATE TABLE `character_pet` (
392 `id` int(11) unsigned NOT NULL default '0',
393 `entry` int(11) unsigned NOT NULL default '0',
394 `owner` int(11) unsigned NOT NULL default '0',
395 `modelid` int(11) unsigned default '0',
396 `CreatedBySpell` int(11) unsigned NOT NULL default '0',
397 `PetType` tinyint(3) unsigned NOT NULL default '0',
398 `level` int(11) unsigned NOT NULL default '1',
399 `exp` int(11) unsigned NOT NULL default '0',
400 `Reactstate` tinyint(1) unsigned NOT NULL default '0',
401 `loyaltypoints` int(11) NOT NULL default '0',
402 `loyalty` int(11) unsigned NOT NULL default '0',
403 `trainpoint` int(11) NOT NULL default '0',
404 `name` varchar(100) default 'Pet',
405 `renamed` tinyint(1) unsigned NOT NULL default '0',
406 `slot` int(11) unsigned NOT NULL default '0',
407 `curhealth` int(11) unsigned NOT NULL default '1',
408 `curmana` int(11) unsigned NOT NULL default '0',
409 `curhappiness` int(11) unsigned NOT NULL default '0',
410 `savetime` bigint(20) unsigned NOT NULL default '0',
411 `resettalents_cost` int(11) unsigned NOT NULL default '0',
412 `resettalents_time` bigint(20) unsigned NOT NULL default '0',
414 `teachspelldata` longtext,
416 KEY `owner` (`owner`)
417 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Pet System';
420 -- Dumping data for table `character_pet`
423 LOCK TABLES `character_pet` WRITE;
424 /*!40000 ALTER TABLE `character_pet` DISABLE KEYS */;
425 /*!40000 ALTER TABLE `character_pet` ENABLE KEYS */;
429 -- Table structure for table `character_pet_declinedname`
432 DROP TABLE IF EXISTS `character_pet_declinedname`;
433 CREATE TABLE `character_pet_declinedname` (
434 `id` int(11) unsigned NOT NULL default '0',
435 `owner` int(11) unsigned NOT NULL default '0',
436 `genitive` varchar(12) NOT NULL default '',
437 `dative` varchar(12) NOT NULL default '',
438 `accusative` varchar(12) NOT NULL default '',
439 `instrumental` varchar(12) NOT NULL default '',
440 `prepositional` varchar(12) NOT NULL default '',
442 KEY owner_key (`owner`)
443 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;
446 -- Dumping data for table `character_pet_declinedname`
449 LOCK TABLES `character_pet_declinedname` WRITE;
450 /*!40000 ALTER TABLE `character_pet_declinedname` DISABLE KEYS */;
451 /*!40000 ALTER TABLE `character_pet_declinedname` ENABLE KEYS */;
455 -- Table structure for table `character_queststatus`
458 DROP TABLE IF EXISTS `character_queststatus`;
459 CREATE TABLE `character_queststatus` (
460 `guid` int(11) unsigned NOT NULL default '0' COMMENT 'Global Unique Identifier',
461 `quest` int(11) unsigned NOT NULL default '0' COMMENT 'Quest Identifier',
462 `status` int(11) unsigned NOT NULL default '0',
463 `rewarded` tinyint(1) unsigned NOT NULL default '0',
464 `explored` tinyint(1) unsigned NOT NULL default '0',
465 `timer` bigint(20) unsigned NOT NULL default '0',
466 `mobcount1` int(11) unsigned NOT NULL default '0',
467 `mobcount2` int(11) unsigned NOT NULL default '0',
468 `mobcount3` int(11) unsigned NOT NULL default '0',
469 `mobcount4` int(11) unsigned NOT NULL default '0',
470 `itemcount1` int(11) unsigned NOT NULL default '0',
471 `itemcount2` int(11) unsigned NOT NULL default '0',
472 `itemcount3` int(11) unsigned NOT NULL default '0',
473 `itemcount4` int(11) unsigned NOT NULL default '0',
474 PRIMARY KEY (`guid`,`quest`)
475 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Player System';
478 -- Dumping data for table `character_queststatus`
481 LOCK TABLES `character_queststatus` WRITE;
482 /*!40000 ALTER TABLE `character_queststatus` DISABLE KEYS */;
483 /*!40000 ALTER TABLE `character_queststatus` ENABLE KEYS */;
487 -- Table structure for table `character_queststatus_daily`
490 DROP TABLE IF EXISTS `character_queststatus_daily`;
491 CREATE TABLE `character_queststatus_daily` (
492 `guid` int(11) unsigned NOT NULL default '0' COMMENT 'Global Unique Identifier',
493 `quest` int(11) unsigned NOT NULL default '0' COMMENT 'Quest Identifier',
494 `time` bigint(20) unsigned NOT NULL default '0',
495 PRIMARY KEY (`guid`,`quest`),
496 KEY `idx_guid` (`guid`)
497 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Player System';
500 -- Dumping data for table `character_queststatus_daily`
503 LOCK TABLES `character_queststatus_daily` WRITE;
504 /*!40000 ALTER TABLE `character_queststatus_daily` DISABLE KEYS */;
505 /*!40000 ALTER TABLE `character_queststatus_daily` ENABLE KEYS */;
509 -- Table structure for table `character_reputation`
512 DROP TABLE IF EXISTS `character_reputation`;
513 CREATE TABLE `character_reputation` (
514 `guid` int(11) unsigned NOT NULL default '0' COMMENT 'Global Unique Identifier',
515 `faction` int(11) unsigned NOT NULL default '0',
516 `standing` int(11) NOT NULL default '0',
517 `flags` int(11) NOT NULL default '0',
518 PRIMARY KEY (`guid`,`faction`)
519 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Player System';
522 -- Dumping data for table `character_reputation`
525 LOCK TABLES `character_reputation` WRITE;
526 /*!40000 ALTER TABLE `character_reputation` DISABLE KEYS */;
527 /*!40000 ALTER TABLE `character_reputation` ENABLE KEYS */;
531 -- Table structure for table `character_social`
534 DROP TABLE IF EXISTS `character_social`;
535 CREATE TABLE `character_social` (
536 `guid` int(11) unsigned NOT NULL default '0' COMMENT 'Character Global Unique Identifier',
537 `friend` int(11) unsigned NOT NULL default '0' COMMENT 'Friend Global Unique Identifier',
538 `flags` tinyint(1) unsigned NOT NULL default '0' COMMENT 'Friend Flags',
539 `note` varchar(48) NOT NULL DEFAULT '' COMMENT 'Friend Note',
540 PRIMARY KEY (`guid`,`friend`,`flags`),
542 KEY `friend` (`friend`),
543 KEY `guid_flags` (`guid`,`flags`),
544 KEY `friend_flags` (`friend`,`flags`)
545 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Player System';
548 -- Dumping data for table `character_social`
551 LOCK TABLES `character_social` WRITE;
552 /*!40000 ALTER TABLE `character_social` DISABLE KEYS */;
553 /*!40000 ALTER TABLE `character_social` ENABLE KEYS */;
557 -- Table structure for table `character_spell`
560 DROP TABLE IF EXISTS `character_spell`;
561 CREATE TABLE `character_spell` (
562 `guid` int(11) unsigned NOT NULL default '0' COMMENT 'Global Unique Identifier',
563 `spell` int(11) unsigned NOT NULL default '0' COMMENT 'Spell Identifier',
564 `slot` int(11) unsigned NOT NULL default '0',
565 `active` tinyint(3) unsigned NOT NULL default '1',
566 `disabled` tinyint(3) unsigned NOT NULL default '0',
567 PRIMARY KEY (`guid`,`spell`)
568 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Player System';
571 -- Dumping data for table `character_spell`
574 LOCK TABLES `character_spell` WRITE;
575 /*!40000 ALTER TABLE `character_spell` DISABLE KEYS */;
576 /*!40000 ALTER TABLE `character_spell` ENABLE KEYS */;
580 -- Table structure for table `character_spell_cooldown`
583 DROP TABLE IF EXISTS `character_spell_cooldown`;
584 CREATE TABLE `character_spell_cooldown` (
585 `guid` int(11) unsigned NOT NULL default '0' COMMENT 'Global Unique Identifier, Low part',
586 `spell` int(11) unsigned NOT NULL default '0' COMMENT 'Spell Identifier',
587 `item` int(11) unsigned NOT NULL default '0' COMMENT 'Item Identifier',
588 `time` bigint(20) unsigned NOT NULL default '0',
589 PRIMARY KEY (`guid`,`spell`)
590 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
593 -- Dumping data for table `character_spell_cooldown`
596 LOCK TABLES `character_spell_cooldown` WRITE;
597 /*!40000 ALTER TABLE `character_spell_cooldown` DISABLE KEYS */;
598 /*!40000 ALTER TABLE `character_spell_cooldown` ENABLE KEYS */;
602 -- Table structure for table `character_ticket`
605 DROP TABLE IF EXISTS `character_ticket`;
606 CREATE TABLE `character_ticket` (
607 `ticket_id` int(11) unsigned NOT NULL auto_increment,
608 `guid` int(11) unsigned NOT NULL default '0',
610 `ticket_lastchange` TIMESTAMP ON UPDATE CURRENT_TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
611 PRIMARY KEY (`ticket_id`)
612 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Player System';
615 -- Dumping data for table `character_ticket`
618 LOCK TABLES `character_ticket` WRITE;
619 /*!40000 ALTER TABLE `character_ticket` DISABLE KEYS */;
620 /*!40000 ALTER TABLE `character_ticket` ENABLE KEYS */;
624 -- Table structure for table `character_tutorial`
627 DROP TABLE IF EXISTS `character_tutorial`;
628 CREATE TABLE `character_tutorial` (
629 `account` bigint(20) unsigned NOT NULL auto_increment COMMENT 'Account Identifier',
630 `realmid` int(11) unsigned NOT NULL default '0' COMMENT 'Realm Identifier',
631 `tut0` int(11) unsigned NOT NULL default '0',
632 `tut1` int(11) unsigned NOT NULL default '0',
633 `tut2` int(11) unsigned NOT NULL default '0',
634 `tut3` int(11) unsigned NOT NULL default '0',
635 `tut4` int(11) unsigned NOT NULL default '0',
636 `tut5` int(11) unsigned NOT NULL default '0',
637 `tut6` int(11) unsigned NOT NULL default '0',
638 `tut7` int(11) unsigned NOT NULL default '0',
639 PRIMARY KEY (`account`,`realmid`),
640 KEY acc_key (`account`)
641 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Player System';
644 -- Dumping data for table `character_tutorial`
647 LOCK TABLES `character_tutorial` WRITE;
648 /*!40000 ALTER TABLE `character_tutorial` DISABLE KEYS */;
649 /*!40000 ALTER TABLE `character_tutorial` ENABLE KEYS */;
653 -- Table structure for table `corpse`
656 DROP TABLE IF EXISTS `corpse`;
657 CREATE TABLE `corpse` (
658 `guid` int(11) unsigned NOT NULL default '0' COMMENT 'Global Unique Identifier',
659 `player` int(11) unsigned NOT NULL default '0' COMMENT 'Character Global Unique Identifier',
660 `position_x` float NOT NULL default '0',
661 `position_y` float NOT NULL default '0',
662 `position_z` float NOT NULL default '0',
663 `orientation` float NOT NULL default '0',
664 `zone` int(11) unsigned NOT NULL default '38' COMMENT 'Zone Identifier',
665 `map` int(11) unsigned NOT NULL default '0' COMMENT 'Map Identifier',
667 `time` bigint(20) unsigned NOT NULL default '0',
668 `corpse_type` tinyint(3) unsigned NOT NULL default '0',
669 `instance` int(11) unsigned NOT NULL default '0',
670 PRIMARY KEY (`guid`),
671 KEY `idx_type` (`corpse_type`),
672 KEY `instance` (`instance`)
673 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Death System';
676 -- Dumping data for table `corpse`
679 LOCK TABLES `corpse` WRITE;
680 /*!40000 ALTER TABLE `corpse` DISABLE KEYS */;
681 /*!40000 ALTER TABLE `corpse` ENABLE KEYS */;
685 -- Table structure for table `groups`
688 DROP TABLE IF EXISTS `groups`;
689 CREATE TABLE `groups` (
690 `leaderGuid` int(11) unsigned NOT NULL,
691 `mainTank` int(11) unsigned NOT NULL,
692 `mainAssistant` int(11) unsigned NOT NULL,
693 `lootMethod` tinyint(4) unsigned NOT NULL,
694 `looterGuid` int(11) unsigned NOT NULL,
695 `lootThreshold` tinyint(4) unsigned NOT NULL,
696 `icon1` int(11) unsigned NOT NULL,
697 `icon2` int(11) unsigned NOT NULL,
698 `icon3` int(11) unsigned NOT NULL,
699 `icon4` int(11) unsigned NOT NULL,
700 `icon5` int(11) unsigned NOT NULL,
701 `icon6` int(11) unsigned NOT NULL,
702 `icon7` int(11) unsigned NOT NULL,
703 `icon8` int(11) unsigned NOT NULL,
704 `isRaid` tinyint(1) unsigned NOT NULL,
705 `difficulty` tinyint(3) unsigned NOT NULL default '0',
706 PRIMARY KEY (`leaderGuid`)
707 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Groups';
710 -- Dumping data for table `groups`
713 LOCK TABLES `groups` WRITE;
714 /*!40000 ALTER TABLE `groups` DISABLE KEYS */;
715 /*!40000 ALTER TABLE `groups` ENABLE KEYS */;
718 -- ----------------------------
719 -- Table structure for group_instance
720 -- ----------------------------
721 DROP TABLE IF EXISTS `group_instance`;
722 CREATE TABLE `group_instance` (
723 `leaderGuid` int(11) unsigned NOT NULL default '0',
724 `instance` int(11) unsigned NOT NULL default '0',
725 `permanent` tinyint(1) unsigned NOT NULL default '0',
726 PRIMARY KEY (`leaderGuid`,`instance`),
727 KEY `instance` (`instance`)
728 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
731 -- Dumping data for table `group_instance`
734 LOCK TABLES `group_instance` WRITE;
735 /*!40000 ALTER TABLE `group_instance` DISABLE KEYS */;
736 /*!40000 ALTER TABLE `group_instance` ENABLE KEYS */;
740 -- Table structure for table `group_member`
743 DROP TABLE IF EXISTS `group_member`;
744 CREATE TABLE `group_member` (
745 `leaderGuid` int(11) unsigned NOT NULL,
746 `memberGuid` int(11) unsigned NOT NULL,
747 `assistant` tinyint(1) unsigned NOT NULL,
748 `subgroup` smallint(6) unsigned NOT NULL,
749 PRIMARY KEY (`leaderGuid`,`memberGuid`)
750 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Groups';
753 -- Dumping data for table `group_member`
756 LOCK TABLES `group_member` WRITE;
757 /*!40000 ALTER TABLE `group_member` DISABLE KEYS */;
758 /*!40000 ALTER TABLE `group_member` ENABLE KEYS */;
762 -- Table structure for table `guild`
765 DROP TABLE IF EXISTS `guild`;
766 CREATE TABLE `guild` (
767 `guildid` int(6) unsigned NOT NULL default '0',
768 `name` varchar(255) NOT NULL default '',
769 `leaderguid` int(6) unsigned NOT NULL default '0',
770 `EmblemStyle` int(5) NOT NULL default '0',
771 `EmblemColor` int(5) NOT NULL default '0',
772 `BorderStyle` int(5) NOT NULL default '0',
773 `BorderColor` int(5) NOT NULL default '0',
774 `BackgroundColor` int(5) NOT NULL default '0',
775 `info` text NOT NULL,
776 `motd` varchar(255) NOT NULL default '',
777 `createdate` datetime default NULL,
778 `BankMoney` bigint(20) NOT NULL default '0',
779 PRIMARY KEY (`guildid`)
780 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Guild System';
783 -- Dumping data for table `guild`
786 LOCK TABLES `guild` WRITE;
787 /*!40000 ALTER TABLE `guild` DISABLE KEYS */;
788 /*!40000 ALTER TABLE `guild` ENABLE KEYS */;
792 -- Table structure for table `guild_bank_eventlog`
795 DROP TABLE IF EXISTS `guild_bank_eventlog`;
796 CREATE TABLE `guild_bank_eventlog` (
797 `guildid` int(11) unsigned NOT NULL default '0',
798 `LogGuid` int(11) unsigned NOT NULL default '0',
799 `LogEntry` tinyint(1) unsigned NOT NULL default '0',
800 `TabId` tinyint(1) unsigned NOT NULL default '0',
801 `PlayerGuid` int(11) unsigned NOT NULL default '0',
802 `ItemOrMoney` int(11) unsigned NOT NULL default '0',
803 `ItemStackCount` tinyint(3) unsigned NOT NULL default '0',
804 `DestTabId` tinyint(1) unsigned NOT NULL default '0',
805 `TimeStamp` bigint(20) unsigned NOT NULL default '0',
806 PRIMARY KEY (`guildid`,`LogGuid`),
807 KEY `guildid_key` (`guildid`)
808 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
811 -- Dumping data for table `guild_bank_eventlog`
814 LOCK TABLES `guild_bank_eventlog` WRITE;
815 /*!40000 ALTER TABLE `guild_bank_eventlog` DISABLE KEYS */;
816 /*!40000 ALTER TABLE `guild_bank_eventlog` ENABLE KEYS */;
820 -- Table structure for table `guild_bank_item`
823 DROP TABLE IF EXISTS `guild_bank_item`;
824 CREATE TABLE `guild_bank_item` (
825 `guildid` int(11) unsigned NOT NULL default '0',
826 `TabId` tinyint(1) unsigned NOT NULL default '0',
827 `SlotId` tinyint(3) unsigned NOT NULL default '0',
828 `item_guid` int(11) unsigned NOT NULL default '0',
829 `item_entry` int(11) unsigned NOT NULL default '0',
830 PRIMARY KEY (`guildid`,`tabid`,`slotid`),
831 KEY `guildid_key` (`guildid`)
832 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
835 -- Dumping data for table `guild_bank_item`
838 LOCK TABLES `guild_bank_item` WRITE;
839 /*!40000 ALTER TABLE `guild_bank_item` DISABLE KEYS */;
840 /*!40000 ALTER TABLE `guild_bank_item` ENABLE KEYS */;
844 -- Table structure for table `guild_bank_right`
847 DROP TABLE IF EXISTS `guild_bank_right`;
848 CREATE TABLE `guild_bank_right` (
849 `guildid` int(11) unsigned NOT NULL default '0',
850 `TabId` tinyint(1) unsigned NOT NULL default '0',
851 `rid` int(11) unsigned NOT NULL default '0',
852 `gbright` tinyint(3) unsigned NOT NULL default '0',
853 `SlotPerDay` int(11) unsigned NOT NULL default '0',
854 PRIMARY KEY (`guildid`,`TabId`,`rid`),
855 KEY `guildid_key` (`guildid`)
856 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
859 -- Dumping data for table `guild_bank_right`
862 LOCK TABLES `guild_bank_right` WRITE;
863 /*!40000 ALTER TABLE `guild_bank_right` DISABLE KEYS */;
864 /*!40000 ALTER TABLE `guild_bank_right` ENABLE KEYS */;
868 -- Table structure for table `guild_bank_tab`
871 DROP TABLE IF EXISTS `guild_bank_tab`;
872 CREATE TABLE `guild_bank_tab` (
873 `guildid` int(11) unsigned NOT NULL default '0',
874 `TabId` tinyint(1) unsigned NOT NULL default '0',
875 `TabName` varchar(100) NOT NULL default '',
876 `TabIcon` varchar(100) NOT NULL default '',
878 PRIMARY KEY (`guildid`,`TabId`),
879 KEY `guildid_key` (`guildid`)
880 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
883 -- Dumping data for table `guild_bank_tab`
886 LOCK TABLES `guild_bank_tab` WRITE;
887 /*!40000 ALTER TABLE `guild_bank_tab` DISABLE KEYS */;
888 /*!40000 ALTER TABLE `guild_bank_tab` ENABLE KEYS */;
892 -- Table structure for table `guild_eventlog`
895 DROP TABLE IF EXISTS `guild_eventlog`;
896 CREATE TABLE `guild_eventlog` (
897 `guildid` int(11) NOT NULL COMMENT 'Guild Identificator',
898 `LogGuid` int(11) NOT NULL COMMENT 'Log entry identificator',
899 `EventType` tinyint(1) NOT NULL COMMENT 'Event type',
900 `PlayerGuid1` int(11) NOT NULL COMMENT 'Player 1',
901 `PlayerGuid2` int(11) NOT NULL COMMENT 'Player 2',
902 `NewRank` tinyint(2) NOT NULL COMMENT 'New rank(in case promotion/demotion)',
903 `TimeStamp` bigint(20) NOT NULL COMMENT 'Event UNIX time'
904 ) ENGINE = InnoDB DEFAULT CHARSET = latin1 COMMENT 'Guild Eventlog';
907 -- Dumping data for table `guild_eventlog`
910 LOCK TABLES `guild_eventlog` WRITE;
911 /*!40000 ALTER TABLE `guild_eventlog` DISABLE KEYS */;
912 /*!40000 ALTER TABLE `guild_eventlog` ENABLE KEYS */;
916 -- Table structure for table `guild_member`
919 DROP TABLE IF EXISTS `guild_member`;
920 CREATE TABLE `guild_member` (
921 `guildid` int(6) unsigned NOT NULL default '0',
922 `guid` int(11) unsigned NOT NULL default '0',
923 `rank` tinyint(2) unsigned NOT NULL default '0',
924 `pnote` varchar(255) NOT NULL default '',
925 `offnote` varchar(255) NOT NULL default '',
926 `BankResetTimeMoney` int(11) unsigned NOT NULL default '0',
927 `BankRemMoney` int(11) unsigned NOT NULL default '0',
928 `BankResetTimeTab0` int(11) unsigned NOT NULL default '0',
929 `BankRemSlotsTab0` int(11) unsigned NOT NULL default '0',
930 `BankResetTimeTab1` int(11) unsigned NOT NULL default '0',
931 `BankRemSlotsTab1` int(11) unsigned NOT NULL default '0',
932 `BankResetTimeTab2` int(11) unsigned NOT NULL default '0',
933 `BankRemSlotsTab2` int(11) unsigned NOT NULL default '0',
934 `BankResetTimeTab3` int(11) unsigned NOT NULL default '0',
935 `BankRemSlotsTab3` int(11) unsigned NOT NULL default '0',
936 `BankResetTimeTab4` int(11) unsigned NOT NULL default '0',
937 `BankRemSlotsTab4` int(11) unsigned NOT NULL default '0',
938 `BankResetTimeTab5` int(11) unsigned NOT NULL default '0',
939 `BankRemSlotsTab5` int(11) unsigned NOT NULL default '0',
940 KEY `guildid_key` (`guildid`),
941 KEY `guildid_rank_key` (`guildid`,`rank`),
942 UNIQUE KEY `guid_key` (`guid`)
943 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Guild System';
946 -- Dumping data for table `guild_member`
949 LOCK TABLES `guild_member` WRITE;
950 /*!40000 ALTER TABLE `guild_member` DISABLE KEYS */;
951 /*!40000 ALTER TABLE `guild_member` ENABLE KEYS */;
955 -- Table structure for table `guild_rank`
958 DROP TABLE IF EXISTS `guild_rank`;
959 CREATE TABLE `guild_rank` (
960 `guildid` int(6) unsigned NOT NULL default '0',
961 `rid` int(11) unsigned NOT NULL,
962 `rname` varchar(255) NOT NULL default '',
963 `rights` int(3) unsigned NOT NULL default '0',
964 `BankMoneyPerDay` int(11) unsigned NOT NULL default '0',
965 PRIMARY KEY (`guildid`,`rid`)
966 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Guild System';
969 -- Dumping data for table `guild_rank`
972 LOCK TABLES `guild_rank` WRITE;
973 /*!40000 ALTER TABLE `guild_rank` DISABLE KEYS */;
974 /*!40000 ALTER TABLE `guild_rank` ENABLE KEYS */;
978 -- Table structure for table `instance`
981 DROP TABLE IF EXISTS `instance`;
982 CREATE TABLE `instance` (
983 `id` int(11) unsigned NOT NULL default '0',
984 `map` int(11) unsigned NOT NULL default '0',
985 `resettime` bigint(40) NOT NULL default '0',
986 `difficulty` tinyint(1) unsigned NOT NULL default '0',
990 KEY `resettime` (`resettime`)
991 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
994 -- Dumping data for table `instance`
997 LOCK TABLES `instance` WRITE;
998 /*!40000 ALTER TABLE `instance` DISABLE KEYS */;
999 /*!40000 ALTER TABLE `instance` ENABLE KEYS */;
1002 -- ----------------------------
1003 -- Table structure for instance_reset
1004 -- ----------------------------
1005 DROP TABLE IF EXISTS `instance_reset`;
1006 CREATE TABLE `instance_reset` (
1007 `mapid` int(11) unsigned NOT NULL default '0',
1008 `resettime` bigint(40) NOT NULL default '0',
1009 PRIMARY KEY (`mapid`)
1010 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1013 -- Dumping data for table `instance_reset`
1016 LOCK TABLES `instance_reset` WRITE;
1017 /*!40000 ALTER TABLE `instance_reset` DISABLE KEYS */;
1018 /*!40000 ALTER TABLE `instance_reset` ENABLE KEYS */;
1022 -- Table structure for table `item_instance`
1025 DROP TABLE IF EXISTS `item_instance`;
1026 CREATE TABLE `item_instance` (
1027 `guid` int(11) unsigned NOT NULL default '0',
1028 `owner_guid` int(11) unsigned NOT NULL default '0',
1030 PRIMARY KEY (`guid`),
1031 KEY `idx_owner_guid` (`owner_guid`)
1032 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Item System';
1035 -- Dumping data for table `item_instance`
1038 LOCK TABLES `item_instance` WRITE;
1039 /*!40000 ALTER TABLE `item_instance` DISABLE KEYS */;
1040 /*!40000 ALTER TABLE `item_instance` ENABLE KEYS */;
1044 -- Table structure for table `item_text`
1047 DROP TABLE IF EXISTS `item_text`;
1048 CREATE TABLE `item_text` (
1049 `id` int(11) unsigned NOT NULL default '0',
1052 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Item System';
1055 -- Dumping data for table `item_text`
1058 LOCK TABLES `item_text` WRITE;
1059 /*!40000 ALTER TABLE `item_text` DISABLE KEYS */;
1060 /*!40000 ALTER TABLE `item_text` ENABLE KEYS */;
1064 -- Table structure for table `mail`
1067 DROP TABLE IF EXISTS `mail`;
1068 CREATE TABLE `mail` (
1069 `id` int(11) unsigned NOT NULL default '0' COMMENT 'Identifier',
1070 `messageType` tinyint(3) unsigned NOT NULL default '0',
1071 `stationery` tinyint(3) NOT NULL default '41',
1072 `mailTemplateId` mediumint(8) unsigned NOT NULL default '0',
1073 `sender` int(11) unsigned NOT NULL default '0' COMMENT 'Character Global Unique Identifier',
1074 `receiver` int(11) unsigned NOT NULL default '0' COMMENT 'Character Global Unique Identifier',
1076 `itemTextId` int(11) unsigned NOT NULL default '0',
1077 `has_items` tinyint(3) unsigned NOT NULL default '0',
1078 `expire_time` bigint(40) NOT NULL default '0',
1079 `deliver_time` bigint(40) NOT NULL default '0',
1080 `money` int(11) unsigned NOT NULL default '0',
1081 `cod` int(11) unsigned NOT NULL default '0',
1082 `checked` tinyint(3) unsigned NOT NULL default '0',
1084 KEY `idx_receiver` (`receiver`)
1085 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Mail System';
1088 -- Dumping data for table `mail`
1091 LOCK TABLES `mail` WRITE;
1092 /*!40000 ALTER TABLE `mail` DISABLE KEYS */;
1093 /*!40000 ALTER TABLE `mail` ENABLE KEYS */;
1097 -- Table structure for table `mail_items`
1100 DROP TABLE IF EXISTS `mail_items`;
1101 CREATE TABLE `mail_items` (
1102 `mail_id` int(11) NOT NULL default '0',
1103 `item_guid` int(11) NOT NULL default '0',
1104 `item_template` int(11) NOT NULL default '0',
1105 `receiver` int(11) unsigned NOT NULL default '0' COMMENT 'Character Global Unique Identifier',
1106 PRIMARY KEY (`mail_id`,`item_guid`),
1107 KEY `idx_receiver` (`receiver`)
1108 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;
1111 -- Dumping data for table `mail_items`
1114 LOCK TABLES `mail_items` WRITE;
1115 /*!40000 ALTER TABLE `mail_items` DISABLE KEYS */;
1116 /*!40000 ALTER TABLE `mail_items` ENABLE KEYS */;
1120 -- Table structure for table `pet_aura`
1123 DROP TABLE IF EXISTS `pet_aura`;
1124 CREATE TABLE `pet_aura` (
1125 `guid` int(11) unsigned NOT NULL default '0' COMMENT 'Global Unique Identifier',
1126 `caster_guid` bigint(20) unsigned NOT NULL default '0' COMMENT 'Full Global Unique Identifier',
1127 `spell` int(11) unsigned NOT NULL default '0',
1128 `effect_index` int(11) unsigned NOT NULL default '0',
1129 `stackcount` int(11) NOT NULL default '1',
1130 `amount` int(11) NOT NULL default '0',
1131 `maxduration` int(11) NOT NULL default '0',
1132 `remaintime` int(11) NOT NULL default '0',
1133 `remaincharges` int(11) NOT NULL default '0',
1134 PRIMARY KEY (`guid`,`spell`,`effect_index`)
1135 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Pet System';
1138 -- Dumping data for table `pet_aura`
1141 LOCK TABLES `pet_aura` WRITE;
1142 /*!40000 ALTER TABLE `pet_aura` DISABLE KEYS */;
1143 /*!40000 ALTER TABLE `pet_aura` ENABLE KEYS */;
1147 -- Table structure for table `pet_spell`
1150 DROP TABLE IF EXISTS `pet_spell`;
1151 CREATE TABLE `pet_spell` (
1152 `guid` int(11) unsigned NOT NULL default '0' COMMENT 'Global Unique Identifier',
1153 `spell` int(11) unsigned NOT NULL default '0' COMMENT 'Spell Identifier',
1154 `slot` int(11) unsigned NOT NULL default '0',
1155 `active` int(11) unsigned NOT NULL default '0',
1156 PRIMARY KEY (`guid`,`spell`)
1157 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Pet System';
1160 -- Dumping data for table `pet_spell`
1163 LOCK TABLES `pet_spell` WRITE;
1164 /*!40000 ALTER TABLE `pet_spell` DISABLE KEYS */;
1165 /*!40000 ALTER TABLE `pet_spell` ENABLE KEYS */;
1169 -- Table structure for table `pet_spell_cooldown`
1172 DROP TABLE IF EXISTS `pet_spell_cooldown`;
1173 CREATE TABLE `pet_spell_cooldown` (
1174 `guid` int(11) unsigned NOT NULL default '0' COMMENT 'Global Unique Identifier, Low part',
1175 `spell` int(11) unsigned NOT NULL default '0' COMMENT 'Spell Identifier',
1176 `time` bigint(20) unsigned NOT NULL default '0',
1177 PRIMARY KEY (`guid`,`spell`)
1178 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1181 -- Dumping data for table `pet_spell_cooldown`
1184 LOCK TABLES `pet_spell_cooldown` WRITE;
1185 /*!40000 ALTER TABLE `pet_spell_cooldown` DISABLE KEYS */;
1186 /*!40000 ALTER TABLE `pet_spell_cooldown` ENABLE KEYS */;
1190 -- Table structure for table `petition`
1193 DROP TABLE IF EXISTS `petition`;
1194 CREATE TABLE `petition` (
1195 `ownerguid` int(10) unsigned NOT NULL,
1196 `petitionguid` int(10) unsigned default '0',
1197 `name` varchar(255) NOT NULL default '',
1198 `type` int(10) unsigned NOT NULL default '0',
1199 PRIMARY KEY (`ownerguid`,`type`),
1200 UNIQUE KEY `index_ownerguid_petitionguid` (`ownerguid`,`petitionguid`)
1201 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Guild System';
1204 -- Dumping data for table `petition`
1207 LOCK TABLES `petition` WRITE;
1208 /*!40000 ALTER TABLE `petition` DISABLE KEYS */;
1209 /*!40000 ALTER TABLE `petition` ENABLE KEYS */;
1213 -- Table structure for table `petition_sign`
1216 DROP TABLE IF EXISTS `petition_sign`;
1217 CREATE TABLE `petition_sign` (
1218 `ownerguid` int(10) unsigned NOT NULL,
1219 `petitionguid` int(11) unsigned NOT NULL default '0',
1220 `playerguid` int(11) unsigned NOT NULL default '0',
1221 `player_account` int(11) unsigned NOT NULL default '0',
1222 `type` int(10) unsigned NOT NULL default '0',
1223 PRIMARY KEY (`petitionguid`,`playerguid`)
1224 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Guild System';
1226 -- Dumping data for table `petition_sign`
1229 LOCK TABLES `petition_sign` WRITE;
1230 /*!40000 ALTER TABLE `petition_sign` DISABLE KEYS */;
1231 /*!40000 ALTER TABLE `petition_sign` ENABLE KEYS */;
1233 /*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
1235 /*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
1236 /*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
1237 /*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
1238 /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
1239 /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
1240 /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
1241 /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
1243 -- Dump completed on 2008-01-10 11:37:06