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 */;
20 -- Table structure for table `saved_variables`
23 CREATE TABLE `saved_variables` (
24 `NextArenaPointDistributionTime` bigint(40) UNSIGNED NOT NULL DEFAULT '0'
25 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Variable Saves';
28 -- Table structure for table `character_db_version`
31 DROP TABLE IF EXISTS `character_db_version`;
32 CREATE TABLE `character_db_version` (
33 `required_2008_12_15_01_character_arenas` bit(1) default NULL
34 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Last applied sql update to DB';
37 -- Dumping data for table `character_db_version`
40 LOCK TABLES `character_db_version` WRITE;
41 /*!40000 ALTER TABLE `character_db_version` DISABLE KEYS */;
42 INSERT INTO `character_db_version` VALUES
44 /*!40000 ALTER TABLE `character_db_version` ENABLE KEYS */;
48 -- Table structure for table `arena_team`
51 DROP TABLE IF EXISTS `arena_team`;
52 CREATE TABLE `arena_team` (
53 `arenateamid` int(10) unsigned NOT NULL default '0',
54 `name` char(255) NOT NULL,
55 `captainguid` int(10) unsigned NOT NULL default '0',
56 `type` tinyint(3) unsigned NOT NULL default '0',
57 `BackgroundColor` int(10) unsigned NOT NULL default '0',
58 `EmblemStyle` int(10) unsigned NOT NULL default '0',
59 `EmblemColor` int(10) unsigned NOT NULL default '0',
60 `BorderStyle` int(10) unsigned NOT NULL default '0',
61 `BorderColor` int(10) unsigned NOT NULL default '0',
62 PRIMARY KEY (`arenateamid`)
63 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
66 -- Dumping data for table `arena_team`
69 LOCK TABLES `arena_team` WRITE;
70 /*!40000 ALTER TABLE `arena_team` DISABLE KEYS */;
71 /*!40000 ALTER TABLE `arena_team` ENABLE KEYS */;
75 -- Table structure for table `arena_team_member`
78 DROP TABLE IF EXISTS `arena_team_member`;
79 CREATE TABLE `arena_team_member` (
80 `arenateamid` int(10) unsigned NOT NULL default '0',
81 `guid` int(10) unsigned NOT NULL default '0',
82 `played_week` int(10) unsigned NOT NULL default '0',
83 `wons_week` int(10) unsigned NOT NULL default '0',
84 `played_season` int(10) unsigned NOT NULL default '0',
85 `wons_season` int(10) unsigned NOT NULL default '0',
86 `personal_rating` int(10) UNSIGNED NOT NULL DEFAULT '0'
87 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
90 -- Dumping data for table `arena_team_member`
93 LOCK TABLES `arena_team_member` WRITE;
94 /*!40000 ALTER TABLE `arena_team_member` DISABLE KEYS */;
95 /*!40000 ALTER TABLE `arena_team_member` ENABLE KEYS */;
99 -- Table structure for table `arena_team_stats`
102 DROP TABLE IF EXISTS `arena_team_stats`;
103 CREATE TABLE `arena_team_stats` (
104 `arenateamid` int(10) unsigned NOT NULL default '0',
105 `rating` int(10) unsigned NOT NULL default '0',
106 `games` int(10) unsigned NOT NULL default '0',
107 `wins` int(10) unsigned NOT NULL default '0',
108 `played` int(10) unsigned NOT NULL default '0',
109 `wins2` int(10) unsigned NOT NULL default '0',
110 `rank` int(10) unsigned NOT NULL default '0',
111 PRIMARY KEY (`arenateamid`)
112 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
115 -- Dumping data for table `arena_team_stats`
118 LOCK TABLES `arena_team_stats` WRITE;
119 /*!40000 ALTER TABLE `arena_team_stats` DISABLE KEYS */;
120 /*!40000 ALTER TABLE `arena_team_stats` ENABLE KEYS */;
124 -- Table structure for table `auctionhouse`
127 DROP TABLE IF EXISTS `auctionhouse`;
128 CREATE TABLE `auctionhouse` (
129 `id` int(11) unsigned NOT NULL default '0',
130 `auctioneerguid` int(11) unsigned NOT NULL default '0',
131 `itemguid` int(11) unsigned NOT NULL default '0',
132 `item_template` int(11) unsigned NOT NULL default '0' COMMENT 'Item Identifier',
133 `itemowner` int(11) unsigned NOT NULL default '0',
134 `buyoutprice` int(11) NOT NULL default '0',
135 `time` bigint(40) NOT NULL default '0',
136 `buyguid` int(11) unsigned NOT NULL default '0',
137 `lastbid` int(11) NOT NULL default '0',
138 `startbid` int(11) NOT NULL default '0',
139 `deposit` int(11) NOT NULL default '0',
140 `location` tinyint(3) unsigned NOT NULL default '3',
142 UNIQUE KEY `item_guid` (`itemguid`)
143 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
146 -- Dumping data for table `auctionhouse`
149 LOCK TABLES `auctionhouse` WRITE;
150 /*!40000 ALTER TABLE `auctionhouse` DISABLE KEYS */;
151 /*!40000 ALTER TABLE `auctionhouse` ENABLE KEYS */;
155 -- Table structure for table `bugreport`
158 DROP TABLE IF EXISTS `bugreport`;
159 CREATE TABLE `bugreport` (
160 `id` int(11) NOT NULL auto_increment COMMENT 'Identifier',
161 `type` varchar(255) NOT NULL default '',
162 `content` varchar(255) NOT NULL default '',
164 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Debug System';
167 -- Dumping data for table `bugreport`
170 LOCK TABLES `bugreport` WRITE;
171 /*!40000 ALTER TABLE `bugreport` DISABLE KEYS */;
172 /*!40000 ALTER TABLE `bugreport` ENABLE KEYS */;
176 -- Table structure for table `characters`
179 DROP TABLE IF EXISTS `characters`;
180 CREATE TABLE `characters` (
181 `guid` int(11) unsigned NOT NULL default '0' COMMENT 'Global Unique Identifier',
182 `account` int(11) unsigned NOT NULL default '0' COMMENT 'Account Identifier',
184 `name` varchar(12) NOT NULL default '',
185 `race` tinyint(3) unsigned NOT NULL default '0',
186 `class` tinyint(3) unsigned NOT NULL default '0',
187 `position_x` float NOT NULL default '0',
188 `position_y` float NOT NULL default '0',
189 `position_z` float NOT NULL default '0',
190 `map` int(11) unsigned NOT NULL default '0' COMMENT 'Map Identifier',
191 `dungeon_difficulty` tinyint(1) unsigned NOT NULL DEFAULT '0',
192 `orientation` float NOT NULL default '0',
194 `online` tinyint(3) unsigned NOT NULL default '0',
195 `cinematic` tinyint(3) unsigned NOT NULL default '0',
196 `totaltime` int(11) unsigned NOT NULL default '0',
197 `leveltime` int(11) unsigned NOT NULL default '0',
198 `logout_time` bigint(20) unsigned NOT NULL default '0',
199 `is_logout_resting` tinyint(3) unsigned NOT NULL default '0',
200 `rest_bonus` float NOT NULL default '0',
201 `resettalents_cost` int(11) unsigned NOT NULL default '0',
202 `resettalents_time` bigint(20) unsigned NOT NULL default '0',
203 `trans_x` float NOT NULL default '0',
204 `trans_y` float NOT NULL default '0',
205 `trans_z` float NOT NULL default '0',
206 `trans_o` float NOT NULL default '0',
207 `transguid` bigint(20) unsigned NOT NULL default '0',
208 `extra_flags` int(11) unsigned NOT NULL default '0',
209 `stable_slots` tinyint(1) unsigned NOT NULL default '0',
210 `at_login` int(11) unsigned NOT NULL default '0',
211 `zone` int(11) unsigned NOT NULL default '0',
212 `death_expire_time` bigint(20) unsigned NOT NULL default '0',
214 `arena_pending_points` int(10) UNSIGNED NOT NULL default '0',
215 PRIMARY KEY (`guid`),
216 KEY `idx_account` (`account`),
217 KEY `idx_online` (`online`),
218 KEY `idx_name` (`name`)
219 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Player System';
222 -- Dumping data for table `characters`
225 LOCK TABLES `characters` WRITE;
226 /*!40000 ALTER TABLE `characters` DISABLE KEYS */;
227 /*!40000 ALTER TABLE `characters` ENABLE KEYS */;
231 -- Table structure for table `character_action`
234 DROP TABLE IF EXISTS `character_action`;
235 CREATE TABLE `character_action` (
236 `guid` int(11) unsigned NOT NULL default '0' COMMENT 'Global Unique Identifier',
237 `button` tinyint(3) unsigned NOT NULL default '0',
238 `action` smallint(5) unsigned NOT NULL default '0',
239 `type` tinyint(3) unsigned NOT NULL default '0',
240 `misc` tinyint(3) unsigned NOT NULL default '0',
241 PRIMARY KEY (`guid`,`button`)
242 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Player System';
245 -- Dumping data for table `character_action`
248 LOCK TABLES `character_action` WRITE;
249 /*!40000 ALTER TABLE `character_action` DISABLE KEYS */;
250 /*!40000 ALTER TABLE `character_action` ENABLE KEYS */;
254 -- Table structure for table `character_aura`
257 DROP TABLE IF EXISTS `character_aura`;
258 CREATE TABLE `character_aura` (
259 `guid` int(11) unsigned NOT NULL default '0' COMMENT 'Global Unique Identifier',
260 `caster_guid` bigint(20) unsigned NOT NULL default '0' COMMENT 'Full Global Unique Identifier',
261 `spell` int(11) unsigned NOT NULL default '0',
262 `effect_index` int(11) unsigned NOT NULL default '0',
263 `stackcount` int(11) NOT NULL default '1',
264 `amount` int(11) NOT NULL default '0',
265 `maxduration` int(11) NOT NULL default '0',
266 `remaintime` int(11) NOT NULL default '0',
267 `remaincharges` int(11) NOT NULL default '0',
268 PRIMARY KEY (`guid`,`spell`,`effect_index`)
269 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Player System';
272 -- Dumping data for table `character_aura`
275 LOCK TABLES `character_aura` WRITE;
276 /*!40000 ALTER TABLE `character_aura` DISABLE KEYS */;
277 /*!40000 ALTER TABLE `character_aura` ENABLE KEYS */;
281 -- Table structure for table `character_declinedname`
284 DROP TABLE IF EXISTS `character_declinedname`;
285 CREATE TABLE `character_declinedname` (
286 `guid` int(11) unsigned NOT NULL default '0' COMMENT 'Global Unique Identifier',
287 `genitive` varchar(15) NOT NULL default '',
288 `dative` varchar(15) NOT NULL default '',
289 `accusative` varchar(15) NOT NULL default '',
290 `instrumental` varchar(15) NOT NULL default '',
291 `prepositional` varchar(15) NOT NULL default '',
293 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;
296 -- Dumping data for table `character_declinedname`
299 LOCK TABLES `character_declinedname` WRITE;
300 /*!40000 ALTER TABLE `character_declinedname` DISABLE KEYS */;
301 /*!40000 ALTER TABLE `character_declinedname` ENABLE KEYS */;
305 -- Table structure for table `character_gifts`
308 DROP TABLE IF EXISTS `character_gifts`;
309 CREATE TABLE `character_gifts` (
310 `guid` int(20) unsigned NOT NULL default '0',
311 `item_guid` int(11) unsigned NOT NULL default '0',
312 `entry` int(20) unsigned NOT NULL default '0',
313 `flags` int(20) unsigned NOT NULL default '0',
314 PRIMARY KEY (`item_guid`),
315 KEY `idx_guid` (`guid`)
316 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
319 -- Dumping data for table `character_gifts`
322 LOCK TABLES `character_gifts` WRITE;
323 /*!40000 ALTER TABLE `character_gifts` DISABLE KEYS */;
324 /*!40000 ALTER TABLE `character_gifts` ENABLE KEYS */;
328 -- Table structure for table `character_homebind`
331 DROP TABLE IF EXISTS `character_homebind`;
332 CREATE TABLE `character_homebind` (
333 `guid` int(11) unsigned NOT NULL default '0' COMMENT 'Global Unique Identifier',
334 `map` int(11) unsigned NOT NULL default '0' COMMENT 'Map Identifier',
335 `zone` int(11) unsigned NOT NULL default '0' COMMENT 'Zone Identifier',
336 `position_x` float NOT NULL default '0',
337 `position_y` float NOT NULL default '0',
338 `position_z` float NOT NULL default '0',
340 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Player System';
343 -- Dumping data for table `character_homebind`
346 LOCK TABLES `character_homebind` WRITE;
347 /*!40000 ALTER TABLE `character_homebind` DISABLE KEYS */;
348 /*!40000 ALTER TABLE `character_homebind` ENABLE KEYS */;
352 -- Table structure for table `character_instance`
355 DROP TABLE IF EXISTS `character_instance`;
356 CREATE TABLE `character_instance` (
357 `guid` int(11) unsigned NOT NULL default '0',
358 `instance` int(11) unsigned NOT NULL default '0',
359 `permanent` tinyint(1) unsigned NOT NULL default '0',
360 PRIMARY KEY (`guid`,`instance`),
361 KEY `instance` (`instance`)
362 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
365 -- Dumping data for table `character_instance`
368 LOCK TABLES `character_instance` WRITE;
369 /*!40000 ALTER TABLE `character_instance` DISABLE KEYS */;
370 /*!40000 ALTER TABLE `character_instance` ENABLE KEYS */;
374 -- Table structure for table `character_inventory`
377 DROP TABLE IF EXISTS `character_inventory`;
378 CREATE TABLE `character_inventory` (
379 `guid` int(11) unsigned NOT NULL default '0' COMMENT 'Global Unique Identifier',
380 `bag` int(11) unsigned NOT NULL default '0',
381 `slot` tinyint(3) unsigned NOT NULL default '0',
382 `item` int(11) unsigned NOT NULL default '0' COMMENT 'Item Global Unique Identifier',
383 `item_template` int(11) unsigned NOT NULL default '0' COMMENT 'Item Identifier',
384 PRIMARY KEY (`item`),
385 KEY `idx_guid` (`guid`)
386 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Player System';
389 -- Dumping data for table `character_inventory`
392 LOCK TABLES `character_inventory` WRITE;
393 /*!40000 ALTER TABLE `character_inventory` DISABLE KEYS */;
394 /*!40000 ALTER TABLE `character_inventory` ENABLE KEYS */;
398 -- Table structure for table `character_pet`
401 DROP TABLE IF EXISTS `character_pet`;
402 CREATE TABLE `character_pet` (
403 `id` int(11) unsigned NOT NULL default '0',
404 `entry` int(11) unsigned NOT NULL default '0',
405 `owner` int(11) unsigned NOT NULL default '0',
406 `modelid` int(11) unsigned default '0',
407 `CreatedBySpell` int(11) unsigned NOT NULL default '0',
408 `PetType` tinyint(3) unsigned NOT NULL default '0',
409 `level` int(11) unsigned NOT NULL default '1',
410 `exp` int(11) unsigned NOT NULL default '0',
411 `Reactstate` tinyint(1) unsigned NOT NULL default '0',
412 `loyaltypoints` int(11) NOT NULL default '0',
413 `loyalty` int(11) unsigned NOT NULL default '0',
414 `trainpoint` int(11) NOT NULL default '0',
415 `name` varchar(100) default 'Pet',
416 `renamed` tinyint(1) unsigned NOT NULL default '0',
417 `slot` int(11) unsigned NOT NULL default '0',
418 `curhealth` int(11) unsigned NOT NULL default '1',
419 `curmana` int(11) unsigned NOT NULL default '0',
420 `curhappiness` int(11) unsigned NOT NULL default '0',
421 `savetime` bigint(20) unsigned NOT NULL default '0',
422 `resettalents_cost` int(11) unsigned NOT NULL default '0',
423 `resettalents_time` bigint(20) unsigned NOT NULL default '0',
425 `teachspelldata` longtext,
427 KEY `owner` (`owner`)
428 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Pet System';
431 -- Dumping data for table `character_pet`
434 LOCK TABLES `character_pet` WRITE;
435 /*!40000 ALTER TABLE `character_pet` DISABLE KEYS */;
436 /*!40000 ALTER TABLE `character_pet` ENABLE KEYS */;
440 -- Table structure for table `character_pet_declinedname`
443 DROP TABLE IF EXISTS `character_pet_declinedname`;
444 CREATE TABLE `character_pet_declinedname` (
445 `id` int(11) unsigned NOT NULL default '0',
446 `owner` int(11) unsigned NOT NULL default '0',
447 `genitive` varchar(12) NOT NULL default '',
448 `dative` varchar(12) NOT NULL default '',
449 `accusative` varchar(12) NOT NULL default '',
450 `instrumental` varchar(12) NOT NULL default '',
451 `prepositional` varchar(12) NOT NULL default '',
453 KEY owner_key (`owner`)
454 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;
457 -- Dumping data for table `character_pet_declinedname`
460 LOCK TABLES `character_pet_declinedname` WRITE;
461 /*!40000 ALTER TABLE `character_pet_declinedname` DISABLE KEYS */;
462 /*!40000 ALTER TABLE `character_pet_declinedname` ENABLE KEYS */;
466 -- Table structure for table `character_queststatus`
469 DROP TABLE IF EXISTS `character_queststatus`;
470 CREATE TABLE `character_queststatus` (
471 `guid` int(11) unsigned NOT NULL default '0' COMMENT 'Global Unique Identifier',
472 `quest` int(11) unsigned NOT NULL default '0' COMMENT 'Quest Identifier',
473 `status` int(11) unsigned NOT NULL default '0',
474 `rewarded` tinyint(1) unsigned NOT NULL default '0',
475 `explored` tinyint(1) unsigned NOT NULL default '0',
476 `timer` bigint(20) unsigned NOT NULL default '0',
477 `mobcount1` int(11) unsigned NOT NULL default '0',
478 `mobcount2` int(11) unsigned NOT NULL default '0',
479 `mobcount3` int(11) unsigned NOT NULL default '0',
480 `mobcount4` int(11) unsigned NOT NULL default '0',
481 `itemcount1` int(11) unsigned NOT NULL default '0',
482 `itemcount2` int(11) unsigned NOT NULL default '0',
483 `itemcount3` int(11) unsigned NOT NULL default '0',
484 `itemcount4` int(11) unsigned NOT NULL default '0',
485 PRIMARY KEY (`guid`,`quest`)
486 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Player System';
489 -- Dumping data for table `character_queststatus`
492 LOCK TABLES `character_queststatus` WRITE;
493 /*!40000 ALTER TABLE `character_queststatus` DISABLE KEYS */;
494 /*!40000 ALTER TABLE `character_queststatus` ENABLE KEYS */;
498 -- Table structure for table `character_queststatus_daily`
501 DROP TABLE IF EXISTS `character_queststatus_daily`;
502 CREATE TABLE `character_queststatus_daily` (
503 `guid` int(11) unsigned NOT NULL default '0' COMMENT 'Global Unique Identifier',
504 `quest` int(11) unsigned NOT NULL default '0' COMMENT 'Quest Identifier',
505 `time` bigint(20) unsigned NOT NULL default '0',
506 PRIMARY KEY (`guid`,`quest`),
507 KEY `idx_guid` (`guid`)
508 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Player System';
511 -- Dumping data for table `character_queststatus_daily`
514 LOCK TABLES `character_queststatus_daily` WRITE;
515 /*!40000 ALTER TABLE `character_queststatus_daily` DISABLE KEYS */;
516 /*!40000 ALTER TABLE `character_queststatus_daily` ENABLE KEYS */;
520 -- Table structure for table `character_reputation`
523 DROP TABLE IF EXISTS `character_reputation`;
524 CREATE TABLE `character_reputation` (
525 `guid` int(11) unsigned NOT NULL default '0' COMMENT 'Global Unique Identifier',
526 `faction` int(11) unsigned NOT NULL default '0',
527 `standing` int(11) NOT NULL default '0',
528 `flags` int(11) NOT NULL default '0',
529 PRIMARY KEY (`guid`,`faction`)
530 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Player System';
533 -- Dumping data for table `character_reputation`
536 LOCK TABLES `character_reputation` WRITE;
537 /*!40000 ALTER TABLE `character_reputation` DISABLE KEYS */;
538 /*!40000 ALTER TABLE `character_reputation` ENABLE KEYS */;
542 -- Table structure for table `character_social`
545 DROP TABLE IF EXISTS `character_social`;
546 CREATE TABLE `character_social` (
547 `guid` int(11) unsigned NOT NULL default '0' COMMENT 'Character Global Unique Identifier',
548 `friend` int(11) unsigned NOT NULL default '0' COMMENT 'Friend Global Unique Identifier',
549 `flags` tinyint(1) unsigned NOT NULL default '0' COMMENT 'Friend Flags',
550 `note` varchar(48) NOT NULL DEFAULT '' COMMENT 'Friend Note',
551 PRIMARY KEY (`guid`,`friend`,`flags`),
553 KEY `friend` (`friend`),
554 KEY `guid_flags` (`guid`,`flags`),
555 KEY `friend_flags` (`friend`,`flags`)
556 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Player System';
559 -- Dumping data for table `character_social`
562 LOCK TABLES `character_social` WRITE;
563 /*!40000 ALTER TABLE `character_social` DISABLE KEYS */;
564 /*!40000 ALTER TABLE `character_social` ENABLE KEYS */;
568 -- Table structure for table `character_spell`
571 DROP TABLE IF EXISTS `character_spell`;
572 CREATE TABLE `character_spell` (
573 `guid` int(11) unsigned NOT NULL default '0' COMMENT 'Global Unique Identifier',
574 `spell` int(11) unsigned NOT NULL default '0' COMMENT 'Spell Identifier',
575 `slot` int(11) unsigned NOT NULL default '0',
576 `active` tinyint(3) unsigned NOT NULL default '1',
577 `disabled` tinyint(3) unsigned NOT NULL default '0',
578 PRIMARY KEY (`guid`,`spell`)
579 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Player System';
582 -- Dumping data for table `character_spell`
585 LOCK TABLES `character_spell` WRITE;
586 /*!40000 ALTER TABLE `character_spell` DISABLE KEYS */;
587 /*!40000 ALTER TABLE `character_spell` ENABLE KEYS */;
591 -- Table structure for table `character_spell_cooldown`
594 DROP TABLE IF EXISTS `character_spell_cooldown`;
595 CREATE TABLE `character_spell_cooldown` (
596 `guid` int(11) unsigned NOT NULL default '0' COMMENT 'Global Unique Identifier, Low part',
597 `spell` int(11) unsigned NOT NULL default '0' COMMENT 'Spell Identifier',
598 `item` int(11) unsigned NOT NULL default '0' COMMENT 'Item Identifier',
599 `time` bigint(20) unsigned NOT NULL default '0',
600 PRIMARY KEY (`guid`,`spell`)
601 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
604 -- Dumping data for table `character_spell_cooldown`
607 LOCK TABLES `character_spell_cooldown` WRITE;
608 /*!40000 ALTER TABLE `character_spell_cooldown` DISABLE KEYS */;
609 /*!40000 ALTER TABLE `character_spell_cooldown` ENABLE KEYS */;
613 -- Table structure for table `character_ticket`
616 DROP TABLE IF EXISTS `character_ticket`;
617 CREATE TABLE `character_ticket` (
618 `ticket_id` int(11) unsigned NOT NULL auto_increment,
619 `guid` int(11) unsigned NOT NULL default '0',
621 `ticket_lastchange` TIMESTAMP ON UPDATE CURRENT_TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
622 PRIMARY KEY (`ticket_id`)
623 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Player System';
626 -- Dumping data for table `character_ticket`
629 LOCK TABLES `character_ticket` WRITE;
630 /*!40000 ALTER TABLE `character_ticket` DISABLE KEYS */;
631 /*!40000 ALTER TABLE `character_ticket` ENABLE KEYS */;
635 -- Table structure for table `character_tutorial`
638 DROP TABLE IF EXISTS `character_tutorial`;
639 CREATE TABLE `character_tutorial` (
640 `account` bigint(20) unsigned NOT NULL auto_increment COMMENT 'Account Identifier',
641 `realmid` int(11) unsigned NOT NULL default '0' COMMENT 'Realm Identifier',
642 `tut0` int(11) unsigned NOT NULL default '0',
643 `tut1` int(11) unsigned NOT NULL default '0',
644 `tut2` int(11) unsigned NOT NULL default '0',
645 `tut3` int(11) unsigned NOT NULL default '0',
646 `tut4` int(11) unsigned NOT NULL default '0',
647 `tut5` int(11) unsigned NOT NULL default '0',
648 `tut6` int(11) unsigned NOT NULL default '0',
649 `tut7` int(11) unsigned NOT NULL default '0',
650 PRIMARY KEY (`account`,`realmid`),
651 KEY acc_key (`account`)
652 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Player System';
655 -- Dumping data for table `character_tutorial`
658 LOCK TABLES `character_tutorial` WRITE;
659 /*!40000 ALTER TABLE `character_tutorial` DISABLE KEYS */;
660 /*!40000 ALTER TABLE `character_tutorial` ENABLE KEYS */;
664 -- Table structure for table `corpse`
667 DROP TABLE IF EXISTS `corpse`;
668 CREATE TABLE `corpse` (
669 `guid` int(11) unsigned NOT NULL default '0' COMMENT 'Global Unique Identifier',
670 `player` int(11) unsigned NOT NULL default '0' COMMENT 'Character Global Unique Identifier',
671 `position_x` float NOT NULL default '0',
672 `position_y` float NOT NULL default '0',
673 `position_z` float NOT NULL default '0',
674 `orientation` float NOT NULL default '0',
675 `zone` int(11) unsigned NOT NULL default '38' COMMENT 'Zone Identifier',
676 `map` int(11) unsigned NOT NULL default '0' COMMENT 'Map Identifier',
678 `time` bigint(20) unsigned NOT NULL default '0',
679 `corpse_type` tinyint(3) unsigned NOT NULL default '0',
680 `instance` int(11) unsigned NOT NULL default '0',
681 PRIMARY KEY (`guid`),
682 KEY `idx_type` (`corpse_type`),
683 KEY `instance` (`instance`)
684 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Death System';
687 -- Dumping data for table `corpse`
690 LOCK TABLES `corpse` WRITE;
691 /*!40000 ALTER TABLE `corpse` DISABLE KEYS */;
692 /*!40000 ALTER TABLE `corpse` ENABLE KEYS */;
696 -- Table structure for table `groups`
699 DROP TABLE IF EXISTS `groups`;
700 CREATE TABLE `groups` (
701 `leaderGuid` int(11) unsigned NOT NULL,
702 `mainTank` int(11) unsigned NOT NULL,
703 `mainAssistant` int(11) unsigned NOT NULL,
704 `lootMethod` tinyint(4) unsigned NOT NULL,
705 `looterGuid` int(11) unsigned NOT NULL,
706 `lootThreshold` tinyint(4) unsigned NOT NULL,
707 `icon1` int(11) unsigned NOT NULL,
708 `icon2` int(11) unsigned NOT NULL,
709 `icon3` int(11) unsigned NOT NULL,
710 `icon4` int(11) unsigned NOT NULL,
711 `icon5` int(11) unsigned NOT NULL,
712 `icon6` int(11) unsigned NOT NULL,
713 `icon7` int(11) unsigned NOT NULL,
714 `icon8` int(11) unsigned NOT NULL,
715 `isRaid` tinyint(1) unsigned NOT NULL,
716 `difficulty` tinyint(3) unsigned NOT NULL default '0',
717 PRIMARY KEY (`leaderGuid`)
718 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Groups';
721 -- Dumping data for table `groups`
724 LOCK TABLES `groups` WRITE;
725 /*!40000 ALTER TABLE `groups` DISABLE KEYS */;
726 /*!40000 ALTER TABLE `groups` ENABLE KEYS */;
729 -- ----------------------------
730 -- Table structure for group_instance
731 -- ----------------------------
732 DROP TABLE IF EXISTS `group_instance`;
733 CREATE TABLE `group_instance` (
734 `leaderGuid` int(11) unsigned NOT NULL default '0',
735 `instance` int(11) unsigned NOT NULL default '0',
736 `permanent` tinyint(1) unsigned NOT NULL default '0',
737 PRIMARY KEY (`leaderGuid`,`instance`),
738 KEY `instance` (`instance`)
739 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
742 -- Dumping data for table `group_instance`
745 LOCK TABLES `group_instance` WRITE;
746 /*!40000 ALTER TABLE `group_instance` DISABLE KEYS */;
747 /*!40000 ALTER TABLE `group_instance` ENABLE KEYS */;
751 -- Table structure for table `group_member`
754 DROP TABLE IF EXISTS `group_member`;
755 CREATE TABLE `group_member` (
756 `leaderGuid` int(11) unsigned NOT NULL,
757 `memberGuid` int(11) unsigned NOT NULL,
758 `assistant` tinyint(1) unsigned NOT NULL,
759 `subgroup` smallint(6) unsigned NOT NULL,
760 PRIMARY KEY (`leaderGuid`,`memberGuid`)
761 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Groups';
764 -- Dumping data for table `group_member`
767 LOCK TABLES `group_member` WRITE;
768 /*!40000 ALTER TABLE `group_member` DISABLE KEYS */;
769 /*!40000 ALTER TABLE `group_member` ENABLE KEYS */;
773 -- Table structure for table `guild`
776 DROP TABLE IF EXISTS `guild`;
777 CREATE TABLE `guild` (
778 `guildid` int(6) unsigned NOT NULL default '0',
779 `name` varchar(255) NOT NULL default '',
780 `leaderguid` int(6) unsigned NOT NULL default '0',
781 `EmblemStyle` int(5) NOT NULL default '0',
782 `EmblemColor` int(5) NOT NULL default '0',
783 `BorderStyle` int(5) NOT NULL default '0',
784 `BorderColor` int(5) NOT NULL default '0',
785 `BackgroundColor` int(5) NOT NULL default '0',
786 `info` text NOT NULL,
787 `motd` varchar(255) NOT NULL default '',
788 `createdate` datetime default NULL,
789 `BankMoney` bigint(20) NOT NULL default '0',
790 PRIMARY KEY (`guildid`)
791 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Guild System';
794 -- Dumping data for table `guild`
797 LOCK TABLES `guild` WRITE;
798 /*!40000 ALTER TABLE `guild` DISABLE KEYS */;
799 /*!40000 ALTER TABLE `guild` ENABLE KEYS */;
803 -- Table structure for table `guild_bank_eventlog`
806 DROP TABLE IF EXISTS `guild_bank_eventlog`;
807 CREATE TABLE `guild_bank_eventlog` (
808 `guildid` int(11) unsigned NOT NULL default '0',
809 `LogGuid` int(11) unsigned NOT NULL default '0',
810 `LogEntry` tinyint(1) unsigned NOT NULL default '0',
811 `TabId` tinyint(1) unsigned NOT NULL default '0',
812 `PlayerGuid` int(11) unsigned NOT NULL default '0',
813 `ItemOrMoney` int(11) unsigned NOT NULL default '0',
814 `ItemStackCount` tinyint(3) unsigned NOT NULL default '0',
815 `DestTabId` tinyint(1) unsigned NOT NULL default '0',
816 `TimeStamp` bigint(20) unsigned NOT NULL default '0',
817 PRIMARY KEY (`guildid`,`LogGuid`),
818 KEY `guildid_key` (`guildid`)
819 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
822 -- Dumping data for table `guild_bank_eventlog`
825 LOCK TABLES `guild_bank_eventlog` WRITE;
826 /*!40000 ALTER TABLE `guild_bank_eventlog` DISABLE KEYS */;
827 /*!40000 ALTER TABLE `guild_bank_eventlog` ENABLE KEYS */;
831 -- Table structure for table `guild_bank_item`
834 DROP TABLE IF EXISTS `guild_bank_item`;
835 CREATE TABLE `guild_bank_item` (
836 `guildid` int(11) unsigned NOT NULL default '0',
837 `TabId` tinyint(1) unsigned NOT NULL default '0',
838 `SlotId` tinyint(3) unsigned NOT NULL default '0',
839 `item_guid` int(11) unsigned NOT NULL default '0',
840 `item_entry` int(11) unsigned NOT NULL default '0',
841 PRIMARY KEY (`guildid`,`tabid`,`slotid`),
842 KEY `guildid_key` (`guildid`)
843 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
846 -- Dumping data for table `guild_bank_item`
849 LOCK TABLES `guild_bank_item` WRITE;
850 /*!40000 ALTER TABLE `guild_bank_item` DISABLE KEYS */;
851 /*!40000 ALTER TABLE `guild_bank_item` ENABLE KEYS */;
855 -- Table structure for table `guild_bank_right`
858 DROP TABLE IF EXISTS `guild_bank_right`;
859 CREATE TABLE `guild_bank_right` (
860 `guildid` int(11) unsigned NOT NULL default '0',
861 `TabId` tinyint(1) unsigned NOT NULL default '0',
862 `rid` int(11) unsigned NOT NULL default '0',
863 `gbright` tinyint(3) unsigned NOT NULL default '0',
864 `SlotPerDay` int(11) unsigned NOT NULL default '0',
865 PRIMARY KEY (`guildid`,`TabId`,`rid`),
866 KEY `guildid_key` (`guildid`)
867 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
870 -- Dumping data for table `guild_bank_right`
873 LOCK TABLES `guild_bank_right` WRITE;
874 /*!40000 ALTER TABLE `guild_bank_right` DISABLE KEYS */;
875 /*!40000 ALTER TABLE `guild_bank_right` ENABLE KEYS */;
879 -- Table structure for table `guild_bank_tab`
882 DROP TABLE IF EXISTS `guild_bank_tab`;
883 CREATE TABLE `guild_bank_tab` (
884 `guildid` int(11) unsigned NOT NULL default '0',
885 `TabId` tinyint(1) unsigned NOT NULL default '0',
886 `TabName` varchar(100) NOT NULL default '',
887 `TabIcon` varchar(100) NOT NULL default '',
889 PRIMARY KEY (`guildid`,`TabId`),
890 KEY `guildid_key` (`guildid`)
891 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
894 -- Dumping data for table `guild_bank_tab`
897 LOCK TABLES `guild_bank_tab` WRITE;
898 /*!40000 ALTER TABLE `guild_bank_tab` DISABLE KEYS */;
899 /*!40000 ALTER TABLE `guild_bank_tab` ENABLE KEYS */;
903 -- Table structure for table `guild_eventlog`
906 DROP TABLE IF EXISTS `guild_eventlog`;
907 CREATE TABLE `guild_eventlog` (
908 `guildid` int(11) NOT NULL COMMENT 'Guild Identificator',
909 `LogGuid` int(11) NOT NULL COMMENT 'Log entry identificator',
910 `EventType` tinyint(1) NOT NULL COMMENT 'Event type',
911 `PlayerGuid1` int(11) NOT NULL COMMENT 'Player 1',
912 `PlayerGuid2` int(11) NOT NULL COMMENT 'Player 2',
913 `NewRank` tinyint(2) NOT NULL COMMENT 'New rank(in case promotion/demotion)',
914 `TimeStamp` bigint(20) NOT NULL COMMENT 'Event UNIX time'
915 ) ENGINE = InnoDB DEFAULT CHARSET = latin1 COMMENT 'Guild Eventlog';
918 -- Dumping data for table `guild_eventlog`
921 LOCK TABLES `guild_eventlog` WRITE;
922 /*!40000 ALTER TABLE `guild_eventlog` DISABLE KEYS */;
923 /*!40000 ALTER TABLE `guild_eventlog` ENABLE KEYS */;
927 -- Table structure for table `guild_member`
930 DROP TABLE IF EXISTS `guild_member`;
931 CREATE TABLE `guild_member` (
932 `guildid` int(6) unsigned NOT NULL default '0',
933 `guid` int(11) unsigned NOT NULL default '0',
934 `rank` tinyint(2) unsigned NOT NULL default '0',
935 `pnote` varchar(255) NOT NULL default '',
936 `offnote` varchar(255) NOT NULL default '',
937 `BankResetTimeMoney` int(11) unsigned NOT NULL default '0',
938 `BankRemMoney` int(11) unsigned NOT NULL default '0',
939 `BankResetTimeTab0` int(11) unsigned NOT NULL default '0',
940 `BankRemSlotsTab0` int(11) unsigned NOT NULL default '0',
941 `BankResetTimeTab1` int(11) unsigned NOT NULL default '0',
942 `BankRemSlotsTab1` int(11) unsigned NOT NULL default '0',
943 `BankResetTimeTab2` int(11) unsigned NOT NULL default '0',
944 `BankRemSlotsTab2` int(11) unsigned NOT NULL default '0',
945 `BankResetTimeTab3` int(11) unsigned NOT NULL default '0',
946 `BankRemSlotsTab3` int(11) unsigned NOT NULL default '0',
947 `BankResetTimeTab4` int(11) unsigned NOT NULL default '0',
948 `BankRemSlotsTab4` int(11) unsigned NOT NULL default '0',
949 `BankResetTimeTab5` int(11) unsigned NOT NULL default '0',
950 `BankRemSlotsTab5` int(11) unsigned NOT NULL default '0',
951 KEY `guildid_key` (`guildid`),
952 KEY `guildid_rank_key` (`guildid`,`rank`),
953 UNIQUE KEY `guid_key` (`guid`)
954 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Guild System';
957 -- Dumping data for table `guild_member`
960 LOCK TABLES `guild_member` WRITE;
961 /*!40000 ALTER TABLE `guild_member` DISABLE KEYS */;
962 /*!40000 ALTER TABLE `guild_member` ENABLE KEYS */;
966 -- Table structure for table `guild_rank`
969 DROP TABLE IF EXISTS `guild_rank`;
970 CREATE TABLE `guild_rank` (
971 `guildid` int(6) unsigned NOT NULL default '0',
972 `rid` int(11) unsigned NOT NULL,
973 `rname` varchar(255) NOT NULL default '',
974 `rights` int(3) unsigned NOT NULL default '0',
975 `BankMoneyPerDay` int(11) unsigned NOT NULL default '0',
976 PRIMARY KEY (`guildid`,`rid`)
977 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Guild System';
980 -- Dumping data for table `guild_rank`
983 LOCK TABLES `guild_rank` WRITE;
984 /*!40000 ALTER TABLE `guild_rank` DISABLE KEYS */;
985 /*!40000 ALTER TABLE `guild_rank` ENABLE KEYS */;
989 -- Table structure for table `instance`
992 DROP TABLE IF EXISTS `instance`;
993 CREATE TABLE `instance` (
994 `id` int(11) unsigned NOT NULL default '0',
995 `map` int(11) unsigned NOT NULL default '0',
996 `resettime` bigint(40) NOT NULL default '0',
997 `difficulty` tinyint(1) unsigned NOT NULL default '0',
1001 KEY `resettime` (`resettime`)
1002 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1005 -- Dumping data for table `instance`
1008 LOCK TABLES `instance` WRITE;
1009 /*!40000 ALTER TABLE `instance` DISABLE KEYS */;
1010 /*!40000 ALTER TABLE `instance` ENABLE KEYS */;
1013 -- ----------------------------
1014 -- Table structure for instance_reset
1015 -- ----------------------------
1016 DROP TABLE IF EXISTS `instance_reset`;
1017 CREATE TABLE `instance_reset` (
1018 `mapid` int(11) unsigned NOT NULL default '0',
1019 `resettime` bigint(40) NOT NULL default '0',
1020 PRIMARY KEY (`mapid`)
1021 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1024 -- Dumping data for table `instance_reset`
1027 LOCK TABLES `instance_reset` WRITE;
1028 /*!40000 ALTER TABLE `instance_reset` DISABLE KEYS */;
1029 /*!40000 ALTER TABLE `instance_reset` ENABLE KEYS */;
1033 -- Table structure for table `item_instance`
1036 DROP TABLE IF EXISTS `item_instance`;
1037 CREATE TABLE `item_instance` (
1038 `guid` int(11) unsigned NOT NULL default '0',
1039 `owner_guid` int(11) unsigned NOT NULL default '0',
1041 PRIMARY KEY (`guid`),
1042 KEY `idx_owner_guid` (`owner_guid`)
1043 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Item System';
1046 -- Dumping data for table `item_instance`
1049 LOCK TABLES `item_instance` WRITE;
1050 /*!40000 ALTER TABLE `item_instance` DISABLE KEYS */;
1051 /*!40000 ALTER TABLE `item_instance` ENABLE KEYS */;
1055 -- Table structure for table `item_text`
1058 DROP TABLE IF EXISTS `item_text`;
1059 CREATE TABLE `item_text` (
1060 `id` int(11) unsigned NOT NULL default '0',
1063 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Item System';
1066 -- Dumping data for table `item_text`
1069 LOCK TABLES `item_text` WRITE;
1070 /*!40000 ALTER TABLE `item_text` DISABLE KEYS */;
1071 /*!40000 ALTER TABLE `item_text` ENABLE KEYS */;
1075 -- Table structure for table `mail`
1078 DROP TABLE IF EXISTS `mail`;
1079 CREATE TABLE `mail` (
1080 `id` int(11) unsigned NOT NULL default '0' COMMENT 'Identifier',
1081 `messageType` tinyint(3) unsigned NOT NULL default '0',
1082 `stationery` tinyint(3) NOT NULL default '41',
1083 `mailTemplateId` mediumint(8) unsigned NOT NULL default '0',
1084 `sender` int(11) unsigned NOT NULL default '0' COMMENT 'Character Global Unique Identifier',
1085 `receiver` int(11) unsigned NOT NULL default '0' COMMENT 'Character Global Unique Identifier',
1087 `itemTextId` int(11) unsigned NOT NULL default '0',
1088 `has_items` tinyint(3) unsigned NOT NULL default '0',
1089 `expire_time` bigint(40) NOT NULL default '0',
1090 `deliver_time` bigint(40) NOT NULL default '0',
1091 `money` int(11) unsigned NOT NULL default '0',
1092 `cod` int(11) unsigned NOT NULL default '0',
1093 `checked` tinyint(3) unsigned NOT NULL default '0',
1095 KEY `idx_receiver` (`receiver`)
1096 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Mail System';
1099 -- Dumping data for table `mail`
1102 LOCK TABLES `mail` WRITE;
1103 /*!40000 ALTER TABLE `mail` DISABLE KEYS */;
1104 /*!40000 ALTER TABLE `mail` ENABLE KEYS */;
1108 -- Table structure for table `mail_items`
1111 DROP TABLE IF EXISTS `mail_items`;
1112 CREATE TABLE `mail_items` (
1113 `mail_id` int(11) NOT NULL default '0',
1114 `item_guid` int(11) NOT NULL default '0',
1115 `item_template` int(11) NOT NULL default '0',
1116 `receiver` int(11) unsigned NOT NULL default '0' COMMENT 'Character Global Unique Identifier',
1117 PRIMARY KEY (`mail_id`,`item_guid`),
1118 KEY `idx_receiver` (`receiver`)
1119 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;
1122 -- Dumping data for table `mail_items`
1125 LOCK TABLES `mail_items` WRITE;
1126 /*!40000 ALTER TABLE `mail_items` DISABLE KEYS */;
1127 /*!40000 ALTER TABLE `mail_items` ENABLE KEYS */;
1131 -- Table structure for table `pet_aura`
1134 DROP TABLE IF EXISTS `pet_aura`;
1135 CREATE TABLE `pet_aura` (
1136 `guid` int(11) unsigned NOT NULL default '0' COMMENT 'Global Unique Identifier',
1137 `caster_guid` bigint(20) unsigned NOT NULL default '0' COMMENT 'Full Global Unique Identifier',
1138 `spell` int(11) unsigned NOT NULL default '0',
1139 `effect_index` int(11) unsigned NOT NULL default '0',
1140 `stackcount` int(11) NOT NULL default '1',
1141 `amount` int(11) NOT NULL default '0',
1142 `maxduration` int(11) NOT NULL default '0',
1143 `remaintime` int(11) NOT NULL default '0',
1144 `remaincharges` int(11) NOT NULL default '0',
1145 PRIMARY KEY (`guid`,`spell`,`effect_index`)
1146 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Pet System';
1149 -- Dumping data for table `pet_aura`
1152 LOCK TABLES `pet_aura` WRITE;
1153 /*!40000 ALTER TABLE `pet_aura` DISABLE KEYS */;
1154 /*!40000 ALTER TABLE `pet_aura` ENABLE KEYS */;
1158 -- Table structure for table `pet_spell`
1161 DROP TABLE IF EXISTS `pet_spell`;
1162 CREATE TABLE `pet_spell` (
1163 `guid` int(11) unsigned NOT NULL default '0' COMMENT 'Global Unique Identifier',
1164 `spell` int(11) unsigned NOT NULL default '0' COMMENT 'Spell Identifier',
1165 `slot` int(11) unsigned NOT NULL default '0',
1166 `active` int(11) unsigned NOT NULL default '0',
1167 PRIMARY KEY (`guid`,`spell`)
1168 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Pet System';
1171 -- Dumping data for table `pet_spell`
1174 LOCK TABLES `pet_spell` WRITE;
1175 /*!40000 ALTER TABLE `pet_spell` DISABLE KEYS */;
1176 /*!40000 ALTER TABLE `pet_spell` ENABLE KEYS */;
1180 -- Table structure for table `pet_spell_cooldown`
1183 DROP TABLE IF EXISTS `pet_spell_cooldown`;
1184 CREATE TABLE `pet_spell_cooldown` (
1185 `guid` int(11) unsigned NOT NULL default '0' COMMENT 'Global Unique Identifier, Low part',
1186 `spell` int(11) unsigned NOT NULL default '0' COMMENT 'Spell Identifier',
1187 `time` bigint(20) unsigned NOT NULL default '0',
1188 PRIMARY KEY (`guid`,`spell`)
1189 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1192 -- Dumping data for table `pet_spell_cooldown`
1195 LOCK TABLES `pet_spell_cooldown` WRITE;
1196 /*!40000 ALTER TABLE `pet_spell_cooldown` DISABLE KEYS */;
1197 /*!40000 ALTER TABLE `pet_spell_cooldown` ENABLE KEYS */;
1201 -- Table structure for table `petition`
1204 DROP TABLE IF EXISTS `petition`;
1205 CREATE TABLE `petition` (
1206 `ownerguid` int(10) unsigned NOT NULL,
1207 `petitionguid` int(10) unsigned default '0',
1208 `name` varchar(255) NOT NULL default '',
1209 `type` int(10) unsigned NOT NULL default '0',
1210 PRIMARY KEY (`ownerguid`,`type`),
1211 UNIQUE KEY `index_ownerguid_petitionguid` (`ownerguid`,`petitionguid`)
1212 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Guild System';
1215 -- Dumping data for table `petition`
1218 LOCK TABLES `petition` WRITE;
1219 /*!40000 ALTER TABLE `petition` DISABLE KEYS */;
1220 /*!40000 ALTER TABLE `petition` ENABLE KEYS */;
1224 -- Table structure for table `petition_sign`
1227 DROP TABLE IF EXISTS `petition_sign`;
1228 CREATE TABLE `petition_sign` (
1229 `ownerguid` int(10) unsigned NOT NULL,
1230 `petitionguid` int(11) unsigned NOT NULL default '0',
1231 `playerguid` int(11) unsigned NOT NULL default '0',
1232 `player_account` int(11) unsigned NOT NULL default '0',
1233 `type` int(10) unsigned NOT NULL default '0',
1234 PRIMARY KEY (`petitionguid`,`playerguid`)
1235 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Guild System';
1237 -- Dumping data for table `petition_sign`
1240 LOCK TABLES `petition_sign` WRITE;
1241 /*!40000 ALTER TABLE `petition_sign` DISABLE KEYS */;
1242 /*!40000 ALTER TABLE `petition_sign` ENABLE KEYS */;
1244 /*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
1246 /*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
1247 /*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
1248 /*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
1249 /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
1250 /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
1251 /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
1252 /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
1254 -- Dump completed on 2008-01-10 11:37:06