root/trunk/sql/characters.sql @ 74

Revision 74, 41.6 kB (checked in by yumileroy, 17 years ago)

[svn] * Fixed compile from r78
* Fixed: not apply healling bonus to spell 40972 heal amount. - Source Mangos
* Item 30627 hidden cooldown - Source Mangos
* Fixed Trinityrealm autopatching system - Source Arrai
* Add support for autoconf 2.6.2 and newer - Source Derex
Some decent sized changes, please test before deploying - KP

Original author: KingPin?
Date: 2008-10-19 21:08:34-05:00

Line 
1-- MySQL dump 10.11
2--
3-- Host: localhost    Database: characters
4-- ------------------------------------------------------
5-- Server version       5.0.34-log
6
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 */;
17
18--
19-- Table structure for table `arena_team`
20--
21
22DROP TABLE IF EXISTS `arena_team`;
23CREATE TABLE `arena_team` (
24  `arenateamid` int(10) unsigned NOT NULL default '0',
25  `name` char(255) NOT NULL,
26  `captainguid` int(10) unsigned NOT NULL default '0',
27  `type` tinyint(3) unsigned NOT NULL default '0',
28  `BackgroundColor` int(10) unsigned NOT NULL default '0',
29  `EmblemStyle` int(10) unsigned NOT NULL default '0',
30  `EmblemColor` int(10) unsigned NOT NULL default '0',
31  `BorderStyle` int(10) unsigned NOT NULL default '0',
32  `BorderColor` int(10) unsigned NOT NULL default '0',
33  PRIMARY KEY  (`arenateamid`)
34) ENGINE=InnoDB DEFAULT CHARSET=utf8;
35
36--
37-- Dumping data for table `arena_team`
38--
39
40LOCK TABLES `arena_team` WRITE;
41/*!40000 ALTER TABLE `arena_team` DISABLE KEYS */;
42/*!40000 ALTER TABLE `arena_team` ENABLE KEYS */;
43UNLOCK TABLES;
44
45--
46-- Table structure for table `arena_team_member`
47--
48
49DROP TABLE IF EXISTS `arena_team_member`;
50CREATE TABLE `arena_team_member` (
51  `arenateamid` int(10) unsigned NOT NULL default '0',
52  `guid` int(10) unsigned NOT NULL default '0',
53  `played_week` int(10) unsigned NOT NULL default '0',
54  `wons_week` int(10) unsigned NOT NULL default '0',
55  `played_season` int(10) unsigned NOT NULL default '0',
56  `wons_season` int(10) unsigned NOT NULL default '0',
57  `points_to_add` int(10) unsigned NOT NULL default '0'
58) ENGINE=InnoDB DEFAULT CHARSET=utf8;
59
60--
61-- Dumping data for table `arena_team_member`
62--
63
64LOCK TABLES `arena_team_member` WRITE;
65/*!40000 ALTER TABLE `arena_team_member` DISABLE KEYS */;
66/*!40000 ALTER TABLE `arena_team_member` ENABLE KEYS */;
67UNLOCK TABLES;
68
69--
70-- Table structure for table `arena_team_stats`
71--
72
73DROP TABLE IF EXISTS `arena_team_stats`;
74CREATE TABLE `arena_team_stats` (
75  `arenateamid` int(10) unsigned NOT NULL default '0',
76  `rating` int(10) unsigned NOT NULL default '0',
77  `games` int(10) unsigned NOT NULL default '0',
78  `wins` int(10) unsigned NOT NULL default '0',
79  `played` int(10) unsigned NOT NULL default '0',
80  `wins2` int(10) unsigned NOT NULL default '0',
81  `rank` int(10) unsigned NOT NULL default '0',
82  PRIMARY KEY  (`arenateamid`)
83) ENGINE=InnoDB DEFAULT CHARSET=utf8;
84
85--
86-- Dumping data for table `arena_team_stats`
87--
88
89LOCK TABLES `arena_team_stats` WRITE;
90/*!40000 ALTER TABLE `arena_team_stats` DISABLE KEYS */;
91/*!40000 ALTER TABLE `arena_team_stats` ENABLE KEYS */;
92UNLOCK TABLES;
93
94--
95-- Table structure for table `auctionhouse`
96--
97
98DROP TABLE IF EXISTS `auctionhouse`;
99CREATE TABLE `auctionhouse` (
100  `id` int(11) unsigned NOT NULL default '0',
101  `auctioneerguid` int(11) unsigned NOT NULL default '0',
102  `itemguid` int(11) unsigned NOT NULL default '0',
103  `item_template` int(11) unsigned NOT NULL default '0' COMMENT 'Item Identifier',
104  `itemowner` int(11) unsigned NOT NULL default '0',
105  `buyoutprice` int(11) NOT NULL default '0',
106  `time` bigint(40) NOT NULL default '0',
107  `buyguid` int(11) unsigned NOT NULL default '0',
108  `lastbid` int(11) NOT NULL default '0',
109  `startbid` int(11) NOT NULL default '0',
110  `deposit` int(11) NOT NULL default '0',
111  `location` tinyint(3) unsigned NOT NULL default '3',
112  PRIMARY KEY  (`id`),
113  UNIQUE KEY `item_guid` (`itemguid`)
114) ENGINE=InnoDB DEFAULT CHARSET=utf8;
115
116--
117-- Dumping data for table `auctionhouse`
118--
119
120LOCK TABLES `auctionhouse` WRITE;
121/*!40000 ALTER TABLE `auctionhouse` DISABLE KEYS */;
122/*!40000 ALTER TABLE `auctionhouse` ENABLE KEYS */;
123UNLOCK TABLES;
124
125--
126-- Table structure for table `bugreport`
127--
128
129DROP TABLE IF EXISTS `bugreport`;
130CREATE TABLE `bugreport` (
131  `id` int(11) NOT NULL auto_increment COMMENT 'Identifier',
132  `type` varchar(255) NOT NULL default '',
133  `content` varchar(255) NOT NULL default '',
134  PRIMARY KEY  (`id`)
135) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Debug System';
136
137--
138-- Dumping data for table `bugreport`
139--
140
141LOCK TABLES `bugreport` WRITE;
142/*!40000 ALTER TABLE `bugreport` DISABLE KEYS */;
143/*!40000 ALTER TABLE `bugreport` ENABLE KEYS */;
144UNLOCK TABLES;
145
146--
147-- Table structure for table `character_action`
148--
149
150DROP TABLE IF EXISTS `character_action`;
151CREATE TABLE `character_action` (
152  `guid` int(11) unsigned NOT NULL default '0' COMMENT 'Global Unique Identifier',
153  `button` tinyint(3) unsigned NOT NULL default '0',
154  `action` smallint(5) unsigned NOT NULL default '0',
155  `type` tinyint(3) unsigned NOT NULL default '0',
156  `misc` tinyint(3) unsigned NOT NULL default '0',
157  PRIMARY KEY  (`guid`,`button`)
158) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Player System';
159
160--
161-- Dumping data for table `character_action`
162--
163
164LOCK TABLES `character_action` WRITE;
165/*!40000 ALTER TABLE `character_action` DISABLE KEYS */;
166/*!40000 ALTER TABLE `character_action` ENABLE KEYS */;
167UNLOCK TABLES;
168
169--
170-- Table structure for table `character_aura`
171--
172
173DROP TABLE IF EXISTS `character_aura`;
174CREATE TABLE `character_aura` (
175  `guid` int(11) unsigned NOT NULL default '0' COMMENT 'Global Unique Identifier',
176  `caster_guid` bigint(20) unsigned NOT NULL default '0' COMMENT 'Full Global Unique Identifier',
177  `spell` int(11) unsigned NOT NULL default '0',
178  `effect_index` int(11) unsigned NOT NULL default '0',
179  `amount` int(11) NOT NULL default '0',
180  `maxduration` int(11) NOT NULL default '0',
181  `remaintime` int(11) NOT NULL default '0',
182  `remaincharges` int(11) NOT NULL default '0',
183  PRIMARY KEY  (`guid`,`spell`,`effect_index`)
184) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Player System';
185
186--
187-- Dumping data for table `character_aura`
188--
189
190LOCK TABLES `character_aura` WRITE;
191/*!40000 ALTER TABLE `character_aura` DISABLE KEYS */;
192/*!40000 ALTER TABLE `character_aura` ENABLE KEYS */;
193UNLOCK TABLES;
194
195--
196-- Table structure for table `character_declinedname`
197--
198
199DROP TABLE IF EXISTS `character_declinedname`;
200CREATE TABLE `character_declinedname` (
201  `guid` int(11) unsigned NOT NULL default '0' COMMENT 'Global Unique Identifier',
202  `genitive` varchar(15) NOT NULL default '',
203  `dative` varchar(15) NOT NULL default '',
204  `accusative` varchar(15) NOT NULL default '',
205  `instrumental` varchar(15) NOT NULL default '',
206  `prepositional` varchar(15) NOT NULL default '',
207  PRIMARY KEY  (`guid`)
208) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;
209
210--
211-- Dumping data for table `character_declinedname`
212--
213
214LOCK TABLES `character_declinedname` WRITE;
215/*!40000 ALTER TABLE `character_declinedname` DISABLE KEYS */;
216/*!40000 ALTER TABLE `character_declinedname` ENABLE KEYS */;
217UNLOCK TABLES;
218
219--
220-- Table structure for table `character_gifts`
221--
222
223DROP TABLE IF EXISTS `character_gifts`;
224CREATE TABLE `character_gifts` (
225  `guid` int(20) unsigned NOT NULL default '0',
226  `item_guid` int(11) unsigned NOT NULL default '0',
227  `entry` int(20) unsigned NOT NULL default '0',
228  `flags` int(20) unsigned NOT NULL default '0',
229  PRIMARY KEY  (`item_guid`),
230  KEY `idx_guid` (`guid`)
231) ENGINE=InnoDB DEFAULT CHARSET=utf8;
232
233--
234-- Dumping data for table `character_gifts`
235--
236
237LOCK TABLES `character_gifts` WRITE;
238/*!40000 ALTER TABLE `character_gifts` DISABLE KEYS */;
239/*!40000 ALTER TABLE `character_gifts` ENABLE KEYS */;
240UNLOCK TABLES;
241
242--
243-- Table structure for table `character_homebind`
244--
245
246DROP TABLE IF EXISTS `character_homebind`;
247CREATE TABLE `character_homebind` (
248  `guid` int(11) unsigned NOT NULL default '0' COMMENT 'Global Unique Identifier',
249  `map` int(11) unsigned NOT NULL default '0' COMMENT 'Map Identifier',
250  `zone` int(11) unsigned NOT NULL default '0' COMMENT 'Zone Identifier',
251  `position_x` float NOT NULL default '0',
252  `position_y` float NOT NULL default '0',
253  `position_z` float NOT NULL default '0',
254  PRIMARY KEY  (`guid`)
255) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Player System';
256
257--
258-- Dumping data for table `character_homebind`
259--
260
261LOCK TABLES `character_homebind` WRITE;
262/*!40000 ALTER TABLE `character_homebind` DISABLE KEYS */;
263/*!40000 ALTER TABLE `character_homebind` ENABLE KEYS */;
264UNLOCK TABLES;
265
266--
267-- Table structure for table `character_instance`
268--
269
270DROP TABLE IF EXISTS `character_instance`;
271CREATE TABLE `character_instance` (
272  `guid` int(11) unsigned NOT NULL default '0',
273  `instance` int(11) unsigned NOT NULL default '0',
274  `permanent` tinyint(1) unsigned NOT NULL default '0',
275  PRIMARY KEY  (`guid`,`instance`),
276  KEY `instance` (`instance`)
277) ENGINE=InnoDB DEFAULT CHARSET=utf8;
278
279--
280-- Dumping data for table `character_instance`
281--
282
283LOCK TABLES `character_instance` WRITE;
284/*!40000 ALTER TABLE `character_instance` DISABLE KEYS */;
285/*!40000 ALTER TABLE `character_instance` ENABLE KEYS */;
286UNLOCK TABLES;
287
288--
289-- Table structure for table `character_inventory`
290--
291
292DROP TABLE IF EXISTS `character_inventory`;
293CREATE TABLE `character_inventory` (
294  `guid` int(11) unsigned NOT NULL default '0' COMMENT 'Global Unique Identifier',
295  `bag` int(11) unsigned NOT NULL default '0',
296  `slot` tinyint(3) unsigned NOT NULL default '0',
297  `item` int(11) unsigned NOT NULL default '0' COMMENT 'Item Global Unique Identifier',
298  `item_template` int(11) unsigned NOT NULL default '0' COMMENT 'Item Identifier',
299  PRIMARY KEY  (`item`),
300  KEY `idx_guid` (`guid`)
301) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Player System';
302
303--
304-- Dumping data for table `character_inventory`
305--
306
307LOCK TABLES `character_inventory` WRITE;
308/*!40000 ALTER TABLE `character_inventory` DISABLE KEYS */;
309/*!40000 ALTER TABLE `character_inventory` ENABLE KEYS */;
310UNLOCK TABLES;
311
312--
313-- Table structure for table `character_pet`
314--
315
316DROP TABLE IF EXISTS `character_pet`;
317CREATE TABLE `character_pet` (
318  `id` int(11) unsigned NOT NULL default '0',
319  `entry` int(11) unsigned NOT NULL default '0',
320  `owner` int(11) unsigned NOT NULL default '0',
321  `modelid` int(11) unsigned default '0',
322  `CreatedBySpell` int(11) unsigned NOT NULL default '0',
323  `PetType` tinyint(3) unsigned NOT NULL default '0',
324  `level` int(11) unsigned NOT NULL default '1',
325  `exp` int(11) unsigned NOT NULL default '0',
326  `Reactstate` tinyint(1) unsigned NOT NULL default '0',
327  `loyaltypoints` int(11) NOT NULL default '0',
328  `loyalty` int(11) unsigned NOT NULL default '0',
329  `trainpoint` int(11) NOT NULL default '0',
330  `name` varchar(100) default 'Pet',
331  `renamed` tinyint(1) unsigned NOT NULL default '0',
332  `slot` int(11) unsigned NOT NULL default '0',
333  `curhealth` int(11) unsigned NOT NULL default '1',
334  `curmana` int(11) unsigned NOT NULL default '0',
335  `curhappiness` int(11) unsigned NOT NULL default '0',
336  `savetime` bigint(20) unsigned NOT NULL default '0',
337  `resettalents_cost` int(11) unsigned NOT NULL default '0',
338  `resettalents_time` bigint(20) unsigned NOT NULL default '0',
339  `abdata` longtext,
340  `teachspelldata` longtext,
341  PRIMARY KEY  (`id`),
342  KEY `owner` (`owner`)
343) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Pet System';
344
345--
346-- Dumping data for table `character_pet`
347--
348
349LOCK TABLES `character_pet` WRITE;
350/*!40000 ALTER TABLE `character_pet` DISABLE KEYS */;
351/*!40000 ALTER TABLE `character_pet` ENABLE KEYS */;
352UNLOCK TABLES;
353
354--
355-- Table structure for table `character_pet_declinedname`
356--
357
358DROP TABLE IF EXISTS `character_pet_declinedname`;
359CREATE TABLE `character_pet_declinedname` (
360  `id` int(11) unsigned NOT NULL default '0',
361  `owner` int(11) unsigned NOT NULL default '0',
362  `genitive` varchar(12) NOT NULL default '',
363  `dative` varchar(12) NOT NULL default '',
364  `accusative` varchar(12) NOT NULL default '',
365  `instrumental` varchar(12) NOT NULL default '',
366  `prepositional` varchar(12) NOT NULL default '',
367  PRIMARY KEY  (`id`),
368  KEY `owner_key` (`owner`)
369) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;
370
371--
372-- Dumping data for table `character_pet_declinedname`
373--
374
375LOCK TABLES `character_pet_declinedname` WRITE;
376/*!40000 ALTER TABLE `character_pet_declinedname` DISABLE KEYS */;
377/*!40000 ALTER TABLE `character_pet_declinedname` ENABLE KEYS */;
378UNLOCK TABLES;
379
380--
381-- Table structure for table `character_queststatus`
382--
383
384DROP TABLE IF EXISTS `character_queststatus`;
385CREATE TABLE `character_queststatus` (
386  `guid` int(11) unsigned NOT NULL default '0' COMMENT 'Global Unique Identifier',
387  `quest` int(11) unsigned NOT NULL default '0' COMMENT 'Quest Identifier',
388  `status` int(11) unsigned NOT NULL default '0',
389  `rewarded` tinyint(1) unsigned NOT NULL default '0',
390  `explored` tinyint(1) unsigned NOT NULL default '0',
391  `timer` bigint(20) unsigned NOT NULL default '0',
392  `mobcount1` int(11) unsigned NOT NULL default '0',
393  `mobcount2` int(11) unsigned NOT NULL default '0',
394  `mobcount3` int(11) unsigned NOT NULL default '0',
395  `mobcount4` int(11) unsigned NOT NULL default '0',
396  `itemcount1` int(11) unsigned NOT NULL default '0',
397  `itemcount2` int(11) unsigned NOT NULL default '0',
398  `itemcount3` int(11) unsigned NOT NULL default '0',
399  `itemcount4` int(11) unsigned NOT NULL default '0',
400  PRIMARY KEY  (`guid`,`quest`)
401) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Player System';
402
403--
404-- Dumping data for table `character_queststatus`
405--
406
407LOCK TABLES `character_queststatus` WRITE;
408/*!40000 ALTER TABLE `character_queststatus` DISABLE KEYS */;
409/*!40000 ALTER TABLE `character_queststatus` ENABLE KEYS */;
410UNLOCK TABLES;
411
412--
413-- Table structure for table `character_queststatus_daily`
414--
415
416DROP TABLE IF EXISTS `character_queststatus_daily`;
417CREATE TABLE `character_queststatus_daily` (
418  `guid` int(11) unsigned NOT NULL default '0' COMMENT 'Global Unique Identifier',
419  `quest` int(11) unsigned NOT NULL default '0' COMMENT 'Quest Identifier',
420  `time` bigint(20) unsigned NOT NULL default '0',
421  PRIMARY KEY  (`guid`,`quest`),
422  KEY `idx_guid` (`guid`)
423) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Player System';
424
425--
426-- Dumping data for table `character_queststatus_daily`
427--
428
429LOCK TABLES `character_queststatus_daily` WRITE;
430/*!40000 ALTER TABLE `character_queststatus_daily` DISABLE KEYS */;
431/*!40000 ALTER TABLE `character_queststatus_daily` ENABLE KEYS */;
432UNLOCK TABLES;
433
434--
435-- Table structure for table `character_reputation`
436--
437
438DROP TABLE IF EXISTS `character_reputation`;
439CREATE TABLE `character_reputation` (
440  `guid` int(11) unsigned NOT NULL default '0' COMMENT 'Global Unique Identifier',
441  `faction` int(11) unsigned NOT NULL default '0',
442  `standing` int(11) NOT NULL default '0',
443  `flags` int(11) NOT NULL default '0',
444  PRIMARY KEY  (`guid`,`faction`)
445) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Player System';
446
447--
448-- Dumping data for table `character_reputation`
449--
450
451LOCK TABLES `character_reputation` WRITE;
452/*!40000 ALTER TABLE `character_reputation` DISABLE KEYS */;
453/*!40000 ALTER TABLE `character_reputation` ENABLE KEYS */;
454UNLOCK TABLES;
455
456--
457-- Table structure for table `character_social`
458--
459
460DROP TABLE IF EXISTS `character_social`;
461CREATE TABLE `character_social` (
462  `guid` int(11) unsigned NOT NULL default '0' COMMENT 'Character Global Unique Identifier',
463  `friend` int(11) unsigned NOT NULL default '0' COMMENT 'Friend Global Unique Identifier',
464  `flags` tinyint(1) unsigned NOT NULL default '0' COMMENT 'Friend Flags',
465  `note` varchar(48) NOT NULL default '' COMMENT 'Friend Note',
466  PRIMARY KEY  (`guid`,`friend`,`flags`),
467  KEY `guid` (`guid`),
468  KEY `friend` (`friend`),
469  KEY `guid_flags` (`guid`,`flags`),
470  KEY `friend_flags` (`friend`,`flags`)
471) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Player System';
472
473--
474-- Dumping data for table `character_social`
475--
476
477LOCK TABLES `character_social` WRITE;
478/*!40000 ALTER TABLE `character_social` DISABLE KEYS */;
479/*!40000 ALTER TABLE `character_social` ENABLE KEYS */;
480UNLOCK TABLES;
481
482--
483-- Table structure for table `character_spell`
484--
485
486DROP TABLE IF EXISTS `character_spell`;
487CREATE TABLE `character_spell` (
488  `guid` int(11) unsigned NOT NULL default '0' COMMENT 'Global Unique Identifier',
489  `spell` int(11) unsigned NOT NULL default '0' COMMENT 'Spell Identifier',
490  `slot` int(11) unsigned NOT NULL default '0',
491  `active` tinyint(3) unsigned NOT NULL default '1',
492  `disabled` tinyint(3) unsigned NOT NULL default '0',
493  PRIMARY KEY  (`guid`,`spell`)
494) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Player System';
495
496--
497-- Dumping data for table `character_spell`
498--
499
500LOCK TABLES `character_spell` WRITE;
501/*!40000 ALTER TABLE `character_spell` DISABLE KEYS */;
502/*!40000 ALTER TABLE `character_spell` ENABLE KEYS */;
503UNLOCK TABLES;
504
505--
506-- Table structure for table `character_spell_cooldown`
507--
508
509DROP TABLE IF EXISTS `character_spell_cooldown`;
510CREATE TABLE `character_spell_cooldown` (
511  `guid` int(11) unsigned NOT NULL default '0' COMMENT 'Global Unique Identifier, Low part',
512  `spell` int(11) unsigned NOT NULL default '0' COMMENT 'Spell Identifier',
513  `item` int(11) unsigned NOT NULL default '0' COMMENT 'Item Identifier',
514  `time` bigint(20) unsigned NOT NULL default '0',
515  PRIMARY KEY  (`guid`,`spell`)
516) ENGINE=InnoDB DEFAULT CHARSET=utf8;
517
518--
519-- Dumping data for table `character_spell_cooldown`
520--
521
522LOCK TABLES `character_spell_cooldown` WRITE;
523/*!40000 ALTER TABLE `character_spell_cooldown` DISABLE KEYS */;
524/*!40000 ALTER TABLE `character_spell_cooldown` ENABLE KEYS */;
525UNLOCK TABLES;
526
527--
528-- Table structure for table `character_ticket`
529--
530
531DROP TABLE IF EXISTS `character_ticket`;
532CREATE TABLE `character_ticket` (
533  `ticket_id` int(11) unsigned NOT NULL auto_increment,
534  `guid` int(11) unsigned NOT NULL default '0',
535  `ticket_text` text,
536  `ticket_lastchange` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
537  PRIMARY KEY  (`ticket_id`)
538) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Player System';
539
540--
541-- Dumping data for table `character_ticket`
542--
543
544LOCK TABLES `character_ticket` WRITE;
545/*!40000 ALTER TABLE `character_ticket` DISABLE KEYS */;
546/*!40000 ALTER TABLE `character_ticket` ENABLE KEYS */;
547UNLOCK TABLES;
548
549--
550-- Table structure for table `character_tutorial`
551--
552
553DROP TABLE IF EXISTS `character_tutorial`;
554CREATE TABLE `character_tutorial` (
555  `account` bigint(20) unsigned NOT NULL auto_increment COMMENT 'Account Identifier',
556  `realmid` int(11) unsigned NOT NULL default '0' COMMENT 'Realm Identifier',
557  `tut0` int(11) unsigned NOT NULL default '0',
558  `tut1` int(11) unsigned NOT NULL default '0',
559  `tut2` int(11) unsigned NOT NULL default '0',
560  `tut3` int(11) unsigned NOT NULL default '0',
561  `tut4` int(11) unsigned NOT NULL default '0',
562  `tut5` int(11) unsigned NOT NULL default '0',
563  `tut6` int(11) unsigned NOT NULL default '0',
564  `tut7` int(11) unsigned NOT NULL default '0',
565  PRIMARY KEY  (`account`,`realmid`),
566  KEY `acc_key` (`account`)
567) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Player System';
568
569--
570-- Dumping data for table `character_tutorial`
571--
572
573LOCK TABLES `character_tutorial` WRITE;
574/*!40000 ALTER TABLE `character_tutorial` DISABLE KEYS */;
575/*!40000 ALTER TABLE `character_tutorial` ENABLE KEYS */;
576UNLOCK TABLES;
577
578--
579-- Table structure for table `characters`
580--
581
582DROP TABLE IF EXISTS `characters`;
583CREATE TABLE `characters` (
584  `guid` int(11) unsigned NOT NULL default '0' COMMENT 'Global Unique Identifier',
585  `account` int(11) unsigned NOT NULL default '0' COMMENT 'Account Identifier',
586  `data` longtext,
587  `name` varchar(12) NOT NULL default '',
588  `race` tinyint(3) unsigned NOT NULL default '0',
589  `class` tinyint(3) unsigned NOT NULL default '0',
590  `position_x` float NOT NULL default '0',
591  `position_y` float NOT NULL default '0',
592  `position_z` float NOT NULL default '0',
593  `map` int(11) unsigned NOT NULL default '0' COMMENT 'Map Identifier',
594  `dungeon_difficulty` tinyint(1) unsigned NOT NULL default '0',
595  `orientation` float NOT NULL default '0',
596  `taximask` longtext,
597  `online` tinyint(3) unsigned NOT NULL default '0',
598  `cinematic` tinyint(3) unsigned NOT NULL default '0',
599  `totaltime` int(11) unsigned NOT NULL default '0',
600  `leveltime` int(11) unsigned NOT NULL default '0',
601  `logout_time` bigint(20) unsigned NOT NULL default '0',
602  `is_logout_resting` tinyint(3) unsigned NOT NULL default '0',
603  `rest_bonus` float NOT NULL default '0',
604  `resettalents_cost` int(11) unsigned NOT NULL default '0',
605  `resettalents_time` bigint(20) unsigned NOT NULL default '0',
606  `trans_x` float NOT NULL default '0',
607  `trans_y` float NOT NULL default '0',
608  `trans_z` float NOT NULL default '0',
609  `trans_o` float NOT NULL default '0',
610  `transguid` bigint(20) unsigned NOT NULL default '0',
611  `extra_flags` tinyint(3) unsigned NOT NULL default '0',
612  `stable_slots` tinyint(1) unsigned NOT NULL default '0',
613  `at_login` int(11) unsigned NOT NULL default '0',
614  `zone` int(11) unsigned NOT NULL default '0',
615  `death_expire_time` bigint(20) unsigned NOT NULL default '0',
616  `taxi_path` text,
617  PRIMARY KEY  (`guid`),
618  KEY `idx_account` (`account`),
619  KEY `idx_online` (`online`),
620  KEY `idx_name` (`name`)
621) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Player System';
622
623--
624-- Dumping data for table `characters`
625--
626
627LOCK TABLES `characters` WRITE;
628/*!40000 ALTER TABLE `characters` DISABLE KEYS */;
629/*!40000 ALTER TABLE `characters` ENABLE KEYS */;
630UNLOCK TABLES;
631
632--
633-- Table structure for table `corpse`
634--
635
636DROP TABLE IF EXISTS `corpse`;
637CREATE TABLE `corpse` (
638  `guid` int(11) unsigned NOT NULL default '0' COMMENT 'Global Unique Identifier',
639  `player` int(11) unsigned NOT NULL default '0' COMMENT 'Character Global Unique Identifier',
640  `position_x` float NOT NULL default '0',
641  `position_y` float NOT NULL default '0',
642  `position_z` float NOT NULL default '0',
643  `orientation` float NOT NULL default '0',
644  `zone` int(11) unsigned NOT NULL default '38' COMMENT 'Zone Identifier',
645  `map` int(11) unsigned NOT NULL default '0' COMMENT 'Map Identifier',
646  `data` longtext,
647  `time` bigint(20) unsigned NOT NULL default '0',
648  `corpse_type` tinyint(3) unsigned NOT NULL default '0',
649  `instance` int(11) unsigned NOT NULL default '0',
650  PRIMARY KEY  (`guid`),
651  KEY `idx_type` (`corpse_type`),
652  KEY `instance` (`instance`)
653) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Death System';
654
655--
656-- Dumping data for table `corpse`
657--
658
659LOCK TABLES `corpse` WRITE;
660/*!40000 ALTER TABLE `corpse` DISABLE KEYS */;
661/*!40000 ALTER TABLE `corpse` ENABLE KEYS */;
662UNLOCK TABLES;
663
664--
665-- Table structure for table `game_event_condition_save`
666--
667
668DROP TABLE IF EXISTS `game_event_condition_save`;
669CREATE TABLE `game_event_condition_save` (
670  `event_id` mediumint(8) unsigned NOT NULL,
671  `condition_id` mediumint(8) unsigned NOT NULL default '0',
672  `done` float default '0',
673  PRIMARY KEY  (`event_id`,`condition_id`)
674) ENGINE=InnoDB DEFAULT CHARSET=utf8;
675
676--
677-- Dumping data for table `game_event_condition_save`
678--
679
680LOCK TABLES `game_event_condition_save` WRITE;
681/*!40000 ALTER TABLE `game_event_condition_save` DISABLE KEYS */;
682/*!40000 ALTER TABLE `game_event_condition_save` ENABLE KEYS */;
683UNLOCK TABLES;
684
685--
686-- Table structure for table `game_event_save`
687--
688
689DROP TABLE IF EXISTS `game_event_save`;
690CREATE TABLE `game_event_save` (
691  `event_id` mediumint(8) unsigned NOT NULL,
692  `state` tinyint(3) unsigned NOT NULL default '1',
693  `next_start` timestamp NOT NULL default '0000-00-00 00:00:00',
694  PRIMARY KEY  (`event_id`)
695) ENGINE=InnoDB DEFAULT CHARSET=utf8;
696
697--
698-- Dumping data for table `game_event_save`
699--
700
701LOCK TABLES `game_event_save` WRITE;
702/*!40000 ALTER TABLE `game_event_save` DISABLE KEYS */;
703/*!40000 ALTER TABLE `game_event_save` ENABLE KEYS */;
704UNLOCK TABLES;
705
706--
707-- Table structure for table `group_instance`
708--
709
710DROP TABLE IF EXISTS `group_instance`;
711CREATE TABLE `group_instance` (
712  `leaderGuid` int(11) unsigned NOT NULL default '0',
713  `instance` int(11) unsigned NOT NULL default '0',
714  `permanent` tinyint(1) unsigned NOT NULL default '0',
715  PRIMARY KEY  (`leaderGuid`,`instance`),
716  KEY `instance` (`instance`)
717) ENGINE=InnoDB DEFAULT CHARSET=utf8;
718
719--
720-- Dumping data for table `group_instance`
721--
722
723LOCK TABLES `group_instance` WRITE;
724/*!40000 ALTER TABLE `group_instance` DISABLE KEYS */;
725/*!40000 ALTER TABLE `group_instance` ENABLE KEYS */;
726UNLOCK TABLES;
727
728--
729-- Table structure for table `group_member`
730--
731
732DROP TABLE IF EXISTS `group_member`;
733CREATE TABLE `group_member` (
734  `leaderGuid` int(11) unsigned NOT NULL,
735  `memberGuid` int(11) unsigned NOT NULL,
736  `assistant` tinyint(1) unsigned NOT NULL,
737  `subgroup` smallint(6) unsigned NOT NULL,
738  PRIMARY KEY  (`leaderGuid`,`memberGuid`)
739) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Groups';
740
741--
742-- Dumping data for table `group_member`
743--
744
745LOCK TABLES `group_member` WRITE;
746/*!40000 ALTER TABLE `group_member` DISABLE KEYS */;
747/*!40000 ALTER TABLE `group_member` ENABLE KEYS */;
748UNLOCK TABLES;
749
750--
751-- Table structure for table `groups`
752--
753
754DROP TABLE IF EXISTS `groups`;
755CREATE TABLE `groups` (
756  `leaderGuid` int(11) unsigned NOT NULL,
757  `mainTank` int(11) unsigned NOT NULL,
758  `mainAssistant` int(11) unsigned NOT NULL,
759  `lootMethod` tinyint(4) unsigned NOT NULL,
760  `looterGuid` int(11) unsigned NOT NULL,
761  `lootThreshold` tinyint(4) unsigned NOT NULL,
762  `icon1` int(11) unsigned NOT NULL,
763  `icon2` int(11) unsigned NOT NULL,
764  `icon3` int(11) unsigned NOT NULL,
765  `icon4` int(11) unsigned NOT NULL,
766  `icon5` int(11) unsigned NOT NULL,
767  `icon6` int(11) unsigned NOT NULL,
768  `icon7` int(11) unsigned NOT NULL,
769  `icon8` int(11) unsigned NOT NULL,
770  `isRaid` tinyint(1) unsigned NOT NULL,
771  `difficulty` tinyint(3) unsigned NOT NULL default '0',
772  PRIMARY KEY  (`leaderGuid`)
773) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Groups';
774
775--
776-- Dumping data for table `groups`
777--
778
779LOCK TABLES `groups` WRITE;
780/*!40000 ALTER TABLE `groups` DISABLE KEYS */;
781/*!40000 ALTER TABLE `groups` ENABLE KEYS */;
782UNLOCK TABLES;
783
784--
785-- Table structure for table `guild`
786--
787
788DROP TABLE IF EXISTS `guild`;
789CREATE TABLE `guild` (
790  `guildid` int(6) unsigned NOT NULL default '0',
791  `name` varchar(255) NOT NULL default '',
792  `leaderguid` int(6) unsigned NOT NULL default '0',
793  `EmblemStyle` int(5) NOT NULL default '0',
794  `EmblemColor` int(5) NOT NULL default '0',
795  `BorderStyle` int(5) NOT NULL default '0',
796  `BorderColor` int(5) NOT NULL default '0',
797  `BackgroundColor` int(5) NOT NULL default '0',
798  `info` text NOT NULL,
799  `motd` varchar(255) NOT NULL default '',
800  `createdate` datetime default NULL,
801  `BankMoney` bigint(20) NOT NULL default '0',
802  PRIMARY KEY  (`guildid`)
803) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Guild System';
804
805--
806-- Dumping data for table `guild`
807--
808
809LOCK TABLES `guild` WRITE;
810/*!40000 ALTER TABLE `guild` DISABLE KEYS */;
811/*!40000 ALTER TABLE `guild` ENABLE KEYS */;
812UNLOCK TABLES;
813
814--
815-- Table structure for table `guild_bank_eventlog`
816--
817
818DROP TABLE IF EXISTS `guild_bank_eventlog`;
819CREATE TABLE `guild_bank_eventlog` (
820  `guildid` int(11) unsigned NOT NULL default '0',
821  `LogGuid` int(11) unsigned NOT NULL default '0',
822  `LogEntry` tinyint(1) unsigned NOT NULL default '0',
823  `TabId` tinyint(1) unsigned NOT NULL default '0',
824  `PlayerGuid` int(11) unsigned NOT NULL default '0',
825  `ItemOrMoney` int(11) unsigned NOT NULL default '0',
826  `ItemStackCount` tinyint(3) unsigned NOT NULL default '0',
827  `DestTabId` tinyint(1) unsigned NOT NULL default '0',
828  `TimeStamp` bigint(20) unsigned NOT NULL default '0',
829  PRIMARY KEY  (`guildid`,`LogGuid`),
830  KEY `guildid_key` (`guildid`)
831) ENGINE=InnoDB DEFAULT CHARSET=utf8;
832
833--
834-- Dumping data for table `guild_bank_eventlog`
835--
836
837LOCK TABLES `guild_bank_eventlog` WRITE;
838/*!40000 ALTER TABLE `guild_bank_eventlog` DISABLE KEYS */;
839/*!40000 ALTER TABLE `guild_bank_eventlog` ENABLE KEYS */;
840UNLOCK TABLES;
841
842--
843-- Table structure for table `guild_bank_item`
844--
845
846DROP TABLE IF EXISTS `guild_bank_item`;
847CREATE TABLE `guild_bank_item` (
848  `guildid` int(11) unsigned NOT NULL default '0',
849  `TabId` tinyint(1) unsigned NOT NULL default '0',
850  `SlotId` tinyint(3) unsigned NOT NULL default '0',
851  `item_guid` int(11) unsigned NOT NULL default '0',
852  `item_entry` int(11) unsigned NOT NULL default '0',
853  PRIMARY KEY  (`guildid`,`TabId`,`SlotId`),
854  KEY `guildid_key` (`guildid`)
855) ENGINE=InnoDB DEFAULT CHARSET=utf8;
856
857--
858-- Dumping data for table `guild_bank_item`
859--
860
861LOCK TABLES `guild_bank_item` WRITE;
862/*!40000 ALTER TABLE `guild_bank_item` DISABLE KEYS */;
863/*!40000 ALTER TABLE `guild_bank_item` ENABLE KEYS */;
864UNLOCK TABLES;
865
866--
867-- Table structure for table `guild_bank_right`
868--
869
870DROP TABLE IF EXISTS `guild_bank_right`;
871CREATE TABLE `guild_bank_right` (
872  `guildid` int(11) unsigned NOT NULL default '0',
873  `TabId` tinyint(1) unsigned NOT NULL default '0',
874  `rid` int(11) unsigned NOT NULL default '0',
875  `gbright` tinyint(3) unsigned NOT NULL default '0',
876  `SlotPerDay` int(11) unsigned NOT NULL default '0',
877  PRIMARY KEY  (`guildid`,`TabId`,`rid`),
878  KEY `guildid_key` (`guildid`)
879) ENGINE=InnoDB DEFAULT CHARSET=utf8;
880
881--
882-- Dumping data for table `guild_bank_right`
883--
884
885LOCK TABLES `guild_bank_right` WRITE;
886/*!40000 ALTER TABLE `guild_bank_right` DISABLE KEYS */;
887/*!40000 ALTER TABLE `guild_bank_right` ENABLE KEYS */;
888UNLOCK TABLES;
889
890--
891-- Table structure for table `guild_bank_tab`
892--
893
894DROP TABLE IF EXISTS `guild_bank_tab`;
895CREATE TABLE `guild_bank_tab` (
896  `guildid` int(11) unsigned NOT NULL default '0',
897  `TabId` tinyint(1) unsigned NOT NULL default '0',
898  `TabName` varchar(100) NOT NULL default '',
899  `TabIcon` varchar(100) NOT NULL default '',
900  `TabText` varchar(500) NOT NULL default '',
901  PRIMARY KEY  (`guildid`,`TabId`),
902  KEY `guildid_key` (`guildid`)
903) ENGINE=InnoDB DEFAULT CHARSET=utf8;
904
905--
906-- Dumping data for table `guild_bank_tab`
907--
908
909LOCK TABLES `guild_bank_tab` WRITE;
910/*!40000 ALTER TABLE `guild_bank_tab` DISABLE KEYS */;
911/*!40000 ALTER TABLE `guild_bank_tab` ENABLE KEYS */;
912UNLOCK TABLES;
913
914--
915-- Table structure for table `guild_eventlog`
916--
917
918DROP TABLE IF EXISTS `guild_eventlog`;
919CREATE TABLE `guild_eventlog` (
920  `guildid` int(11) NOT NULL COMMENT 'Guild Identificator',
921  `LogGuid` int(11) NOT NULL COMMENT 'Log entry identificator',
922  `EventType` tinyint(1) NOT NULL COMMENT 'Event type',
923  `PlayerGuid1` int(11) NOT NULL COMMENT 'Player 1',
924  `PlayerGuid2` int(11) NOT NULL COMMENT 'Player 2',
925  `NewRank` tinyint(2) NOT NULL COMMENT 'New rank(in case promotion/demotion)',
926  `TimeStamp` bigint(20) NOT NULL COMMENT 'Event UNIX time'
927) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='Guild Eventlog';
928
929--
930-- Dumping data for table `guild_eventlog`
931--
932
933LOCK TABLES `guild_eventlog` WRITE;
934/*!40000 ALTER TABLE `guild_eventlog` DISABLE KEYS */;
935/*!40000 ALTER TABLE `guild_eventlog` ENABLE KEYS */;
936UNLOCK TABLES;
937
938--
939-- Table structure for table `guild_member`
940--
941
942DROP TABLE IF EXISTS `guild_member`;
943CREATE TABLE `guild_member` (
944  `guildid` int(6) unsigned NOT NULL default '0',
945  `guid` int(11) unsigned NOT NULL default '0',
946  `rank` tinyint(2) unsigned NOT NULL default '0',
947  `pnote` varchar(255) NOT NULL default '',
948  `offnote` varchar(255) NOT NULL default '',
949  `BankResetTimeMoney` int(11) unsigned NOT NULL default '0',
950  `BankRemMoney` int(11) unsigned NOT NULL default '0',
951  `BankResetTimeTab0` int(11) unsigned NOT NULL default '0',
952  `BankRemSlotsTab0` int(11) unsigned NOT NULL default '0',
953  `BankResetTimeTab1` int(11) unsigned NOT NULL default '0',
954  `BankRemSlotsTab1` int(11) unsigned NOT NULL default '0',
955  `BankResetTimeTab2` int(11) unsigned NOT NULL default '0',
956  `BankRemSlotsTab2` int(11) unsigned NOT NULL default '0',
957  `BankResetTimeTab3` int(11) unsigned NOT NULL default '0',
958  `BankRemSlotsTab3` int(11) unsigned NOT NULL default '0',
959  `BankResetTimeTab4` int(11) unsigned NOT NULL default '0',
960  `BankRemSlotsTab4` int(11) unsigned NOT NULL default '0',
961  `BankResetTimeTab5` int(11) unsigned NOT NULL default '0',
962  `BankRemSlotsTab5` int(11) unsigned NOT NULL default '0',
963  KEY `guildid_key` (`guildid`),
964  KEY `guildid_rank_key` (`guildid`,`rank`),
965  KEY `guid_key` (`guid`)
966) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Guild System';
967
968--
969-- Dumping data for table `guild_member`
970--
971
972LOCK TABLES `guild_member` WRITE;
973/*!40000 ALTER TABLE `guild_member` DISABLE KEYS */;
974/*!40000 ALTER TABLE `guild_member` ENABLE KEYS */;
975UNLOCK TABLES;
976
977--
978-- Table structure for table `guild_rank`
979--
980
981DROP TABLE IF EXISTS `guild_rank`;
982CREATE TABLE `guild_rank` (
983  `guildid` int(6) unsigned NOT NULL default '0',
984  `rid` int(11) unsigned NOT NULL,
985  `rname` varchar(255) NOT NULL default '',
986  `rights` int(3) unsigned NOT NULL default '0',
987  `BankMoneyPerDay` int(11) unsigned NOT NULL default '0',
988  PRIMARY KEY  (`guildid`,`rid`)
989) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Guild System';
990
991--
992-- Dumping data for table `guild_rank`
993--
994
995LOCK TABLES `guild_rank` WRITE;
996/*!40000 ALTER TABLE `guild_rank` DISABLE KEYS */;
997/*!40000 ALTER TABLE `guild_rank` ENABLE KEYS */;
998UNLOCK TABLES;
999
1000--
1001-- Table structure for table `has_logged_in_before`
1002--
1003
1004DROP TABLE IF EXISTS `has_logged_in_before`;
1005CREATE TABLE `has_logged_in_before` (
1006  `guid` int(11) unsigned NOT NULL default '0',
1007  PRIMARY KEY  (`guid`)
1008) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='ImpConfig check';
1009
1010--
1011-- Dumping data for table `has_logged_in_before`
1012--
1013
1014LOCK TABLES `has_logged_in_before` WRITE;
1015/*!40000 ALTER TABLE `has_logged_in_before` DISABLE KEYS */;
1016/*!40000 ALTER TABLE `has_logged_in_before` ENABLE KEYS */;
1017UNLOCK TABLES;
1018
1019--
1020-- Table structure for table `instance`
1021--
1022
1023DROP TABLE IF EXISTS `instance`;
1024CREATE TABLE `instance` (
1025  `id` int(11) unsigned NOT NULL default '0',
1026  `map` int(11) unsigned NOT NULL default '0',
1027  `resettime` bigint(40) NOT NULL default '0',
1028  `difficulty` tinyint(1) unsigned NOT NULL default '0',
1029  `data` longtext,
1030  PRIMARY KEY  (`id`),
1031  KEY `map` (`map`),
1032  KEY `resettime` (`resettime`)
1033) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1034
1035--
1036-- Dumping data for table `instance`
1037--
1038
1039LOCK TABLES `instance` WRITE;
1040/*!40000 ALTER TABLE `instance` DISABLE KEYS */;
1041/*!40000 ALTER TABLE `instance` ENABLE KEYS */;
1042UNLOCK TABLES;
1043
1044--
1045-- Table structure for table `instance_reset`
1046--
1047
1048DROP TABLE IF EXISTS `instance_reset`;
1049CREATE TABLE `instance_reset` (
1050  `mapid` int(11) unsigned NOT NULL default '0',
1051  `resettime` bigint(40) NOT NULL default '0',
1052  PRIMARY KEY  (`mapid`)
1053) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1054
1055--
1056-- Dumping data for table `instance_reset`
1057--
1058
1059LOCK TABLES `instance_reset` WRITE;
1060/*!40000 ALTER TABLE `instance_reset` DISABLE KEYS */;
1061/*!40000 ALTER TABLE `instance_reset` ENABLE KEYS */;
1062UNLOCK TABLES;
1063
1064--
1065-- Table structure for table `item_instance`
1066--
1067
1068DROP TABLE IF EXISTS `item_instance`;
1069CREATE TABLE `item_instance` (
1070  `guid` int(11) unsigned NOT NULL default '0',
1071  `owner_guid` int(11) unsigned NOT NULL default '0',
1072  `data` longtext,
1073  PRIMARY KEY  (`guid`),
1074  KEY `idx_owner_guid` (`owner_guid`)
1075) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Item System';
1076
1077--
1078-- Dumping data for table `item_instance`
1079--
1080
1081LOCK TABLES `item_instance` WRITE;
1082/*!40000 ALTER TABLE `item_instance` DISABLE KEYS */;
1083/*!40000 ALTER TABLE `item_instance` ENABLE KEYS */;
1084UNLOCK TABLES;
1085
1086--
1087-- Table structure for table `item_text`
1088--
1089
1090DROP TABLE IF EXISTS `item_text`;
1091CREATE TABLE `item_text` (
1092  `id` int(11) unsigned NOT NULL default '0',
1093  `text` longtext,
1094  PRIMARY KEY  (`id`)
1095) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Item System';
1096
1097--
1098-- Dumping data for table `item_text`
1099--
1100
1101LOCK TABLES `item_text` WRITE;
1102/*!40000 ALTER TABLE `item_text` DISABLE KEYS */;
1103/*!40000 ALTER TABLE `item_text` ENABLE KEYS */;
1104UNLOCK TABLES;
1105
1106--
1107-- Table structure for table `mail`
1108--
1109
1110DROP TABLE IF EXISTS `mail`;
1111CREATE TABLE `mail` (
1112  `id` int(11) unsigned NOT NULL default '0' COMMENT 'Identifier',
1113  `messageType` tinyint(3) unsigned NOT NULL default '0',
1114  `stationery` tinyint(3) NOT NULL default '41',
1115  `mailTemplateId` mediumint(8) unsigned NOT NULL default '0',
1116  `sender` int(11) unsigned NOT NULL default '0' COMMENT 'Character Global Unique Identifier',
1117  `receiver` int(11) unsigned NOT NULL default '0' COMMENT 'Character Global Unique Identifier',
1118  `subject` longtext,
1119  `itemTextId` int(11) unsigned NOT NULL default '0',
1120  `has_items` tinyint(3) unsigned NOT NULL default '0',
1121  `expire_time` bigint(40) NOT NULL default '0',
1122  `deliver_time` bigint(40) NOT NULL default '0',
1123  `money` int(11) unsigned NOT NULL default '0',
1124  `cod` int(11) unsigned NOT NULL default '0',
1125  `checked` tinyint(3) unsigned NOT NULL default '0',
1126  PRIMARY KEY  (`id`),
1127  KEY `idx_receiver` (`receiver`)
1128) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Mail System';
1129
1130--
1131-- Dumping data for table `mail`
1132--
1133
1134LOCK TABLES `mail` WRITE;
1135/*!40000 ALTER TABLE `mail` DISABLE KEYS */;
1136/*!40000 ALTER TABLE `mail` ENABLE KEYS */;
1137UNLOCK TABLES;
1138
1139--
1140-- Table structure for table `mail_items`
1141--
1142
1143DROP TABLE IF EXISTS `mail_items`;
1144CREATE TABLE `mail_items` (
1145  `mail_id` int(11) NOT NULL default '0',
1146  `item_guid` int(11) NOT NULL default '0',
1147  `item_template` int(11) NOT NULL default '0',
1148  `receiver` int(11) unsigned NOT NULL default '0' COMMENT 'Character Global Unique Identifier',
1149  PRIMARY KEY  (`mail_id`,`item_guid`),
1150  KEY `idx_receiver` (`receiver`)
1151) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;
1152
1153--
1154-- Dumping data for table `mail_items`
1155--
1156
1157LOCK TABLES `mail_items` WRITE;
1158/*!40000 ALTER TABLE `mail_items` DISABLE KEYS */;
1159/*!40000 ALTER TABLE `mail_items` ENABLE KEYS */;
1160UNLOCK TABLES;
1161
1162--
1163-- Table structure for table `pet_aura`
1164--
1165
1166DROP TABLE IF EXISTS `pet_aura`;
1167CREATE TABLE `pet_aura` (
1168  `guid` int(11) unsigned NOT NULL default '0' COMMENT 'Global Unique Identifier',
1169  `caster_guid` bigint(20) unsigned NOT NULL default '0' COMMENT 'Full Global Unique Identifier',
1170  `spell` int(11) unsigned NOT NULL default '0',
1171  `effect_index` int(11) unsigned NOT NULL default '0',
1172  `amount` int(11) NOT NULL default '0',
1173  `maxduration` int(11) NOT NULL default '0',
1174  `remaintime` int(11) NOT NULL default '0',
1175  `remaincharges` int(11) NOT NULL default '0',
1176  PRIMARY KEY  (`guid`,`spell`,`effect_index`)
1177) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Pet System';
1178
1179--
1180-- Dumping data for table `pet_aura`
1181--
1182
1183LOCK TABLES `pet_aura` WRITE;
1184/*!40000 ALTER TABLE `pet_aura` DISABLE KEYS */;
1185/*!40000 ALTER TABLE `pet_aura` ENABLE KEYS */;
1186UNLOCK TABLES;
1187
1188--
1189-- Table structure for table `pet_spell`
1190--
1191
1192DROP TABLE IF EXISTS `pet_spell`;
1193CREATE TABLE `pet_spell` (
1194  `guid` int(11) unsigned NOT NULL default '0' COMMENT 'Global Unique Identifier',
1195  `spell` int(11) unsigned NOT NULL default '0' COMMENT 'Spell Identifier',
1196  `slot` int(11) unsigned NOT NULL default '0',
1197  `active` int(11) unsigned NOT NULL default '0',
1198  PRIMARY KEY  (`guid`,`spell`)
1199) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Pet System';
1200
1201--
1202-- Dumping data for table `pet_spell`
1203--
1204
1205LOCK TABLES `pet_spell` WRITE;
1206/*!40000 ALTER TABLE `pet_spell` DISABLE KEYS */;
1207/*!40000 ALTER TABLE `pet_spell` ENABLE KEYS */;
1208UNLOCK TABLES;
1209
1210--
1211-- Table structure for table `pet_spell_cooldown`
1212--
1213
1214DROP TABLE IF EXISTS `pet_spell_cooldown`;
1215CREATE TABLE `pet_spell_cooldown` (
1216  `guid` int(11) unsigned NOT NULL default '0' COMMENT 'Global Unique Identifier, Low part',
1217  `spell` int(11) unsigned NOT NULL default '0' COMMENT 'Spell Identifier',
1218  `time` bigint(20) unsigned NOT NULL default '0',
1219  PRIMARY KEY  (`guid`,`spell`)
1220) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1221
1222--
1223-- Dumping data for table `pet_spell_cooldown`
1224--
1225
1226LOCK TABLES `pet_spell_cooldown` WRITE;
1227/*!40000 ALTER TABLE `pet_spell_cooldown` DISABLE KEYS */;
1228/*!40000 ALTER TABLE `pet_spell_cooldown` ENABLE KEYS */;
1229UNLOCK TABLES;
1230
1231--
1232-- Table structure for table `petition`
1233--
1234
1235DROP TABLE IF EXISTS `petition`;
1236CREATE TABLE `petition` (
1237  `ownerguid` int(10) unsigned NOT NULL,
1238  `petitionguid` int(10) unsigned default '0',
1239  `name` varchar(255) NOT NULL default '',
1240  `type` int(10) unsigned NOT NULL default '0',
1241  PRIMARY KEY  (`ownerguid`,`type`),
1242  UNIQUE KEY `index_ownerguid_petitionguid` (`ownerguid`,`petitionguid`)
1243) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Guild System';
1244
1245--
1246-- Dumping data for table `petition`
1247--
1248
1249LOCK TABLES `petition` WRITE;
1250/*!40000 ALTER TABLE `petition` DISABLE KEYS */;
1251/*!40000 ALTER TABLE `petition` ENABLE KEYS */;
1252UNLOCK TABLES;
1253
1254--
1255-- Table structure for table `petition_sign`
1256--
1257
1258DROP TABLE IF EXISTS `petition_sign`;
1259CREATE TABLE `petition_sign` (
1260  `ownerguid` int(10) unsigned NOT NULL,
1261  `petitionguid` int(11) unsigned NOT NULL default '0',
1262  `playerguid` int(11) unsigned NOT NULL default '0',
1263  `player_account` int(11) unsigned NOT NULL default '0',
1264  `type` int(10) unsigned NOT NULL default '0',
1265  PRIMARY KEY  (`petitionguid`,`playerguid`)
1266) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Guild System';
1267
1268--
1269-- Dumping data for table `petition_sign`
1270--
1271
1272LOCK TABLES `petition_sign` WRITE;
1273/*!40000 ALTER TABLE `petition_sign` DISABLE KEYS */;
1274/*!40000 ALTER TABLE `petition_sign` ENABLE KEYS */;
1275UNLOCK TABLES;
1276
1277--
1278-- Table structure for table `saved_variables`
1279--
1280
1281DROP TABLE IF EXISTS `saved_variables`;
1282CREATE TABLE `saved_variables` (
1283  `NextArenaPointDistributionTime` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP
1284) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Variable Saves';
1285
1286--
1287-- Dumping data for table `saved_variables`
1288--
1289
1290LOCK TABLES `saved_variables` WRITE;
1291/*!40000 ALTER TABLE `saved_variables` DISABLE KEYS */;
1292/*!40000 ALTER TABLE `saved_variables` ENABLE KEYS */;
1293UNLOCK TABLES;
1294/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
1295
1296/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
1297/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
1298/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
1299/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
1300/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
1301/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
1302/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
1303
1304-- Dump completed on 2008-10-14 13:27:52
Note: See TracBrowser for help on using the browser.