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_8469_01_characters_character_spell` 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 PRIMARY KEY (`guid`),
236 KEY `idx_account` (`account`),
237 KEY `idx_online` (`online`),
238 KEY `idx_name` (`name`)
239 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Player System';
242 -- Dumping data for table `characters`
245 LOCK TABLES `characters` WRITE;
246 /*!40000 ALTER TABLE `characters` DISABLE KEYS */;
247 /*!40000 ALTER TABLE `characters` ENABLE KEYS */;
251 -- Table structure for table `character_account_data`
254 DROP TABLE IF EXISTS `character_account_data`;
255 CREATE TABLE `character_account_data` (
256 `guid` int(11) unsigned NOT NULL default '0',
257 `type` int(11) unsigned NOT NULL default '0',
258 `time` bigint(11) unsigned NOT NULL default '0',
259 `data` longtext NOT NULL,
260 PRIMARY KEY (`guid`,`type`)
261 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
264 -- Dumping data for table `character_account_data`
267 LOCK TABLES `character_account_data` WRITE;
268 /*!40000 ALTER TABLE `character_account_data` DISABLE KEYS */;
269 /*!40000 ALTER TABLE `character_account_data` ENABLE KEYS */;
273 -- Table structure for table `character_achievement`
276 DROP TABLE IF EXISTS `character_achievement`;
277 CREATE TABLE `character_achievement` (
278 `guid` int(11) unsigned NOT NULL,
279 `achievement` int(11) unsigned NOT NULL,
280 `date` bigint(11) unsigned NOT NULL default '0',
281 PRIMARY KEY (`guid`,`achievement`)
282 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
285 -- Dumping data for table `character_achievement`
288 LOCK TABLES `character_achievement` WRITE;
289 /*!40000 ALTER TABLE `character_achievement` DISABLE KEYS */;
290 /*!40000 ALTER TABLE `character_achievement` ENABLE KEYS */;
294 -- Table structure for table `character_achievement_progress`
297 DROP TABLE IF EXISTS `character_achievement_progress`;
298 CREATE TABLE `character_achievement_progress` (
299 `guid` int(11) unsigned NOT NULL,
300 `criteria` int(11) unsigned NOT NULL,
301 `counter` int(11) unsigned NOT NULL,
302 `date` bigint(11) unsigned NOT NULL default '0',
303 PRIMARY KEY (`guid`,`criteria`)
304 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
307 -- Dumping data for table `character_achievement_progress`
310 LOCK TABLES `character_achievement_progress` WRITE;
311 /*!40000 ALTER TABLE `character_achievement_progress` DISABLE KEYS */;
312 /*!40000 ALTER TABLE `character_achievement_progress` ENABLE KEYS */;
316 -- Table structure for table `character_action`
319 DROP TABLE IF EXISTS `character_action`;
320 CREATE TABLE `character_action` (
321 `guid` int(11) unsigned NOT NULL default '0' COMMENT 'Global Unique Identifier',
322 `button` tinyint(3) unsigned NOT NULL default '0',
323 `action` int(11) unsigned NOT NULL default '0',
324 `type` tinyint(3) unsigned NOT NULL default '0',
325 PRIMARY KEY (`guid`,`button`)
326 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Player System';
329 -- Dumping data for table `character_action`
332 LOCK TABLES `character_action` WRITE;
333 /*!40000 ALTER TABLE `character_action` DISABLE KEYS */;
334 /*!40000 ALTER TABLE `character_action` ENABLE KEYS */;
338 -- Table structure for table `character_aura`
341 DROP TABLE IF EXISTS `character_aura`;
342 CREATE TABLE `character_aura` (
343 `guid` int(11) unsigned NOT NULL default '0' COMMENT 'Global Unique Identifier',
344 `caster_guid` bigint(20) unsigned NOT NULL default '0' COMMENT 'Full Global Unique Identifier',
345 `spell` int(11) unsigned NOT NULL default '0',
346 `effect_index` int(11) unsigned NOT NULL default '0',
347 `stackcount` int(11) NOT NULL default '1',
348 `amount` int(11) NOT NULL default '0',
349 `maxduration` int(11) NOT NULL default '0',
350 `remaintime` int(11) NOT NULL default '0',
351 `remaincharges` int(11) NOT NULL default '0',
352 PRIMARY KEY (`guid`,`spell`,`effect_index`)
353 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Player System';
356 -- Dumping data for table `character_aura`
359 LOCK TABLES `character_aura` WRITE;
360 /*!40000 ALTER TABLE `character_aura` DISABLE KEYS */;
361 /*!40000 ALTER TABLE `character_aura` ENABLE KEYS */;
365 -- Table structure for table `character_battleground_data`
368 DROP TABLE IF EXISTS `character_battleground_data`;
369 CREATE TABLE `character_battleground_data` (
370 `guid` int(11) unsigned NOT NULL default '0' COMMENT 'Global Unique Identifier',
371 `instance_id` int(11) unsigned NOT NULL default '0',
372 `team` int(11) unsigned NOT NULL default '0',
373 `join_x` float NOT NULL default '0',
374 `join_y` float NOT NULL default '0',
375 `join_z` float NOT NULL default '0',
376 `join_o` float NOT NULL default '0',
377 `join_map` int(11) NOT NULL default '0',
378 `taxi_start` int(11) NOT NULL default '0',
379 `taxi_end` int(11) NOT NULL default '0',
380 `mount_spell` int(11) NOT NULL default '0',
382 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Player System';
385 -- Dumping data for table `character_battleground_data`
388 LOCK TABLES `character_battleground_data` WRITE;
389 /*!40000 ALTER TABLE `character_battleground_data` DISABLE KEYS */;
390 /*!40000 ALTER TABLE `character_battleground_data` ENABLE KEYS */;
394 -- Table structure for table `character_declinedname`
397 DROP TABLE IF EXISTS `character_declinedname`;
398 CREATE TABLE `character_declinedname` (
399 `guid` int(11) unsigned NOT NULL default '0' COMMENT 'Global Unique Identifier',
400 `genitive` varchar(15) NOT NULL default '',
401 `dative` varchar(15) NOT NULL default '',
402 `accusative` varchar(15) NOT NULL default '',
403 `instrumental` varchar(15) NOT NULL default '',
404 `prepositional` varchar(15) NOT NULL default '',
406 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;
409 -- Dumping data for table `character_declinedname`
412 LOCK TABLES `character_declinedname` WRITE;
413 /*!40000 ALTER TABLE `character_declinedname` DISABLE KEYS */;
414 /*!40000 ALTER TABLE `character_declinedname` ENABLE KEYS */;
418 -- Table structure for table `character_equipmentsets`
421 DROP TABLE IF EXISTS `character_equipmentsets`;
422 CREATE TABLE `character_equipmentsets` (
423 `guid` int(11) NOT NULL default '0',
424 `setguid` bigint(20) NOT NULL auto_increment,
425 `setindex` tinyint(4) NOT NULL default '0',
426 `name` varchar(100) NOT NULL,
427 `iconname` varchar(100) NOT NULL,
428 `item0` int(11) NOT NULL default '0',
429 `item1` int(11) NOT NULL default '0',
430 `item2` int(11) NOT NULL default '0',
431 `item3` int(11) NOT NULL default '0',
432 `item4` int(11) NOT NULL default '0',
433 `item5` int(11) NOT NULL default '0',
434 `item6` int(11) NOT NULL default '0',
435 `item7` int(11) NOT NULL default '0',
436 `item8` int(11) NOT NULL default '0',
437 `item9` int(11) NOT NULL default '0',
438 `item10` int(11) NOT NULL default '0',
439 `item11` int(11) NOT NULL default '0',
440 `item12` int(11) NOT NULL default '0',
441 `item13` int(11) NOT NULL default '0',
442 `item14` int(11) NOT NULL default '0',
443 `item15` int(11) NOT NULL default '0',
444 `item16` int(11) NOT NULL default '0',
445 `item17` int(11) NOT NULL default '0',
446 `item18` int(11) NOT NULL default '0',
447 PRIMARY KEY (`setguid`),
448 UNIQUE KEY `idx_set` (`guid`,`setguid`,`setindex`)
449 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
452 -- Dumping data for table `character_equipmentsets`
455 LOCK TABLES `character_equipmentsets` WRITE;
456 /*!40000 ALTER TABLE `character_equipmentsets` DISABLE KEYS */;
457 /*!40000 ALTER TABLE `character_equipmentsets` ENABLE KEYS */;
461 -- Table structure for table `character_gifts`
464 DROP TABLE IF EXISTS `character_gifts`;
465 CREATE TABLE `character_gifts` (
466 `guid` int(20) unsigned NOT NULL default '0',
467 `item_guid` int(11) unsigned NOT NULL default '0',
468 `entry` int(20) unsigned NOT NULL default '0',
469 `flags` int(20) unsigned NOT NULL default '0',
470 PRIMARY KEY (`item_guid`),
471 KEY `idx_guid` (`guid`)
472 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
475 -- Dumping data for table `character_gifts`
478 LOCK TABLES `character_gifts` WRITE;
479 /*!40000 ALTER TABLE `character_gifts` DISABLE KEYS */;
480 /*!40000 ALTER TABLE `character_gifts` ENABLE KEYS */;
484 -- Table structure for table `character_homebind`
487 DROP TABLE IF EXISTS `character_homebind`;
488 CREATE TABLE `character_homebind` (
489 `guid` int(11) unsigned NOT NULL default '0' COMMENT 'Global Unique Identifier',
490 `map` int(11) unsigned NOT NULL default '0' COMMENT 'Map Identifier',
491 `zone` int(11) unsigned NOT NULL default '0' COMMENT 'Zone Identifier',
492 `position_x` float NOT NULL default '0',
493 `position_y` float NOT NULL default '0',
494 `position_z` float NOT NULL default '0',
496 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Player System';
499 -- Dumping data for table `character_homebind`
502 LOCK TABLES `character_homebind` WRITE;
503 /*!40000 ALTER TABLE `character_homebind` DISABLE KEYS */;
504 /*!40000 ALTER TABLE `character_homebind` ENABLE KEYS */;
508 -- Table structure for table `character_instance`
511 DROP TABLE IF EXISTS `character_instance`;
512 CREATE TABLE `character_instance` (
513 `guid` int(11) unsigned NOT NULL default '0',
514 `instance` int(11) unsigned NOT NULL default '0',
515 `permanent` tinyint(1) unsigned NOT NULL default '0',
516 PRIMARY KEY (`guid`,`instance`),
517 KEY `instance` (`instance`)
518 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
521 -- Dumping data for table `character_instance`
524 LOCK TABLES `character_instance` WRITE;
525 /*!40000 ALTER TABLE `character_instance` DISABLE KEYS */;
526 /*!40000 ALTER TABLE `character_instance` ENABLE KEYS */;
530 -- Table structure for table `character_inventory`
533 DROP TABLE IF EXISTS `character_inventory`;
534 CREATE TABLE `character_inventory` (
535 `guid` int(11) unsigned NOT NULL default '0' COMMENT 'Global Unique Identifier',
536 `bag` int(11) unsigned NOT NULL default '0',
537 `slot` tinyint(3) unsigned NOT NULL default '0',
538 `item` int(11) unsigned NOT NULL default '0' COMMENT 'Item Global Unique Identifier',
539 `item_template` int(11) unsigned NOT NULL default '0' COMMENT 'Item Identifier',
540 PRIMARY KEY (`item`),
541 KEY `idx_guid` (`guid`)
542 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Player System';
545 -- Dumping data for table `character_inventory`
548 LOCK TABLES `character_inventory` WRITE;
549 /*!40000 ALTER TABLE `character_inventory` DISABLE KEYS */;
550 /*!40000 ALTER TABLE `character_inventory` ENABLE KEYS */;
554 -- Table structure for table `character_pet`
557 DROP TABLE IF EXISTS `character_pet`;
558 CREATE TABLE `character_pet` (
559 `id` int(11) unsigned NOT NULL default '0',
560 `entry` int(11) unsigned NOT NULL default '0',
561 `owner` int(11) unsigned NOT NULL default '0',
562 `modelid` int(11) unsigned default '0',
563 `CreatedBySpell` int(11) unsigned NOT NULL default '0',
564 `PetType` tinyint(3) unsigned NOT NULL default '0',
565 `level` int(11) unsigned NOT NULL default '1',
566 `exp` int(11) unsigned NOT NULL default '0',
567 `Reactstate` tinyint(1) unsigned NOT NULL default '0',
568 `name` varchar(100) default 'Pet',
569 `renamed` tinyint(1) unsigned NOT NULL default '0',
570 `slot` int(11) unsigned NOT NULL default '0',
571 `curhealth` int(11) unsigned NOT NULL default '1',
572 `curmana` int(11) unsigned NOT NULL default '0',
573 `curhappiness` int(11) unsigned NOT NULL default '0',
574 `savetime` bigint(20) unsigned NOT NULL default '0',
575 `resettalents_cost` int(11) unsigned NOT NULL default '0',
576 `resettalents_time` bigint(20) unsigned NOT NULL default '0',
579 KEY `owner` (`owner`)
580 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Pet System';
583 -- Dumping data for table `character_pet`
586 LOCK TABLES `character_pet` WRITE;
587 /*!40000 ALTER TABLE `character_pet` DISABLE KEYS */;
588 /*!40000 ALTER TABLE `character_pet` ENABLE KEYS */;
592 -- Table structure for table `character_pet_declinedname`
595 DROP TABLE IF EXISTS `character_pet_declinedname`;
596 CREATE TABLE `character_pet_declinedname` (
597 `id` int(11) unsigned NOT NULL default '0',
598 `owner` int(11) unsigned NOT NULL default '0',
599 `genitive` varchar(12) NOT NULL default '',
600 `dative` varchar(12) NOT NULL default '',
601 `accusative` varchar(12) NOT NULL default '',
602 `instrumental` varchar(12) NOT NULL default '',
603 `prepositional` varchar(12) NOT NULL default '',
605 KEY owner_key (`owner`)
606 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;
609 -- Dumping data for table `character_pet_declinedname`
612 LOCK TABLES `character_pet_declinedname` WRITE;
613 /*!40000 ALTER TABLE `character_pet_declinedname` DISABLE KEYS */;
614 /*!40000 ALTER TABLE `character_pet_declinedname` ENABLE KEYS */;
618 -- Table structure for table `character_queststatus`
621 DROP TABLE IF EXISTS `character_queststatus`;
622 CREATE TABLE `character_queststatus` (
623 `guid` int(11) unsigned NOT NULL default '0' COMMENT 'Global Unique Identifier',
624 `quest` int(11) unsigned NOT NULL default '0' COMMENT 'Quest Identifier',
625 `status` int(11) unsigned NOT NULL default '0',
626 `rewarded` tinyint(1) unsigned NOT NULL default '0',
627 `explored` tinyint(1) unsigned NOT NULL default '0',
628 `timer` bigint(20) unsigned NOT NULL default '0',
629 `mobcount1` int(11) unsigned NOT NULL default '0',
630 `mobcount2` int(11) unsigned NOT NULL default '0',
631 `mobcount3` int(11) unsigned NOT NULL default '0',
632 `mobcount4` int(11) unsigned NOT NULL default '0',
633 `itemcount1` int(11) unsigned NOT NULL default '0',
634 `itemcount2` int(11) unsigned NOT NULL default '0',
635 `itemcount3` int(11) unsigned NOT NULL default '0',
636 `itemcount4` int(11) unsigned NOT NULL default '0',
637 PRIMARY KEY (`guid`,`quest`)
638 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Player System';
641 -- Dumping data for table `character_queststatus`
644 LOCK TABLES `character_queststatus` WRITE;
645 /*!40000 ALTER TABLE `character_queststatus` DISABLE KEYS */;
646 /*!40000 ALTER TABLE `character_queststatus` ENABLE KEYS */;
650 -- Table structure for table `character_queststatus_daily`
653 DROP TABLE IF EXISTS `character_queststatus_daily`;
654 CREATE TABLE `character_queststatus_daily` (
655 `guid` int(11) unsigned NOT NULL default '0' COMMENT 'Global Unique Identifier',
656 `quest` int(11) unsigned NOT NULL default '0' COMMENT 'Quest Identifier',
657 `time` bigint(20) unsigned NOT NULL default '0',
658 PRIMARY KEY (`guid`,`quest`),
659 KEY `idx_guid` (`guid`)
660 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Player System';
663 -- Dumping data for table `character_queststatus_daily`
666 LOCK TABLES `character_queststatus_daily` WRITE;
667 /*!40000 ALTER TABLE `character_queststatus_daily` DISABLE KEYS */;
668 /*!40000 ALTER TABLE `character_queststatus_daily` ENABLE KEYS */;
672 -- Table structure for table `character_reputation`
675 DROP TABLE IF EXISTS `character_reputation`;
676 CREATE TABLE `character_reputation` (
677 `guid` int(11) unsigned NOT NULL default '0' COMMENT 'Global Unique Identifier',
678 `faction` int(11) unsigned NOT NULL default '0',
679 `standing` int(11) NOT NULL default '0',
680 `flags` int(11) NOT NULL default '0',
681 PRIMARY KEY (`guid`,`faction`)
682 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Player System';
685 -- Dumping data for table `character_reputation`
688 LOCK TABLES `character_reputation` WRITE;
689 /*!40000 ALTER TABLE `character_reputation` DISABLE KEYS */;
690 /*!40000 ALTER TABLE `character_reputation` ENABLE KEYS */;
694 -- Table structure for table `character_social`
697 DROP TABLE IF EXISTS `character_social`;
698 CREATE TABLE `character_social` (
699 `guid` int(11) unsigned NOT NULL default '0' COMMENT 'Character Global Unique Identifier',
700 `friend` int(11) unsigned NOT NULL default '0' COMMENT 'Friend Global Unique Identifier',
701 `flags` tinyint(1) unsigned NOT NULL default '0' COMMENT 'Friend Flags',
702 `note` varchar(48) NOT NULL DEFAULT '' COMMENT 'Friend Note',
703 PRIMARY KEY (`guid`,`friend`,`flags`),
705 KEY `friend` (`friend`),
706 KEY `guid_flags` (`guid`,`flags`),
707 KEY `friend_flags` (`friend`,`flags`)
708 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Player System';
711 -- Dumping data for table `character_social`
714 LOCK TABLES `character_social` WRITE;
715 /*!40000 ALTER TABLE `character_social` DISABLE KEYS */;
716 /*!40000 ALTER TABLE `character_social` ENABLE KEYS */;
720 -- Table structure for table `character_spell`
723 DROP TABLE IF EXISTS `character_spell`;
724 CREATE TABLE `character_spell` (
725 `guid` int(11) unsigned NOT NULL default '0' COMMENT 'Global Unique Identifier',
726 `spell` int(11) unsigned NOT NULL default '0' COMMENT 'Spell Identifier',
727 `active` tinyint(3) unsigned NOT NULL default '1',
728 `disabled` tinyint(3) unsigned NOT NULL default '0',
729 PRIMARY KEY (`guid`,`spell`)
730 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Player System';
733 -- Dumping data for table `character_spell`
736 LOCK TABLES `character_spell` WRITE;
737 /*!40000 ALTER TABLE `character_spell` DISABLE KEYS */;
738 /*!40000 ALTER TABLE `character_spell` ENABLE KEYS */;
742 -- Table structure for table `character_spell_cooldown`
745 DROP TABLE IF EXISTS `character_spell_cooldown`;
746 CREATE TABLE `character_spell_cooldown` (
747 `guid` int(11) unsigned NOT NULL default '0' COMMENT 'Global Unique Identifier, Low part',
748 `spell` int(11) unsigned NOT NULL default '0' COMMENT 'Spell Identifier',
749 `item` int(11) unsigned NOT NULL default '0' COMMENT 'Item Identifier',
750 `time` bigint(20) unsigned NOT NULL default '0',
751 PRIMARY KEY (`guid`,`spell`)
752 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
755 -- Dumping data for table `character_spell_cooldown`
758 LOCK TABLES `character_spell_cooldown` WRITE;
759 /*!40000 ALTER TABLE `character_spell_cooldown` DISABLE KEYS */;
760 /*!40000 ALTER TABLE `character_spell_cooldown` ENABLE KEYS */;
764 -- Table structure for table `character_ticket`
767 DROP TABLE IF EXISTS `character_ticket`;
768 CREATE TABLE `character_ticket` (
769 `ticket_id` int(11) unsigned NOT NULL auto_increment,
770 `guid` int(11) unsigned NOT NULL default '0',
772 `ticket_lastchange` TIMESTAMP ON UPDATE CURRENT_TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
773 PRIMARY KEY (`ticket_id`)
774 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Player System';
777 -- Dumping data for table `character_ticket`
780 LOCK TABLES `character_ticket` WRITE;
781 /*!40000 ALTER TABLE `character_ticket` DISABLE KEYS */;
782 /*!40000 ALTER TABLE `character_ticket` ENABLE KEYS */;
786 -- Table structure for table `character_tutorial`
789 DROP TABLE IF EXISTS `character_tutorial`;
790 CREATE TABLE `character_tutorial` (
791 `account` bigint(20) unsigned NOT NULL auto_increment COMMENT 'Account Identifier',
792 `realmid` int(11) unsigned NOT NULL default '0' COMMENT 'Realm Identifier',
793 `tut0` int(11) unsigned NOT NULL default '0',
794 `tut1` int(11) unsigned NOT NULL default '0',
795 `tut2` int(11) unsigned NOT NULL default '0',
796 `tut3` int(11) unsigned NOT NULL default '0',
797 `tut4` int(11) unsigned NOT NULL default '0',
798 `tut5` int(11) unsigned NOT NULL default '0',
799 `tut6` int(11) unsigned NOT NULL default '0',
800 `tut7` int(11) unsigned NOT NULL default '0',
801 PRIMARY KEY (`account`,`realmid`),
802 KEY acc_key (`account`)
803 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Player System';
806 -- Dumping data for table `character_tutorial`
809 LOCK TABLES `character_tutorial` WRITE;
810 /*!40000 ALTER TABLE `character_tutorial` DISABLE KEYS */;
811 /*!40000 ALTER TABLE `character_tutorial` ENABLE KEYS */;
815 -- Table structure for table `corpse`
818 DROP TABLE IF EXISTS `corpse`;
819 CREATE TABLE `corpse` (
820 `guid` int(11) unsigned NOT NULL default '0' COMMENT 'Global Unique Identifier',
821 `player` int(11) unsigned NOT NULL default '0' COMMENT 'Character Global Unique Identifier',
822 `position_x` float NOT NULL default '0',
823 `position_y` float NOT NULL default '0',
824 `position_z` float NOT NULL default '0',
825 `orientation` float NOT NULL default '0',
826 `zone` int(11) unsigned NOT NULL default '38' COMMENT 'Zone Identifier',
827 `map` int(11) unsigned NOT NULL default '0' COMMENT 'Map Identifier',
828 `phaseMask` smallint(5) unsigned NOT NULL default '1',
830 `time` bigint(20) unsigned NOT NULL default '0',
831 `corpse_type` tinyint(3) unsigned NOT NULL default '0',
832 `instance` int(11) unsigned NOT NULL default '0',
833 PRIMARY KEY (`guid`),
834 KEY `idx_type` (`corpse_type`),
835 KEY `instance` (`instance`)
836 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Death System';
839 -- Dumping data for table `corpse`
842 LOCK TABLES `corpse` WRITE;
843 /*!40000 ALTER TABLE `corpse` DISABLE KEYS */;
844 /*!40000 ALTER TABLE `corpse` ENABLE KEYS */;
848 -- Table structure for table `groups`
851 DROP TABLE IF EXISTS `groups`;
852 CREATE TABLE `groups` (
853 `leaderGuid` int(11) unsigned NOT NULL,
854 `mainTank` int(11) unsigned NOT NULL,
855 `mainAssistant` int(11) unsigned NOT NULL,
856 `lootMethod` tinyint(4) unsigned NOT NULL,
857 `looterGuid` int(11) unsigned NOT NULL,
858 `lootThreshold` tinyint(4) unsigned NOT NULL,
859 `icon1` int(11) unsigned NOT NULL,
860 `icon2` int(11) unsigned NOT NULL,
861 `icon3` int(11) unsigned NOT NULL,
862 `icon4` int(11) unsigned NOT NULL,
863 `icon5` int(11) unsigned NOT NULL,
864 `icon6` int(11) unsigned NOT NULL,
865 `icon7` int(11) unsigned NOT NULL,
866 `icon8` int(11) unsigned NOT NULL,
867 `isRaid` tinyint(1) unsigned NOT NULL,
868 `difficulty` tinyint(3) unsigned NOT NULL default '0',
869 PRIMARY KEY (`leaderGuid`)
870 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Groups';
873 -- Dumping data for table `groups`
876 LOCK TABLES `groups` WRITE;
877 /*!40000 ALTER TABLE `groups` DISABLE KEYS */;
878 /*!40000 ALTER TABLE `groups` ENABLE KEYS */;
881 -- ----------------------------
882 -- Table structure for group_instance
883 -- ----------------------------
884 DROP TABLE IF EXISTS `group_instance`;
885 CREATE TABLE `group_instance` (
886 `leaderGuid` int(11) unsigned NOT NULL default '0',
887 `instance` int(11) unsigned NOT NULL default '0',
888 `permanent` tinyint(1) unsigned NOT NULL default '0',
889 PRIMARY KEY (`leaderGuid`,`instance`),
890 KEY `instance` (`instance`)
891 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
894 -- Dumping data for table `group_instance`
897 LOCK TABLES `group_instance` WRITE;
898 /*!40000 ALTER TABLE `group_instance` DISABLE KEYS */;
899 /*!40000 ALTER TABLE `group_instance` ENABLE KEYS */;
903 -- Table structure for table `group_member`
906 DROP TABLE IF EXISTS `group_member`;
907 CREATE TABLE `group_member` (
908 `leaderGuid` int(11) unsigned NOT NULL,
909 `memberGuid` int(11) unsigned NOT NULL,
910 `assistant` tinyint(1) unsigned NOT NULL,
911 `subgroup` smallint(6) unsigned NOT NULL,
912 PRIMARY KEY (`leaderGuid`,`memberGuid`)
913 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Groups';
916 -- Dumping data for table `group_member`
919 LOCK TABLES `group_member` WRITE;
920 /*!40000 ALTER TABLE `group_member` DISABLE KEYS */;
921 /*!40000 ALTER TABLE `group_member` ENABLE KEYS */;
925 -- Table structure for table `guild`
928 DROP TABLE IF EXISTS `guild`;
929 CREATE TABLE `guild` (
930 `guildid` int(6) unsigned NOT NULL default '0',
931 `name` varchar(255) NOT NULL default '',
932 `leaderguid` int(6) unsigned NOT NULL default '0',
933 `EmblemStyle` int(5) NOT NULL default '0',
934 `EmblemColor` int(5) NOT NULL default '0',
935 `BorderStyle` int(5) NOT NULL default '0',
936 `BorderColor` int(5) NOT NULL default '0',
937 `BackgroundColor` int(5) NOT NULL default '0',
938 `info` text NOT NULL,
939 `motd` varchar(255) NOT NULL default '',
940 `createdate` bigint(20) NOT NULL default '0',
941 `BankMoney` bigint(20) NOT NULL default '0',
942 PRIMARY KEY (`guildid`)
943 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Guild System';
946 -- Dumping data for table `guild`
949 LOCK TABLES `guild` WRITE;
950 /*!40000 ALTER TABLE `guild` DISABLE KEYS */;
951 /*!40000 ALTER TABLE `guild` ENABLE KEYS */;
955 -- Table structure for table `guild_bank_eventlog`
958 DROP TABLE IF EXISTS `guild_bank_eventlog`;
959 CREATE TABLE `guild_bank_eventlog` (
960 `guildid` int(11) unsigned NOT NULL default '0' COMMENT 'Guild Identificator',
961 `LogGuid` int(11) unsigned NOT NULL default '0' COMMENT 'Log record identificator - auxiliary column',
962 `TabId` tinyint(3) unsigned NOT NULL default '0' COMMENT 'Guild bank TabId',
963 `EventType` tinyint(3) unsigned NOT NULL default '0' COMMENT 'Event type',
964 `PlayerGuid` int(11) unsigned NOT NULL default '0',
965 `ItemOrMoney` int(11) unsigned NOT NULL default '0',
966 `ItemStackCount` tinyint(3) unsigned NOT NULL default '0',
967 `DestTabId` tinyint(1) unsigned NOT NULL default '0' COMMENT 'Destination Tab Id',
968 `TimeStamp` bigint(20) unsigned NOT NULL default '0' COMMENT 'Event UNIX time',
969 PRIMARY KEY (`guildid`,`LogGuid`,`TabId`),
970 KEY `guildid_key` (`guildid`)
971 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
974 -- Dumping data for table `guild_bank_eventlog`
977 LOCK TABLES `guild_bank_eventlog` WRITE;
978 /*!40000 ALTER TABLE `guild_bank_eventlog` DISABLE KEYS */;
979 /*!40000 ALTER TABLE `guild_bank_eventlog` ENABLE KEYS */;
983 -- Table structure for table `guild_bank_item`
986 DROP TABLE IF EXISTS `guild_bank_item`;
987 CREATE TABLE `guild_bank_item` (
988 `guildid` int(11) unsigned NOT NULL default '0',
989 `TabId` tinyint(1) unsigned NOT NULL default '0',
990 `SlotId` tinyint(3) unsigned NOT NULL default '0',
991 `item_guid` int(11) unsigned NOT NULL default '0',
992 `item_entry` int(11) unsigned NOT NULL default '0',
993 PRIMARY KEY (`guildid`,`tabid`,`slotid`),
994 KEY `guildid_key` (`guildid`)
995 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
998 -- Dumping data for table `guild_bank_item`
1001 LOCK TABLES `guild_bank_item` WRITE;
1002 /*!40000 ALTER TABLE `guild_bank_item` DISABLE KEYS */;
1003 /*!40000 ALTER TABLE `guild_bank_item` ENABLE KEYS */;
1007 -- Table structure for table `guild_bank_right`
1010 DROP TABLE IF EXISTS `guild_bank_right`;
1011 CREATE TABLE `guild_bank_right` (
1012 `guildid` int(11) unsigned NOT NULL default '0',
1013 `TabId` tinyint(1) unsigned NOT NULL default '0',
1014 `rid` int(11) unsigned NOT NULL default '0',
1015 `gbright` tinyint(3) unsigned NOT NULL default '0',
1016 `SlotPerDay` int(11) unsigned NOT NULL default '0',
1017 PRIMARY KEY (`guildid`,`TabId`,`rid`),
1018 KEY `guildid_key` (`guildid`)
1019 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1022 -- Dumping data for table `guild_bank_right`
1025 LOCK TABLES `guild_bank_right` WRITE;
1026 /*!40000 ALTER TABLE `guild_bank_right` DISABLE KEYS */;
1027 /*!40000 ALTER TABLE `guild_bank_right` ENABLE KEYS */;
1031 -- Table structure for table `guild_bank_tab`
1034 DROP TABLE IF EXISTS `guild_bank_tab`;
1035 CREATE TABLE `guild_bank_tab` (
1036 `guildid` int(11) unsigned NOT NULL default '0',
1037 `TabId` tinyint(1) unsigned NOT NULL default '0',
1038 `TabName` varchar(100) NOT NULL default '',
1039 `TabIcon` varchar(100) NOT NULL default '',
1041 PRIMARY KEY (`guildid`,`TabId`),
1042 KEY `guildid_key` (`guildid`)
1043 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1046 -- Dumping data for table `guild_bank_tab`
1049 LOCK TABLES `guild_bank_tab` WRITE;
1050 /*!40000 ALTER TABLE `guild_bank_tab` DISABLE KEYS */;
1051 /*!40000 ALTER TABLE `guild_bank_tab` ENABLE KEYS */;
1055 -- Table structure for table `guild_eventlog`
1058 DROP TABLE IF EXISTS `guild_eventlog`;
1059 CREATE TABLE `guild_eventlog` (
1060 `guildid` int(11) NOT NULL COMMENT 'Guild Identificator',
1061 `LogGuid` int(11) NOT NULL COMMENT 'Log record identificator - auxiliary column',
1062 `EventType` tinyint(1) NOT NULL COMMENT 'Event type',
1063 `PlayerGuid1` int(11) NOT NULL COMMENT 'Player 1',
1064 `PlayerGuid2` int(11) NOT NULL COMMENT 'Player 2',
1065 `NewRank` tinyint(2) NOT NULL COMMENT 'New rank(in case promotion/demotion)',
1066 `TimeStamp` bigint(20) NOT NULL COMMENT 'Event UNIX time',
1067 PRIMARY KEY (`guildid`, `LogGuid`)
1068 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT 'Guild Eventlog';
1071 -- Dumping data for table `guild_eventlog`
1074 LOCK TABLES `guild_eventlog` WRITE;
1075 /*!40000 ALTER TABLE `guild_eventlog` DISABLE KEYS */;
1076 /*!40000 ALTER TABLE `guild_eventlog` ENABLE KEYS */;
1080 -- Table structure for table `guild_member`
1083 DROP TABLE IF EXISTS `guild_member`;
1084 CREATE TABLE `guild_member` (
1085 `guildid` int(6) unsigned NOT NULL default '0',
1086 `guid` int(11) unsigned NOT NULL default '0',
1087 `rank` tinyint(2) unsigned NOT NULL default '0',
1088 `pnote` varchar(255) NOT NULL default '',
1089 `offnote` varchar(255) NOT NULL default '',
1090 `BankResetTimeMoney` int(11) unsigned NOT NULL default '0',
1091 `BankRemMoney` int(11) unsigned NOT NULL default '0',
1092 `BankResetTimeTab0` int(11) unsigned NOT NULL default '0',
1093 `BankRemSlotsTab0` int(11) unsigned NOT NULL default '0',
1094 `BankResetTimeTab1` int(11) unsigned NOT NULL default '0',
1095 `BankRemSlotsTab1` int(11) unsigned NOT NULL default '0',
1096 `BankResetTimeTab2` int(11) unsigned NOT NULL default '0',
1097 `BankRemSlotsTab2` int(11) unsigned NOT NULL default '0',
1098 `BankResetTimeTab3` int(11) unsigned NOT NULL default '0',
1099 `BankRemSlotsTab3` int(11) unsigned NOT NULL default '0',
1100 `BankResetTimeTab4` int(11) unsigned NOT NULL default '0',
1101 `BankRemSlotsTab4` int(11) unsigned NOT NULL default '0',
1102 `BankResetTimeTab5` int(11) unsigned NOT NULL default '0',
1103 `BankRemSlotsTab5` int(11) unsigned NOT NULL default '0',
1104 KEY `guildid_key` (`guildid`),
1105 KEY `guildid_rank_key` (`guildid`,`rank`),
1106 UNIQUE KEY `guid_key` (`guid`)
1107 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Guild System';
1110 -- Dumping data for table `guild_member`
1113 LOCK TABLES `guild_member` WRITE;
1114 /*!40000 ALTER TABLE `guild_member` DISABLE KEYS */;
1115 /*!40000 ALTER TABLE `guild_member` ENABLE KEYS */;
1119 -- Table structure for table `guild_rank`
1122 DROP TABLE IF EXISTS `guild_rank`;
1123 CREATE TABLE `guild_rank` (
1124 `guildid` int(6) unsigned NOT NULL default '0',
1125 `rid` int(11) unsigned NOT NULL,
1126 `rname` varchar(255) NOT NULL default '',
1127 `rights` int(3) unsigned NOT NULL default '0',
1128 `BankMoneyPerDay` int(11) unsigned NOT NULL default '0',
1129 PRIMARY KEY (`guildid`,`rid`)
1130 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Guild System';
1133 -- Dumping data for table `guild_rank`
1136 LOCK TABLES `guild_rank` WRITE;
1137 /*!40000 ALTER TABLE `guild_rank` DISABLE KEYS */;
1138 /*!40000 ALTER TABLE `guild_rank` ENABLE KEYS */;
1142 -- Table structure for table `instance`
1145 DROP TABLE IF EXISTS `instance`;
1146 CREATE TABLE `instance` (
1147 `id` int(11) unsigned NOT NULL default '0',
1148 `map` int(11) unsigned NOT NULL default '0',
1149 `resettime` bigint(40) NOT NULL default '0',
1150 `difficulty` tinyint(1) unsigned NOT NULL default '0',
1154 KEY `resettime` (`resettime`)
1155 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1158 -- Dumping data for table `instance`
1161 LOCK TABLES `instance` WRITE;
1162 /*!40000 ALTER TABLE `instance` DISABLE KEYS */;
1163 /*!40000 ALTER TABLE `instance` ENABLE KEYS */;
1166 -- ----------------------------
1167 -- Table structure for instance_reset
1168 -- ----------------------------
1169 DROP TABLE IF EXISTS `instance_reset`;
1170 CREATE TABLE `instance_reset` (
1171 `mapid` int(11) unsigned NOT NULL default '0',
1172 `resettime` bigint(40) NOT NULL default '0',
1173 PRIMARY KEY (`mapid`)
1174 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1177 -- Dumping data for table `instance_reset`
1180 LOCK TABLES `instance_reset` WRITE;
1181 /*!40000 ALTER TABLE `instance_reset` DISABLE KEYS */;
1182 /*!40000 ALTER TABLE `instance_reset` ENABLE KEYS */;
1186 -- Table structure for table `item_instance`
1189 DROP TABLE IF EXISTS `item_instance`;
1190 CREATE TABLE `item_instance` (
1191 `guid` int(11) unsigned NOT NULL default '0',
1192 `owner_guid` int(11) unsigned NOT NULL default '0',
1194 PRIMARY KEY (`guid`),
1195 KEY `idx_owner_guid` (`owner_guid`)
1196 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Item System';
1199 -- Dumping data for table `item_instance`
1202 LOCK TABLES `item_instance` WRITE;
1203 /*!40000 ALTER TABLE `item_instance` DISABLE KEYS */;
1204 /*!40000 ALTER TABLE `item_instance` ENABLE KEYS */;
1208 -- Table structure for table `item_text`
1211 DROP TABLE IF EXISTS `item_text`;
1212 CREATE TABLE `item_text` (
1213 `id` int(11) unsigned NOT NULL default '0',
1216 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Item System';
1219 -- Dumping data for table `item_text`
1222 LOCK TABLES `item_text` WRITE;
1223 /*!40000 ALTER TABLE `item_text` DISABLE KEYS */;
1224 /*!40000 ALTER TABLE `item_text` ENABLE KEYS */;
1228 -- Table structure for table `mail`
1231 DROP TABLE IF EXISTS `mail`;
1232 CREATE TABLE `mail` (
1233 `id` int(11) unsigned NOT NULL default '0' COMMENT 'Identifier',
1234 `messageType` tinyint(3) unsigned NOT NULL default '0',
1235 `stationery` tinyint(3) NOT NULL default '41',
1236 `mailTemplateId` mediumint(8) unsigned NOT NULL default '0',
1237 `sender` int(11) unsigned NOT NULL default '0' COMMENT 'Character Global Unique Identifier',
1238 `receiver` int(11) unsigned NOT NULL default '0' COMMENT 'Character Global Unique Identifier',
1240 `itemTextId` int(11) unsigned NOT NULL default '0',
1241 `has_items` tinyint(3) unsigned NOT NULL default '0',
1242 `expire_time` bigint(40) NOT NULL default '0',
1243 `deliver_time` bigint(40) NOT NULL default '0',
1244 `money` int(11) unsigned NOT NULL default '0',
1245 `cod` int(11) unsigned NOT NULL default '0',
1246 `checked` tinyint(3) unsigned NOT NULL default '0',
1248 KEY `idx_receiver` (`receiver`)
1249 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Mail System';
1252 -- Dumping data for table `mail`
1255 LOCK TABLES `mail` WRITE;
1256 /*!40000 ALTER TABLE `mail` DISABLE KEYS */;
1257 /*!40000 ALTER TABLE `mail` ENABLE KEYS */;
1261 -- Table structure for table `mail_items`
1264 DROP TABLE IF EXISTS `mail_items`;
1265 CREATE TABLE `mail_items` (
1266 `mail_id` int(11) NOT NULL default '0',
1267 `item_guid` int(11) NOT NULL default '0',
1268 `item_template` int(11) NOT NULL default '0',
1269 `receiver` int(11) unsigned NOT NULL default '0' COMMENT 'Character Global Unique Identifier',
1270 PRIMARY KEY (`mail_id`,`item_guid`),
1271 KEY `idx_receiver` (`receiver`)
1272 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;
1275 -- Dumping data for table `mail_items`
1278 LOCK TABLES `mail_items` WRITE;
1279 /*!40000 ALTER TABLE `mail_items` DISABLE KEYS */;
1280 /*!40000 ALTER TABLE `mail_items` ENABLE KEYS */;
1284 -- Table structure for table `pet_aura`
1287 DROP TABLE IF EXISTS `pet_aura`;
1288 CREATE TABLE `pet_aura` (
1289 `guid` int(11) unsigned NOT NULL default '0' COMMENT 'Global Unique Identifier',
1290 `caster_guid` bigint(20) unsigned NOT NULL default '0' COMMENT 'Full Global Unique Identifier',
1291 `spell` int(11) unsigned NOT NULL default '0',
1292 `effect_index` int(11) unsigned NOT NULL default '0',
1293 `stackcount` int(11) NOT NULL default '1',
1294 `amount` int(11) NOT NULL default '0',
1295 `maxduration` int(11) NOT NULL default '0',
1296 `remaintime` int(11) NOT NULL default '0',
1297 `remaincharges` int(11) NOT NULL default '0',
1298 PRIMARY KEY (`guid`,`spell`,`effect_index`)
1299 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Pet System';
1302 -- Dumping data for table `pet_aura`
1305 LOCK TABLES `pet_aura` WRITE;
1306 /*!40000 ALTER TABLE `pet_aura` DISABLE KEYS */;
1307 /*!40000 ALTER TABLE `pet_aura` ENABLE KEYS */;
1311 -- Table structure for table `pet_spell`
1314 DROP TABLE IF EXISTS `pet_spell`;
1315 CREATE TABLE `pet_spell` (
1316 `guid` int(11) unsigned NOT NULL default '0' COMMENT 'Global Unique Identifier',
1317 `spell` int(11) unsigned NOT NULL default '0' COMMENT 'Spell Identifier',
1318 `active` int(11) unsigned NOT NULL default '0',
1319 PRIMARY KEY (`guid`,`spell`)
1320 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Pet System';
1323 -- Dumping data for table `pet_spell`
1326 LOCK TABLES `pet_spell` WRITE;
1327 /*!40000 ALTER TABLE `pet_spell` DISABLE KEYS */;
1328 /*!40000 ALTER TABLE `pet_spell` ENABLE KEYS */;
1332 -- Table structure for table `pet_spell_cooldown`
1335 DROP TABLE IF EXISTS `pet_spell_cooldown`;
1336 CREATE TABLE `pet_spell_cooldown` (
1337 `guid` int(11) unsigned NOT NULL default '0' COMMENT 'Global Unique Identifier, Low part',
1338 `spell` int(11) unsigned NOT NULL default '0' COMMENT 'Spell Identifier',
1339 `time` bigint(20) unsigned NOT NULL default '0',
1340 PRIMARY KEY (`guid`,`spell`)
1341 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1344 -- Dumping data for table `pet_spell_cooldown`
1347 LOCK TABLES `pet_spell_cooldown` WRITE;
1348 /*!40000 ALTER TABLE `pet_spell_cooldown` DISABLE KEYS */;
1349 /*!40000 ALTER TABLE `pet_spell_cooldown` ENABLE KEYS */;
1353 -- Table structure for table `petition`
1356 DROP TABLE IF EXISTS `petition`;
1357 CREATE TABLE `petition` (
1358 `ownerguid` int(10) unsigned NOT NULL,
1359 `petitionguid` int(10) unsigned default '0',
1360 `name` varchar(255) NOT NULL default '',
1361 `type` int(10) unsigned NOT NULL default '0',
1362 PRIMARY KEY (`ownerguid`,`type`),
1363 UNIQUE KEY `index_ownerguid_petitionguid` (`ownerguid`,`petitionguid`)
1364 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Guild System';
1367 -- Dumping data for table `petition`
1370 LOCK TABLES `petition` WRITE;
1371 /*!40000 ALTER TABLE `petition` DISABLE KEYS */;
1372 /*!40000 ALTER TABLE `petition` ENABLE KEYS */;
1376 -- Table structure for table `petition_sign`
1379 DROP TABLE IF EXISTS `petition_sign`;
1380 CREATE TABLE `petition_sign` (
1381 `ownerguid` int(10) unsigned NOT NULL,
1382 `petitionguid` int(11) unsigned NOT NULL default '0',
1383 `playerguid` int(11) unsigned NOT NULL default '0',
1384 `player_account` int(11) unsigned NOT NULL default '0',
1385 `type` int(10) unsigned NOT NULL default '0',
1386 PRIMARY KEY (`petitionguid`,`playerguid`)
1387 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Guild System';
1390 -- Dumping data for table `petition_sign`
1393 LOCK TABLES `petition_sign` WRITE;
1394 /*!40000 ALTER TABLE `petition_sign` DISABLE KEYS */;
1395 /*!40000 ALTER TABLE `petition_sign` ENABLE KEYS */;
1397 /*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
1400 -- Table structure for table `saved_variables`
1403 DROP TABLE IF EXISTS `saved_variables`;
1404 CREATE TABLE `saved_variables` (
1405 `NextArenaPointDistributionTime` bigint(40) UNSIGNED NOT NULL DEFAULT '0'
1406 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Variable Saves';
1409 -- Dumping data for table `saved_variables`
1412 LOCK TABLES `saved_variables` WRITE;
1413 /*!40000 ALTER TABLE `saved_variables` DISABLE KEYS */;
1414 /*!40000 ALTER TABLE `saved_variables` ENABLE KEYS */;
1416 /*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
1419 /*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
1420 /*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
1421 /*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
1422 /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
1423 /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
1424 /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
1425 /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
1427 -- Dump completed on 2008-01-10 11:37:06