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_8104_01_characters` bit(1) default NULL
25 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Last applied sql update to DB';
28 -- Dumping data for table `character_db_version`
31 LOCK TABLES `character_db_version` WRITE;
32 /*!40000 ALTER TABLE `character_db_version` DISABLE KEYS */;
33 INSERT INTO `character_db_version` VALUES
35 /*!40000 ALTER TABLE `character_db_version` ENABLE KEYS */;
39 -- Table structure for table `account_data`
42 DROP TABLE IF EXISTS `account_data`;
43 CREATE TABLE `account_data` (
44 `account` int(11) unsigned NOT NULL default '0',
45 `type` int(11) unsigned NOT NULL default '0',
46 `time` bigint(11) unsigned NOT NULL default '0',
47 `data` longtext NOT NULL,
48 PRIMARY KEY (`account`,`type`)
49 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
52 -- Dumping data for table `account_data`
55 LOCK TABLES `account_data` WRITE;
56 /*!40000 ALTER TABLE `account_data` DISABLE KEYS */;
57 /*!40000 ALTER TABLE `account_data` ENABLE KEYS */;
61 -- Table structure for table `arena_team`
64 DROP TABLE IF EXISTS `arena_team`;
65 CREATE TABLE `arena_team` (
66 `arenateamid` int(10) unsigned NOT NULL default '0',
67 `name` char(255) NOT NULL,
68 `captainguid` int(10) unsigned NOT NULL default '0',
69 `type` tinyint(3) unsigned NOT NULL default '0',
70 `BackgroundColor` int(10) unsigned NOT NULL default '0',
71 `EmblemStyle` int(10) unsigned NOT NULL default '0',
72 `EmblemColor` int(10) unsigned NOT NULL default '0',
73 `BorderStyle` int(10) unsigned NOT NULL default '0',
74 `BorderColor` int(10) unsigned NOT NULL default '0',
75 PRIMARY KEY (`arenateamid`)
76 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
79 -- Dumping data for table `arena_team`
82 LOCK TABLES `arena_team` WRITE;
83 /*!40000 ALTER TABLE `arena_team` DISABLE KEYS */;
84 /*!40000 ALTER TABLE `arena_team` ENABLE KEYS */;
88 -- Table structure for table `arena_team_member`
91 DROP TABLE IF EXISTS `arena_team_member`;
92 CREATE TABLE `arena_team_member` (
93 `arenateamid` int(10) unsigned NOT NULL default '0',
94 `guid` int(10) unsigned NOT NULL default '0',
95 `played_week` int(10) unsigned NOT NULL default '0',
96 `wons_week` int(10) unsigned NOT NULL default '0',
97 `played_season` int(10) unsigned NOT NULL default '0',
98 `wons_season` int(10) unsigned NOT NULL default '0',
99 `personal_rating` int(10) UNSIGNED NOT NULL DEFAULT '0',
100 PRIMARY KEY (`arenateamid`,`guid`)
101 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
104 -- Dumping data for table `arena_team_member`
107 LOCK TABLES `arena_team_member` WRITE;
108 /*!40000 ALTER TABLE `arena_team_member` DISABLE KEYS */;
109 /*!40000 ALTER TABLE `arena_team_member` ENABLE KEYS */;
113 -- Table structure for table `arena_team_stats`
116 DROP TABLE IF EXISTS `arena_team_stats`;
117 CREATE TABLE `arena_team_stats` (
118 `arenateamid` int(10) unsigned NOT NULL default '0',
119 `rating` int(10) unsigned NOT NULL default '0',
120 `games` int(10) unsigned NOT NULL default '0',
121 `wins` int(10) unsigned NOT NULL default '0',
122 `played` int(10) unsigned NOT NULL default '0',
123 `wins2` int(10) unsigned NOT NULL default '0',
124 `rank` int(10) unsigned NOT NULL default '0',
125 PRIMARY KEY (`arenateamid`)
126 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
129 -- Dumping data for table `arena_team_stats`
132 LOCK TABLES `arena_team_stats` WRITE;
133 /*!40000 ALTER TABLE `arena_team_stats` DISABLE KEYS */;
134 /*!40000 ALTER TABLE `arena_team_stats` ENABLE KEYS */;
138 -- Table structure for table `auctionhouse`
141 DROP TABLE IF EXISTS `auctionhouse`;
142 CREATE TABLE `auctionhouse` (
143 `id` int(11) unsigned NOT NULL default '0',
144 `auctioneerguid` int(11) unsigned NOT NULL default '0',
145 `itemguid` int(11) unsigned NOT NULL default '0',
146 `item_template` int(11) unsigned NOT NULL default '0' COMMENT 'Item Identifier',
147 `itemowner` int(11) unsigned NOT NULL default '0',
148 `buyoutprice` int(11) NOT NULL default '0',
149 `time` bigint(40) NOT NULL default '0',
150 `buyguid` int(11) unsigned NOT NULL default '0',
151 `lastbid` int(11) NOT NULL default '0',
152 `startbid` int(11) NOT NULL default '0',
153 `deposit` int(11) NOT NULL default '0',
155 UNIQUE KEY `item_guid` (`itemguid`)
156 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
159 -- Dumping data for table `auctionhouse`
162 LOCK TABLES `auctionhouse` WRITE;
163 /*!40000 ALTER TABLE `auctionhouse` DISABLE KEYS */;
164 /*!40000 ALTER TABLE `auctionhouse` ENABLE KEYS */;
168 -- Table structure for table `bugreport`
171 DROP TABLE IF EXISTS `bugreport`;
172 CREATE TABLE `bugreport` (
173 `id` int(11) NOT NULL auto_increment COMMENT 'Identifier',
174 `type` varchar(255) NOT NULL default '',
175 `content` varchar(255) NOT NULL default '',
177 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Debug System';
180 -- Dumping data for table `bugreport`
183 LOCK TABLES `bugreport` WRITE;
184 /*!40000 ALTER TABLE `bugreport` DISABLE KEYS */;
185 /*!40000 ALTER TABLE `bugreport` ENABLE KEYS */;
189 -- Table structure for table `characters`
192 DROP TABLE IF EXISTS `characters`;
193 CREATE TABLE `characters` (
194 `guid` int(11) unsigned NOT NULL default '0' COMMENT 'Global Unique Identifier',
195 `account` int(11) unsigned NOT NULL default '0' COMMENT 'Account Identifier',
197 `name` varchar(12) NOT NULL default '',
198 `race` tinyint(3) unsigned NOT NULL default '0',
199 `class` tinyint(3) unsigned NOT NULL default '0',
200 `gender` TINYINT UNSIGNED NOT NULL default '0',
201 `level` TINYINT UNSIGNED NOT NULL default '0',
202 `xp` INT UNSIGNED NOT NULL default '0',
203 `money` INT UNSIGNED NOT NULL default '0',
204 `playerBytes` INT UNSIGNED NOT NULL default '0',
205 `playerBytes2` INT UNSIGNED NOT NULL default '0',
206 `playerFlags` INT UNSIGNED NOT NULL default '0',
207 `position_x` float NOT NULL default '0',
208 `position_y` float NOT NULL default '0',
209 `position_z` float NOT NULL default '0',
210 `map` int(11) unsigned NOT NULL default '0' COMMENT 'Map Identifier',
211 `dungeon_difficulty` tinyint(1) unsigned NOT NULL DEFAULT '0',
212 `orientation` float NOT NULL default '0',
214 `online` tinyint(3) unsigned NOT NULL default '0',
215 `cinematic` tinyint(3) unsigned NOT NULL default '0',
216 `totaltime` int(11) unsigned NOT NULL default '0',
217 `leveltime` int(11) unsigned NOT NULL default '0',
218 `logout_time` bigint(20) unsigned NOT NULL default '0',
219 `is_logout_resting` tinyint(3) unsigned NOT NULL default '0',
220 `rest_bonus` float NOT NULL default '0',
221 `resettalents_cost` int(11) unsigned NOT NULL default '0',
222 `resettalents_time` bigint(20) unsigned NOT NULL default '0',
223 `trans_x` float NOT NULL default '0',
224 `trans_y` float NOT NULL default '0',
225 `trans_z` float NOT NULL default '0',
226 `trans_o` float NOT NULL default '0',
227 `transguid` bigint(20) unsigned NOT NULL default '0',
228 `extra_flags` int(11) unsigned NOT NULL default '0',
229 `stable_slots` tinyint(1) unsigned NOT NULL default '0',
230 `at_login` int(11) unsigned NOT NULL default '0',
231 `zone` int(11) unsigned NOT NULL default '0',
232 `death_expire_time` bigint(20) unsigned NOT NULL default '0',
234 `arena_pending_points` int(10) UNSIGNED NOT NULL default '0',
235 `bgid` int(10) unsigned NOT NULL default '0',
236 `bgteam` int(10) unsigned NOT NULL default '0',
237 `bgmap` int(10) unsigned NOT NULL default '0',
238 `bgx` float NOT NULL default '0',
239 `bgy` float NOT NULL default '0',
240 `bgz` float NOT NULL default '0',
241 `bgo` float NOT NULL default '0',
242 PRIMARY KEY (`guid`),
243 KEY `idx_account` (`account`),
244 KEY `idx_online` (`online`),
245 KEY `idx_name` (`name`)
246 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Player System';
249 -- Dumping data for table `characters`
252 LOCK TABLES `characters` WRITE;
253 /*!40000 ALTER TABLE `characters` DISABLE KEYS */;
254 /*!40000 ALTER TABLE `characters` ENABLE KEYS */;
258 -- Table structure for table `character_achievement`
261 DROP TABLE IF EXISTS `character_achievement`;
262 CREATE TABLE `character_achievement` (
263 `guid` int(11) unsigned NOT NULL,
264 `achievement` int(11) unsigned NOT NULL,
265 `date` bigint(11) unsigned NOT NULL default '0',
266 PRIMARY KEY (`guid`,`achievement`)
267 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
270 -- Dumping data for table `character_achievement`
273 LOCK TABLES `character_achievement` WRITE;
274 /*!40000 ALTER TABLE `character_achievement` DISABLE KEYS */;
275 /*!40000 ALTER TABLE `character_achievement` ENABLE KEYS */;
279 -- Table structure for table `character_achievement_progress`
282 DROP TABLE IF EXISTS `character_achievement_progress`;
283 CREATE TABLE `character_achievement_progress` (
284 `guid` int(11) unsigned NOT NULL,
285 `criteria` int(11) unsigned NOT NULL,
286 `counter` int(11) unsigned NOT NULL,
287 `date` bigint(11) unsigned NOT NULL default '0',
288 PRIMARY KEY (`guid`,`criteria`)
289 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
292 -- Dumping data for table `character_achievement_progress`
295 LOCK TABLES `character_achievement_progress` WRITE;
296 /*!40000 ALTER TABLE `character_achievement_progress` DISABLE KEYS */;
297 /*!40000 ALTER TABLE `character_achievement_progress` ENABLE KEYS */;
301 -- Table structure for table `character_action`
304 DROP TABLE IF EXISTS `character_action`;
305 CREATE TABLE `character_action` (
306 `guid` int(11) unsigned NOT NULL default '0' COMMENT 'Global Unique Identifier',
307 `button` tinyint(3) unsigned NOT NULL default '0',
308 `action` int(11) unsigned NOT NULL default '0',
309 `type` tinyint(3) unsigned NOT NULL default '0',
310 PRIMARY KEY (`guid`,`button`)
311 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Player System';
314 -- Dumping data for table `character_action`
317 LOCK TABLES `character_action` WRITE;
318 /*!40000 ALTER TABLE `character_action` DISABLE KEYS */;
319 /*!40000 ALTER TABLE `character_action` ENABLE KEYS */;
323 -- Table structure for table `character_aura`
326 DROP TABLE IF EXISTS `character_aura`;
327 CREATE TABLE `character_aura` (
328 `guid` int(11) unsigned NOT NULL default '0' COMMENT 'Global Unique Identifier',
329 `caster_guid` bigint(20) unsigned NOT NULL default '0' COMMENT 'Full Global Unique Identifier',
330 `spell` int(11) unsigned NOT NULL default '0',
331 `effect_index` int(11) unsigned NOT NULL default '0',
332 `stackcount` int(11) NOT NULL default '1',
333 `amount` int(11) NOT NULL default '0',
334 `maxduration` int(11) NOT NULL default '0',
335 `remaintime` int(11) NOT NULL default '0',
336 `remaincharges` int(11) NOT NULL default '0',
337 PRIMARY KEY (`guid`,`spell`,`effect_index`)
338 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Player System';
341 -- Dumping data for table `character_aura`
344 LOCK TABLES `character_aura` WRITE;
345 /*!40000 ALTER TABLE `character_aura` DISABLE KEYS */;
346 /*!40000 ALTER TABLE `character_aura` ENABLE KEYS */;
350 -- Table structure for table `character_declinedname`
353 DROP TABLE IF EXISTS `character_declinedname`;
354 CREATE TABLE `character_declinedname` (
355 `guid` int(11) unsigned NOT NULL default '0' COMMENT 'Global Unique Identifier',
356 `genitive` varchar(15) NOT NULL default '',
357 `dative` varchar(15) NOT NULL default '',
358 `accusative` varchar(15) NOT NULL default '',
359 `instrumental` varchar(15) NOT NULL default '',
360 `prepositional` varchar(15) NOT NULL default '',
362 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;
365 -- Dumping data for table `character_declinedname`
368 LOCK TABLES `character_declinedname` WRITE;
369 /*!40000 ALTER TABLE `character_declinedname` DISABLE KEYS */;
370 /*!40000 ALTER TABLE `character_declinedname` ENABLE KEYS */;
374 -- Table structure for table `character_equipmentsets`
377 DROP TABLE IF EXISTS `character_equipmentsets`;
378 CREATE TABLE `character_equipmentsets` (
379 `guid` int(11) NOT NULL default '0',
380 `setguid` bigint(20) NOT NULL auto_increment,
381 `setindex` tinyint(4) NOT NULL default '0',
382 `name` varchar(100) NOT NULL,
383 `iconname` varchar(100) NOT NULL,
384 `item0` int(11) NOT NULL default '0',
385 `item1` int(11) NOT NULL default '0',
386 `item2` int(11) NOT NULL default '0',
387 `item3` int(11) NOT NULL default '0',
388 `item4` int(11) NOT NULL default '0',
389 `item5` int(11) NOT NULL default '0',
390 `item6` int(11) NOT NULL default '0',
391 `item7` int(11) NOT NULL default '0',
392 `item8` int(11) NOT NULL default '0',
393 `item9` int(11) NOT NULL default '0',
394 `item10` int(11) NOT NULL default '0',
395 `item11` int(11) NOT NULL default '0',
396 `item12` int(11) NOT NULL default '0',
397 `item13` int(11) NOT NULL default '0',
398 `item14` int(11) NOT NULL default '0',
399 `item15` int(11) NOT NULL default '0',
400 `item16` int(11) NOT NULL default '0',
401 `item17` int(11) NOT NULL default '0',
402 `item18` int(11) NOT NULL default '0',
403 PRIMARY KEY (`setguid`),
404 UNIQUE KEY `idx_set` (`guid`,`setguid`,`setindex`)
405 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
408 -- Dumping data for table `character_equipmentsets`
411 LOCK TABLES `character_equipmentsets` WRITE;
412 /*!40000 ALTER TABLE `character_equipmentsets` DISABLE KEYS */;
413 /*!40000 ALTER TABLE `character_equipmentsets` ENABLE KEYS */;
417 -- Table structure for table `character_gifts`
420 DROP TABLE IF EXISTS `character_gifts`;
421 CREATE TABLE `character_gifts` (
422 `guid` int(20) unsigned NOT NULL default '0',
423 `item_guid` int(11) unsigned NOT NULL default '0',
424 `entry` int(20) unsigned NOT NULL default '0',
425 `flags` int(20) unsigned NOT NULL default '0',
426 PRIMARY KEY (`item_guid`),
427 KEY `idx_guid` (`guid`)
428 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
431 -- Dumping data for table `character_gifts`
434 LOCK TABLES `character_gifts` WRITE;
435 /*!40000 ALTER TABLE `character_gifts` DISABLE KEYS */;
436 /*!40000 ALTER TABLE `character_gifts` ENABLE KEYS */;
440 -- Table structure for table `character_homebind`
443 DROP TABLE IF EXISTS `character_homebind`;
444 CREATE TABLE `character_homebind` (
445 `guid` int(11) unsigned NOT NULL default '0' COMMENT 'Global Unique Identifier',
446 `map` int(11) unsigned NOT NULL default '0' COMMENT 'Map Identifier',
447 `zone` int(11) unsigned NOT NULL default '0' COMMENT 'Zone Identifier',
448 `position_x` float NOT NULL default '0',
449 `position_y` float NOT NULL default '0',
450 `position_z` float NOT NULL default '0',
452 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Player System';
455 -- Dumping data for table `character_homebind`
458 LOCK TABLES `character_homebind` WRITE;
459 /*!40000 ALTER TABLE `character_homebind` DISABLE KEYS */;
460 /*!40000 ALTER TABLE `character_homebind` ENABLE KEYS */;
464 -- Table structure for table `character_instance`
467 DROP TABLE IF EXISTS `character_instance`;
468 CREATE TABLE `character_instance` (
469 `guid` int(11) unsigned NOT NULL default '0',
470 `instance` int(11) unsigned NOT NULL default '0',
471 `permanent` tinyint(1) unsigned NOT NULL default '0',
472 PRIMARY KEY (`guid`,`instance`),
473 KEY `instance` (`instance`)
474 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
477 -- Dumping data for table `character_instance`
480 LOCK TABLES `character_instance` WRITE;
481 /*!40000 ALTER TABLE `character_instance` DISABLE KEYS */;
482 /*!40000 ALTER TABLE `character_instance` ENABLE KEYS */;
486 -- Table structure for table `character_inventory`
489 DROP TABLE IF EXISTS `character_inventory`;
490 CREATE TABLE `character_inventory` (
491 `guid` int(11) unsigned NOT NULL default '0' COMMENT 'Global Unique Identifier',
492 `bag` int(11) unsigned NOT NULL default '0',
493 `slot` tinyint(3) unsigned NOT NULL default '0',
494 `item` int(11) unsigned NOT NULL default '0' COMMENT 'Item Global Unique Identifier',
495 `item_template` int(11) unsigned NOT NULL default '0' COMMENT 'Item Identifier',
496 PRIMARY KEY (`item`),
497 KEY `idx_guid` (`guid`)
498 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Player System';
501 -- Dumping data for table `character_inventory`
504 LOCK TABLES `character_inventory` WRITE;
505 /*!40000 ALTER TABLE `character_inventory` DISABLE KEYS */;
506 /*!40000 ALTER TABLE `character_inventory` ENABLE KEYS */;
510 -- Table structure for table `character_pet`
513 DROP TABLE IF EXISTS `character_pet`;
514 CREATE TABLE `character_pet` (
515 `id` int(11) unsigned NOT NULL default '0',
516 `entry` int(11) unsigned NOT NULL default '0',
517 `owner` int(11) unsigned NOT NULL default '0',
518 `modelid` int(11) unsigned default '0',
519 `CreatedBySpell` int(11) unsigned NOT NULL default '0',
520 `PetType` tinyint(3) unsigned NOT NULL default '0',
521 `level` int(11) unsigned NOT NULL default '1',
522 `exp` int(11) unsigned NOT NULL default '0',
523 `Reactstate` tinyint(1) unsigned NOT NULL default '0',
524 `name` varchar(100) default 'Pet',
525 `renamed` tinyint(1) unsigned NOT NULL default '0',
526 `slot` int(11) unsigned NOT NULL default '0',
527 `curhealth` int(11) unsigned NOT NULL default '1',
528 `curmana` int(11) unsigned NOT NULL default '0',
529 `curhappiness` int(11) unsigned NOT NULL default '0',
530 `savetime` bigint(20) unsigned NOT NULL default '0',
531 `resettalents_cost` int(11) unsigned NOT NULL default '0',
532 `resettalents_time` bigint(20) unsigned NOT NULL default '0',
535 KEY `owner` (`owner`)
536 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Pet System';
539 -- Dumping data for table `character_pet`
542 LOCK TABLES `character_pet` WRITE;
543 /*!40000 ALTER TABLE `character_pet` DISABLE KEYS */;
544 /*!40000 ALTER TABLE `character_pet` ENABLE KEYS */;
548 -- Table structure for table `character_pet_declinedname`
551 DROP TABLE IF EXISTS `character_pet_declinedname`;
552 CREATE TABLE `character_pet_declinedname` (
553 `id` int(11) unsigned NOT NULL default '0',
554 `owner` int(11) unsigned NOT NULL default '0',
555 `genitive` varchar(12) NOT NULL default '',
556 `dative` varchar(12) NOT NULL default '',
557 `accusative` varchar(12) NOT NULL default '',
558 `instrumental` varchar(12) NOT NULL default '',
559 `prepositional` varchar(12) NOT NULL default '',
561 KEY owner_key (`owner`)
562 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;
565 -- Dumping data for table `character_pet_declinedname`
568 LOCK TABLES `character_pet_declinedname` WRITE;
569 /*!40000 ALTER TABLE `character_pet_declinedname` DISABLE KEYS */;
570 /*!40000 ALTER TABLE `character_pet_declinedname` ENABLE KEYS */;
574 -- Table structure for table `character_queststatus`
577 DROP TABLE IF EXISTS `character_queststatus`;
578 CREATE TABLE `character_queststatus` (
579 `guid` int(11) unsigned NOT NULL default '0' COMMENT 'Global Unique Identifier',
580 `quest` int(11) unsigned NOT NULL default '0' COMMENT 'Quest Identifier',
581 `status` int(11) unsigned NOT NULL default '0',
582 `rewarded` tinyint(1) unsigned NOT NULL default '0',
583 `explored` tinyint(1) unsigned NOT NULL default '0',
584 `timer` bigint(20) unsigned NOT NULL default '0',
585 `mobcount1` int(11) unsigned NOT NULL default '0',
586 `mobcount2` int(11) unsigned NOT NULL default '0',
587 `mobcount3` int(11) unsigned NOT NULL default '0',
588 `mobcount4` int(11) unsigned NOT NULL default '0',
589 `itemcount1` int(11) unsigned NOT NULL default '0',
590 `itemcount2` int(11) unsigned NOT NULL default '0',
591 `itemcount3` int(11) unsigned NOT NULL default '0',
592 `itemcount4` int(11) unsigned NOT NULL default '0',
593 PRIMARY KEY (`guid`,`quest`)
594 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Player System';
597 -- Dumping data for table `character_queststatus`
600 LOCK TABLES `character_queststatus` WRITE;
601 /*!40000 ALTER TABLE `character_queststatus` DISABLE KEYS */;
602 /*!40000 ALTER TABLE `character_queststatus` ENABLE KEYS */;
606 -- Table structure for table `character_queststatus_daily`
609 DROP TABLE IF EXISTS `character_queststatus_daily`;
610 CREATE TABLE `character_queststatus_daily` (
611 `guid` int(11) unsigned NOT NULL default '0' COMMENT 'Global Unique Identifier',
612 `quest` int(11) unsigned NOT NULL default '0' COMMENT 'Quest Identifier',
613 `time` bigint(20) unsigned NOT NULL default '0',
614 PRIMARY KEY (`guid`,`quest`),
615 KEY `idx_guid` (`guid`)
616 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Player System';
619 -- Dumping data for table `character_queststatus_daily`
622 LOCK TABLES `character_queststatus_daily` WRITE;
623 /*!40000 ALTER TABLE `character_queststatus_daily` DISABLE KEYS */;
624 /*!40000 ALTER TABLE `character_queststatus_daily` ENABLE KEYS */;
628 -- Table structure for table `character_reputation`
631 DROP TABLE IF EXISTS `character_reputation`;
632 CREATE TABLE `character_reputation` (
633 `guid` int(11) unsigned NOT NULL default '0' COMMENT 'Global Unique Identifier',
634 `faction` int(11) unsigned NOT NULL default '0',
635 `standing` int(11) NOT NULL default '0',
636 `flags` int(11) NOT NULL default '0',
637 PRIMARY KEY (`guid`,`faction`)
638 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Player System';
641 -- Dumping data for table `character_reputation`
644 LOCK TABLES `character_reputation` WRITE;
645 /*!40000 ALTER TABLE `character_reputation` DISABLE KEYS */;
646 /*!40000 ALTER TABLE `character_reputation` ENABLE KEYS */;
650 -- Table structure for table `character_social`
653 DROP TABLE IF EXISTS `character_social`;
654 CREATE TABLE `character_social` (
655 `guid` int(11) unsigned NOT NULL default '0' COMMENT 'Character Global Unique Identifier',
656 `friend` int(11) unsigned NOT NULL default '0' COMMENT 'Friend Global Unique Identifier',
657 `flags` tinyint(1) unsigned NOT NULL default '0' COMMENT 'Friend Flags',
658 `note` varchar(48) NOT NULL DEFAULT '' COMMENT 'Friend Note',
659 PRIMARY KEY (`guid`,`friend`,`flags`),
661 KEY `friend` (`friend`),
662 KEY `guid_flags` (`guid`,`flags`),
663 KEY `friend_flags` (`friend`,`flags`)
664 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Player System';
667 -- Dumping data for table `character_social`
670 LOCK TABLES `character_social` WRITE;
671 /*!40000 ALTER TABLE `character_social` DISABLE KEYS */;
672 /*!40000 ALTER TABLE `character_social` ENABLE KEYS */;
676 -- Table structure for table `character_spell`
679 DROP TABLE IF EXISTS `character_spell`;
680 CREATE TABLE `character_spell` (
681 `guid` int(11) unsigned NOT NULL default '0' COMMENT 'Global Unique Identifier',
682 `spell` int(11) unsigned NOT NULL default '0' COMMENT 'Spell Identifier',
683 `active` tinyint(3) unsigned NOT NULL default '1',
684 `disabled` tinyint(3) unsigned NOT NULL default '0',
685 PRIMARY KEY (`guid`,`spell`)
686 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Player System';
689 -- Dumping data for table `character_spell`
692 LOCK TABLES `character_spell` WRITE;
693 /*!40000 ALTER TABLE `character_spell` DISABLE KEYS */;
694 /*!40000 ALTER TABLE `character_spell` ENABLE KEYS */;
698 -- Table structure for table `character_spell_cooldown`
701 DROP TABLE IF EXISTS `character_spell_cooldown`;
702 CREATE TABLE `character_spell_cooldown` (
703 `guid` int(11) unsigned NOT NULL default '0' COMMENT 'Global Unique Identifier, Low part',
704 `spell` int(11) unsigned NOT NULL default '0' COMMENT 'Spell Identifier',
705 `item` int(11) unsigned NOT NULL default '0' COMMENT 'Item Identifier',
706 `time` bigint(20) unsigned NOT NULL default '0',
707 PRIMARY KEY (`guid`,`spell`)
708 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
711 -- Dumping data for table `character_spell_cooldown`
714 LOCK TABLES `character_spell_cooldown` WRITE;
715 /*!40000 ALTER TABLE `character_spell_cooldown` DISABLE KEYS */;
716 /*!40000 ALTER TABLE `character_spell_cooldown` ENABLE KEYS */;
720 -- Table structure for table `character_ticket`
723 DROP TABLE IF EXISTS `character_ticket`;
724 CREATE TABLE `character_ticket` (
725 `ticket_id` int(11) unsigned NOT NULL auto_increment,
726 `guid` int(11) unsigned NOT NULL default '0',
728 `ticket_lastchange` TIMESTAMP ON UPDATE CURRENT_TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
729 PRIMARY KEY (`ticket_id`)
730 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Player System';
733 -- Dumping data for table `character_ticket`
736 LOCK TABLES `character_ticket` WRITE;
737 /*!40000 ALTER TABLE `character_ticket` DISABLE KEYS */;
738 /*!40000 ALTER TABLE `character_ticket` ENABLE KEYS */;
742 -- Table structure for table `character_tutorial`
745 DROP TABLE IF EXISTS `character_tutorial`;
746 CREATE TABLE `character_tutorial` (
747 `account` bigint(20) unsigned NOT NULL auto_increment COMMENT 'Account Identifier',
748 `realmid` int(11) unsigned NOT NULL default '0' COMMENT 'Realm Identifier',
749 `tut0` int(11) unsigned NOT NULL default '0',
750 `tut1` int(11) unsigned NOT NULL default '0',
751 `tut2` int(11) unsigned NOT NULL default '0',
752 `tut3` int(11) unsigned NOT NULL default '0',
753 `tut4` int(11) unsigned NOT NULL default '0',
754 `tut5` int(11) unsigned NOT NULL default '0',
755 `tut6` int(11) unsigned NOT NULL default '0',
756 `tut7` int(11) unsigned NOT NULL default '0',
757 PRIMARY KEY (`account`,`realmid`),
758 KEY acc_key (`account`)
759 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Player System';
762 -- Dumping data for table `character_tutorial`
765 LOCK TABLES `character_tutorial` WRITE;
766 /*!40000 ALTER TABLE `character_tutorial` DISABLE KEYS */;
767 /*!40000 ALTER TABLE `character_tutorial` ENABLE KEYS */;
771 -- Table structure for table `corpse`
774 DROP TABLE IF EXISTS `corpse`;
775 CREATE TABLE `corpse` (
776 `guid` int(11) unsigned NOT NULL default '0' COMMENT 'Global Unique Identifier',
777 `player` int(11) unsigned NOT NULL default '0' COMMENT 'Character Global Unique Identifier',
778 `position_x` float NOT NULL default '0',
779 `position_y` float NOT NULL default '0',
780 `position_z` float NOT NULL default '0',
781 `orientation` float NOT NULL default '0',
782 `zone` int(11) unsigned NOT NULL default '38' COMMENT 'Zone Identifier',
783 `map` int(11) unsigned NOT NULL default '0' COMMENT 'Map Identifier',
784 `phaseMask` smallint(5) unsigned NOT NULL default '1',
786 `time` bigint(20) unsigned NOT NULL default '0',
787 `corpse_type` tinyint(3) unsigned NOT NULL default '0',
788 `instance` int(11) unsigned NOT NULL default '0',
789 PRIMARY KEY (`guid`),
790 KEY `idx_type` (`corpse_type`),
791 KEY `instance` (`instance`)
792 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Death System';
795 -- Dumping data for table `corpse`
798 LOCK TABLES `corpse` WRITE;
799 /*!40000 ALTER TABLE `corpse` DISABLE KEYS */;
800 /*!40000 ALTER TABLE `corpse` ENABLE KEYS */;
804 -- Table structure for table `groups`
807 DROP TABLE IF EXISTS `groups`;
808 CREATE TABLE `groups` (
809 `leaderGuid` int(11) unsigned NOT NULL,
810 `mainTank` int(11) unsigned NOT NULL,
811 `mainAssistant` int(11) unsigned NOT NULL,
812 `lootMethod` tinyint(4) unsigned NOT NULL,
813 `looterGuid` int(11) unsigned NOT NULL,
814 `lootThreshold` tinyint(4) unsigned NOT NULL,
815 `icon1` int(11) unsigned NOT NULL,
816 `icon2` int(11) unsigned NOT NULL,
817 `icon3` int(11) unsigned NOT NULL,
818 `icon4` int(11) unsigned NOT NULL,
819 `icon5` int(11) unsigned NOT NULL,
820 `icon6` int(11) unsigned NOT NULL,
821 `icon7` int(11) unsigned NOT NULL,
822 `icon8` int(11) unsigned NOT NULL,
823 `isRaid` tinyint(1) unsigned NOT NULL,
824 `difficulty` tinyint(3) unsigned NOT NULL default '0',
825 PRIMARY KEY (`leaderGuid`)
826 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Groups';
829 -- Dumping data for table `groups`
832 LOCK TABLES `groups` WRITE;
833 /*!40000 ALTER TABLE `groups` DISABLE KEYS */;
834 /*!40000 ALTER TABLE `groups` ENABLE KEYS */;
837 -- ----------------------------
838 -- Table structure for group_instance
839 -- ----------------------------
840 DROP TABLE IF EXISTS `group_instance`;
841 CREATE TABLE `group_instance` (
842 `leaderGuid` int(11) unsigned NOT NULL default '0',
843 `instance` int(11) unsigned NOT NULL default '0',
844 `permanent` tinyint(1) unsigned NOT NULL default '0',
845 PRIMARY KEY (`leaderGuid`,`instance`),
846 KEY `instance` (`instance`)
847 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
850 -- Dumping data for table `group_instance`
853 LOCK TABLES `group_instance` WRITE;
854 /*!40000 ALTER TABLE `group_instance` DISABLE KEYS */;
855 /*!40000 ALTER TABLE `group_instance` ENABLE KEYS */;
859 -- Table structure for table `group_member`
862 DROP TABLE IF EXISTS `group_member`;
863 CREATE TABLE `group_member` (
864 `leaderGuid` int(11) unsigned NOT NULL,
865 `memberGuid` int(11) unsigned NOT NULL,
866 `assistant` tinyint(1) unsigned NOT NULL,
867 `subgroup` smallint(6) unsigned NOT NULL,
868 PRIMARY KEY (`leaderGuid`,`memberGuid`)
869 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Groups';
872 -- Dumping data for table `group_member`
875 LOCK TABLES `group_member` WRITE;
876 /*!40000 ALTER TABLE `group_member` DISABLE KEYS */;
877 /*!40000 ALTER TABLE `group_member` ENABLE KEYS */;
881 -- Table structure for table `guild`
884 DROP TABLE IF EXISTS `guild`;
885 CREATE TABLE `guild` (
886 `guildid` int(6) unsigned NOT NULL default '0',
887 `name` varchar(255) NOT NULL default '',
888 `leaderguid` int(6) unsigned NOT NULL default '0',
889 `EmblemStyle` int(5) NOT NULL default '0',
890 `EmblemColor` int(5) NOT NULL default '0',
891 `BorderStyle` int(5) NOT NULL default '0',
892 `BorderColor` int(5) NOT NULL default '0',
893 `BackgroundColor` int(5) NOT NULL default '0',
894 `info` text NOT NULL,
895 `motd` varchar(255) NOT NULL default '',
896 `createdate` datetime default NULL,
897 `BankMoney` bigint(20) NOT NULL default '0',
898 PRIMARY KEY (`guildid`)
899 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Guild System';
902 -- Dumping data for table `guild`
905 LOCK TABLES `guild` WRITE;
906 /*!40000 ALTER TABLE `guild` DISABLE KEYS */;
907 /*!40000 ALTER TABLE `guild` ENABLE KEYS */;
911 -- Table structure for table `guild_bank_eventlog`
914 DROP TABLE IF EXISTS `guild_bank_eventlog`;
915 CREATE TABLE `guild_bank_eventlog` (
916 `guildid` int(11) unsigned NOT NULL default '0',
917 `LogGuid` int(11) unsigned NOT NULL default '0',
918 `LogEntry` tinyint(1) unsigned NOT NULL default '0',
919 `TabId` tinyint(1) unsigned NOT NULL default '0',
920 `PlayerGuid` int(11) unsigned NOT NULL default '0',
921 `ItemOrMoney` int(11) unsigned NOT NULL default '0',
922 `ItemStackCount` tinyint(3) unsigned NOT NULL default '0',
923 `DestTabId` tinyint(1) unsigned NOT NULL default '0',
924 `TimeStamp` bigint(20) unsigned NOT NULL default '0',
925 PRIMARY KEY (`guildid`,`LogGuid`),
926 KEY `guildid_key` (`guildid`)
927 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
930 -- Dumping data for table `guild_bank_eventlog`
933 LOCK TABLES `guild_bank_eventlog` WRITE;
934 /*!40000 ALTER TABLE `guild_bank_eventlog` DISABLE KEYS */;
935 /*!40000 ALTER TABLE `guild_bank_eventlog` ENABLE KEYS */;
939 -- Table structure for table `guild_bank_item`
942 DROP TABLE IF EXISTS `guild_bank_item`;
943 CREATE TABLE `guild_bank_item` (
944 `guildid` int(11) unsigned NOT NULL default '0',
945 `TabId` tinyint(1) unsigned NOT NULL default '0',
946 `SlotId` tinyint(3) unsigned NOT NULL default '0',
947 `item_guid` int(11) unsigned NOT NULL default '0',
948 `item_entry` int(11) unsigned NOT NULL default '0',
949 PRIMARY KEY (`guildid`,`tabid`,`slotid`),
950 KEY `guildid_key` (`guildid`)
951 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
954 -- Dumping data for table `guild_bank_item`
957 LOCK TABLES `guild_bank_item` WRITE;
958 /*!40000 ALTER TABLE `guild_bank_item` DISABLE KEYS */;
959 /*!40000 ALTER TABLE `guild_bank_item` ENABLE KEYS */;
963 -- Table structure for table `guild_bank_right`
966 DROP TABLE IF EXISTS `guild_bank_right`;
967 CREATE TABLE `guild_bank_right` (
968 `guildid` int(11) unsigned NOT NULL default '0',
969 `TabId` tinyint(1) unsigned NOT NULL default '0',
970 `rid` int(11) unsigned NOT NULL default '0',
971 `gbright` tinyint(3) unsigned NOT NULL default '0',
972 `SlotPerDay` int(11) unsigned NOT NULL default '0',
973 PRIMARY KEY (`guildid`,`TabId`,`rid`),
974 KEY `guildid_key` (`guildid`)
975 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
978 -- Dumping data for table `guild_bank_right`
981 LOCK TABLES `guild_bank_right` WRITE;
982 /*!40000 ALTER TABLE `guild_bank_right` DISABLE KEYS */;
983 /*!40000 ALTER TABLE `guild_bank_right` ENABLE KEYS */;
987 -- Table structure for table `guild_bank_tab`
990 DROP TABLE IF EXISTS `guild_bank_tab`;
991 CREATE TABLE `guild_bank_tab` (
992 `guildid` int(11) unsigned NOT NULL default '0',
993 `TabId` tinyint(1) unsigned NOT NULL default '0',
994 `TabName` varchar(100) NOT NULL default '',
995 `TabIcon` varchar(100) NOT NULL default '',
997 PRIMARY KEY (`guildid`,`TabId`),
998 KEY `guildid_key` (`guildid`)
999 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1002 -- Dumping data for table `guild_bank_tab`
1005 LOCK TABLES `guild_bank_tab` WRITE;
1006 /*!40000 ALTER TABLE `guild_bank_tab` DISABLE KEYS */;
1007 /*!40000 ALTER TABLE `guild_bank_tab` ENABLE KEYS */;
1011 -- Table structure for table `guild_eventlog`
1014 DROP TABLE IF EXISTS `guild_eventlog`;
1015 CREATE TABLE `guild_eventlog` (
1016 `guildid` int(11) NOT NULL COMMENT 'Guild Identificator',
1017 `LogGuid` int(11) NOT NULL COMMENT 'Log entry identificator',
1018 `EventType` tinyint(1) NOT NULL COMMENT 'Event type',
1019 `PlayerGuid1` int(11) NOT NULL COMMENT 'Player 1',
1020 `PlayerGuid2` int(11) NOT NULL COMMENT 'Player 2',
1021 `NewRank` tinyint(2) NOT NULL COMMENT 'New rank(in case promotion/demotion)',
1022 `TimeStamp` bigint(20) NOT NULL COMMENT 'Event UNIX time'
1023 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT 'Guild Eventlog';
1026 -- Dumping data for table `guild_eventlog`
1029 LOCK TABLES `guild_eventlog` WRITE;
1030 /*!40000 ALTER TABLE `guild_eventlog` DISABLE KEYS */;
1031 /*!40000 ALTER TABLE `guild_eventlog` ENABLE KEYS */;
1035 -- Table structure for table `guild_member`
1038 DROP TABLE IF EXISTS `guild_member`;
1039 CREATE TABLE `guild_member` (
1040 `guildid` int(6) unsigned NOT NULL default '0',
1041 `guid` int(11) unsigned NOT NULL default '0',
1042 `rank` tinyint(2) unsigned NOT NULL default '0',
1043 `pnote` varchar(255) NOT NULL default '',
1044 `offnote` varchar(255) NOT NULL default '',
1045 `BankResetTimeMoney` int(11) unsigned NOT NULL default '0',
1046 `BankRemMoney` int(11) unsigned NOT NULL default '0',
1047 `BankResetTimeTab0` int(11) unsigned NOT NULL default '0',
1048 `BankRemSlotsTab0` int(11) unsigned NOT NULL default '0',
1049 `BankResetTimeTab1` int(11) unsigned NOT NULL default '0',
1050 `BankRemSlotsTab1` int(11) unsigned NOT NULL default '0',
1051 `BankResetTimeTab2` int(11) unsigned NOT NULL default '0',
1052 `BankRemSlotsTab2` int(11) unsigned NOT NULL default '0',
1053 `BankResetTimeTab3` int(11) unsigned NOT NULL default '0',
1054 `BankRemSlotsTab3` int(11) unsigned NOT NULL default '0',
1055 `BankResetTimeTab4` int(11) unsigned NOT NULL default '0',
1056 `BankRemSlotsTab4` int(11) unsigned NOT NULL default '0',
1057 `BankResetTimeTab5` int(11) unsigned NOT NULL default '0',
1058 `BankRemSlotsTab5` int(11) unsigned NOT NULL default '0',
1059 KEY `guildid_key` (`guildid`),
1060 KEY `guildid_rank_key` (`guildid`,`rank`),
1061 UNIQUE KEY `guid_key` (`guid`)
1062 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Guild System';
1065 -- Dumping data for table `guild_member`
1068 LOCK TABLES `guild_member` WRITE;
1069 /*!40000 ALTER TABLE `guild_member` DISABLE KEYS */;
1070 /*!40000 ALTER TABLE `guild_member` ENABLE KEYS */;
1074 -- Table structure for table `guild_rank`
1077 DROP TABLE IF EXISTS `guild_rank`;
1078 CREATE TABLE `guild_rank` (
1079 `guildid` int(6) unsigned NOT NULL default '0',
1080 `rid` int(11) unsigned NOT NULL,
1081 `rname` varchar(255) NOT NULL default '',
1082 `rights` int(3) unsigned NOT NULL default '0',
1083 `BankMoneyPerDay` int(11) unsigned NOT NULL default '0',
1084 PRIMARY KEY (`guildid`,`rid`)
1085 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Guild System';
1088 -- Dumping data for table `guild_rank`
1091 LOCK TABLES `guild_rank` WRITE;
1092 /*!40000 ALTER TABLE `guild_rank` DISABLE KEYS */;
1093 /*!40000 ALTER TABLE `guild_rank` ENABLE KEYS */;
1097 -- Table structure for table `instance`
1100 DROP TABLE IF EXISTS `instance`;
1101 CREATE TABLE `instance` (
1102 `id` int(11) unsigned NOT NULL default '0',
1103 `map` int(11) unsigned NOT NULL default '0',
1104 `resettime` bigint(40) NOT NULL default '0',
1105 `difficulty` tinyint(1) unsigned NOT NULL default '0',
1109 KEY `resettime` (`resettime`)
1110 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1113 -- Dumping data for table `instance`
1116 LOCK TABLES `instance` WRITE;
1117 /*!40000 ALTER TABLE `instance` DISABLE KEYS */;
1118 /*!40000 ALTER TABLE `instance` ENABLE KEYS */;
1121 -- ----------------------------
1122 -- Table structure for instance_reset
1123 -- ----------------------------
1124 DROP TABLE IF EXISTS `instance_reset`;
1125 CREATE TABLE `instance_reset` (
1126 `mapid` int(11) unsigned NOT NULL default '0',
1127 `resettime` bigint(40) NOT NULL default '0',
1128 PRIMARY KEY (`mapid`)
1129 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1132 -- Dumping data for table `instance_reset`
1135 LOCK TABLES `instance_reset` WRITE;
1136 /*!40000 ALTER TABLE `instance_reset` DISABLE KEYS */;
1137 /*!40000 ALTER TABLE `instance_reset` ENABLE KEYS */;
1141 -- Table structure for table `item_instance`
1144 DROP TABLE IF EXISTS `item_instance`;
1145 CREATE TABLE `item_instance` (
1146 `guid` int(11) unsigned NOT NULL default '0',
1147 `owner_guid` int(11) unsigned NOT NULL default '0',
1149 PRIMARY KEY (`guid`),
1150 KEY `idx_owner_guid` (`owner_guid`)
1151 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Item System';
1154 -- Dumping data for table `item_instance`
1157 LOCK TABLES `item_instance` WRITE;
1158 /*!40000 ALTER TABLE `item_instance` DISABLE KEYS */;
1159 /*!40000 ALTER TABLE `item_instance` ENABLE KEYS */;
1163 -- Table structure for table `item_text`
1166 DROP TABLE IF EXISTS `item_text`;
1167 CREATE TABLE `item_text` (
1168 `id` int(11) unsigned NOT NULL default '0',
1171 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Item System';
1174 -- Dumping data for table `item_text`
1177 LOCK TABLES `item_text` WRITE;
1178 /*!40000 ALTER TABLE `item_text` DISABLE KEYS */;
1179 /*!40000 ALTER TABLE `item_text` ENABLE KEYS */;
1183 -- Table structure for table `mail`
1186 DROP TABLE IF EXISTS `mail`;
1187 CREATE TABLE `mail` (
1188 `id` int(11) unsigned NOT NULL default '0' COMMENT 'Identifier',
1189 `messageType` tinyint(3) unsigned NOT NULL default '0',
1190 `stationery` tinyint(3) NOT NULL default '41',
1191 `mailTemplateId` mediumint(8) unsigned NOT NULL default '0',
1192 `sender` int(11) unsigned NOT NULL default '0' COMMENT 'Character Global Unique Identifier',
1193 `receiver` int(11) unsigned NOT NULL default '0' COMMENT 'Character Global Unique Identifier',
1195 `itemTextId` int(11) unsigned NOT NULL default '0',
1196 `has_items` tinyint(3) unsigned NOT NULL default '0',
1197 `expire_time` bigint(40) NOT NULL default '0',
1198 `deliver_time` bigint(40) NOT NULL default '0',
1199 `money` int(11) unsigned NOT NULL default '0',
1200 `cod` int(11) unsigned NOT NULL default '0',
1201 `checked` tinyint(3) unsigned NOT NULL default '0',
1203 KEY `idx_receiver` (`receiver`)
1204 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Mail System';
1207 -- Dumping data for table `mail`
1210 LOCK TABLES `mail` WRITE;
1211 /*!40000 ALTER TABLE `mail` DISABLE KEYS */;
1212 /*!40000 ALTER TABLE `mail` ENABLE KEYS */;
1216 -- Table structure for table `mail_items`
1219 DROP TABLE IF EXISTS `mail_items`;
1220 CREATE TABLE `mail_items` (
1221 `mail_id` int(11) NOT NULL default '0',
1222 `item_guid` int(11) NOT NULL default '0',
1223 `item_template` int(11) NOT NULL default '0',
1224 `receiver` int(11) unsigned NOT NULL default '0' COMMENT 'Character Global Unique Identifier',
1225 PRIMARY KEY (`mail_id`,`item_guid`),
1226 KEY `idx_receiver` (`receiver`)
1227 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;
1230 -- Dumping data for table `mail_items`
1233 LOCK TABLES `mail_items` WRITE;
1234 /*!40000 ALTER TABLE `mail_items` DISABLE KEYS */;
1235 /*!40000 ALTER TABLE `mail_items` ENABLE KEYS */;
1239 -- Table structure for table `pet_aura`
1242 DROP TABLE IF EXISTS `pet_aura`;
1243 CREATE TABLE `pet_aura` (
1244 `guid` int(11) unsigned NOT NULL default '0' COMMENT 'Global Unique Identifier',
1245 `caster_guid` bigint(20) unsigned NOT NULL default '0' COMMENT 'Full Global Unique Identifier',
1246 `spell` int(11) unsigned NOT NULL default '0',
1247 `effect_index` int(11) unsigned NOT NULL default '0',
1248 `stackcount` int(11) NOT NULL default '1',
1249 `amount` int(11) NOT NULL default '0',
1250 `maxduration` int(11) NOT NULL default '0',
1251 `remaintime` int(11) NOT NULL default '0',
1252 `remaincharges` int(11) NOT NULL default '0',
1253 PRIMARY KEY (`guid`,`spell`,`effect_index`)
1254 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Pet System';
1257 -- Dumping data for table `pet_aura`
1260 LOCK TABLES `pet_aura` WRITE;
1261 /*!40000 ALTER TABLE `pet_aura` DISABLE KEYS */;
1262 /*!40000 ALTER TABLE `pet_aura` ENABLE KEYS */;
1266 -- Table structure for table `pet_spell`
1269 DROP TABLE IF EXISTS `pet_spell`;
1270 CREATE TABLE `pet_spell` (
1271 `guid` int(11) unsigned NOT NULL default '0' COMMENT 'Global Unique Identifier',
1272 `spell` int(11) unsigned NOT NULL default '0' COMMENT 'Spell Identifier',
1273 `active` int(11) unsigned NOT NULL default '0',
1274 PRIMARY KEY (`guid`,`spell`)
1275 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Pet System';
1278 -- Dumping data for table `pet_spell`
1281 LOCK TABLES `pet_spell` WRITE;
1282 /*!40000 ALTER TABLE `pet_spell` DISABLE KEYS */;
1283 /*!40000 ALTER TABLE `pet_spell` ENABLE KEYS */;
1287 -- Table structure for table `pet_spell_cooldown`
1290 DROP TABLE IF EXISTS `pet_spell_cooldown`;
1291 CREATE TABLE `pet_spell_cooldown` (
1292 `guid` int(11) unsigned NOT NULL default '0' COMMENT 'Global Unique Identifier, Low part',
1293 `spell` int(11) unsigned NOT NULL default '0' COMMENT 'Spell Identifier',
1294 `time` bigint(20) unsigned NOT NULL default '0',
1295 PRIMARY KEY (`guid`,`spell`)
1296 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1299 -- Dumping data for table `pet_spell_cooldown`
1302 LOCK TABLES `pet_spell_cooldown` WRITE;
1303 /*!40000 ALTER TABLE `pet_spell_cooldown` DISABLE KEYS */;
1304 /*!40000 ALTER TABLE `pet_spell_cooldown` ENABLE KEYS */;
1308 -- Table structure for table `petition`
1311 DROP TABLE IF EXISTS `petition`;
1312 CREATE TABLE `petition` (
1313 `ownerguid` int(10) unsigned NOT NULL,
1314 `petitionguid` int(10) unsigned default '0',
1315 `name` varchar(255) NOT NULL default '',
1316 `type` int(10) unsigned NOT NULL default '0',
1317 PRIMARY KEY (`ownerguid`,`type`),
1318 UNIQUE KEY `index_ownerguid_petitionguid` (`ownerguid`,`petitionguid`)
1319 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Guild System';
1322 -- Dumping data for table `petition`
1325 LOCK TABLES `petition` WRITE;
1326 /*!40000 ALTER TABLE `petition` DISABLE KEYS */;
1327 /*!40000 ALTER TABLE `petition` ENABLE KEYS */;
1331 -- Table structure for table `petition_sign`
1334 DROP TABLE IF EXISTS `petition_sign`;
1335 CREATE TABLE `petition_sign` (
1336 `ownerguid` int(10) unsigned NOT NULL,
1337 `petitionguid` int(11) unsigned NOT NULL default '0',
1338 `playerguid` int(11) unsigned NOT NULL default '0',
1339 `player_account` int(11) unsigned NOT NULL default '0',
1340 `type` int(10) unsigned NOT NULL default '0',
1341 PRIMARY KEY (`petitionguid`,`playerguid`)
1342 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Guild System';
1345 -- Dumping data for table `petition_sign`
1348 LOCK TABLES `petition_sign` WRITE;
1349 /*!40000 ALTER TABLE `petition_sign` DISABLE KEYS */;
1350 /*!40000 ALTER TABLE `petition_sign` ENABLE KEYS */;
1352 /*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
1355 -- Table structure for table `saved_variables`
1358 DROP TABLE IF EXISTS `saved_variables`;
1359 CREATE TABLE `saved_variables` (
1360 `NextArenaPointDistributionTime` bigint(40) UNSIGNED NOT NULL DEFAULT '0'
1361 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Variable Saves';
1364 -- Dumping data for table `saved_variables`
1367 LOCK TABLES `saved_variables` WRITE;
1368 /*!40000 ALTER TABLE `saved_variables` DISABLE KEYS */;
1369 /*!40000 ALTER TABLE `saved_variables` ENABLE KEYS */;
1371 /*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
1374 /*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
1375 /*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
1376 /*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
1377 /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
1378 /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
1379 /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
1380 /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
1382 -- Dump completed on 2008-01-10 11:37:06